Root Cause Fix: Missing Record In WIP_PERIOD_BALANCES and CST_INVALID_WIP Errors - Most Current or Recent Root Cause Fix
Last updated on DECEMBER 20, 2016
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 220.127.116.11 to 18.104.22.168 [Release 11.5]
Oracle Work in Process - Version 22.214.171.124 to 126.96.36.199 [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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms