Order to Cash Cycle (Explained in detail)
Step#1 - Creating Customer
Order Management Super User - Navigation: Customer/Standard
Enter Customer name
Table affected – HZ_CUST_ACCOUNTS (account_number is customer number, cust_account_id is id)
HZ_CUST_ACCT_SITES_ALL (linked to HZ_CUST_ACCOUNTS.cust_account_id)
HZ_CUST_SITE_USES_ALL will determine site usage like bill to ship to etc.
(Linked as HZ_CUST_ACCT_SITES_ALL.cust_acct_site_id)
Click on ship to site and enter the defaults like order type, price list and warehouse
Step#2 - Creating Item
Inventory- Navigation: Items/Master Item
Table affected – MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS
Copy from template tools – copy from –purchased item
Assigning locator control
Organization assignment - Assigning it to M1.
Please note here
In the Vision Demo instance, the Purchasing and Order Management Attributes are controlled at Item Master level. By choosing the attributes at the item master level (V1) automatically sets these attributes for all organizations which are assigned (ex. M1 and M2). By choosing the attributes at the Item Master level - they are already set for all inventory organizations assigned.
Step#3 create onhand inventory for the item created
Inventory- Navigation: transactions/Miscellaneous Transaction
Table affected – MTL_ONHAND_QUANTITIES_DETAIL
Change the organization as M1 and then do the miscellaneous receipt
Enter subinventory and locator (remember item is locator controlled) and account as miscellaneous and save the record
Check the On-hand quantity for your item.
- Navigate to Inventory > On-hand, Availability > On-hand Quantity
- Enter your item in the Query Material screen and click on Find.
- Verify that the On-hand quantity exists.
Step#4 Create Price List and assign item to price list
Oracle Pricing Manager Vision operations - Navigation: Price Lists/Price List Setup
Table affected – QP_LIST_HEADERS, QP_LIST_LINES, QP_PRICING_ATTRIBUTES
Create price list as ORATEST_PRICELIST
Add item to price list
Product Context: Item
Product Attribute : Item Number
Product Value : ORATEST_ORDER_ITEM
Value : 100
Product Attribute : Item Number
Product Value : ORATEST_ORDER_ITEM
Value : 100
Step#4 Defaulting Rule
Defaulting rules determine the values that you want to get defaulted into a sales order to reduce the amount of information you need to enter manually.
You could create and modify defaulting rules, in which case the Defaulting Generator concurrent program needs to be run.
Order Management Super User- Navigation: Rules/Defaulting
Examine the setup from the following screenshot. This is saying that when entering a sales order, the Order Type will default to the value set up at the Invoice To, Ship To, and finally the Customer, wherever it is found first in that sequence.
Now you can default the order type to the customer site, does mean whenever you get the order created against this site the order will be Mixed as its defaulted from customer Site.
Step#5 Creating an Order
Order Management Super User- Navigation: Orders Returns/Sales Orders
Table affected –
· OE_ORDER_HEADERS_ALL (FLOW_STATUS_CODE, BOOKED_FLAG, HEADER_ID)
· OE_ORDER_LINES_ALL (LINE_ID, OE_ORDER_HEADERS_ALL.HEADER_ID, FLOW_STATUS_CODE)
FLOW_STATUS_CODE = ENTERED
As soon as you create order note the order type, price lists and warehouse are getting defaulted from customer site
Note here order line status will be ENTERED and once you book the order it will be BOOKED
Table affected –
· OE_ORDER_HEADERS_ALL (FLOW_STATUS_CODE as BOOKED, BOOKED_FLAG updated to Y)
· OE_ORDER_LINES_ALL (FLOW_STATUS_CODE as AWAITING_SHIPPING, BOOKED_FLAG updated Y)
· WSH_DELIVERY_DETAILS (DELIVERY_DETAIL_ID is assigned here, RELEASED_STATUS ‘R’ ready to release, LINE_ID comes as SOURCE_LINE_ID)
In shipping transaction form order status remains "Ready to Release".
Reserving the order-
You can either do auto allocate or manually reserve the order by opening order lines and tools- reservation details.
Enter subinventory, lot, locator reservations.
Table affected –
· MTL_DEMAND and MTL_RESERVATIONS table get updated. LINE_ID gets updated in DEMAND_SOURCE_LINE_ID in both the tables.
Step#6 Pick Release the Order
Order Management Super User- Navigation: Shipping/Release Sales Orders/Release Sales Orders
Table affected –
· WSH_NEW_DELIVERIES (one record gets inserted with SOURCE_HEADER_ID= order header ID, STATUS_CODE=OP =>open)
· WSH_DELIVERY_ASSIGNMENTS (DELIVERY_ID gets assigned which comes from WSH_NEW_DELIVERIES)
· WSH_DELIVERY_DETAILS (RELEASED_STATUS ‘S’ ‘submitted for release’)
Pick confirmed
· OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘PICKED’ )
· WSH_DELIVERY_DETAILS (RELEASED_STATUS becomes ‘Y’ => ‘Released’ )
In the Order tab, enter your order number
Under Inventory tab enter warehouse as M1 and auto allocate as Yes
Shipping tab. Set the following value if it is not defaulted.
Autocreate Delivery = Yes
Auto Pick Confirm = Yes
Autocreate Delivery = Yes
Auto Pick Confirm = Yes
Click on the Concurrent button.
Once submitted Pick selection List generation will run in background, this is the concurrent program will will do pick release of the sales order.
Step#7 Ship Confirm the Order
Order Management Super User- Navigation: Shipping/Transactions
Table affected –
· OE_ORDER_LINES_ALL (FLOW_STATUS_CODE ‘shipped’)
· WSH_DELIVERY_DETAILS (RELEASED_STATUS ‘C’ ‘Shipped’)
· Data deleted from MTL_DEMAND, MTL_RESERVATIONS
· Item deducted from MTL_ONHAND_QUANTITIES
Once completed the order line status will be staged/pick confirmed
Go to the Delivery tab and click the Ship Confirm button. In the Confirm Delivery window, accept the default parameters and click on OK.
Once clicked OK Interface trip stop (ITS) will run automatically deferring ITS (checking this box) means you need to run the concurrent in a separate step(Shipping > Interfaces > Run (Interface Trip Stop - SRS)).
ITS will actually do the inventory reduction for the item
So if you navigate to Inventory > Transactions > Material Transactions
You will see the transaction type as Sales Order Issue
This is the Inventory Transaction that happened when the item was shipped out of the warehouse M
Sales Order Pick, are for the move order transaction that happened automatically during Pick Release
Until ITS is not completed the order status will be Shipped
Once ITS completes order status will change to interfaced
Once the order is shipped the status or the order line will show as shipped
To make it closed we need to run Workflow Background process
Once Workflow background process completes order status will be closed and the order then will be transferred to Receivables by which you can create an invoice.
Step#7 Invoice Creation
Receivables Vision Operations - Navigation: Control/AutoInvoice/Interface Lines
Table affected –
SELECT * FROM RA_INTERFACE_LINES_ALL WHERE INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND INTERFACE_LINE_ATTRIBUTE1 =<Order_number>
Once the order is closed you can see its eligible for invoicing by querying Sales order number in interface lines
Run the Auto invoice
Receivables Vision Operations - Navigation: Interfaces/AutoInvoice
Pass on the Invoice Source
Invoice source – you can find the exact invoice source by looking the order management /setup/transaction types.
For example invoice source for transaction type mixed is ORDER ENTRY
Once the auto invoice completes ok you can see the invoice generated.
Table affected –
select * from ra_customer_trx_lines_all where interface_line_attribute1 =<Order_number>
Here the O2C cycle end