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

Last updated on JULY 03, 2022

Applies to:

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

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