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 APRIL 11, 2023
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 |