TABLES & PROFILE OPTIONS ARE USED WITH THE MOVE ORDER FUNCTION

TABLES

1. MTL_TXN_REQUEST_HEADERS
This table stores all of the move order headers. The headers contain all information which pertains to entire move orders, including the transaction type of the move order, the move order type, the move order status, and the request number of the move order.


2. MTL_TXN_REQUEST_LINES
The table MTL_TXN_REQUEST_LINES stores all of the move order lines. The lines are requests to move some quantity of an item from a source location to a destination location or account. Each move order line must be tied to a specific move order header.When a line is detailed or pick released, the quantity detailed is updated appropriately and transaction lines are created in MTL_MATERIAL_TRANSACTIONS_TEMP. When the transaction lines are transacted, the quantity delivered is updated.


PROFILE OPTION

TP:INV Move Order Transact Form

This profile options will be set at Site Level with Following Possible values

On-line processing
Concurrent processing
Background processing

By Deafult it will be Online Processing

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.

Oracle Purchasing with Other Oracle Applications Modules

Oracle Purchasing with Other Oracle Applications Modules

Oracle Purchasing integrates with a number of other Oracle Applications modules, including:

· Oracle Order Entry

· Oracle Inventory

· Oracle Work flow

· Oracle Material Resource Planing

· Oracle Projects

· Oracle Human Resources

· Oracle Alert

· Oracle Quality

· Oracle EDI Gateway

· Oracle General Ledger

Oracle Order Entry

Once the internal requisition has been approved and interfaced to Order Entry, the sales order must proceed through the order cycle. This includes pick release, ship confirm, and inventory interface processing (not Supplier), which can automatically create internal sales orders in Oracle Order Entry. Internal sales orders are those that are ordered from another organization within your own company. The organization that fulfills the order is the selling organization, while the organization with the purchase requisition is the buying organization.

Oracle Inventory

Purchasing increases Inventory’s on-hand balance when POs are received and delivered. Internal requisitions, mentioned above, also affect demand once the item has been reserved and depletes the shipping organization’s on-hand balance once it has been shipped.

Oracle Work flow

There are two areas where Oracle Purchasing integrates with Oracle Work flow. The first is Account Generator, with a work flow process that defines the business rules in which account combinations are generated. The second area consists of some seeded approval work flow processes. These work flow processes read the approval business rules and hierarchies you set up in Oracle Purchasing, and they drive purchasing documents such as purchase requisitions and purchase orders through defined approval business rules and hierarchies.

Oracle Material Resource Planing

The material planning process in Oracle Material resource planing automatically generates purchase requisitions for raw materials (goods) or outside processing (services).

Oracle Projects

When you buy goods and/or services for a particular project, Oracle Purchasing, which allows you to capture project information on purchasing documents, integrates with Oracle Projects.

Oracle Human Resources

Oracle Purchasing shares employees and positions information with Oracle Human Resources. The two also share position hierarchies if approvals in Oracle Purchasing and Human Resources are set up to use the same position hierarchies.

Oracle Alert

Oracle Purchasing has some seeded alerts to help monitor exceptions and buyer performances, get notified with releases and expirations against planned and/or blanket purchase orders, and identify potential forecast overconsumption.

Oracle Quality

You can capture quality data, which will be automatically stored in Oracle Quality, during receiving. You can also make the capturing of quality data mandatory in Oracle Purchasing.

Oracle EDI Gateway

Oracle EDI gateways offers EDI capability to Oracle Purchasing. Supported purchasing EDI transactions in Oracle EDI gateways are Inbound Price/Sales Catalog (832), Inbound Response to Request for Quote (843), Inbound Ship Notice/Manifest (856), Inbound Shipping and Billing Notice (857), Outbound Planning Schedule (830), Outbound Shipping Schedule (862), Outbound Purchase Order (850), and Outbound Purchase Order Change request (860).

Oracle General Ledger

Oracle Purchasing posts encumbrance entries and receipt accrual entries to Oracle General Ledger.