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
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_ | |
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_ 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. only under serial control. TRANSACTION_ID joins to MTL_TRANSACTION_LOT_NUMBERS. 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_ 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. p_secondary_quantity ,p_origination_type, p_expiration_action_code, p_expiration_action_date,p_ ,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
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. |
2.10. Obsolete Objects
Following Concurrents are no longer use in R12
1) Transfer transactions to GL
Navigation:->View RequestàSubmit Request.
2.11 Others
Material Aging workflow.
Concurrent Request can be scheduled to take action on any date attribute of a lot or serial.
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
No comments:
Post a Comment