Oracle R12 O2C Steps
Oracle R12 O2C Steps
Oracle R12 O2C Steps
erpSchools
https://erpschools.com/erps/articles/order-to-cash-cycle 1/22
6/10/22, 11:58 AM order to cash process in oracle apps
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.
https://erpschools.com/erps/articles/order-to-cash-cycle 3/22
6/10/22, 11:58 AM order to cash process in oracle apps
Now that the Order is BOOKED, the status on the header is change
accordingly.
At this stage:
‘BOOKED’
https://erpschools.com/erps/articles/order-to-cash-cycle 4/22
6/10/22, 11:58 AM order to cash process in oracle apps
‘AWAITING_SHIPPING’.
into MTL_DEMAND
Navigation: Shipping > Release Sales Order > Release Sales Orders.
https://erpschools.com/erps/articles/order-to-cash-cycle 5/22
6/10/22, 11:58 AM order to cash process in oracle apps
https://erpschools.com/erps/articles/order-to-cash-cycle 6/22
6/10/22, 11:58 AM order to cash process in oracle apps
Pick Release process in turn will kick off several other requests like Pick
Slip Report,
https://erpschools.com/erps/articles/order-to-cash-cycle 7/22
6/10/22, 11:58 AM order to cash process in oracle apps
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
In the HEADER tab, enter the BATCH NUMBER (from the above step) of
the order. Click FIND. Click on VIEW/UPDATE Allocation, then Click
TRANSACT button. Then Transact button will be deactivated then just
close it and go to next step.
https://erpschools.com/erps/articles/order-to-cash-cycle 8/22
6/10/22, 11:58 AM order to cash process in oracle apps
https://erpschools.com/erps/articles/order-to-cash-cycle 9/22
6/10/22, 11:58 AM order to cash process in oracle apps
https://erpschools.com/erps/articles/order-to-cash-cycle 10/22
6/10/22, 11:58 AM order to cash process in oracle apps
Create Invoice:
https://erpschools.com/erps/articles/order-to-cash-cycle 11/22
6/10/22, 11:58 AM order to cash process in oracle apps
INTERFACE_LINE_ATTRIBUTE1= Order_number
INTERFACE_LINE_ATTRIBUTE3= Delivery_id
and spawns Auto invoice Master Program and Auto invoice import
program which creates Invoice for that particular Order.
https://erpschools.com/erps/articles/order-to-cash-cycle 12/22
6/10/22, 11:58 AM order to cash process in oracle apps
Underlying tables:
Create receipt:
https://erpschools.com/erps/articles/order-to-cash-cycle 13/22
6/10/22, 11:58 AM order to cash process in oracle apps
https://erpschools.com/erps/articles/order-to-cash-cycle 14/22
6/10/22, 11:58 AM order to cash process in oracle apps
Underlying tables:
AR_CASH_RECEIPTS_ALL
Parameters:
Give in the Start date and Post through date to specify the date range of the
transactions to be transferred.
Specify the GL Posted Date, defaults to SYSDATE.
Post in summary: This controls how Receivables creates journal entries for your
transactions in the interface table. If you select ‘No’, then the General Ledger
Interface program creates at least one journal entry in the interface table for
each transaction in your posting submission. If you select ‘Yes’, then the
program creates one journal entry for each general ledger account.
If the Parameter Run Journal Import is set to ‘Yes’, the journal import program
is kicked off automatically which transfers journal entries from the interface
https://erpschools.com/erps/articles/order-to-cash-cycle 15/22
6/10/22, 11:58 AM order to cash process in oracle apps
table to General Ledger, otherwise follow the topic Journal Import to import
the journals to General Ledger manually.
Underlying tables:
Journal Import:
Parameters:
https://erpschools.com/erps/articles/order-to-cash-cycle 16/22
6/10/22, 11:58 AM order to cash process in oracle apps
No Group ID: To import all data for that source that has no group ID.
Use this option if you specified a NULL group ID for this source.
All Group IDs: To import all data for that source that has a group ID.
Use this option to import multiple journal batches for the same source
with varying group IDs.
If you do not specify a Group ID, General Ledger imports all data from
the specified journal entry source, where the Group_ID is null.
• one journal line for all transactions that share the same account,
period, and currency and that has a debit balance
• one journal line for all transactions that share the same account,
period, and currency and that has a credit balance.
Enter a Date Range to have General Ledger import only journals with
accounting dates in that range. If you do not specify a date range, General
Ledger imports all journals data.
Choose whether to Import Descriptive Flexfields, and whether to import them
with validation.
Underlying tables:
Posting:
Query for the unposted journals for a specific period as shown below.
https://erpschools.com/erps/articles/order-to-cash-cycle 18/22
6/10/22, 11:58 AM order to cash process in oracle apps
From the list of unposted journals displayed, select one journal at a time
and click on Post button to post the journal.
https://erpschools.com/erps/articles/order-to-cash-cycle 19/22
6/10/22, 11:58 AM order to cash process in oracle apps
If you know the batch name to be posted you can directly post using the
Post window
https://erpschools.com/erps/articles/order-to-cash-cycle 20/22
6/10/22, 11:58 AM order to cash process in oracle apps
Underlying tables:
GL_BALANCES.
https://erpschools.com/erps/articles/order-to-cash-cycle 21/22
6/10/22, 11:58 AM order to cash process in oracle apps
https://erpschools.com/erps/articles/order-to-cash-cycle 22/22