R12 FATRACE: Generate Asset Trace Errors With 'ORA-00942: table or view does not exist' After Post Asset Revaluation (Doc ID 1902727.1)

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


Symptoms

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:

Error
-----------------------
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_pvt.get_tbl_cnt: Error
fa_asset_trace_pvt.do_primary: Error
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.

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