RXI: Fixed Assets Book Report Fails with ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 363882.1)

Last updated on OCTOBER 15, 2016

Applies to:

Oracle Assets - Version 10.7 and later
Information in this document applies to any platform.
Oracle Assets - Version: 11.5.10
This problem can occur on any platform.
ConcurrentProgram:RXFABK - RX-only: Fixed Assets Book

Symptoms

RXFABK module: RX-only: Fixed Assets Book fails with:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small
+---------------------------------------------------------------------------+
Error generating dynamic SQL statements for structure 101 of flexfield CAT#.
Unhandled exception generating segments for structure 101 of flexfield CAT#.
+---------------------------------------------------------------------------+

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