Order Management Integration With Oracle Inventory Module

Order Management integrates with Oracle Inventory Management in the following areas:

Managing reservations

Order Management calls Inventory’s reservation APIs to manage reservations. You can create reservations to on-hand quantities from the Sales Orders form. You can also go to Inventory reservation form the Sales Orders form and create a reservation to any level of inventory

(Sub-inventory, locator, lot).When supply is created for an ATO configuration (for a configuration item); it is reserved to a Work Order. This reservation gets transferred to on-hand

When the work order is completed, thus reserves the Order line to on-hand. For every Order created, Order Management creates a record in MTL_SALES_ORDERS, an entity that Inventory uses to manage demand from various sources. Reservation information is stored in MTL_RESERVATIONS. Reservation records for order Lines point to both MTL_SALES_ORDERS and OE_ORDER_LINES_ALL.

Customer-Item Cross reference

You can use Oracle Inventory to set-up Customer Items and Customer Item Cross reference information. You can then place orders using those pre-defined customer item identifiers. Order Management calls the Inventory API INV_CUSTOMER_ITEM_GRP to derive the internal item based on the specified customer item, ship-to site and the warehouse on the Order Line.

The Item Identifier Type on the Order Line indicates the Cross-reference Type that was used for placing the order. The Ordered Item tracks identifier that was used to place the order.

One thought on “Order Management Integration With Oracle Inventory Module

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s