Generate Asset Trace Errors With FA_ASSET_TRACE_PVT.DO_PRIMARY (Doc ID 1635692.1)

Last updated on MAY 25, 2017

Applies to:

Oracle Assets - Version 11.5.10.0 and later
Information in this document applies to any platform.
FATRACE - Generate Asset Trace

KM Doc ID 800184.1 has been deleted and the info consolidated into this note

Symptoms

When attempting to run 'Generate Asset trace' FATRACE, the program errors due to the following:

------------------------------------------------------
fa_asset_trace_pvt.exec_sql: l_stmt is:  SELECT '<TR>'||'<TD bgcolor="#f2f2f5">'||bk.BOOK_TYPE_CODE||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.DISTRIBUTION_SOURCE_BOOK||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.BOOK_CLASS||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.DATE_INEFFECTIVE||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.SET_OF_BOOKS_ID||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.LAST_DEPRN_RUN_DATE||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.DEPRN_STATUS||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.MASS_REQUEST_ID||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||bc.LAST_PERIOD_COUNTER||'</TD>'||''||'<TD bgcolor="#f2f2f5">'||dp.PERIOD_COUNTER||'</TD>' from fa_books bk, fa_book_controls bc, fa_deprn_periods dp
                         where bc.book_type_code = bk.book_type_code
                         and dp.book_type_code = bk.book_type_code
                         and dp.period_close_date is null
                         and bk.date_ineffective is null
                         and bk.asset_id = XXXXXXX
fa_asset_trace_pvt.do_primary: Error
fa_asset_trace_pub.run_trace: OTHERS Exception
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Error: function fa_asset_trace_pkg.do_trace returned failure
------------------------------------------------------

 

OR

fa_asset_trace_pvt.get_system_options: Error
fa_asset_trace_pub.run_trace: OTHERS Exception
ORA-06502: PL/SQL: numeric or value error
Error: function fa_asset_trace_pkg.do_trace returned failure

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