O2C Process Flow in Oracle Fusion

O2C Process Flow in Oracle Fusion --OM / INV / AR / SLA / GL

Enter Sales Order  --OM 

Submit the Order --OM

Create Pick Wave --Inv

Pick  Confirm  --Inv

Ship Confirm --OM

--Data Reaches to RA_INTERFACE_LINES table with source system  as DOO //SFDC/SAP

Create AR Transactions /Invoice -- by running  Import Receivables Transactions Using AutoInvoice

it will trigger below child programs 

Import AutoInvoice

Import AutoInvoice: Execution Report

Notify Feeder System of Receivables Transactions

it will insert records into AR transactions base tables  

Header  --RA_CUSTOMER_TRX_ALL  pk CUSTOMER_TRX_id

  Lines   --RA_CUSTOMER_TRX_LINES_ALL  pk -CUSTOMER_TRX_LINE_ID  fk  CUSTOMER_TRX_id

      Distributions  --RA_CUST_TRX_LINE_GL_DIST_ALL  pk-CUST_TRX_LINE_GL_DIST_ID   

                      fk CUSTOMER_TRX_LINE_ID , CUSTOMER_TRX_id











AR cash Receipt -- 

Apply Receipt to Invoice   --ra_receivable applications_all  

SLA (Sub-Ledger)    --Account Entries

General Ledger    --Journal Creation /Posting 

High-Level Flow:

O2C process starts with sales order, booking the order, creating a pick wave, confirm pick slips and then the ship confirmation. 

So, from Sales Order to Shipconfirm creation of the Sales order process involved and delivery of the product involved.

After the shipping is done, we will generally creating AR Invoice, AR Reeccipts and then post it to GL.

For example ; If we want to book any item in the Amazon web site, we will first we will sign up and create account by entering the customer details.

Also, we will mention for which location we want to deliver the item and for which address we want to bill.

Bill-To-Address

Ship-To-Address

And then we will choose the products like mobile devices and book the order for it.

The next will be Order will be confirmed

After that the respective vendor(Amazon) fulfils the order that we placed.

Meaning Amazon will send the order details to manufacturer nothing but inventory transactions like

Inventory, pick wave, confirm the pick slips and ship confirm.

Also, bill will be generated(items booked, tax deduction amount,total amount need to be paid)

Once the customer paid the invoice and Amazon receives the payment, Cash receipt will be generated against the invoice.

All the transaction will be entered into accounting and then post them to General Ledger.

-------------------

Order-to-Cash (O2C) Process Overview

The Order-to-Cash (O2C) flow is the end-to-end process of entering a sales order into the system, delivering the goods, and invoicing the customer.

1. Order Entry and Booking

The process begins when an order is entered into the system. This entry includes essential details such as the customer, ship-to and bill-to addresses, payment terms, order type, price list, unit price, and warehouse. Once this information is finalized, the order is booked and proceeds through the defined workflow.

2. Shipping Execution

If an item is ready for shipment and quantities are available, the shipping execution phase begins:

Pick Wave: Shipment lines are grouped into a "pick wave"—a batch of items released together based on specific business criteria.

Pick Release: This action generates a move order. Items are then moved from their subinventory to a staging area.

Ship Confirm: Once the items are staged and placed on a delivery vehicle, the ship confirm process is executed to finalize the departure.

3. Billing and Invoicing

Following shipment, the AutoInvoice process imports invoices, credit memos, and on-account credits from external systems into Oracle Fusion Receivables. These invoices are then generated, printed, and sent to the customer for payment.

4. Receipt and Payment

When the payment is received, a receipt is generated and posted within the Receivables sub-ledger.

5. General Ledger (GL)

Finally, the accounting entries for both the AR invoice and the receipt are transferred to the General Ledger journal to ensure the company's financial records are updated and synchronized.

====================

Navivation:

Log into SCM_IMPL Account

Go to Order Management-->Order Management.

Click on Order Management

Click on Create Order

Click on Add the line.

Untill unless we click on save, it will generate any of the Sales Order Number.

Select FedEx Air Priority Overnight

Provide the warehouse: 001 Seatle

And then click on Save.

Create Order: Business World - 98578 - Draft

Click on Submit

Click on Ok

Now, we can see here: 

Header level the Order Status shows as "Processing" and Line Level it says "Not Started".

Wait for some time and click on Refresh button

We can see that Status shows as : Awaiting for Shipping. Means item is available waiting to ship.

Now, go to Home. Click on Supply Chain Execution and click on Inventory Management(Classic)

Under Inventory and click on Picks

Click on Create Pick Wave.

Now, go to Pick Confirm

Enter the Order Number 95878

Click on Search

Choose 225539 's item and click on confirm

Click on Manage Shipments

Got to two errors 

enter description

enter transport reason

118200

The above is the ship confirm number.

Now, checked line level it says shipped

As it is already interfaced, we can ignore the above message.

Not getting ready for Awaiting billing for a long time.

 SELECT dha.order_number, dla.line_number || '~' || dfl.FULFILL_LINE_NUMBER sales_order_line_line, 

dla.line_number, dfl.FULFILL_LINE_NUMBER,

         dha.CUSTOMER_PO_NUMBER, dha.ORDER_TYPE_CODE, dle.ATTRIBUTE_CHAR14 Quote_Number, 

dfle.attribute_char7 IPN,

dha.Header_id, dla.Line_id, to_char(dfl.FULFILL_LINE_ID) FULFILL_LINE_ID

     FROM DOO_HEADERS_ALL dha, 

      DOO_LINES_ALL dla,

      DOO_FULFILL_LINES_ALL dfl,

  DOO_LINES_EFF_B dle, 

  doo_fulfill_lines_eff_b dfle

WHERE dla.Header_id = dha.Header_id

  AND dfl.Line_Id = dla.Line_id 

  AND dla.LINE_ID = dle.LINE_ID (+)

  AND dle.CONTEXT_CODE (+) = 'Additional Line Information'

  AND dfle.fulfill_line_id (+) = dfl.fulfill_line_id

  AND dfle.CONTEXT_CODE (+) = 'Additional Line Information'

ShipMent tables 

                                     SELECT wnd.delivery_name,

                                            wdd.source_header_number

                                     FROM   wsh_new_deliveries wnd,

                                            wsh_delivery_assignments wds,

                                            wsh_delivery_details wdd

                                     WHERE  1=1--wdd.source_header_number =

                                     AND    wdd.delivery_detail_id = wds.delivery_detail_id

                                     AND    wds.delivery_id = wnd.delivery_id

for success case: 

Click Here

To Watch Full Cycle of Order to Cash(O2C)

                                                        Click Here