My Oracle Support Banner

FTP Rate Card Batch Does Not Generate Results for Floating Rate Products (Doc ID 2890412.1)

Last updated on AUGUST 19, 2022

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.6 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 Enterprise Performance Management (EPM)


The FTP Rate Card Batch does not generate results for floating rate products.

Have tested the FTP Rate Card functionality with different types of products and identified that for floating rate products, the engine does not write results in the FSI_PM_GENERATED_INSTRMTS table. The process generates results only for fixed rate and other adjustable products.

The issue can be reproduced at will with the following steps:
1. Go to Funds Transfer Pricing > FTP Rate Card > Products
2. Create a definition using Adjustable Type = Floating.
3. Go to Operations > Batch Execution.
4. Run Batch TEST_RATE_CARD.
5. Review results in FSI_PM_GENERATED_INSTRMTS:

select * From FSI_PM_GENERATED_INSTRMTS where as_of_date = '31-DEC-1999';
If Adjustable Type = Floating, no row is inserted into FSI_PM_GENERATED_INSTRMTS.

6. Verify this by deleting and re-creating the floating product as Other Adjustable. After making this one change, the row is inserted into FSI_PM_GENERATED_INSTRMTS.




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.