Metadata Synchronization Does Not Use Assigned Dimension Code (Doc ID 2184331.1)

Last updated on JANUARY 13, 2017

Applies to:

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

Symptoms

On : 8.0.2.0.2 version, Calculation Engine

Metadata synchronization process is still using system generated IDs after patch 8.0.2.0.2.

Expected Behavior:
Expect _ID column equal to _CODE column in dimension tables after metadata synchronization not system generated IDS.

Error:
MetadataSync.log:
2016-07-27 16:38:37,932 INFO com.oracle.bsp.udf.ClsStandardDimension :: select distinct PRODUCT_ID, PRODUCT_NAME from DIM_PRODUCTS_TL tl, DIM_PRODUCTS_HIER hr where tl.PRODUCT_ID = hr.child_id and tl.language = (select default_application_language from rev_app_user_preferences where appid='BSP') and hr.hierarchy_id = 200006
2016-07-27 16:38:38,000 INFO com.oracle.bsp.udf.BSPCsvUtil :: Errrorrr...For input string: "10000000010"


Steps:
1. Installed Patch 23590264: CONSOLIDATED BSP PATCH 8.0.2.0.2
2. Truncated all hierarchical dimension tables and ran metadata synchronization process.
3. Dimension members inserted into the dimension tables are still using system generated ids, instead of setting _ID column equal to _CODE 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