Resource Transactions with Date in a Closed Period Throws EAM_RESOURCE_TXN_INVALID instead of No entry exists in the WIP_PERIOD_BALANCE (Doc ID 956373.1)

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.

Symptoms

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”.

Cause

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