T2T Data Load Retrieves No Records When Join on <Dimension>_CODE Column Fails (Doc ID 1270986.1)

Last updated on NOVEMBER 17, 2015

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 to 7.3 [Release 7]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Checked for relevance on 15-Mar-2013.

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), the seeded T2T Extracts contain joins on null dimension code columns.  There are joins from the instrument tables to the following dimension tables and columns:

DIM_PRODUCTS_B.PRODUCT_CODE
DIM_ORG_UNIT_B.ORG_UNIT_CODE
DIM_GENERAL_LEDGER_B.GL_ACCOUNT_CODE
DIM_COMMON_COA_B.COMMON_COA_CODE

All of these columns, PRODUCT_CODE, ORG_UNIT_CODE, GL_ACCOUNT_CODE, and COMMON_COA_CODE, are not populated.  They contain no values.  As a result, the Table To Table load does not load any records.

The following is in the log file in $FIC_DB_HOME/logs/t2t/:

2010-10-22 | 22:15:41 | t2tserver | WARN | | | ClsUTableToTableLoad::directLoad, no rows selected for the given definition in the source table(s)

Steps to Reproduce:

  1. Load data into an STG_ table (ex. STG_TD_CONTRACTS)
  2. Go to Operations > Batch Scheduling
  3. Run a Batch with the following selected:

Component ID: LOAD DATA
Parameters:

Load Mode: Table To Table
Source Name: STAGING_SOURCE_T2T
File Name: T2T_TERM_DEPOSITS

No records are loaded by the Table To Table load.

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