My Oracle Support Banner

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

Last updated on MARCH 24, 2019

Applies to:

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


In Oracle Financial Services Balance Sheet Planning (BSP) 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 :: /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 :: 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 :: 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.




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.