Parent Child Hierarchy Creation issue

Rajagopal R-Oracle

Hi.,

Getting the below error while executing data population script created by wizard when creating parent child hierarchy in obiee 11.1.1.7.1

Error report -

ORA-06502: PL/SQL: numeric or value error

ORA-06512: at line 41

06502. 00000 -  "PL/SQL: numeric or value error%s"

*Cause:    An arithmetic, numeric, string, conversion, or constraint error

           occurred. For example, this error occurs if an attempt is made to

           assign the value NULL to a variable declared NOT NULL, or if an

           attempt is made to assign an integer larger than 99 to a variable

           declared NUMBER(2).

*Action:   Change the data, how it is manipulated, or how it is declared so

           that values do not violate constraints.

FTisiot

Basically reading the error You should verify that the source column definition in your Closure Table has:

- Not Nullable columns where you're trying to push a null

- Numbers defined as NUMBER(2) where the query is trying to push a number greater than 99.

Compare the datatype with the result of the SQL generated by OBIEE and you'll understand where the error is.