My Oracle Support Banner

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 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


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



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


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

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