Inventory Items (APC/PLM/PIM) - EBS (MOSC)

MOSC Banner

delete component reference designators performance issue

edited Dec 6, 2012 6:40PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 5 commentsAnswered ✓

Hi experts:

 

In 12.1.3

In BOM,when delete one component reference designators take 4 min.

DELETE FROM BOM_REFERENCE_DESIGNATORS
WHERE
COMMON_COMPONENT_SEQUENCE_ID = :B2 AND COMPONENT_REFERENCE_DESIGNATOR = :B1

call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------
Parse        1      0.00       0.00          0          0          0           0
Execute      1     23.51     237.57     436306     438907         81           0
Fetch        0      0.00       0.00          0          0          0           0
------- ------  -------- ---------- ---------- ---------- ----------  ----------
total        2     23.51     237.57     436306     438907         81           0

Create an index , the issue solved.

But we want a patch to solve this issue, Which file need to upgrade to high version can solve this issue?

This script include in which package?


Thanks
Fengling

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center