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

Last updated on APRIL 04, 2025

Applies to:

Symptoms

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
Error
sid:115961905: fa_asset_trace_pub.run_trace: OTHERS Exception
OTHERS Exception
OFA

Steps to reproduce:

1)  Use menu path Other : Requests : Run

2)  Submit the concurrent request Generate Asset Trace

Cause

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