My Oracle Support Banner

Questions Related to Column Mapping of V_CCY3_CODE in the STG_FX_CONTRACTS Table (Doc ID 2482593.1)

Last updated on NOVEMBER 14, 2019

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)

Goal

The column V_CCY3_CODE in stg_fx_contracts is not mapped, the STG_FX_CONTRACTS table has V_PAY_CCY and V_RCV_CCY mapped, so what is the meaning of V_CCY3_CODE column and what should be mapped to it?

1. Does it mean that V_CCY3_CODE column is useless and can be ignored?
2. If yes, what should be amended in the T2T_STG_FX_CONTRACTS_CAS data mapping ? Currently, both the inner join and FCT_COMMON_ACCOUNT_SUMMARY.V_ISO_CURRENCY_CD mapping are referencing DIM_CURRENCY which join this CCY3 column.
3. The value of FCT_COMMON_ACCOUNT_SUMMARY.V_ISO_CURRENCY_CD would always be NULL after changing the join to 'Left outer join' in this case since INNER join resulst in - 0 records inserted. So what should be the settlement currency code for FX in this table?

Solution

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
Goal
Solution
References


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