APP-FND-01564 ORACLE error 1403 in fdxwho

GLXOCPER: Open Close Periods Help-Record History: APP-FND-01564 Oracle Error 1403 in Fdxwho [ID 1322961.1]

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Setup forms and programs

When attempting to use Help-Record History on the "open/close period" form the following error occurs.

APP-FND-01564 ORACLE error 1403 in fdxwho
Cause: fdxwho failed due to ORA-01403: no data found

The issue can be reproduced at will with the following steps:

1. Go to Setup > Open / Close
2. Query a closed period
3. Use Help -> Record History
4. Error comes up

Changes

Upgrade from 11i to R12

Cause

Data corruption due to upgrade SLA bug 9098523

Solution

To avoid this issue , download and apply patch 11829821:R12.XLA.B.
This delivers fixed file xlaugspes.sql version 120.29.12010000.7 which would avoid the corruption during the upgrade.

To fix the existing corrutpion in the upgraded instance you need to execute a datafix.
If you want to fix this data please log a Service Request to ask support for the datafix.