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).
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
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
Nicely explained
ReplyDeletenice
ReplyDeletevery nice sir
ReplyDeleteYou actually make it seem so easy with your presentation but I find this topic to be really something which I think I would never understand. It seems too complicated and extremely broad for me. I’m looking forward to your next post, I will try to get the hang of it!
ReplyDeletewe buy cars
cash for scrap cars melbourne
Thank you sir. It's really explained very well by you
ReplyDelete