BSP 8.0.1 Adds _CCOA, _ST, _CS1 and _ORGN Suffixes for Dimension Members in RES_DTL That Do Not Exist in Essbase

(Doc ID 2147830.1)

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, 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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms