Order to Cash (O2C) Cycle in Oracle Apps Technical

Order to Cash:

• Enter the sales order
• Book the sales order
• Launch pick release
• Ship confirm
• Create Invoice
• Create Receipt
• Transfer to GL
• Journal Import
• Posting 

Enter the sales order:

Navigation: Order Management Super User ->Orders Returns -> Sales Orders

Enter the Customer details (Ship to and Bill to address), Order type and line details under lines tab.

In OE_ORDER_HEADERS_ALL-> Flow_status_code = “Entered”

Book the sales order:

Under same page Book the Order by clicking on the Book Order button.

OE_ORDER_HEADERS_ALL —> Flow_status_code =“BOOKED”

OE_ORDER_LINES_ALL—> Flow_Status_code = “AWAITING_SHIPPING”

Record will be created into “WSH_DELIVERY_ASSIGNMENTS” MTL_DEMAND

WSH_DELIVERY_ASSIGNMENTS —> Released_Status = ‘R’ (read to release)

Launch Pick Release:

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

If auto create delivery is set to ‘YES’ then new record will be created in WSH_NEW_DELIVERIES.

delivery_id is populated with WSH_DELIVERY_ASSIGNMENTS in

 WSH_DELIVERY_DETAILS = ‘Y’ (pick confirm)

                                                   ’S’ (Release to warehouse)

Ship Confirm the order:

Navigation: Order Management Super User>Shipping >Transactions.

Query with the Order Number.

Now click on delivery tab and confirm the shipment.

OE_ORDER_HEADERS_ALL —> Flow_status_code= “booked”

OE_ORDER_LINES_ALL —> Flow_Status_code = “Shipped”

WSH_DELIVERY_DETAILS —> release_status = C (ship confirm)

Create Invoice:

Run workflow background Process

Navigation: Order Management >view >Requests

Workflow Background Process inserts the records RA_INTERFACE_LINES_ALL with

INTERFACE_LINE_CONTEXT     =     ‘ORDER ENTRY’

INTERFACE_LINE_ATTRIBUTE1=     Order_number

INTERFACE_LINE_ATTRIBUTE3=     Delivery_id

and runs 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

Query with the Order Number as Reference.

RA_CUSTOMER_TRX_ALL will have the Invoice header information.

The column INTERFACE_HEADER_ATTRIBUTE1 will have the Order Number.

RA_CUSTOMER_TRX_LINES_ALL will have the Invoice lines information.

The column INTERFACE_LINE_ATTRIBUTE1 will have the Order Number.

CREATE RECEIPT:

Navigation: Receivables> Receipts> Receipts

After entering the receipt information you could see the information in AR_CASH_RECEIPTS_ALL

TRANSFER:

In Release 12,  “General ledger transfer program” and Journal Import is no longer used. we are using Submit Accounting program instead this spawns Revenue Recognition Process.

POSTING:

After Posting we can see the data in GL_BALANCES.

Over View:

OE_ORDER_HEADERS_ALL—> Flow_ststus_code= Entered

                                                                                     = Booked

OE_ORDER_LINES_ALL —> Flow_status_code = “Awaiting_shipping”

                                                                                   =“Shipped”

WSH_DELIVERY_DETAILS—>Released_Status = “R” (Read to release - book sale order)

                                                               = “Y” (Pick Confirm -launch pick release)

                                                               = “S” (Release to warehouse - launch pick rel)

                                                               = “C” (ship confirm - Ship confirm)

Table Joins between OM, AR and GL

OM and AR

oe_order_lines_all.header_id = ra_customer_trx_all.interface_line_attribut6

AR and GL

Ra_cust_trx_line_gl_dist_all.code_combination_id= code_combination_id.gl_code_combinations.