My Oracle Support Banner

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 JUNE 17, 2022

Applies to:

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


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);

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 1234
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 5678
IGI.PLSQL.igiiaprb.IGI_IAC_DEPRN_PKG.Synchronize_Accounts IGI IGI_LOGGING_UNEXP_ERROR N CODE 100 N MSG ORA-01403: no data found


 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.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

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