My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

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.


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.

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:

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:

101010101   110
301010101   301010101
801020101   801020101
901030205   901030205


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.