My Oracle Support Banner

FTP 8.1.1: Rate Card Report Does Not Display The Results Generated In FSI_PM_GENERATED_INSTRMTS (Doc ID 2921142.1)

Last updated on JANUARY 18, 2023

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)


On FTP 8.1.1 version, Rate Card Report doesn't display the results generated in fsi_pm_generated_instrmts.
The FTP Rate Card batch containing only the first 2 tasks was successful. Transfer rate got calculated in fsi_pm_generated_instrmts and it took the correct rate from the base rate curve.

After running the batch, when you access the report in UI, you don't get any error, but neither can you see the results from fsi_pm_generated_instrmts (see below screenshot).


Note: According to Doc ID 2444204.1, the following three tasks used to be run to generate FTP Rate Cards:

Task 1: Generates instruments and inserts records into FSI_PM_GENERATED_INSTRMTS table.
Task 2: Executes the TP Process to populate the generated instruments with TP Rates.
Task 3: Moves the results into a reporting table and the seeded Rate Card Report pulls data from the reporting table and shows results in the report.

Earlier, data got picked from FSI_M_PROD_TRANSFER_RATE, for rate card reporting. However, third step is not required anymore, since fsi_pm_generated_instrmts itself can now retain history and be used for Rate Card Reporting.


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.