O2C Technical Flow

Order to Cash cycle

In this article, we will go through the Order to Cash cycle. The below are the steps in short:

·         Enter the Sales Order

·         Book the Sales Order

·         Launch Pick Release

·         Ship Confirm

·         Create Invoice

·         Create the Receipts either manually or using Auto Lockbox ( In this article we will concentrate on Manual creation)

·         Transfer to General Ledger

·         Journal Import

·         Posting

enter the Order

Header Order Table Name   :                              OE_ORDER_HEADERS_ALL

Line Order Table Name         :                              OE_ORDER_LINES_ALL

FLOW STATUS CODE          :                      FLOW_STATUS_CODE

Sales order header

Select * from OE_ORDER_HEADERS_ALL where Order # ‘66396‘

FLOW_STATUS_CODE in OE_ORDER_HEADERS_ALL is ‘Entered’

Sales order Lines

Select * from OE_ORDER_LINES_ALL where Header_ID = ‘191320’

FLOW_STATUS_CODE in OE_ORDER_LINES_ALL is ‘Entered’

Additional Order header:

Deliveries: Pick status: Blank

BOOK THE ORDER

Sales order header

Select * from OE_ORDER_HEADERS_ALL where Order # ‘66396‘

FLOW_STATUS_CODE in OE_ORDER_HEADERS_ALL is ‘BOOKED’

Sales order Lines

Select * from OE_ORDER_LINES_ALL where Header_ID = ‘191320’

FLOW_STATUS_CODE in OE_ORDER_LINES_ALL is ‘Awaiting_Shipping’

Additional Order header:

Deliveries: Pick status: Ready to Release

Delivery details & Released status code:

Select * from WSH_DELIVERY_DETAILS where SOURCE_HEADER_ID= ‘191320’

REALEASED_STATUS_CODE in OE_ORDER_LINES_ALL is ‘R’

RELASE SALES ORDER

Select * from MTL_TXN_REQUEST_HEADERS Where Request_Number # ‘3904035‘

Select * from MTL_TXN_REQUEST_LINES HEADER_ID # ‘3904035‘

REALEASED_STATUS_CODE in OE_ORDER_LINES_ALL is ‘Y’

Additional Order header:

Deliveries: Pick status: Ready to Release

Bill of lading: How much amount you are going to generate

Vehicle load sheet details: What are the item you are going to load in vehicle

InterfaceTrip Stop : What is first and what is the last stop and Trips . For one stop how many trip are there

Packing slip: Item list need to pack it for customer.

Commercial invoice: Invoice will generate

Additional header information:

·         There won’t be any reservation for this order after ship confirm:

·                                  

Material Transaction:

Inventory to staging area, staging area to transportation

Data is interfaced:

Workflow Background process