BSP 8.0.1 Adds _CCOA, _ST, _CS1 and _ORGN Suffixes for Dimension Members in RES_DTL That Do Not Exist in Essbase
Last updated on AUGUST 31, 2016
Applies to:Oracle Financial Services Balance Sheet Planning - Version 8.0.1 and later
Information in this document applies to any platform.
Oracle Financial Services Balance Sheet Planning (BSP)
On BSP 188.8.131.52.1, running current position after applying the latest debug patch to fix IDs after upgrade, it appears that invalid suffixes are appended to the results IDs for certain dimensions during the import to Essbase. (Chart of Account, Strategy, Custom1 and Entity). When BSP tries to load data from RES_DTL (vw_res_dtl_cur_buss) to Essbase, errors such as the following are generated:
\\ Member 354067_CCOA Not Found In Database
FY16 Apr 4081964.28 354067_CCOA 43019908_ST 38796685_CS1 USD 301432_ORGN C60 Working Forecast No Attribute Value
Note the _CCOA, _ST, _CS1 and _ORGN suffixes are not valid since the Essbase member names are only the ID portion as shown in the results detail table.
The issue can be reproduced at will with the following steps:
1. Apply debug fix
2. Run cash flow current position
3. See errors
Upgraded from BSP 6.1.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms