Depreciation Errors With ‘App-Fnd-01564: Oracle Error 1403 in Fadatd’ After Changing Life of the Assets (Doc ID 2944240.1)

Last updated on APRIL 25, 2023

Applies to:

Symptoms

When attempting to run depreciation after changing the life of some assets, the following error occurs.

ERROR

APP-OFA-47715: Error: function fazccmt returned failure (called from fadais)
APP-OFA-47715: Error: function fadaid returned failure (called from fadpaa)
APP-OFA-47715: Error: function fadpaa returned failure (called from fadatd)
APP-FND-01564: ORACLE error 1403 in fadatd

Cause: fadatd failed due to ORA-01403: no data found
  .
The SQL statement being executed at the time of the error was: and was executed from the file .
APP-OFA-47180: Error: FETCHing cursor &CURSOR



STEPS

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

1. Fixed Assets Responsibility
2. Change the life of the asset - through custom process
3. Run the depreciation. FA > Depreciation> Run Depreciation

Changes

 Life of the assets has been changed to a new life through custom process

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.