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

Last updated on OCTOBER 06, 2020

Applies to:

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

Changes

Cause

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