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 laterOracle 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)
Symptoms
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.
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |