Org Unit Values Not Copied from Staging Table into FSI_D_<table> by T2T Extract (Doc ID 2080727.1)

Last updated on NOVEMBER 23, 2015

Applies to:

Oracle Financial Services Hedge Management and IFRS Valuations - Version 6.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Oracle Financial Services Asset Liability Management - Version 6.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA), when you run a T2T database extract like T2T_LOAN_CONTRACTS to move data from STG_LOAN_CONTRACTS to FSI_D_LOAN_CONTRACTS, the data is transferred successfully but the ORG_UNIT_ID column is not populated correctly.

In STG_LOAN_CONTRACTS, V_ORG_UNIT_CODE = 3029.
In FSI_D_LOAN_CONTRACTS, ORG_UNIT_ID = -1.

You expect the T2T extract to copy the value of 3029 from STG_LOAN_CONTRACTS into FSI_D_LOAN_CONTRACTS.

The value 3029 exists in DIM_ORG_UNIT_B and has ORG_UNIT_CODE = 3029.  You do not understand why the value is not copied.  This issue occurs in multiple T2T extracts.

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