My Oracle Support Banner

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

Last updated on DECEMBER 26, 2017

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.


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


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

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.


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.