Scribd
Upload
72 views2 pages

Order To Cash (O2C) Cycle With in Oracle Apps

Uploaded by

PRAVEEN

The Order to Cash cycle in Oracle Apps involves 8 steps: 1) Entering a sales order 2) Booking the sales order 3) Launching pick release 4) Shipping confirmation 5) Creating an invoice 6) Creating receipts 7) Transferring to the general ledger 8) Posting. It affects various tables in the Oracle Apps database to update order, shipping, billing, and accounting records as the order progresses through the fulfillment and payment process.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt

Order To Cash (O2C) Cycle With in Oracle Apps

Uploaded by

PRAVEEN
72 views2 pages
The Order to Cash cycle in Oracle Apps involves 8 steps: 1) Entering a sales order 2) Booking the sales order 3) Launching pick release 4) Shipping confirmation 5) Creating an invoice 6) Creating receipts 7) Transferring to the general ledger 8) Posting. It affects various tables in the Oracle Apps database to update order, shipping, billing, and accounting records as the order progresses through the fulfillment and payment process.

Original Title

Order to Cash

Copyright

© © All Rights Reserved

Available Formats

DOCX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

The Order to Cash cycle in Oracle Apps involves 8 steps: 1) Entering a sales order 2) Booking the sales order 3) Launching pick release 4) Shipping confirmation 5) Creating an invoice 6) Creating receipts 7) Transferring to the general ledger 8) Posting. It affects various tables in the Oracle Apps database to update order, shipping, billing, and accounting records as the order progresses through the fulfillment and payment process.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
72 views2 pages

Order To Cash (O2C) Cycle With in Oracle Apps

Uploaded by

PRAVEEN
The Order to Cash cycle in Oracle Apps involves 8 steps: 1) Entering a sales order 2) Booking the sales order 3) Launching pick release 4) Shipping confirmation 5) Creating an invoice 6) Creating receipts 7) Transferring to the general ledger 8) Posting. It affects various tables in the Oracle Apps database to update order, shipping, billing, and accounting records as the order progresses through the fulfillment and payment process.

Copyright:

© All Rights Reserved
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 2

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

You might also like