T2T is Successful With Target FSI_ Code Columns Populated With Null Values

(Doc ID 2081312.1)

Last updated on JANUARY 29, 2016

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.2.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Table to Table (T2T)
Data Ingestion
Data Mapping

Symptoms

On Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) 7.3.3.2.0, after running the T2T for Loans, Amortization Code is not populated in the FSI_D table.

ACTUAL BEHAVIOR
AMRT_TYPE_CD is populated with null in the FSI_D_ table.

EXPECTED BEHAVIOR
Expect the T2T to populate the FSI_D table with correct values from Staging table after running the T2T.

The issue can be reproduced at will with the following steps:
1. Run T2T from Operations -> Batch Execution.

Note: This issue can occur for other "code" related columns on the staging tables where the code columns are populated with a left outer join on an FSI_<dimension>_CD table.  For example, v_Interest_payment_Type from STG_LOAN_CONTRACTS is joined to a column in the table FSI_INTEREST_TIMING_TYPE_CD to populate the INT_TYPE code column.

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