My Oracle Support Banner

T2T is Successful With Target FSI_ Code Columns Populated With Null Values (Doc ID 2081312.1)

Last updated on JULY 10, 2019

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.

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


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