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 JULY 26, 2017

Applies to:

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

Symptoms

When attempting to run depreciation, the following error occurs:



ERROR
-----------------------
FADEPR module: Depreciation Run log file

APP-OFA-48208: fadatd: asset fetched: has the value of 11888.
Depreciation Program Exception Report
APP-OFA-48208: fadatd: asset fetched: has the value of 11888.
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 11888 ¿t
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)

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms