My Oracle Support Banner

T2T_SWAPS_CONTRACTS_RCV Contains Wrong Mapping for Column PMT_FREQ_MULT (Doc ID 2161482.1)

Last updated on MARCH 24, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 to 8.0.4 [Release 8]
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 to 8.0.4 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Asset Liability Management (ALM) 8.0.1, the T2T Data Mapping T2T_SWAPS_CONTRACTS_RCV contains the wrong mapping for the column PMT_FREQ_MULT.

Currently, the STG_SWAPS_CONTRACTS column V_PMT_FREQ_PAY_UNIT is mapped to the column PMT_FREQ_MULT on FSI_D_SWAPS.  The Source - Target Mappings section of the Data Mapping definition shows the following:

Source Table: STG_SWAPS_CONTRACTS
Source Column: V_PMT_FREQ_PAY_UNIT
Target Table: FSI_D_SWAPS
Target Column: PMT_FREQ_MULT

You expect T2T_SWAPS_CONTRACTS_RCV to use the source column V_PMT_FREQ_RCV_UNIT to populate PMT_FREQ_MULT.

Cause

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
Symptoms
Cause
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.