O2C Cycle involves following steps
1.Order Entry and Booking
There are three types of Order
i) Standard Sales Order
ii) Return Sales Order
iii) Mixed Sales Order
Tables Affected :
Important Column in this tables are HEADER_ID,LINE_ID,LINE_TYPE_ID,LINE_NUMBER and FLOW_STATUS_CODE.
When user enter sale order and save the record at that time FLOW_STATUS_CODE='ENTERED' and when he book the sales order it will changes to FLOW_STATUS_CODE='AWAITING_SHIPPING'.
2.Shipping Transaction
This steps involve following actions
i) Launch Pick Release
Pick Release Process run the following concurrent requests
Auto Pack Report,Pick Slip Report,Shipping Exceptions Report.
iii) Move Order Transaction
iv) Ship Confirm
When you perform Ship Confirm then it will run the concurrent programs like INTERFACE TRIP STOP, Commercial Invoice, Packing Slip Report, Bill of Lading
3.Submit AR Auto Invoice Master Program to Generate AR Invoice.
4.To transfer tax from Sales order to AR Invoice Submit Request India - Local Concurrent For Processing Order Lines to AR.
5.If Excise and Vat invoice numbers are not got transferred with AR Invoices then Submit the request India - Importing Excise/VAT Invoice Numbers in AR to transfer Excise/Vat No
6.Money Receipt.
7.Application of Money Receipt with AR Invoice.
8.Adjustment of Invoices if any.
9.Refund of Money to Customer.
1.Order Entry and Booking
There are three types of Order
i) Standard Sales Order
ii) Return Sales Order
iii) Mixed Sales Order
Tables Affected :
OE_ORDER_HEADERS_ALL
Important Column in this tables are HEADER_ID, ORG_ID,ORDER_TYPE_ID,ORDER_NUMBER,SOLD_TO_ORG_ID,INVOICE_TO_ORG_ID and FLOW_STATUS_CODE.
When user enter sale order and save the record at that time FLOW_STATUS_CODE='ENTERED' and when he book the sales order it will changes to FLOW_STATUS_CODE='BOOKED'.
OE_ORDER_LINES_ALLImportant Column in this tables are HEADER_ID,LINE_ID,LINE_TYPE_ID,LINE_NUMBER and FLOW_STATUS_CODE.
When user enter sale order and save the record at that time FLOW_STATUS_CODE='ENTERED' and when he book the sales order it will changes to FLOW_STATUS_CODE='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
At the same time DEMAND INTERFACE PROGRAM runs in the background and inserts into MTL_DEMAND.
2.Shipping Transaction
This steps involve following actions
i) Launch Pick Release
Pick Release Process run the following concurrent requests
Auto Pack Report,Pick Slip Report,Shipping Exceptions Report.
Tables Affected:
If Auto create Delivery is set to ‘Yes’ then a new record is created in the table WSH_NEW_DELIVERIES
DELIVERY_ID is populated in the table WSH_DELIVERY_ASSIGNMENTS
The
RELEASED_STATUS in WSH_DELIVERY_DETAILS would be now set to ‘Y’ (Pick
Confirmed) if Auto Pick Confirm is set to Yes otherwise RELEASED_STATUS
is ‘S’ (Release to Warehouse).
ii) Allocation of Move Order iii) Move Order Transaction
iv) Ship Confirm
When you perform Ship Confirm then it will run the concurrent programs like INTERFACE TRIP STOP, Commercial Invoice, Packing Slip Report, Bill of Lading
Tables Affected:
RELEASED_STATUS in WSH_DELIVERY_DETAILS would be ‘C’ (Ship Confirmed)
FLOW_STATUS_CODE in OE_ORDER_HEADERS_ALL would be 'BOOKED'
FLOW_STATUS_CODE in OE_ORDER_LINES_ALL would be 'SHIPPED'
Once all background process completes, the Shipping Transaction Status in Lines/LPNs tab becomes Interfaced
3.Submit AR Auto Invoice Master Program to Generate AR Invoice.
4.To transfer tax from Sales order to AR Invoice Submit Request India - Local Concurrent For Processing Order Lines to AR.
5.If Excise and Vat invoice numbers are not got transferred with AR Invoices then Submit the request India - Importing Excise/VAT Invoice Numbers in AR to transfer Excise/Vat No
6.Money Receipt.
7.Application of Money Receipt with AR Invoice.
8.Adjustment of Invoices if any.
9.Refund of Money to Customer.
