My Oracle Support Banner

FIC_MIS_DATE Primary Key (PK_624) on STG_PPMT_CALC_PARAMS is Incorrect (Doc ID 2424029.1)

Last updated on JULY 17, 2018

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Oracle Financial Services Data Foundation - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Data Foundation (FSDF) previously known as Oracle Financial Services Data Warehouse (FSDW)

Goal

The primary key on STG_PPMT_CALC_PARAMS is set to FIC_MIS_DATE only.

Expect that the correct primary key would include:
V_PPMT_NAME
V_PRODUCT_CODE
D_ORIGINATION_START_DATE
FIC_MIS_DATE

Or the primary key (PK) should be NONUNIQUE.  What is the correct PK for STG_PPMT_CALC_PARAMS table?

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!


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