My Oracle Support Banner

Suggestions to Improve Performance when Booking Orders (Doc ID 473754.1)

Last updated on JULY 12, 2021

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
FORM:OEXOEORD.FMB - Sales Orders


Goal

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:
       - MRP_ATP_SCHEDULE_TEMP
       - MRP_ATP_DETAILS_TEMP
    4. Ensure "MSC" schema is analyzed at frequent interval

Solution

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
Goal
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.