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

MOSC Banner

When Assign Master items to child organization , run DELETE FROM DR$WAITING , why

edited Feb 27, 2013 7:07PM in Inventory Items (APC/PLM/PIM) - EBS (MOSC) 3 commentsAnswered ✓

Hi experts

In 12.1.3.

In master items form, assign item to child organization , the performance is poor. Generate trace file see that following SQL take more time. Why assign item to child organization need to run following script?

SQL ID: 1xjwug6sa5g2d
Plan Hash: 1546474621
DELETE FROM DR$WAITING
WHERE
 WTG_CID = :B2 AND WTG_PID = :B1 AND EXISTS (SELECT 1 FROM DR$PENDING WHERE
  DR$PENDING.PND_CID = DR$WAITING.WTG_CID AND DR$PENDING.PND_PID =
  DR$WAITING.WTG_PID AND DR$PENDING.PND_ROWID = DR$WAITING.WTG_ROWID)


call     count       cpu    elapsed       disk      query    current        rows
------- ------  -------- ---------- ---------- ---------- ----------  ----------

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