My Oracle Support Banner

R12.1: Depreciation Fails On CIP Asset with APP-OFA-47697 Unable to Insert into FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY Tables (Doc ID 1496975.1)

Last updated on OCTOBER 12, 2022

Applies to:

Oracle Assets - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


When attempting to run depreciation, the following error occurs:

FADEPR module: Depreciation Run log file

APP-OFA-48208: fadatd: asset fetched: has the value of ####.
Depreciation Program Exception Report
APP-OFA-48208: fadatd: asset fetched: has the value of ####.
APP-OFA-48208: fadatd: has the value of and book is fetched.
APP-OFA-48208: fadatd: has the value of calling fadpaa.
APP-OFA-48208: fadatd: method has the value of UNIT OF PROD.
APP-OFA-48208: fadatd: life has the value of 0.
APP-OFA-48208: fadpaa: before faddha: method: has the value of UNIT OF PROD.
APP-OFA-48208: fadpaa: before fadaid: method: has the value of .
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
APP-OFA-48152: Asset number ####
APP-OFA-47715: Error: function fadatd returned failure (called from faddep)
APP-OFA-47697: Error: Unable to insert into FA_DEPRN_DETAIL and FA_DEPRN_SUMMARY tables
Cause: You have a database problem.
Action: Contact your system administrator.
APP-OFA-47715: Error: function faddep returned failure (called from FADEPR)




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
 Still Have Questions?

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