OFSRR 8081 - Mismatches In All Non USD Balances From FCT_REG_ACCOUNT_SUMMARY
(Doc ID 2616355.1)
Last updated on MAY 24, 2021
Applies to:Oracle Financial Services - Regulatory Reporting for US Federal Reserve - Lombard Risk Integration Pack - Version 8.0.8 and later
Information in this document applies to any platform.
Following join is failing (this is a new join added in 808 in the
T2T_FCT_REG_ACCOUNT_SUMMARY) and all non USD balances are reported as 0 in
Select V_COMPONENT_VALUE from SETUP_MASTER where V_COMPONENT_CODE =
select distinct V_RATE_DATA_SOURCE_CD from FSI_EXCHANGE_RATES where 1=1
V_TO_CCY_CODE='USD' and V_from_CCY_CODE='CAD'
select RATE_DATA_SOURCE_DISPLAY_CD from atomic.fsi_rate_data_source_Cd where
When checked the SQL statement for T2T_FCT_REG_ACCOUNT_SUMMARY along with the T2T log file, although there is no error issue, the expectation from the customer is that all the RCY columns are getting wrongly addressed. Request you to let us know.
Customer's addition to the SQL statement is:
One parameter condition to this T2T as they have 2 sets of data for N_LOAD_RUN_ID
AND FCT_COMMON_ACCOUNT_SUMMARY.N_LOAD_RUN_ID = '[LOADRUN]'
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