I found this link very useful and informative to learn Oracle Advanced Pricing.
http://download.oracle.com/docs/cd/E18727_01/doc.121/e13427/toc.htm
Thursday, June 9, 2011
Friday, June 3, 2011
Oracle Order Capture - an Overview.
I would say Order Capture is a virtual module in Oracle CRM. The application code for Oracle Order Capture is ASO.
Order capture is mainly used by Oracle iStore and Oracle Quoting modules. Order capture is a set of APIs being used by these modules in converting the Cart or Quote to Sales order.
The IBE or QOT purely depends on the ASO to convert the cart or quote to Sales Order in Order Management.
The two important tables in ASO,
ASO_QUOTE_HEADERS_ALL
ASO_QUOTE_LINES_ALL
ASO_QUOTE_HEADERS_ALL -- Will have the header level details for Cart or Quote
ASO_QUOTE_LINES_ALL -- will have the line level details for Cart or Quote.
When the Quote or Cart is converted to Sales order, the data from ASO_QUOTE_HEADERS_ALL flows to OE_ORDER_HEADERS_ALL and the data from ASO_QUOTE_LINES_ALL flows to OE_ORDER_LINES_ALL.
ASO_PRICE_ADJUSTMENTS is the another important table which stores the adjustments(modifier) details on the cart or Quote.
There are status column in the ASO headers table to identify the status of the Quote or Cart and the source column to identify the source of the Quote.
Order capture is mainly used by Oracle iStore and Oracle Quoting modules. Order capture is a set of APIs being used by these modules in converting the Cart or Quote to Sales order.
The IBE or QOT purely depends on the ASO to convert the cart or quote to Sales Order in Order Management.
The two important tables in ASO,
ASO_QUOTE_HEADERS_ALL
ASO_QUOTE_LINES_ALL
ASO_QUOTE_HEADERS_ALL -- Will have the header level details for Cart or Quote
ASO_QUOTE_LINES_ALL -- will have the line level details for Cart or Quote.
When the Quote or Cart is converted to Sales order, the data from ASO_QUOTE_HEADERS_ALL flows to OE_ORDER_HEADERS_ALL and the data from ASO_QUOTE_LINES_ALL flows to OE_ORDER_LINES_ALL.
ASO_PRICE_ADJUSTMENTS is the another important table which stores the adjustments(modifier) details on the cart or Quote.
There are status column in the ASO headers table to identify the status of the Quote or Cart and the source column to identify the source of the Quote.
OM - Receivables (Non invoiceable item)
OM - Receivables ( Non invoiceable item )
The non invoiceable item when added to the Sales order will not be interfaced to AR. The INVOICE_INTERFACE_STATUS_CODE for the non invoiceable item is set to NOT_ELIGIBLE when the SO is posted to AR.
The non invoiceable item when added to the Sales order will not be interfaced to AR. The INVOICE_INTERFACE_STATUS_CODE for the non invoiceable item is set to NOT_ELIGIBLE when the SO is posted to AR.
Subscribe to:
Comments (Atom)