Metadata Synchronization Does Not Use Assigned Dimension Code
Last updated on JANUARY 13, 2017
Applies to:Oracle Financial Services Balance Sheet Planning - Version 184.108.40.206.2 to 220.127.116.11.5 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On : 18.104.22.168.2 version, Calculation Engine
Metadata synchronization process is still using system generated IDs after patch 22.214.171.124.2.
Expect _ID column equal to _CODE column in dimension tables after metadata synchronization not system generated IDS.
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"
1. Installed Patch 23590264: CONSOLIDATED BSP PATCH 126.96.36.199.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.
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