Inventory Interface
The Inventory Interface program generates inventory transactions for costing, relieves demand and reservations, and updates inventory balances as you ship orders.
Attention: You can only run the Inventory Interface for those order lines with Source Type set to internal. Order lines with their Source Type set to external will have the Inventory Interface cycle action result set to Not Applicable. Order lines without a Source Type defined will be ignored. See: Overview of Sales Orders, Defining Sales Order Line Scheduling Information, Drop Shipments
Profile Options
The following profile options affect the operation of the Inventory Interface:
- OE: Set of Books - determines currency for the transaction.
- OE: Source Code - three key fields are interfaced to Oracle Inventory to uniquely identify each demand transaction: Order Number, Order Type, and Source Code.
Item Attributes
The following item attributes affect the operation of the Inventory Interface:
- Cost of Goods Sold Account - used if the Account Generator assignment for the Cost of Goods Sold Account includes the item as a source.
- OE Transactable - only items with the attribute set to Yes are interfaced to Inventory.
- Shippable Item - items with the attribute set to Yes are interfaced to Inventory. Items with this item attribute set to No can still be interfaced to Inventory if the OE Transactable item attribute is set to Yes. If both the OE Transactable and Shippable Item item attributes are set to No, then none of the items will be interfaced to Inventory.
- Transactable -- only items with the attribute set to Yes are interfaced to Inventory.
Interfacing Shipments
The Inventory Interface transfers information on the shipped picking lines for any eligible order lines. An order line is eligible for this interface when all prerequisite cycle actions have been successfully completed (usually Ship Confirm - Confirmed). If an order line item is non-shippable, but has shippable included items, the shipped included items are interfaced once the order line is eligible.
Interfacing Non-Shipped Order Lines
If you forecast a non-shippable model or option, the demand placed to consume a forecast is relieved when the non-shippable item is interfaced. The full quantity of the non-shippable item is interfaced when the first associated shippable component is interfaced.
Assigning Ship Dates for Non-Shippable Order Lines
The Inventory Interface program assigns the ship date for non-shippable order lines based on the following rules:
- If a ship date has not been entered for the order, the ship date will be set to Sysdate (the current system date).
- If only one ship date has been entered for the order, the entered date is used for both the non-shippable and shippable order lines.
- If multiple ship dates have been entered for the order, the maximum ship date is assigned to the non-shippable order lines. For example, if you assigned March 1, March 5, and March 9 as ship dates to different order lines, March 9 is assigned to the non-shippable order lines.
Holds Effect on Eligible Order Lines
The Inventory Interface program does not process orders or order lines with unreleased holds that specify no cycle action or a cycle action of Inventory Interface. You must remove any such holds on orders or order lines that you want to interface to Oracle Inventory.
Inventory Interface Without Pick Release and Confirm Shipments
If you include Inventory Interface in an order cycle without Pick Release and Confirm Shipments, the order line schedule details are interfaced instead of the shipped picking lines. Hence, inventory will not be decremented. Inventory will only be decremented if you run Confirm Shipments prior to using the Inventory Interface.
Cost of Goods Sold Account
The Inventory Interface determines the COGS Account for each transaction. You can use the Account Generator to create the COGS Account dynamically, based on one or more attributes such as order type, salesperson, item, and so on. Each COGS Account is validated against the chart of accounts associated with the OE: Set of Books. If the generated COGS Account is valid for the rules for the set of books, the transaction is interfaced. If the COGS Account is not valid, the transaction is rejected, the Inventory Interface status is set to Interface Error and an error message appears on the Process Exception Report.
Inventory Transaction Manager
The Oracle Inventory Material Transaction Manager processes the records Order Entry/Shipping inserts into the interface table. The Material Transaction Manager creates inventory transaction records, updates the inventory balances on shippable items, and relieves demand and/or reservations on both shippable and non-shippable items.
Cycle Action Results
The following cycle action results are possible for the Inventory Interface:
- Eligible - the order line has passed all other cycle actions required to be eligible for Inventory Interface.
- Not Applicable - the item attribute OE Transactable is set to No or the Source Type for the order line is set to external.
- Interfaced - the order line has been completely interfaced.
- Interface Error - an error occurred when the order line schedule detail or picking line was being interfaced. This often means a problem with the COGS Account. The exact error can be identified by running the Process Exception Report.
- Partial - a partial quantity of an order line with multiple schedule details has been interfaced.
Exception Handling
Any errors that occur are recorded in the process exceptions table (SO_EXCEPTIONS). Use the Process Exception Report to report all the errors for the Inventory Interface.
The Inventory Interface program is only applicable for order cycles that include the Inventory Interface cycle action.
Suggestion: Use the View Orders window to view orders' and order lines' cycle statuses.
Prerequisites
Before using this program to transfer inventory information, you should:
- Confirm items you have shipped and backordered using the Confirm Shipments window.
- Satisfy any other order or order line prerequisites that you have defined for the order cycle.
Submission
In the Shipping Interfaces concurrent requests window, enter Inventory Interface in the Name field. If the OE: Immediate Inventory Update profile option is set to Yes, the Inventory Interface program is automatically run when the pick slip or batch is closed. See Order Entry/Shipping Profile Options
Order Entry/Shipping can resubmit this program at a time or time interval you specify at submission time so that inventory information is automatically updated.
Parameters
The Inventory Interface program does not have any parameters.
See Also
Order Cycles
Viewing Orders and Returns
Overview of Delivery-based Ship Confirm
Order Entry/Shipping Profile Options