APP-FND-01564 ORACLE error 1403 in fdxwho




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.

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...