R12 FATRACE: Generate Asset Trace Errors With 'ORA-00942: table or view does not exist' After Post Asset Revaluation
Last updated on MARCH 24, 2016
Applies to:Oracle Assets - Version 12.2 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.
FATRACE - Generate Asset Trace
On : 12.2.4 version,
After performing a mass revaluation on an asset and running the 'Generate Asset Trace' program, the following error occurs in logfile:
fa_asset_trace_pvt.get_tbl_cnt: Select count(1) FROM
FA_MASS_REVALUATIONS_RULES where asset_id = 110762 and mass_reval_id in
(select mass_transaction_id from fa_transaction_headers where
transaction_type_code = 'REVALUATION' and asset_id = 110762 and
book_type_code = 'OPS CORP')
fa_asset_trace_pub.run_trace: OTHERS Exception
ORA-00942: table or view does not exist
Steps to reproduce problem
Using FA Responsibility
1. For any asset in a corporate book, run 'Generate asset trace' program before revaluation. The program completes normal with an output file.
2. Later, perform mass revaluation on that asset.
3. Run 'Generate Asset Trace' program again for the same asset. The program completes in error.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms