My Oracle Support Banner

Run Depreciation with Period Close on IAC Enabled Book fails: APP-OFA-47314: Error: Error in routine IAC:Do_Depreciation (Doc ID 2763799.1)

Last updated on MARCH 26, 2021

Applies to:

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

Symptoms

When attempting to run Depreciation with period close enabled from the Depreciation Run form, for a book that has Inflation Accounting for Assets enabled, the following error is encountered:


APP-OFA-47314: Error: Error in routine IAC:Do_Depreciation

 

The issue may occur when the following conditions are met:

a)  Inflation Accounting for Assets is enabled on the asset book

b)  Revaluation for Inflation Accounting has been run twice in the open period

c)  Period Close Depreciation is going to be submitted  (this does not fail on preliminary depreciation without period close checked)

 

Steps to replicate:

1)  Use Fixed Assets Manager or similar responsibility that has the ability to submit Depreciation

Menu path:  Depreciation : Run Depreciation

2)  Choose Run Depreciation form

3)  Submit Depreciation with period close enabled for the period that defaults on the form, which will be the open period.

4)  Depreciation will fail with the message: "APP-OFA-47314: Error: Error in routine IAC:Do_Depreciation" in the log file. 

5)  This is a fairly generic error message so FND Log Messages should be gathered per <Note 433199.1> How to enable and retrieve FND debug log messages.

6)  Upon reviewing FND Log Messages, the following is found:

Value of l_latest_adj_id after reassign123456
Value of l_asset_id 123456 Value of l_book_type_code CORPORATE_BOOK Value of l_last_period_counter 24250
Data not found for last_period_counter
before Value of l_period_counter.period_counter 24249
Value of l_period_counter.period_counter 24249l_asset_id 123456 l_book_type_code: CORPORATE_BOOK
Data not found for l_period_counter.period_counter
IGI?IGI_LOGGING_UNEXP_ERROR?N?CODE?100?N?MSG?ORA-01403: no data found?
OFA?FA_SHARED_ORACLE_ERR?N?ORACLE_ERR?ORA-01403: no data found?
End of procedure
cost reval pkg returns false
APP-OFA-47314: Error: Error in routine IAC:Do_Depreciation

Cause: You have a database problem.

Action: Contact your system administrator.

APP-OFA-47314: Error: Error in routine IAC

Cause: You have a database problem.

Action: Contact your system administrator.

 

 

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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