Search over 500+ Posts

Nov 17, 2011

Quote vs Order in Oracle Order Management.



In Oracle Order management we have option to create Sales Order from Sales Quote ( for more info plese refer my earlier post Quote to Order flow  ).During this flow system will create only 1 record for Quote Header as well as for each line in the Quote, by that I mean when we creates the Quote , data for Quote header/lines got inserted into oe_order_headers_all/oe_order_lines all , and once Quote got converted into Order, same data will be used for order header /lines,only difference are
1.Flow Status Code  for Order header will be updated to "Entered", plus
2.For Quote, system insert the data into workflow tables like

  • wf_items and wf_item_activity_statuses with item_type ='OENH' , but once Quote got approved and converted to Orders , system will end_date the workflow with item_type ='OENH' and creates new workflow with item_type ='OEOH'( for order header) and OEOL (for order lines).
Please note that in Quotes there is no workflow for Order lines.


Nov 3, 2011

Defaulting Rules not working



Defaulting Rule 

When ever we define a new defaulting rule , we need to compile the Defaulting API by means of executing Generate Defaulting Handler so that new condition added in the defaulting API.

Once setup for defaulting rule is complete , follow below steps compile the defaulting API .
  1. Navigate to the Defaulting Rule UI.
  2. Tools >>  Generate Defaulting Handler package
  3. Make sure concurrent program "Defaulting Generator" , completed successfully.
Hope that helps