My Oracle Support Banner

FN_PPMT_RATE_LOADER Does Not Filter By FIC_MIS_DATE When Loading Records From STG_PPMT_MODEL_HYPERCUBE (Doc ID 2809843.1)

Last updated on NOVEMBER 16, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7 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)


You are using fn_ppmt_rate_loader to load data from STG_PPMT_MODEL_HYPERCUBE into FSI_PPMT_MODEL_HYPERCUBE.

STG_PPMT_MODEL_HYPERCUBE contains data for multiple As of Date / FIC_MIS_Date values.  According to the Data Model Utilities Guide, this is allowed:

"The Data Loader accepts the AS_OF_DATE as a parameter, that is, date to load all prepayment rates from the Staging table into the OFSAA metadata table for the specific as of date."

However, when you run the prepayment loader, the following error occurs in FSI_MESSAGE_LOG:

Load Failed . Staging Record count is more than those defined in FSI_M_PPMT_MODEL 5017506

You do not understand why this error occurs when data for multiple dates exists in STG_PPMT_MODEL_HYPERCUBE.


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.