Org Unit Values Not Copied from Staging Table into FSI_D_<table> by T2T Extract
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)
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.
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