1. Overview

This document describes new or changed features of the Oracle E-Business Suite Release 12 Inventory compared to those of Release 11i. It consists of information intended to assist in understanding the technical delta changes of R12 with respect to prior releases.

2. Business process

i) On hand availability (Material Workbench) changes :

This form has the major changes. Now here you can also view the Inbound and receiving quantity. Earlier you were able to view only quantity lying in inventory. Lot of new criteria’s are added to query the data. User can see item quantity across multiple operating units.

ii) New concept of Lot and Sub lot :

Now you can have parent lot and child lot. Earlier you can have only lot but not child lots.

iii) New feature of Grades :

Now you can define grades for the items and you can reserve the material against a grade in sales order.

iv) Reservation against Serial numbers :

Now you can reserve specific serial numbers. Earlier you were only able to reserve the quantity and not the serial numbers but now you can reserve the serial numbers also.

v) Lot level conversions :

Now in R12 you can define UOM conversions specific to a particular lot.

vi) Dual Unit of Measure

Now from R12 you have Dual UOM feature where you can stock and transact in dual unit of measure.

vii) New concept of Material Status :

You have new concept of Material status. Using it you can restrict certain operations like Subinventory transfer, Miscellaneous issue etc for specific subinventory, lot, locator etc.

viii) Pick release rules now shared across organizations.

2.1. Changes in the forms

Following forms are changed :

i)On-hand availability (Material Workbench) :

On-hand AvailabilityàOn-hand Quantity

New feature has been added where you can save your query which you fire frequently.New tabs are added for search .additional view by options provided such as Serial, Grade, Lot. Also for inbound type you can view purchase order number

ii) Master Items

ItemsàMaster Items

Several new attributes are added in the item definition screen shown in above screen shots . A completely new tab as Process Manufacturing is added in the item definition screen.

iii) Organization Parameters

SetupàOrganizationsàParameters

Several New attributes are added in Organization Parameter screen which are shown in screenshots above.

iv) Reservation Window

On-hand AvailabilityàReservations

Now on reservation screen reservations can include cross dock by selecting (Include cross dock) field.Cross dock allows warehouses to increase its operational efficiency by transferring inbound material directly to an outbound area. It bypasses the inventory-holding function of a warehouse while still allowing it to serve its consolidation and shipping functions.

v) Subinventory form

SetupàOrganizationsàSubinventories

New attributes are added as shown in above screenshots.

vi) Miscellaneous transactions

Transactionsà Miscellaneous transactions

New attributes are added in the Miscellaneous transactions screen

viii) Lots Screen

Onhand AvailabilityàLots

many new attributes are added in the find screen as well as result screen such as Retest date,maturity date,hold date, grade code,status etc.

2.2. Changes in reports

Sr.No.	Report Name	Description Of the report	Changes Made In R12
1	Serial Number Transaction Register Navigation:->View View RequestàSubmit New RequestàSingle Request	This report is used for audit serial number transactions for a specified time interval, location or group of locations,reason or group of reasons, or other criteria.	A new parameter as Organization is added in the report to retrieve serial data for the organization. If this field is blank, the report retrieves serial data for all organizations.
2	Transaction Historical Summary Report View RequestàSubmit New RequestàSingle Request	The Transaction Historical Summary Report is used to report past item quantities, past item value, or past inventory balances.	A new parameter as Include Consigned is added in the report giving options whether user want to include consigned inventory in this report.
3	Item Definition Detail View RequestàSubmit New RequestàSingle Request	to view comprehensive information for items. Use this report to verify items have been classified in conformance with decisions you have made regarding how the parts are to be planned, costed, and located.	Three new parameters are added as the base table for item is changed. Three new parameters are as Process Manufacturing Item Attributes Service Item Attributes Web Item Attributes User can select Yes if want to print these attributes.
4	Cycle Count Entries and Adjustments Report View RequestàSubmit New RequestàSingle Request	Cycle Count Entries and Adjustments Report is used to monitor inventory accuracy. The report shows counts and adjustments for the items and calculates the monetary value of the adjustments to inventory value.	A new parameter is added as Approved Cycle Counts Only user can select Yes to indicate whether the report includes only approved cycle counts.
5	Item Quantities Summary Report View RequestàSubmit New RequestàSingle Request	This report is used to report just the item and the quantity. The report is useful to provide a fast list of the items in the inventory.	A new parameter is added as Negative Quantities Only user can select Yes to indicate whether the report includes only Negative Quantities.
6	Supplier Lot Trace Report View RequestàSubmit New RequestàSingle Request	The Supplier lot trace report enables you to view the lot number, and associated vendor lot number for an item.	The name of this report is changed to Vendor Lot Trace Report.

2.3. Changes in Tables

In R12 in several Tables New columns are added. Following are some important tables with the changes in them.

Table Name Along with Description of changes	Changes In R12(Newly Added Columns)
MTL_MATERIAL_TRANSACTIONS Changes in table is related to new concept of Deferred COGS which is now possible in 12. Now just after ship confirm no need to recognize COGS directly we can defer it and put it to the Deferred_COGS_Account set at the organization level. Flag to mark if the transaction is costed or not (for Process Organizations). MTL_MATERIAL_TRANSACTIONS.SO_ISSUE_ACCOUNT_TYPE should be '2' if the Sales Order line is set for deferred revenue recognition.
	COGS_RECOGNITION_PERCENT
	SO_ISSUE_ACCOUNT_TYPE
	OPM_COSTED_FLAG
MTL_MATERIAL_TRANSACTIONS_TEMP MTL_MATERIAL_TRANSACTIONS_TEMP is the gateway for all Material transactions. Records are processed from this table into Inventory through the transaction processor. All Inventory transaction forms write directly to this table. Outside applications must write transaction records to to MTL_TRANSACTIONS_INTERFACE be processed through MTL_MATERIAL_TRANSACTIONS_TEMP and the transaction processor by the Transaction Worker concurrent program. RELIEVE_HIGH_LEVEL_RSV_FLAG - Indicates whether to check for high level reservations that needs to be relieved during transaction processing. RELIEVE_RESERVATIONS_FLAG - Indicates whether to relieve the reservations during transaction processing	RELIEVE_HIGH_LEVEL_RSV_FLAG
	RELIEVE_RESERVATIONS_FLAG
	SOURCE_LOT_NUMBER
	TRANSFER_PRICE
	TRANSFER_SECONDARY_QUANTITY
	TRANSFER_SECONDARY_UOM
MTL_CYCLE_COUNT_ENTRIES Stores the actual counts of a cycle count. A row in this table without a count is considered to be a count request. Oracle Inventory uses this information to determine and store cycle count adjustments, recounts, and approval requirements. As we know from R12 Secondary UOM concept is introduced so in this table all the changes are related to secondary UOM of inventory.	COUNT_SECONDARY_UOM_CURRENT
	COUNT_SECONDARY_UOM_FIRST
	COUNT_SECONDARY_UOM_PRIOR
	SECONDARY_ADJUSTMENT_QUANTITY
	SECONDARY_SYSTEM_QTY_CURRENT
	SECONDARY_SYSTEM_QTY_FIRST
	SECONDARY_SYSTEM_QTY_PRIOR
	SECONDARY_UOM_QUANTITY_CURRENT
	SECONDARY_UOM_QUANTITY_FIRST
	SECONDARY_UOM_QUANTITY_PRIOR
MTL_INTERFACE_ERRORS MTL_INTERFACE_ERRORS is used for error tracking of all items that the Item Interface fails. Message type to differentiate the message.	MESSAGE_TYPE
MTL_ITEM_LOCATIONS MTL_ITEM_LOCATIONS is the definition table for stock locators.The associated attributes describe which subinventory this locator belongs to, what the locator physical capacity is, etc. .The locator is a key flexfield. The Flexfield Code is MTLL. AVAILABILITY_TYPE - Subinventory availability code INVENTORY_ATP_CODE - Inventory available to promise code RESERVABLE_TYPE - Hard reservation eligibility ALIAS - Short Alias for the Locator name	ALIAS
	AVAILABILITY_TYPE
	INVENTORY_ATP_CODE
	RESERVABLE_TYPE
MTL_LOT_NUMBERS MTL_LOT_NUMBERS stores the definition and expiration date of all lot numbers in inventory. Since the primary key consists of LOT_NUMBER, ORGANIZATION_ID, and INVENTORY_ITEM_ID, a lot number could exist in more than one organization or for different items. SAMPLING_EVENT_ID - This is the latest OPM Quality sampling event tested against the lot.	AVAILABILITY_TYPE
	EXPIRATION_ACTION_CODE
	EXPIRATION_ACTION_DATE
	HOLD_DATE
	INVENTORY_ATP_CODE
	ORIGINATION_TYPE
	PARENT_LOT_NUMBER
	RESERVABLE_TYPE
	SAMPLING_EVENT_ID
MTL_MATERIAL_STATUS_HISTORY MTL_MATERIAL_STATUS_HISTORY stores the status update history for subinventory, locator, lot and serial. AVAILABILITY_TYPE - Inventory available to promise code RESERVABLE_TYPE - Hard reservation eligibility	AVAILABILITY_TYPE
	GRADE_CODE
	INVENTORY_ATP_CODE
	PRIMARY_ONHAND
	SECONDARY_ONHAND
	RESERVABLE_TYPE
MTL_MATERIAL_STATUSES_B MTL_MATERIAL_STATUSES_B is the base table for the inventory statuses. It contains all the attributes which are not translated and don't vary by language. The defined status can be assigned to Subinventory, locator, lot and serial to restrict certain transaction types. AVAILABILITY_TYPE - Inventory available to promise code RESERVABLE_TYPE - Hard reservation eligibility	AVAILABILITY_TYPE
	INVENTORY_ATP_CODE
	RESERVABLE_TYPE
MTL_PARAMETERS MTL_PARAMETERS maintains a set of default options like general ledger accounts; locator, lot, and serial controls; inter-organization options; costing method; etc. for each organization defined in Oracle Inventory. Each organization's item master organization (MASTER_ORGANIZATION_ID)and costing organization (COST_ORGANIZATION_ID) are maintained here. You specify which manufacturing calendar the organization will use (CALENDAR_CODE), as well as the set of exceptions to this calendar (CALENDAR_EXCEPTION_SET_ID). NEGATIVE_INV_RECEIPT_CODE indicates whether this organization will allow negative balances in inventory. It is used in the transaction system to ensure, for example, that you do not over-issue a particular item (if you have indicated that negative balances are not allowed). For lot number and serial number auto-generation, you can specify whether you want the numbers generated from defaults defined at theorganization level or the item level (LOT_NUMBER_GENERATION,SERIAL_NUMBER_GENERATION). You can also specify uniqueness constraints for lot numbers (LOT_NUMBER_UNIQUENESS) and serial numbers (SERIAL_NUMBER_TYPE). Among the accounting defaults that can be defined here are valuation accounts, receiving accounts, profit and loss accounts, and inter- organization transfer accounts. So all the new columns added here are the new attributes added in R12 to the organization parameter form. We have one column for each of the attribute.	ALLOW_DIFFERENT_STATUS
	CHILD_LOT_ALPHA_PREFIX
	CHILD_LOT_NUMBER_LENGTH
	CHILD_LOT_VALIDATION_FLAG
	CHILD_LOT_ZERO_PADDING_FLAG
	COMMERCIAL_GOVT_ENTITY_NUMBER
	COMPANY_PREFIX
	COMPANY_PREFIX_INDEX
	COPY_LOT_ATTRIBUTE_FLAG
	CREATE_LOT_UOM_CONVERSION
	DEFAULT_CROSSDOCK_CRITERIA_ID
	DEFERRED_COGS_ACCOUNT
	ENFORCE_LOCATOR_ALIS_UNQ_FLAG
	EPC_GENERATION_ENABLED_FLAG
	GENEALOGY_FORMULA_SECURITY
	LABOR_MANAGEMENT_ENABLED_FLAG
	PARENT_CHILD_GENERATION_FLAG
	RULES_OVERRIDE_LOT_RESERVATION
	TRADING_PARTNER_ORG_FLAG
	YARD_MANAGEMENT_ENABLED_FLAG
MTL_SECONDARY_INVENTORIES MTL_SECONDARY_INVENTORIES is the definition table for the subinventory. A subinventory is a section of inventory, i.e., raw material, finished goods, etc. Subinventories are assigned to items (in a many to one relationship), indicating a list of valid places where this item will physically exist in inventory. Other attributes include general ledger accounts, demand picking order, locator type, availability type, and reservable type. You can also specify whether this subinventory is an expense or asset subinventory (ASSET_INVENTORY), or whether quantities are tracked (QUANTITY_TRACKED). ENABLE_LOCATOR_ALIAS - Indicates whether Locator Aliases are enabled for this Subinventory ENFORCE_ALIAS_UNIQUENESS - Flag to Enforce Locator Alias Uniqueness in the Subinventory	ENABLE_LOCATOR_ALIAS
	ENFORCE_ALIAS_UNIQUENESS
MTL_SERIAL_NUMBERS MTL_SERIAL_NUMBERS stores the definition and current status of all serial numbers in Oracle Inventory. These serial numbers are also used in other areas of Oracle Manufacturing. A serial number can have one of four statuses: -Defined but not used -Resides in stores -Issued out of stores -Resides in intransit . The serial generation program populates this table, given the number of serial numbers to create and the starting number and prefix. AVAILABILITY_TYPE - Subinventory availability code RESERVABLE_TYPE - Hard reservation eligibility DEPENDENT_ASSET_FLAG - Dependent asset flag -- Used by EAM	AVAILABILITY_TYPE
	DEPENDENT_ASSET_FLAG
	INVENTORY_ATP_CODE
	OPERATIONAL_LOG_FLAG
	OPERATIONAL_STATUS_FLAG
	PARENT_LOT_NUMBER
	RESERVABLE_TYPE
	RESERVATION_ID
MTL_SYSTEM_ITEMS_B As we know in R12 on the Item Master form lot of new fields are added like retest interval, Expiration Action,Process Manufacturing is the new tab and all its attributes so related to that this table is affected. All the new columns are added with respect to each new item added on the form in table also.	ATTRIBUTE16
	ATTRIBUTE17
	ATTRIBUTE18
	ATTRIBUTE19
	ATTRIBUTE20
	ATTRIBUTE21
	ATTRIBUTE22
	ATTRIBUTE23
	ATTRIBUTE24
	ATTRIBUTE25
	ATTRIBUTE26
	ATTRIBUTE27
	ATTRIBUTE28
	ATTRIBUTE29
	ATTRIBUTE30
	CAS_NUMBER
	CHARGE_PERIODICITY_CODE
	CHILD_LOT_FLAG
	CHILD_LOT_PREFIX
	CHILD_LOT_STARTING_NUMBER
	CHILD_LOT_VALIDATION_FLAG
	COPY_LOT_ATTRIBUTE_FLAG
	DEFAULT_GRADE
	EGO_MASTER_ITEMS_DFF_CTX
	EXPIRATION_ACTION_CODE
	EXPIRATION_ACTION_INTERVAL
	GRADE_CONTROL_FLAG
	HAZARDOUS_MATERIAL_FLAG
	HOLD_DAYS
	LOT_DIVISIBLE_FLAG
	MATURITY_DAYS
	OUTSOURCED_ASSEMBLY
	PARENT_CHILD_GENERATION_FLAG
	PREPOSITION_POINT
	PROCESS_COSTING_ENABLED_FLAG
	PROCESS_EXECUTION_ENABLED_FLAG
	PROCESS_QUALITY_ENABLED_FLAG
	PROCESS_SUPPLY_LOCATOR_ID
	PROCESS_SUPPLY_SUBINVENTORY
	PROCESS_YIELD_LOCATOR_ID
	PROCESS_YIELD_SUBINVENTORY
	RECIPE_ENABLED_FLAG
	REPAIR_LEADTIME
	REPAIR_PROGRAM
	REPAIR_YIELD
	RETEST_INTERVAL
	SUBCONTRACTING_COMPONENT
MTL_RESERVATIONS This table stores reservation information. Each record is a reservation that ties an item/organization combination with a demand source and a supply source. Demand source information comprises demand source type (Sales Order, Account, Account Alias, Inventory), demand source header, demand source line and demand source name. Supply source information comprises supply source type (Inventory, WIP jobs), supply source header, supply source line, supply source name and inventory controls (revision, lot, subinventory, locator).	CROSSDOCK_CRITERIA_ID
	CROSSDOCK_FLAG
	DEMAND_SHIP_DATE
	DEMAND_SOURCE_LINE_DETAIL
	EXCEPTION_CODE
	ORIG_DEMAND_SOURCE_HEADER_ID
	ORIG_DEMAND_SOURCE_LINE_DETAIL
	ORIG_DEMAND_SOURCE_LINE_ID
	ORIG_DEMAND_SOURCE_TYPE_ID
	ORIG_SUPPLY_SOURCE_HEADER_ID
	ORIG_SUPPLY_SOURCE_LINE_DETAIL
	ORIG_SUPPLY_SOURCE_LINE_ID
	ORIG_SUPPLY_SOURCE_TYPE_ID
	PROJECT_ID
	SECONDARY_DETAILED_QUANTITY
	SECONDARY_RESERVATION_QUANTITY
	SECONDARY_UOM_CODE
	SECONDARY_UOM_ID
	SERIAL_RESERVATION_QUANTITY
	SUPPLY_RECEIPT_DATE
	TASK_ID
MTL_TRANSACTION_TYPES MTL_TRANSACTION_TYPES contains seeded transaction types and the user defined ones. USER_DEFINED_FLAG will distinguish the two. The table also stores the TRANSACTION_ACTION_ID and TRANSACTION_SOURCE_TYPE_ID that is associated with each transaction type. Location_required_flag - Flag to indicate whether the Location is mandatory for the given Transaction.	LOCATION_REQUIRED_FLAG
MTL_UNIT_TRANSACTIONS MTL_UNIT_TRANSACTIONS stores a record of every material transaction of a serialized unit in Inventory. Records are inserted into this table through the transaction processor. . . . Many serial numbers may be specified for a given transaction record. TRANSACTION_ID joins to MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID when only under serial control. TRANSACTION_ID joins to MTL_TRANSACTION_LOT_NUMBERS.SERIAL_TRANSACTION_ID when also under lot control. New columns all are related genealogy.	PARENT_ITEM_ID
	PARENT_OBJECT_ID
	PARENT_OBJECT_ID2
	PARENT_OBJECT_NUMBER
	PARENT_OBJECT_NUMBER2
	PARENT_OBJECT_TYPE
	PARENT_OBJECT_TYPE2

Following tables are newly added in R12 Inventory

INV_DIAG_MSN_TEMP

MTL_ACTIONS_B

MTL_ACTIONS_TL

MTL_CHILD_LOT_NUMBERS

MTL_COGS_RECOGNITION_TEMP

MTL_CONSUMPTION_TXN_TEMP

MTL_CROSS_REFERENCES_TL

MTL_CROSS_REFERENCES_B

MTL_GEN_TEMP

MTL_GRADES_B

MTL_GRADES_TL

MTL_INV_PACKSLIPS

MTL_INV_PICKING_RULES

MTL_ITEM_ATTRIBUTES_SEED_INFO

MTL_ITEM_BULKLOAD_RECS

MTL_ITEM_STATUS_TL

MTL_ITEM_TEMPLATES_B

MTL_ITEM_TEMPLATES_TL

MTL_LOT_CONV_AUDIT

MTL_LOT_CONV_AUDIT_DETAILS

MTL_LOT_ERES_GTMP

MTL_LOT_GRADE_HISTORY

MTL_LOT_UOM_CLASS_CONVERSIONS

MTL_LPN_ATR_QTY_GT

MTL_MOQD_BACKUP

MTL_MWB_GTMP

MTL_ONHAND_LOCK_TEMP

MTL_PICK_SLIP_NUMBERS

MTL_PO_PACKSLIPS

MTL_RMA_SERIAL_TEMP

MTL_SERIAL_NUMBERS_GT

MTL_TRANS_REASON_SECURITY

MTL_UOM_CONVERSIONS_ERES_GTMP

MTL_VMI_QUANTITIES_TEMP

WMS_CARTONIZATION_TEMP

2.4. Changes in Interfaces

Following interfaces tables are changed in R12.

Interface Table Name	Changes In R12(Newly Added Columns)
MTL_ITEM_CATEGORIES_INTERFACE MTL_ITEM_CATEGORIES_INTERFACE table temporarily stores data about inventory item assignments to category sets and categories before loading this information into Oracle Inventory. This table contains user friendly columns which allow you to easily enter your data. Inventory items, category sets and categories participating in an assignment can be entered as corresponding ids or values. If ids are not entered, Oracle Inventory will convert column values to ids. For example, you enter the ORGANIZATION_CODE, ITEM_NUMBER, CATEGORY_SET_NAME, CATEGORY_NAME and Oracle Inventory will fill in the corresponding ORGANIZATION_ID, INVENTORY_ITEM_ID, CATEGORY_SET_ID, CATEGORY_ID for you. After performing the proper validation Oracle Inventory will insert a record into the MTL_ITEM_CATEGORIES table. Description of newly added columns : SOURCE_SYSTEM_ID - Source System Identifier(PIM) SOURCE_SYSTEM_REFERENCE- Source System Reference (PIM) CHANGE_ID- Change Identifier(PIM) CHANGE_LINE_ID- Change Line Indentifier (PIM)	CHANGE_ID
	CHANGE_LINE_ID
	SOURCE_SYSTEM_ID
	SOURCE_SYSTEM_REFERENCE
MTL_ITEM_REVISIONS_INTERFACE MTL_ITEM_REVISIONS_INTERFACE temporarily stores revision levels for an inventory item before loading this information into Oracle Inventory. This table contains user friendly columns which allow you to easily enter your data as well as the corresponding foreign keys. Oracle Inventory will derive column values you do not enter, after performing the proper validation. For example, if you enter the ORGANIZATION_CODE, Oracle Inventory will fill in the corresponding ORGANIZATION_ID. You will need to specify the ITEM_NUMBER column, which is the concatenation of the sytem item segments with the correct delimiter in between. This table is used by the item interface program in conjunction with the MTL_SYSTEM_ITEMS_INTERFACE table. Description of newly added columns : SOURCE_SYSTEM_ID - Source System Identifier(PIM) SOURCE_SYSTEM_REFERENCE- Source System Reference (PIM) CHANGE_ID- Change Identifier(PIM) CHANGE_LINE_ID- Change Line Indentifier (PIM). Template_id - ItemTemplate Identifier TEMPLATE_NAME - Item Template Name	CHANGE_ID
	INTERFACE_TABLE_UNIQUE_ID
	SOURCE_SYSTEM_ID
	SOURCE_SYSTEM_REFERENCE
	TEMPLATE_ID
	TEMPLATE_NAME
MTL_SERIAL_NUMBERS_INTERFACE This is the open interface table of serial information corresponding to material transactions posted to Oracle Inventory. The records in this table have a corresponding parent record in MTL_TRANSACTIONS_INTERFACE. The records in this table will be picked up and validated by the Transaction Manager and then transferred to their respective temporary table for processing. In R12 we have genealogy related enhancements also. From Serial Numbers screen we can also see the corresponding lot number if items is lot enabled and now lot genealogy can also be seen and its serial numbers. Below columns are related to this functionality. Description of newly added columns : PARENT_ITEM_ID- Parent Item Identifier PARENT_OBJECT_TYPE2- Parent Object Type2 PARENT_OBJECT_ID- Genealogy Object Identifier of the Parent entity PARENT_OBJECT_NUMBER- Parent Object Number	PARENT_ITEM_ID
	PARENT_OBJECT_ID
	PARENT_OBJECT_ID2
	PARENT_OBJECT_NUMBER
	PARENT_OBJECT_NUMBER2
	PARENT_OBJECT_TYPE
	PARENT_OBJECT_TYPE2
MTL_SYSTEM_ITEMS_INTERFACE MTL_SYSTEM_ITEMS_INTERFACE temporarily stores the definitions for inventory items, engineering items and purchasing items before loading this information into Oracle Inventory. . This table contains user friendly columns which allow you to easily enter your data as well as their corresponding foreign keys. Oracle Inventory will default column values you do not enter, after performing the proper validation. For example, you enter the ORGANIZATION_CODE, and Oracle Inventory will fill in the corresponding ORGANIZATION_ID for you. It is strongly recommended that users enter the segment information for the item instead of the item number. . You can also specifiy a TEMPLATE_ID to copy item attributes from. . Also, if you enter REVISION, Oracle Inventory will insert a record into MTL_ITEM_REVISIONS for your item. As we know in R12 on the Item Master form lot of new fields are added like retest interval, Expiration Action,Process Manufacturing is the new tab and all its attributes so related to that this table is affected. All the new columns are added with respect to each new item added on the form in Interface table also. Also for DFF where we were having only 15 attributes now it has extended to 30 so attribute16 to 30 are added.	ATTRIBUTE16
	ATTRIBUTE17
	ATTRIBUTE18
	ATTRIBUTE19
	ATTRIBUTE20
	ATTRIBUTE21
	ATTRIBUTE22
	ATTRIBUTE23
	ATTRIBUTE24
	ATTRIBUTE25
	ATTRIBUTE26
	ATTRIBUTE27
	ATTRIBUTE28
	ATTRIBUTE29
	ATTRIBUTE30
	CAS_NUMBER
	CHANGE_ID
	CHANGE_LINE_ID
	CHARGE_PERIODICITY_CODE
	CHILD_LOT_FLAG
	CHILD_LOT_PREFIX
	CHILD_LOT_STARTING_NUMBER
	CHILD_LOT_VALIDATION_FLAG
	CONFIRM_STATUS
	COPY_LOT_ATTRIBUTE_FLAG
	DEFAULT_GRADE
	EXPIRATION_ACTION_CODE
	EXPIRATION_ACTION_INTERVAL
	GLOBAL_TRADE_ITEM_NUMBER
	GRADE_CONTROL_FLAG
	GTIN_DESCRIPTION
	HAZARDOUS_MATERIAL_FLAG
	HOLD_DAYS
	INTERFACE_TABLE_UNIQUE_ID
	ITEM_CATALOG_GROUP_NAME
	LOT_DIVISIBLE_FLAG
	MATURITY_DAYS
	OUTSOURCED_ASSEMBLY
	PARENT_CHILD_GENERATION_FLAG
	PREPOSITION_POINT
	PROCESS_COSTING_ENABLED_FLAG
	PROCESS_EXECUTION_ENABLED_FLAG
	PROCESS_QUALITY_ENABLED_FLAG
	PROCESS_SUPPLY_LOCATOR_ID
	PROCESS_SUPPLY_SUBINVENTORY
	PROCESS_YIELD_LOCATOR_ID
	PROCESS_YIELD_SUBINVENTORY
	RECIPE_ENABLED_FLAG
	REPAIR_LEADTIME
	REPAIR_PROGRAM
	REPAIR_YIELD
	RETEST_INTERVAL
	REVISION_IMPORT_POLICY
	SOURCE_SYSTEM_ID
	SOURCE_SYSTEM_REFERENCE
	SOURCE_SYSTEM_REFERENCE_DESC
	SUBCONTRACTING_COMPONENT
MTL_TRANSACTIONS_INTERFACE MTL_TRANSACTIONS_INTERFACE allows calling applications to post material transactions (movements, issues, receipts etc. to Oracle Inventory transaction module. Transaction Manager concurrent program polls this table at a user-specified process interval, and submits the Transaction Workers to process them. Processing consists of data derivation, validation, and the transfer of records from MTL_TRANSACTIONS_INTERFACE, MTL_TRANSACTION_LOTS_INTERFACE, and MTL_SERIAL_NUMBERS_INTERFACE into their respective temporary tables, from where they are processed by the transaction processor. MTL_TRANSACTIONS_INTERFACE follows the Inventory standard for interfacing flexfields. Any parameters which are represented by flexfields may be entered in the interface table either as code combination identifiers or as flexfield segment combinations. The Transaction Worker will validate that any given identifiers are valid and enabled. If no identifier is given, then the Transaction Worker will validate and decode the flexfield segment values, and where appropriate, create new flexfield combinations in the database. The Transaction Manager picks up the rows to process based on the LOCK_FLAG, TRANSACTION_MODE, PROCESS_FLAG. Only records with TRANSACTION_MODE of '3', LOCK_FLAG of '2', and PROCESS_FLAG of '1' will be picked up by the Transaction Manager and assigned to a Transaction Worker. If a record fails to process completely, then PROCESS_FLAG will be set to '3' and ERROR_CODE and ERROR_EXPLANATION will be populated with the cause for the error. Description of newly added columns : RELIEVE_HIGH_LEVEL_RSV_FLAG- Indicates whether to check for high level reservations that needs to be relieved during transaction processing. RELIEVE_RESERVATIONS_FLAG- Indicates whether to relieve the reservations during transaction processing	RELIEVE_HIGH_LEVEL_RSV_FLAG
	RELIEVE_RESERVATIONS_FLAG
	SOURCE_LOT_NUMBER
	TRANSFER_PRICE

2.5. Changes in APIs

SR No.	API Name	Changes Made
1	INV_ITEM_REVISION_PUB	In API for a record type two new columns are added as template_name,template_id. Which are used in process item revision procedure also a new parameter as p_process_control is added in the procedures to create item revisions,update item revisions
2	INV_ITEM_API	As the columns in the item table has been changed the record types also changed in the API
3	INV_RCV_COMMON_APIS	A new column is added in the record for po startup values as inv_org_id
4	INV_RCV_INTEGRATION_APIS	Two new columns as sec_uom_code,sec_qty are added to record child_record_info .Three columns added to record mol_in_rec as sec_qty,wdd_id,reservation_id.New parameters are added to procedure insert_mtli which inserts records in MTL_TRANSACTION_LOTS_INTERFACE as p_secondary_quantity ,p_origination_type, p_expiration_action_code, p_expiration_action_date,p_hold_date ,p_parent_lot_number, p_reasond_id

2.6. New forms

New form in R12 :

i)Material Status Definitions

SetupàTransactionsàMaterial Status

Here you can specify which transactions are you can restrict.

ii)Maintain Grades:->

SetupàLabel PrintàGrades

This is a grade master form where you can enter all the grades.

iii)Picking Rules Enhancement:->

Setup->Rules->Picking)

iv) Find Serials:->

On hand availability->Serial Numbers->

This screen enables you to find the serial numbers for particular item in an organization based upon your search criterion. You can navigate to Lot genealogy which is new feature.If item is already lot controlled enabled then lot button is enabled on this form.

v) Lot specific conversions:->

Setup->Unit of Measure->Lot specific conversions

Conversion can be created and modified for particular lot numbers. is the new screen.

2.7. New Reports

Following New Reports are added in R12.

Write here the navigation to these reports and 2 line description.

Sr No.	Report Name
1	Consolidate Inventory Onhand Quantites
2	Genealogy Reports
3	Grade Change History Report
4	Inventory Packing Slip
5	Lot Inventory Report
6	Lot Master Report
7	Material Status Definition Report
8	Purchasing Packing Slip

Sr No.	Report Name
1	Grade Change History Report View RequestàSubmit New RequestàSingle Request	This report enables you to view all of the grade changes made during a given time period for a particular item within an organization.
2	Inventory Packing Slip View RequestàSubmit New RequestàSingle Request	You can use the Inventory Packing Slip report to create a packing slip for return to vendor and inter-organization transactions. This report verifies the carrier is not the owner of the shipped goods. This packing slip is issued to transport goods not related to a sale. You can also print a packing slip for the transfer of goods between warehouses that have a user-defined inventory transaction type.
3	Lot Inventory Report View RequestàSubmit New RequestàSingle Request	This reports provides you with an overview of item lots, quantities, and lot statuses in all or the selected subinventories and locators within the organization can be submitted from submit request window can be submitted through submit request window.
4	Lot Master Report View RequestàSubmit New RequestàSingle Request	This report provides you with an overview of the information you set up in the lot master. You can run this report for a specific item, or all items in the organization.can be submitted through submit request window.
5	Material Status Definition Report View RequestàSubmit New RequestàSingle Request	This report provides you an overview of each material status and how it is used. can be submitted through submit request window.
6	Transaction Purge Report View RequestàSubmit New RequestàSingle Request	this report is used to purge transactions within the organization ,can be submitted through submit request window.
7	Create Deferred Logical Transactions ReportsàTransactions	Create Deferred Logical Transactions concurrent request enables you to defer the creation of logical transactions for a pure shipment across multiple operating units.

2.8. New Interfaces

1	INV_MAINTAIN_RESERVATION_PUB	API will handle changes to the resevation record based on the changes to the supply or demand record changes. This Interface will handle changes to the reservation record based on the action code and the supply or demand record changes.
2	INV_LOT_ATTR_PUB	This interface will perform all the validations and update insert related to LOTs like validating retest date, maturity date, hold date ,grade code then inserting UOM, Validating child lot etc.

2.9. New APIs

Following New APIs are added in R12.

1	Consolidate Inventory Onhand Quantites INV_CONSOLIDATE_ONHAND	The quantity is consumed in the order received. If multiple users try to use onhand quantity at the same time, users might experience locks or queues waiting to use the onhand quantity record. A concurrent program was introduced to consolidate Onhand Quantity records for a particular item to reduce the enqueue waits. The consolidation will also remove zero onhand quantity records. This will be done through a concurrent program called "Consolidate Inventory Onhand Quantities".
2	INV_LOT_API_PKG	This API is used to perform following actions It populates the parent and child lot records and returns them to the Create_Inv_Lot procedure.It populates the grade code, origination type, expiration date, retest date, expiration action code, expiration action date,hold date and maturity date based on the values from mtl_system_items for a given organization and inventory item id.It performs the validations on the lot and defaults the missing attributes as per the logic existing in the earlier create_inv_lot procedure.It returns the populate lot record. This Function would be used to check whether the lot number passed exists in the database or not.
3	INV_COPY_ITEM_CP	This procedure submits the Item Import concurrent program. Before submitting the request, it verifies that there are enough workers available and wait for the completion of one if necessary.
4	MTL_CC_SCHEDULE_REQUESTS	This API is used to schedule item in the MTL_CC_SCHEDULE_REQUESTS table after scheduling in the cycle count entries.

Workflow is initiated when any selected date attribute of a lot or serial is within X days of the current date. Default workflow sends notification, but can be customized to support any functionality

Pages

Sunday, August 5, 2012

Oracle R12 Inventory Changes