BSP Metadata Synchronization Fails to Load Dimension Members with 'Errrorrr...For input string' (Doc ID 2223231.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Financial Services Balance Sheet Planning - Version 8.0.0 to 8.0.2.0.2 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Balance Sheet Planning (BSP) 8.0.2.0.2 or earlier versions, when you run Metadata Synchronization to load members into a dimension from a file like 'Chart of Account.csv', no values are loaded.  You find the following error in the Metadata_Sync.log from $EPM_ORACLE_HOME/logs/bsplog:

2017-01-11 17:05:42,551 INFO com.oracle.bsp.udf.ClsStandardDimension :: /app/artifacts/import_export/BSPAPP_MS/resource/Global Artifacts/Common Dimensions/Standard Dimensions/Chart of Account.csv
2017-01-11 17:05:42,551 INFO com.oracle.bsp.udf.ClsStandardDimension :: select distinct COMMON_COA_ID, COMMON_COA_NAME from DIM_COMMON_COA_TL tl, DIM_COMMON_COA_HIER hr where tl.COMMON_COA_ID = hr.child_id and tl.language = (select default_application_language from rev_app_user_preferences where appid='BSP') and hr.hierarchy_id = 200001
2017-01-11 17:05:42,603 INFO com.oracle.bsp.udf.BSPCsvUtil :: Errrorrr...For input string: "10000000010"


(10000000010 is a value in Chart of Account.csv)

As a result of this error, no members are loaded into the Chart of Account dimension in BSP.

Changes

 

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