Order Entry:
OE_ORDER_HEADERS_ALL
At the time of Order entry, the Flow_Status_Code is ‘Entered’
OE_ORDER_LINES_ALL
OE_PRICE_ADJUSTMENTS – when discount gets applied
OE_ORDER_PRICE_ATTRIBS – if line has price attributes
OE_ORDER_HOLDS_ALL – if any hold applied for order like Credit check etc…
Header_id is the link between OE_ORDER_HEADERS_ALL and OE_ORDER_LINES_ALL tables.
Order Booking:
WSH_DELIVERY_DETAILS
WSH_DELIVERY_ASSIGNMENTS
When the Order is Booked, the Flow_Status_Code in OE_ORDER_HEADERS_ALL will be ‘Booked’ and the Flow_Status_Code in OE_ORDER_LINES_ALL will be ‘Awaiting Shipping’.
New records will be created in WSH_DELIVERY_DETAILS with Released_Status=’R’ (Ready to Release). Also Record(s) will be inserted into WSH_DELIVERY_ASSIGNMENTS.
Launch Pick Release:
Flow_status_code in OE_ORDER_HEADERS_ALL will be ‘Picked’ or ‘Awaiting Shipping’ depending on Auto Pick Confirm (set to No or Yes)
Released_Status in WSH_DELIVERY_DETAILS will be ‘S’ (Submitted for Release) or ‘Y’ (Pick Confirmed). These values again depend on the parameters given at Auto Pick Confirm (set to No or Yes)
WSH_DELIVERY_ASSIGNMENTS - Delivery_ID is populated here (from Delivery_Detail_ID with reference to WSH_DELIVERY_DETAILS table)
MTL_TRANSACTIONS_INTERFACE is updated with Sales order Pick transaction.
Ship Confirm:
Data from MTL_TRANSACTIONS_INTERFACE is moved to MTL_MATERIAL_TRANACTIONS and MTL_MATERIAL_TRANSACTIONS is updated with Sales Order Issue transaction.
Flow_status_code in OE_ORDER_LINES_ALL will be ‘Shipped’
Released_Status in WSH_DELIVERY_DETAILS will be ‘C’ (means shipped)
Creating Invoices in Receivables:
Workflow Background Process inserts new records in RA_INTERFACE_LINES_ALL table.
Auto Invoice Master Program transfers the data from RA_INTERFACE_LINES_ALL to the following tables,
RA_CUSTOMER_TRX_ALL: Stores Invoice header information.
RA_CUSTOMER_TRX_LINES_ALL: Stores Invoice lines information.
Creating Receipt:
AR_CASH_RECEIPTS_ALL
Flow_status_code in OE_ORDER_LINES_ALL should be ‘CLOSED’
---X---
No comments:
“