Discrete Manufacturing - EBS (MOSC)

MOSC Banner

UPDATE WIP_REQUIREMENT_OPERATIONS SET QUANTITY_BACKORDERED = 0 WHERE WIP_ENTITY_ID = :B1, deadlock

edited Nov 23, 2012 6:15AM in Discrete Manufacturing - EBS (MOSC) 1 commentAnswered ✓

Hi Experts

In 12.1.3.

MRP and Oracle ERP are split server.

UPDATE WIP_REQUIREMENT_OPERATIONS SET QUANTITY_BACKORDERED = 0 WHERE WIP_ENTITY_ID = :B1
DUMP LOCAL BLOCKER: initiate state dump for DEADLOCK

 SELECT JOBS.ROWID, JOBS.WIP_ENTITY_ID, JOBS.ORGANIZATION_ID FROM WIP_REQUIREMENT_OPERATIONS OPS, WIP_DISCRETE_JOBS JOBS, MRP_RELIEF_INTERFACE MRP WHERE OPS.WIP_ENTITY_ID (+) = JOBS.WIP_ENTITY_ID AND OPS.ORGANIZATION_ID (+) = JOBS.ORGANIZATION_ID AND MRP.DISPOSITION_TYPE = :B7 AND MRP.RELIEF_TYPE = :B6 AND MRP.REQUEST_ID = :B5 AND MRP.PROCESS_STATUS = :B4 AND MRP.ERROR_MESSAGE IS NULL AND MRP.INVENTORY_ITEM_ID = DECODE(:B3 ,:B2 , MRP.INVENTORY_ITEM_ID, :B3 ) AND MRP.ORGANIZATION_ID = DECODE(:B1 ,:B2 ,MRP.ORGANIZATION_ID, :B1 ) AND JOBS.PRIMARY_ITEM_ID = MRP.INVENTORY_ITEM_ID AND JOBS.ORGANIZATION_ID = MRP.ORGANIZATION_ID AND JOBS.WIP_ENTITY_ID = MRP.DISPOSITION_ID FOR UPDATE OF JOBS.MPS_NET_QUANTITY, OPS.MPS_REQUIRED_QUANTITY ORDER BY JOBS.ORGANIZATION_ID, JOBS.WIP_ENTITY_ID

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

EBS Discrete Mfg Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center