O2C – Order To Cash Flow

	oe_order_headers_all  flow_status_code = entered oe_order_lines_all flow_status_code= entered order number is generated
	oe_order_headers_all flow_status_code = booked booked_flag= Y –updated oe_order_lines_all  flow_status_code = awaiting shipping, booked_flag = Y- updated wsh_new_deliveries  status_code = OP [open] wsh_delivery_details  released_status = R [ready to release] At the same time DEMAND INTERFACE PROGRAM runs in the background and inserts into MTL_DEMAND
	SCHEDULE ORDER PROGRAM runs in the background Once the program successfully get completed then quantities are reserved and MTL_RESERVATIONS table get updated.
Navigation:Shipping > Release Sales Order > Release Sales Orders Order Tab Based on Rule and Order Number Shipping Tab Auto Create Delivery: Yes Auto Pick Confirm: Yes Auto Pack Delivery: Yes Inventory Tab: Auto Allocate: Yes Enter the Warehouse Click on Execute Now Button	pick release SRS program runs in background Pick Release program kick off other requests like Pick Slip Report, Shipping Exception Report and Auto Pack Report Once the program successfully get completed then items on the sales order are taken out from inventory. oe_order_lines_all flow_status_code = PICKED wsh_delivery_details released_status = S [submitted ] and DELIVERY_ID is populated in wsh_delivery_assignments. And move order tables.Here request is generated to move item from saleble to staging sub inventory mtl_txn_request_headers mtl_txn_request_lines Now link to above tables through move_order_header_id/line_id To Mtl_material_transactions_temp Table
IF Auto Pick Confirm in the above step is set to NO, then the following should be done Navigation: Inventory Super User > Move Order> Transact Move Order	Items are transferred from saleble to staging Subinventory. mtl_material_transactions mtl_transaction_accounts wsh_delivery_details released_status = Released wsh_delivery_assignments
Navigation: Order Management Super User>Shipping >Transactions Query with the Order Number Click On Delivery Tab Click on Ship Confirm. Now the Status in Shipping Transaction screen will be closed. and This will kick off concurrent programs like. INTERFACE TRIP Stop, Commercial Invoice, Packing Slip Report, Bill of Lading	Here ship confirm interface program runs in background . Data removed from wsh_new_deliveries oe_order_lines_all flow_status_code = shipped wsh_delivery_details  released_status = C [Shipped] oe_order_Headers_all flow_status_code = Booked mtl_transaction_interface mtl_material_transactions(linked through Transaction source header id) mtl_transaction_accounts Data deleted from mtl_demand,mtl_reservations Item deducted from mtl_onhand_quantities

Create Invoice:Run workflow background Process. Navigation: Order Management >view >Requests		This is also called Receivables interface that mean information moved to accounting area for invoicing details. To create Invoices Run workflow background process then Invoicing workflow activity transfers shipped item information to Oracle Receivables. ra_interface_lines_all (interface table into which the data is transferred from order management) interface_line_context = ’order entry’ interface_line_attribute1= order_number interface_line_attribute3= delivery_id Then Autoinvoice program imports data from this Interface table which get affected into this stage are receivables base table. ra_customer_trx_all  cust_trx_id is primary key to link it to trx_lines table and trx_number is the invoice number ra_customer_trx_lines_all line_attribute_1 and line_attribute_6 are linked to header_id (or order number) and line_id of the orders
	In this stage order line leval table get updated with Flow status and open flag. oe_order_lines_all  flow_status_code = shipped open_flag will be updated
	This is last step of Order Processing . In this stage only oe_order_lines_all table get updated. oe_order_lines_all (flow_status_code closed open_flag These are the typically data flow of a order to cash model for a standard order.

1. The Invoice created can be seen using the Receivables responsibility

Navigation: Receivables Super User> Transactions> Transactions

• Query with the Order Number as Reference.

2. Create receipt:

Navigation: Receivables> Receipts> Receipts

• Enter the information.
• Click on Apply Button to apply it to the Invoice
• Underlying tables: AR_CASH_RECEIPTS_ALL

3. Transfer to General Ledger:

To transfer the Receivables accounting information to general ledger, run General Ledger Transfer Program.

Navigation: Receivables> View Requests

This transfers data about of invoices and receipts to the GL_INTERFACE table

4. Journal Import:

To transfer the data from General Ledger Interface table to General Ledger, run the Journal Import program from Oracle General Ledger.

Navigation:General Ledger > Journal> Import> Run

Underlying tables:GL_JE_BATCHES, GL_JE_HEADERS, GL_JE_LINES

5. Posting:

We have to Post journal batches that we have imported previously to update the account balances in General Ledger.

Navigation:General Ledger> Journals > Enter

Query for the unposted journals for a specific period as shown below.

Underlying tables:GL_BALANCES.