Why are N_INTEREST_FREQ and N_PMT_FREQ Fields Used in Different T2TS for PMT_FREQ? (Doc ID 2283986.1)

Last updated on JULY 06, 2017

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.4 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Asset Liability Management (ALM)
Table to Table (T2T)
Data Mapping

Goal

Is there a functional reason why some T2T (e.g. for STG_SWAPS_CONTRACTS, STG_RETIREMENT_ACCOUNTS) use n_pmt_freq to populate PMT_FREQ in the instrument tables, whilst others (STG_CASA, STG_LOAN_CONTRACTS) use n_interest_freq? Unless user defined payment patterns are used, the cash flow engine still assumes that principal and interest payments are made at the same point in time.

At the moment this is causing some challenges with data mapping definitions.

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