T2T_LOAN_CONTRACTS Loads Incorrect ORG_UNIT_ID into FSI_D_LOAN_CONTRACTS in ALM 126.96.36.199
(Doc ID 2671236.1)
Last updated on JULY 23, 2020
Applies to:Oracle Financial Services Asset Liability Management - Version 188.8.131.52.0 to 184.108.40.206.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)
On 220.127.116.11.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.
outer join dim_org_unit_b on dim_org_unit_b.org_unit_code = stg_loan_contracts.v_business_unit_code
outer join dim_org_unit_b on dim_org_unit_b.org_unit_code = stg_loan_contracts.v_org_unit_code
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