<Insert Picture Here><Insert Picture Here><Insert Picture Here>

WMS Brownbag Sessions

WMS Inbound Data Flow and Datafix Bugs Analysis (Part 1)Presenters: Wael Amer and Sara Almeda

© 2011 Oracle Corporation – Proprietary and Confidential Slide 2

Agenda

1. Inbound Process Summary

2. Examples Based on Receiving Routings

© 2011 Oracle Corporation – Proprietary and Confidential Slide 3

Clarifications About Serial and Lot Transactions

This session will contain data flow through different tables, in the main diagrams serial and lot transactions are not taken into account for making the explanation simpler. But note the following tables will be involved as child when serial/lot transactions are involved:

If records in RCV_SUPPLY then tables involved:

- rcv_serials_supply

- rcv_lots_supply

If records in RCV_TRANSACTIONS_INTERFACE then tables involved:

- rcv_serials_interface

- rcv_lots_interface

If records in RCV_TRANSACTIONS then tables involved:

- rcv_serial_transactions

- rcv_lot_transactions

© 2011 Oracle Corporation – Proprietary and Confidential Slide 4

Clarifications About Serial and Lot Transactions

If records in MTL_MATERIAL_TRANSACTIONS_TEMP then tables involved:

- mtl_serial_numbers_temp

- mtl_transaction_lots_temp

If records in MTL_MATERIAL_TRANSACTIONS then tables involved:

- mtl_unit_transactions

- mtl_transaction_lot_numbers

If records in MTL_ONHAND_QUANTITIES_DETAIL then tables involved:

- mtl_serial_numbers

- mtl_lot_numbers

© 2011 Oracle Corporation – Proprietary and Confidential Slide 5

Inbound SummaryReceiving Area Inspection Inventory / Stock Area

Routing Type

Direct

Standard

Inspection

New Record in RCV_SUPPLY

New Move Order (Not In Direct Routing)

LPN Generated and Added Content

LPN Context = 3 (In Receiving)

RECEIVE Record in RCV_TRANSACTIONS

ACCEPT/REJECT Record in RCV_TRANSACTIONS

Move Order Inspection Status Populated

LPN Context = 3 (In Receiving)

Cleared Record from RCV_SUPPLY

DELIVER Record in RCV_TRANSACTIONS

Create Material Transaction (MMT) When LPN is Dropped

Create Onhand Record MTL_ONHAND_QUANTITIES_DETAIL

LPN Context = 1 (In Inventory)

No Inspection

Receipt

Receipt

Putaway (Load and Drop)No Inspection

Receipt

Inspection

Putaway (Load and Drop)

MO Allocation Created (MMTT Record)

WMS Tasks Table RecordWhen Loading LPN

© 2011 Oracle Corporation – Proprietary and Confidential Slide 6

Examples Based on Receiving Routing

1. Direct Routing2. Standard Routing3. Inspection Required

 

© 2011 Oracle Corporation – Proprietary and Confidential Slide 7