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 11.5.10.2 to 11.5.10.2 [Release 11.5]
Oracle Work in Process - Version 11.5.10.2 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
Form:WIPDJMDF.FMB - Define Discrete Job
Form:EAMWOMDF.FMB - EAM Work Order Definition
Symptoms
Actual Behavior
When a Work Order is created shortly after a period is opened, transactions against the work order will error.
Error
Missing record for WO in WIP_PERIOD_BALANCE table
Expected Behavior
The transactions should process without error.
Steps
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |