Root Cause Fix: Missing Record In WIP_PERIOD_BALANCES and CST_INVALID_WIP Errors - Most Current or Recent Root Cause Fix
(Doc ID 1416033.1)
Last updated on JANUARY 12, 2023
Applies to:Oracle Enterprise Asset Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Work in Process - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Enterprise Asset Management - Version 188.8.131.52 to 184.108.40.206 [Release 11.5]
Oracle Work in Process - Version 220.127.116.11 to 18.104.22.168 [Release 11.5]
Information in this document applies to any platform.
Form:WIPDJMDF.FMB - Define Discrete Job
Form:EAMWOMDF.FMB - EAM Work Order Definition
When a Work Order is created shortly after a period is opened, transactions against the work order will error.
Missing record for WO in WIP_PERIOD_BALANCE table
The transactions should process without error.
Scenario 1 (For Work In Process):
1. In the month end when the user open the next month period on last day of the month (31-DEC-2011 4.11.30pm)
2. Then another user create WO with release status at almost same time (31-DEC-2011 4.11.56pm).
3. The system fails to insert the record in WIP_PERIOD_BALANCE for that particular WO
Scenario 2 (for Enterprise Asset Management):
1 thru 3. See Scenario #1.
4. The issue happens if the user change the WO status from Draft/ unreleased to released while period open is ongoing
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