RES_DTL COMMON_COA_ID Column is Populated with PRODUCT_ID Dimension Members (Doc ID 1276252.1)

Last updated on DECEMBER 23, 2010

Applies to:

Oracle Financial Services Asset Liability Management - Version: 5.2 and later   [Release: 5 and later ]
Information in this document applies to any platform.
OFSAA

Symptoms


When attempting to run ALM Static Deterministic Process the results show COMMON_COA_ID with PRODUCT_ID dimension members.

Expected Behavior:
Expect to see COMMON_COA_ID members in COMMON_COA_ID columns of RES_DTL Table.

Steps:
1. Load new dimension members through T2T process.

2. Run ALM Static Deterministic Process.
The instrument table has the following corresponding PRODUCT_ID and COMMON_COA_ID:

PRODUCT_ID COMMON_COA_ID
101010101  110
301010101  130
801020101  180
901030205  190
104010101  110


3. Review RES_DTL for the process and find mismatch values for common_coa_id:

PRODUCT_ID  COMMON_COA_ID
101010101   110
301010101   301010101
801020101   801020101
901030205   901030205

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