Table Definition Missing from Fixed Asset Analyzer and Log shows Error: ORA-00904: "UNREVALUED_COST": invalid identifier (Doc ID 2887790.1)

Last updated on DECEMBER 10, 2024

Applies to:

Symptoms

ACTUAL BEHAVIOR

While running Fixed Asset Analyzer FA_DEPRN_SUMMARY/DETAIL and FA_MC_DEPRN_DETAIL/SUMMARY missing from "Asset Transactions and Setups Data Checks" section

Also on checking log below error is present

Line 1192: Error in run_sig_sql at step 30 running: select PERIOD_COUNTER,
Line 1232: Error: ORA-00904: "UNREVALUED_COST": invalid identifier
Line 1236: Error in run_sig_sql at step 30 running: select SET_OF_BOOKS_ID
Line 1280: Error: ORA-00904: "HISTORICAL_NBV": invalid identifier
Line 1284: Error in run_sig_sql at step 30 running: select PERIOD_COUNTER,

EXPECTED BEHAVIOR

Fixed Assets Analyzer should show all the Fixed Assets Transaction and setup tables

STEPS

The issue can be reproduced at will with the following steps:

1. Fixed Assets Manager
2. Others -> Request -> Run -> Fixed Assets Analyzer
3. Provide Parameter as "Book Type Code" and "Asset Number".

Cause

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