ASCP Planners Workbench Show Slow Performance Expanding Pegging Details (Doc ID 427659.1)

Last updated on JANUARY 03, 2023

Applies to:

Symptoms

On 11.5.10 find that attempting to view pegging information in the ASCP planners workbench shows very bad performance.

The issue can be reproduced at will with the following steps:

1. Use aresponsibility such as Advanced Supply Chain Planner
2. Navigate to supply/chain workbench and select an item
3. click on Supply Pegging to see pegging details for the item

The trace file shows :

SELECT SR_TP_ID
FROM
MSC_TRADING_PARTNERS WHERE SR_INSTANCE_ID = :b1 AND ORGANIZATION_CODE = :b2

call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
Execute 255 0.08 0.11 0 0 0 0
Fetch 255 347.48 2005.64 1435685 1840080 0 255
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total 511 347.56 2005.77 1435685 1840080 0 255

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 173 (APPS)

Rows Row Source Operation
------- ---------------------------------------------------
255 TABLE ACCESS FULL OBJ#(40123)

Rows Execution Plan
------- ---------------------------------------------------
0 SELECT STATEMENT GOAL: CHOOSE
255 TABLE ACCESS GOAL: ANALYZED (FULL) OF 'MSC_TRADING_PARTNERS'  

Cause

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