My Oracle Support Banner

T2T_LOAN_CONTRACTS Loads Incorrect ORG_UNIT_ID into FSI_D_LOAN_CONTRACTS in ALM 8.0.7.2 (Doc ID 2671236.1)

Last updated on JULY 23, 2020

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.7.2.0 to 8.1.0.0.0 [Release 8 to 8.1]
Information in this document applies to any platform.
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Table-to-Table Transformation (T2T)

Symptoms

On 8.0.7.2.0 version, T2T_LOAN_CONTRACTS loads incorrect ORG_UNIT_ID into FSI_D_LOAN_CONTRACTS table due to wrong join with DIM_ORG_UNIT_B.

The issue is in the ANSI join, not in the mapping. Refer the join between STG_LOAN_CONTRACTS and DIM_ORG_UNIT_B from the T2T log.

 

Existing join:

outer join dim_org_unit_b on dim_org_unit_b.org_unit_code = stg_loan_contracts.v_business_unit_code

Expected join:

outer join dim_org_unit_b on dim_org_unit_b.org_unit_code = stg_loan_contracts.v_org_unit_code

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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