ORA-01400 when Uploading a Hierarchy via the Create from Spreadsheet Option

(Doc ID 435460.1)

Last updated on NOVEMBER 24, 2008

Applies to:

Oracle Enterprise Performance Foundation - Version: 11.5.10
This problem can occur on any platform.
FEM.D.1 RUP2
FEM.D.1 RUP3

Symptoms

When attempting to upload a hierarchy using Create Spreadsheet Option the following occurs:

ERROR:
ORA-06502: PL/SQL numeric or value error: character string buffer too small
ORA-01400: cannot insert NULL into ("FEM"."FEM_HIER_VALUE_SETS_T"."VALUE_SET_DISPLAY_CODE")

STEPS:
1. Clicked "Create from Spreadsheet" option for hierarchy.
2. Entered rows of data into the hierarchy.
3. On spreadsheet, entered the parameters.
4. Selected from menu ORACLE > Upload.
5. Received the error above.

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