Suggestions to Improve Performance when Booking Orders
(Doc ID 473754.1)
Last updated on JULY 12, 2021
Applies to:Oracle Order Management - Version 126.96.36.199 to 188.8.131.52 [Release 11.5.10]
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders
The slow performance while booking an order is influenced by setup involving scheduling, tax calculation, and MRP: Calculate Supply Demand is On
Optimizing Performance for the Order Management Booking Process
There are a number of variables to consider when trying to
improve performance for booking, such as, tax calculation, pricing strategy, hold definitions, etc.
Configuring the system to defer scheduling requires the following steps:
•= Turn AutoScheduling Off
•= Ensure the Schedule Date is not populated by Default Rules or manually entered
•= Modify the Line Process Flow to Defer Scheduling.
If Tkprof file shows the top 3 expensive SQL statements are:
1. begin OE_OEOL_SCH.SCHEDULE_LINE (:v1, :v2, :v3, :v4, :v5); end;
2. begin UTX_AR_LINK.INV_TAX_GET; end;
3. INSERT INTO MSC_ATP_SD_DETAILS_TEMP ( ATP_LEVEL, ORDER_LINE_ID, SCENARIO_ID,
INVENTORY_ITEM_ID, REQUEST_ITEM_ID, ORGANIZATION_ID, DEPARTMENT_ID,
Research on each of these statements suggests the following be reviewed/ changed.
1. <Note 130511.1>-PERFORMANCE Issues In OM, SE, QP;
Parts: 4. Scheduling during Order/Line Creation
and 5. Deferred Scheduling
For more information on deferring scheduling please review the Technical Brief
'Optimizing Performance for the Order Management Booking Process ' on Metalink:
Top Tech Docs -> E-Business Suite: ERP -> Order Management -> Technical Brief
2. <Note 130511.1>-PERFORMANCE Issues In OM, SE, QP; 9. Deferring Tax Calculation
With Order Management Pack G, users can now setup the TAX calculation
point on Order Type. If they set it to INVOICING then OM will defer the
tax calculation and users will see improvement in saving order lines.
3. Bug 3840076 - PERFORMANCE DURING PLACING ORDER
Please change following setup and re-try performance:
1. Set MRP: Calculate Supply Demand to "No".
2. Set MSC: ATP Debug Mode to "None".
3. Ensure following tables are purged frequently based on data volume:
4. Ensure "MSC" schema is analyzed at frequent interval
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document