Oracle Apps: Oracle APPS O2C Cycle

An Order to Cash cycle in an ERP goes through the following steps

Enter the Sales Order
Book the Sales Order
Pick and release the Sales Order lines
Shipping the transaction of the Sales Oder Line
Create the Receivable Invoice
Create the receipt of the payment (manual or auto lock box)
Transfer the accounting detail to General Ledger
Journal Import
Posting

Oracle ERP has the following details from Functional and Technical perspective

Enter the Sales Order:

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

Sales Order Header has two tab 1) main 2) Others

Customer: to enter the Customer Name and Customer account

Customer Bill to/Ship to : Every Customer has certain sites called as Customer Sites ,

each site has Business significance like Bill to site or ship to site or Both .

Order Type : there are different Order Types for kind of business transactions
Standard Order
RMA Order (for Return material Authorization) ,

Drop Ship/Back to Back Order (for external items getting it outside the Organization through PO Requisition and PO)

Price List: Price list is a setup to maintain/create the commercial price of an item to sale to the respective Customer .

In the Others tab, there are certain significance filed like

Payment term: determine the term of the payment , a simple example 30PD which means 30 days after shipping

Enter the Line item

Once click on the Line Items header tab from above screen, it opens a form where in Line item details like Order Item and Order quantity can be entered .

at the bottom there are 4 tabs related to

Actions : where in the ordered item can be scheduled or unscheduled manually .

Related Items : gives the functionality to replace the item with a related item, in case actual Ordered Item is not available with sufficient qty in the warehouse .

Configurator : in case Order Item is a configuration Item like Model Item or ATO (Assemble to Order) or PTO (Pick to Order ), it gives the functionality to choose the peripheral for the Model Item.

Availability: it let you know the availability of the Ordered Item in the warehouse .

Table Affected while entering the Order

OE_ORDER_HEADERS_ALL -- Having details about the Order Header (Header Id is the Primary key)

OE_ORDER_LINES_ALL - it has details about the Order lines , joins the Header_id with the above details

Both the tables are having column called 'FLOW_STATUS_CODE' with value 'Entered'.

Book the Enetered Sales Order

while click on the Book Order button, Order can be booked

Table Affected while entering the Order

OE_ORDER_HEADERS_ALL.flow_status_code will be 'BOOKED'.

OE_ORDER_LINES_ALL.flow_status_code will be 'AWAITING_SHIPPING'

As soon as Order gets booked, it does the entry to the following tables which are related to the Picking and Shipping of an Item.

WSH_DELIVERY_DETAILS , having delivery_detail_id column auto-generated, and delivery_id will be NULL initially .

WSH_DELIVERY_DETAILS.related_status will R (Ready to Release)

If OM module is linked with the Planning , then it run the DEMAND_INTERFACE_PROGRAM in the back ground and insert the record in MTL_DEMAND table, accordingly WIP modules can have Work Order Number and other details to work on the given BOM via following the Routing through which Item gets ready in the Inventory.

Pick and release the Sales Order lines

Navigation: Order Management Super User Operations (USA)>Shipping->Release Sales Order

It has 3 tabs, under Release Criteria , i) Order ii) Shipping iii) Inventory

i) Order: Enter the Order Number and gives the scheduled_ship_Date as today's date .

ii) Shipping: just to avoid the manual picking and release transaction, set the following attribute Yes so that Oracle can auto release the item from the warehouse and generate the delivery id .

iii) Inventory: gives the relevant warehouse also called Inventory Org, along with Sub-inventory and location which are optional , from where the items gets picked and can be released. then press the Execute Now button .

which gets triggered the following Concurrent Programs ,

Pick slip Report , Shipping Exception Report and Auto Pack Report

on successful completion below messages pops up, click on the Ok .

Table Affected while Pick Release the Order

If Auto Create Delivery is set to 'Yes' then its insert a new records in WSH_NEW_DELIVIRIES with a delivery id, which signifies that the inserted item has been picked and released from warehouse and available in dock area for shipping

same delivery id gets populated in the WSH_DELIVERY_ASSIGNMENTS and WSH_DELIVERY_DETAILS .

WSH_DELIVERY_DETAILS.released_status will be 'Y' if Auto Pick Confirm is set to Yes which means 'Pick Confirmed' . else it will be 'S' which means release to warehouse .

If Auto Pick Confirm is set to 'No'

In this case , transact mover order will have to be done manually by following the below steps .

Navigation:

Inventory Super User -> Move Order -> Transact Move Order

enter the Batch Number in the header tab , click on VIEW/UPDATE allocation, then click on the Transact Button.

Ship the Sales Oder Line

Navigation: Order Management Super User Operations (USA)>Shipping->Transactions

Enter the Order Number-> go to Delivery tab -> Click on Ship Confirm

It gets invoked the following Program in the background

Interface TRIP STOP , Packing Slip Report , Commercial Invoice and Bill Of Lading .

after the successful transaction of the shipping the final status will be closed as above .

Table Affected after Shipping Transactions

OE_ORDER_HEADERS_ALL.flow_Status_code will be Closed

OE_ORDER_LINES_ALL.flow_Status_code will be Shipped

WSH_DELIVERY_DETAILS.released_Status will be 'C' completed

Create the Receivable Invoice

Navigation: Order Management Super User Operations (USA)>View->Requests

run the Work Flow Background Process, which insert the record in RA_INTERFACE_LINES_ALL table which is the Oracle Interface table to import the AR invoice in the EBS .

with the following columns values

RA_INTERFACE_LINES_ALL.interface_line_context = 'ORDER_ENTRY'

RA_INTERFACE_LINES_ALL.interface_line_attributex = order number

RA_INTERFACE_LINES_ALL.interface_line_attributex = line id

RA_INTERFACE_LINES_ALL.interface_line_attributex = delivery_id

here 'x' is the number 1,2,3 which depends upon the setup

then run the Auto Invoice Master program which spawn Auto Invoice import Program, which refers the record from RA_INTERFACE_LINES_ALL table and import the AR invoice in the EBS table .

to view the Invoice

Navigation: Receivable Super User -> Transactions -> Transactions

Table Affected after Invoice creation

RA_CUSTOMER_TRAX_ALL

RA_CUST_TRX_LINES_ALL

create the receipt of the payment (manual )

Navigation: Receivable Super User -> Receipts-> Receipts

Table Affected after Invoice creation

AR_CASH_RECEIPTS_ALL

Transfer the accounting detail to General Ledger

Navigation: Receivable Super User ->View Requests

Run General Ledger Transfer Program

Table Affected

GL_INTERFACE

Journal Import

Run the Journal Import program, which will refer the data form GL_INTERFACE table and create the journal entry into GL .

Source: Select the appropriate Source, in this case it will be Receivable

Selection Criteria: belongs to a specific group , no group or all the group id , default will be all the group id belongs to the source

Run Option:

'Post Error to Suspense' is meant for posting any error while importing the journal into suspense account .

'Create Summary Journal ' gives the option to create the summary report of all imported journal into GL on basis of same account , currency , period and debit/credit balance .

Date Range: Pass the Date range to import the Journal

Import Descriptive Flex Field: No/With Validation/Without Validation