My Oracle Support Banner

ALM 5.6 Process Does Not Output Correct Dimension Values for User Defined Product Dimension (Doc ID 1416283.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 5.6 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Checked for relevance on 01-Oct-2013.


On Oracle Financial Services Asset Liability Management (ALM) 5.6, incorrect dimension values are output for the ALM product dimension.


When executing a ALM Standard Deterministic Process, the results generated in the RES_DTL_XXXXXX and CONS_DTL_XXXXXXX = 0 for RM_COA_ID, the ALM product dimension.

The below error may also occur on the ALM debug log file:


Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function: [4] -
oexn() SQL Function: [34] - PL/ SQL EXECUTE Oracle Error: ORA-
01452: cannot
CREATE UNIQUE INDEX; duplicate keys found ORA- 06512: at
"ATOMIC.OFSA_DBA", line 1345 ORA- 06512: at "ATOMIC.OFSA_DBA",
line 2339 ORA- 06512: at "ATOMIC.OFSA_SQL", line 398 ORA- 06512:
at line 1 Driver Function: drv_oci::Execute() SQL Statement:
declare begin ofsa_sql.clone_all_indexes('ATOMIC',
'CONS_DTL_209920', 'FSI_O_CONS_DETAIL_TEMPLATE', '209920'); end;

The RM_COA_ID should be output with the appropriate RM_COA_ID dimension values.

The issue can be reproduced at will with the following steps:
1. Create new ALM Standard Deterministic Process
2. Run the ALM process
3. RM_COA_ID is 0.


To view full details, 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 a vibrant support community of peers and Oracle experts.