How to Populate N_COUPON_FREQUENCY for the Extract T2T_INVESTMENTS (Doc ID 2126895.1)

Last updated on APRIL 14, 2016

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

In Oracle Financial Services Asset Liability Management (ALM) 8.0, why does the T2T_INVESTMENTS extract/mapping contain hard-coded N_COUPON_FREQUENCY values for populating the PMT_FREQ column on FSI_D_INVESTMENTS?  How do you populate this column if you need to map an investment in commercial paper that pays at maturity which could be any term from 3 days to 20 days?

The mapping from N_COUPON_FREQUENCY in STG_INVESTMENTS to PMT_FREQ in FSI_D_INVESTMENTS uses the following Expression:

<EXPRESSION>
case when stg_investments.N_COUPON_FREQUENCY=-1 then NULL
when stg_investments.N_COUPON_FREQUENCY=0 then NULL
when stg_investments.N_COUPON_FREQUENCY=1 then 1
when stg_investments.N_COUPON_FREQUENCY=2 then 6
when stg_investments.N_COUPON_FREQUENCY=3 then 4
when stg_investments.N_COUPON_FREQUENCY=4 then 3
when stg_investments.N_COUPON_FREQUENCY=6 then 2
when stg_investments.N_COUPON_FREQUENCY=12 then 1
when stg_investments.N_COUPON_FREQUENCY=26 then 14
when stg_investments.N_COUPON_FREQUENCY=52 then 7
when stg_investments.N_COUPON_FREQUENCY=365 then 1 end
</EXPRESSION>

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms