My Oracle Support Banner

HM 8.0.7.4 Incorrect Column Mappings for “V_int_rate_type_recv” and “V_int_rate_type_pay” for T2T_SWAPS_CONTRACTS_RCV and T2T_SWAP_CONTRACTS_PAY (Doc ID 2820916.1)

Last updated on NOVEMBER 26, 2021

Applies to:

Oracle Financial Services Hedge Management and IFRS Valuations - Version 8.0.7 to 8.1.1.1 [Release 8 to 8.1]
Information in this document applies to any platform.
ALM - Oracle Financial Services Asset Liability Management
HM - Oracle Financial Services Hedge Management and IFRS Valuations
AAI - Oracle Financial Services Analytical Application Infrastructure
T2T - Table to Table

Goal

On HM 8.0.7.4.0 in the T2T_SWAPS_CONTRACTS_RCV and T2T_SWAPS_CONTRACTS_PAY, there is a "left outer join fsi_interest_timing_type_cd on fsi_interest_timing_type_cd.interest_timing_display_cd = stg_swaps_contracts.v_interest_type".
The values for fsi_interest_timing_type_cd.interest_timing_display_cd and stg_swaps_contracts.v_interest_type should be different, so there cannot be a join between these two columns, as per below comparison:

 

Left outer join fsi_interest_timing_type_cd on fsi_interest_timing_type_cd.interest_timing_display_cd = stg_swaps_contracts.v_interest_type
 

Comments: The expected value in V_INTEREST_TYPE is  FIXED RATES or FLOATING RATES . Whereas, the table fsi_interest_timing_type_cd holds value for Advance or Arrear payments

 

Left outer join fsi_interest_timing_type_cd on fsi_interest_timing_type_cd.interest_timing_display_cd = stg_swaps_contracts.v_interest_type

 

Mapping for Reference

 

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.