Metadata Sync Error on Prod_Registration_Needed (Doc ID 1465591.1)

Last updated on JUNE 07, 2012

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 5.2.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

On : 5.2.2 version, Data Model

When attempting to run Metadata Sync in Balance Sheet Planning, the process is not completed successfully and the following error occurs.

ERROR
-----------------------
Metadata_Sync.log

2012-05-11 08:47:55,663 INFO com.oracle.bsp.udf.ClsStandardDimension :: insert into DIM_COMMON_COA_HIER(HIERARCHY_ID,PARENT_DEPTH_NUM,PARENT_ID,CHILD_DEPTH_NUM,CHILD_ID,DISPLAY_ORDER_NUM,SINGLE_DEPTH_FLAG,CREATED_BY,CREATION_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE) values (200071,5,30929000,6,330000,1,'Y','SYSADMN',SYSDATE,'SYSADMN',SYSDATE)
2012-05-11 08:47:55,665 INFO com.oracle.bsp.udf.ClsStandardDimension :: prod_registration_needed :false ent_registration_needed:false strategy_registration_needed : false
2012-05-11 08:47:55,786 INFO com.oracle.bsp.udf.ClsStandardDimension :: error occurred during batching: ORA-01400: cannot insert NULL into ("EPMBSP"."DIM_COMMON_COA_TL"."COMMON_COA_NAME")

.... etc

2012-05-11 08:47:57,227 INFO com.oracle.bsp.udf.ClsStandardDimension :: insert into DIM_ORG_UNIT_HIER(HIERARCHY_ID,PARENT_DEPTH_NUM,PARENT_ID,CHILD_DEPTH_NUM,CHILD_ID,DISPLAY_ORDER_NUM,SINGLE_DEPTH_FLAG,CREATED_BY,CREATION_DATE,LAST_MODIFIED_BY,LAST_MODIFIED_DATE) values (200070,3,3160102000071599999,4,45001,2,'Y','SYSADMN',SYSDATE,'SYSADMN',SYSDATE)
2012-05-11 08:47:57,231 INFO com.oracle.bsp.udf.ClsStandardDimension :: prod_registration_needed :false ent_registration_needed:false strategy_registration_needed : false
2012-05-11 08:47:57,242 INFO com.oracle.bsp.udf.ClsStandardDimension :: error occurred during batching: ORA-01438: value larger than specified precision allowed for this column



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