My Oracle Support Banner

Depreciation Calculator Tool Has Invalid Objects R12.2 (Doc ID 2195672.1)

Last updated on MARCH 19, 2018

Applies to:

Oracle Assets - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

While installing the depreciation calculator on a 12.2 installation, there is an error: component 'HISTORICAL_NBV' must be declared.

Two packages in the FA Depreciation Calculator have these warnings/errors.


SQL> ALTER PACKAGE FA_DCD_ASSET_VAL_PVT COMPILE BODY;

Warning: Package Body altered with compilation errors.

SQL> SHOW ERRORS
Errors for PACKAGE BODY FA_DCD_ASSET_VAL_PVT:

7182/4 PL/SQL: Statement ignored
7182/34 PLS-00302: component 'HISTORICAL_NBV' must be declared
SQL> ALTER PACKAGE FA_DCD_QUERY_BALANCES_PKG COMPILE BODY

Warning: Package Body altered with compilation errors.

SQL> SHOW ERRORS
Errors for PACKAGE BODY FA_DCD_QUERY_BALANCES_PKG:

726/10 PL/SQL: SQL Statement ignored
787/21 PL/SQL: ORA-00904: "UNREVALUED_COST": invalid identifier
797/10 PL/SQL: SQL Statement ignored
862/21 PL/SQL: ORA-00904: "UNREVALUED_COST": invalid identifier
872/10 PL/SQL: SQL Statement ignored
930/25 PL/SQL: ORA-00904: "UNREVALUED_COST": invalid identifier
947/10 PL/SQL: SQL Statement ignored
1005/25 PL/SQL: ORA-00904: "UNREVALUED_COST": invalid identifier

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
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.