My Oracle Support Banner

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

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
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.