My Oracle Support Banner

Incremental Load Failed With Character String Buffer Too Small ORA-06502 (Doc ID 359085.1)

Last updated on MARCH 20, 2019

Applies to:

Oracle Enterprise Performance Foundation - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
FEM D.R.5

Symptoms

When attempting to run External GL Data Load program for FEM_BALANCES the following error occurs when Incremental load is selected:

ERROR:

+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Unexpected error has occurred: ORA-06502: PL/SQL: numeric or value error:
character string buffer too small.
Please contact your system administrator.

Parent request 358682
Sub-request 358683 : Engine program aborted before completing
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+

STEPS:
The issue can be reproduced at will with the following steps:
1. Successfully ran the External GL Data Load program using Snapshot option. 
2. Added more records into FEM_BAL_INTERFACE_T table and set the following columns to
    LOAD_METHOD_CODE = I       (Incremental)
    BAL_POST_TYPE_CODE = R    (Replace)
3. Ran the External GL Data Load program using Incremental option and it failed.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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