Depreciation (FADEPR) Error 'APP-OFA-47314: Error in routine IAC:Do_Depreciation' For IAC-Enabled Book and FND Log Error: 'ORA-01403 in IGI_IAC_DEPRN_PKG.Synchronize_Accounts'. (Doc ID 2051548.1)

Last updated on MAY 11, 2017

Applies to:

Oracle Public Sector Financials (International) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

The Depreciation program (FADEPR), when run with the 'period close' option, ends with the following error in the log file, for an asset book which is enabled for IAC (Inflation Accounting for Assets);

Error
--------
Depreciation Program Exception Report
Do_dep routine completed
APP-OFA-47314: Error: Error in routine IAC:Do_Depreciation
APP-OFA-47314: Error: Error in routine IAC

and in the FND log file;

IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts asset_id nnnnnnn
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts distribution 10743610
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts adjustment type COST
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts account ccid -1
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts fetched ccid 10338998
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts IGI IGI_LOGGING_UNEXP_ERROR N CODE 100 N MSG ORA-01403: no data found

Changes

 Some new assets were added in the period, but were later deleted using the application toolbar option/ 'red cross' delete button from the Asset Workbench.

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