My Oracle Support Banner

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:

Oracle Assets - Version 12.0.0 and later
Information in this document applies to any platform.


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


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


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


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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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