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

Last updated on OCTOBER 20, 2016

Applies to:

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

Symptoms

2 packages in the FA Depreciation Calculator have warnings/errors. See below and advise.

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
 2 /

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

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