My Oracle Support Banner

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

Last updated on AUGUST 18, 2022

Applies to:

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

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

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

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