Resource Transactions with Date in a Closed Period Throws EAM_RESOURCE_TXN_INVALID instead of No entry exists in the WIP_PERIOD_BALANCE
Last updated on MARCH 18, 2016
Applies to:Oracle Enterprise Asset Management - Version 12.0.4 to 12.0.6 [Release 12]
Information in this document applies to any platform.
Find that you are able to enter a resource into a closed period it eventually errors in the pending resources that No entry exists in the WIP_PERIOD_BALANCE
Expect there to be an error on the front end
The issue can be reproduced at will with the following steps:
1. Access the “Charge Time” at Self Service Asset Management”, the resource appointment is allowed for dates in inventory monthly period closed.
2. This transaction starts an error on the “Pending Resource Transactions”.
3. The error message is: “Record not found in WIP_PERIOD_BALANCE. Cause: There is no record in WIP_PERIOD_BALANCES for the repetitive schedule or job. Action: Contact Oracle Support Representative”.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms