My Oracle Support Banner

OFSRR 8081 - Mismatches In All Non USD Balances From FCT_REG_ACCOUNT_SUMMARY (Doc ID 2616355.1)

Last updated on DECEMBER 02, 2019

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.

Goal

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


FSI_EXCHANGE_RATES.V_RATE_DATA_SOURCE_CD =
  SETUP_MASTER.V_COMPONENT_VALUE


Select V_COMPONENT_VALUE from SETUP_MASTER where V_COMPONENT_CODE =
'DEFAULT_FX_RATE_SRC'
DEFAULT


 select distinct V_RATE_DATA_SOURCE_CD from FSI_EXCHANGE_RATES where 1=1
  and
  V_TO_CCY_CODE='USD' and V_from_CCY_CODE='CAD'
CCIS

select RATE_DATA_SOURCE_DISPLAY_CD from atomic.fsi_rate_data_source_Cd where
RATE_DATA_SOURCE_CD=7
CCIS

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]'

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


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