My Oracle Support Banner

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

Last updated on MARCH 15, 2021

Applies to:

Oracle Financial Services Asset Liability Management - Version 8.0.4 to 8.1.1 [Release 8 to 8.1]
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


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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.