My Oracle Support Banner

FATRACE Error ORA-06502: PL/SQL: Numeric Or Value Error: Character String Buffer Too Small (Doc ID 2408586.1)

Last updated on MAY 24, 2021

Applies to:

Oracle Assets - Version 12.2.4 and later
Information in this document applies to any platform.


When running Generate Asset Trace, it fails with:

FATRACE returning error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small


When reviewing FND Log Messages, it is clear that selects are failing for FA tables:

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 = 108600"
sid:115961905: fa_asset_trace_pvt.do_primary: Error
sid:115961905: fa_asset_trace_pub.run_trace: OTHERS Exception
OTHERS Exception


Steps to reproduce:

1)  Use menu path Other : Requests : Run

2)  Submit the concurrent request Generate Asset Trace


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
 Still Have Questions?

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