Order to Cash (O2C) Cycle in Oracle Apps

Order to Cash (O2C) Cycle with in Oracle Apps

• Enter the Sales Order
• Book the Sales Order
• Launch Pick Release
• Ship Confirm
• Create Invoice
• Create the Receipts 
• Transfer to General Ledger
• Journal Import
• Posting

1. Enter the Sales Order:

Navigation: Order Management Super User Operations (USA)>Orders Returns >Sales Orders

Enter the Customer details (Ship to and Bill to address), Order type.

Click on Lines Tab. Enter the Item to be ordered and the quantity required.

Table Affected :

OE_ORDER_HEADERS_ALL

OE_ORDER_LINES_ALL

FLOW_STATUS_CODE in both table is ‘Entered’

2. Book the Sales Order:

Book the Order by clicking on the Book Order button.

Table Affected :

OE_ORDER_HEADERS_ALL -> FLOW_STATUS_CODE value will be ‘BOOKED’

OE_ORDER_LINES_ALL -> FLOW_STATUS_CODE value will be ‘AWAITING_SHIPPING’.

3. Launch Pick Release:

Navigation: Shipping > Release Sales Order > Release Sales Orders.

Key in Based on Rule and Order Number
In the Shipping Tab key in the below:
Auto Create Delivery: Yes
Auto Pick Confirm: Yes
Auto Pack Delivery: Yes
In the Inventory Tab:
Auto Allocate: Yes
Enter the Warehouse
Click on Execute Now Button
Table Affected: 
WSH_NEW_DELIVERIES
WSH_DELIVERY_ASSIGNMENTS
WSH_DELIVERY_DETAILS -> RELEASED_STATUS value will be ‘Y’ (Pick Confirmed) OR ‘S’ (Release to Warehouse).

4. Ship Confirm the Order:

Navigation: Order Management Super User>Shipping >Transactions.

Query with the Order Number.

Click On Delivery Tab

Click on Ship Confirm.

The Status in Shipping Transaction screen will now be closed.

Table Affected :

WSH_DELIVERY_DETAILS -> RELEASED_STATUS value will be ‘C’ (Ship Confirmed)

OE_ORDER_HEADERS_ALL-> FLOW_STATUS_CODE value will be “BOOKED”

OE_ORDER_LINES_ALL-> FLOW_STATUS_CODE value will be “SHIPPED”

5. Create Invoice:
Run workflow background Process.
Navigation: Order Management >view >Requests
Table Affected :
RA_INTERFACE_LINES_ALL
Column INTERFACE_LINE_CONTEXT value will be ‘ORDER ENTRY’
Column INTERFACE_LINE_ATTRIBUTE1 will populate ORDER_NUMBER value.
Column INTERFACE_LINE_ATTRIBUTE3 will populate Delivery_id value.

Then Run Auto invoice Master Program and Auto invoice import program which creates Invoice for that particular Order.
The Invoice created can be seen using the Receivables responsibility
Navigation: Receivables Super User> Transactions> Transactions
Table Affected :
RA_CUSTOMER_TRX_ALL -> INTERFACE_HEADER_ATTRIBUTE1 will show order number value
RA_CUSTOMER_TRX_LINES_ALL

7. Create receipt:
Navigation: Receivables> Receipts> Receipts

Enter the information.
Click on Apply Button to apply it to the Invoice.
Table Affected :
AR_CASH_RECEIPTS_ALL

8. Transfer to General Ledger:
To transfer the Receivables accounting information to general ledger, run General Ledger Transfer Program.
Navigation: Receivables> View Requests
Query program : "General Ledger Transfer Program" Pass the parameter and submit program.
Table Affected : 
GL_JE_HEADERS
GL_JE_LINES
GL_JE_BATCHES
GL_BALANCES