My Oracle Support Banner

Column Missing from Alternate Rate Output Mapping Screen When UDP Set Correctly (Doc ID 2526554.1)

Last updated on JANUARY 08, 2024

Applies to:

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


In Oracle Financial Services Funds Transfer Pricing (FTP), in the Alternate Rate Output Mapping screen, when you select the Mortgages table only, a custom column, Option Cost, is missing from the drop down list for "Other Adjustment Rate'.  The column exists if you select the Loan Contracts table.

Loan Contracts:


You did update OPTION_COST for the PORTFOLIO super class table in the Erwin Data Model and set Adj Spread Output = YES in the UDP tab.  As a result, you expect to see Option Cost listed in the screen under "Other Adjustment Rate".

Additionally, the column is not listed when you check REV_COLUMN_PROPERTIES for column_property_cd = 82 (Other Adj Spread Output):

select * from REV_COLUMN_PROPERTIES where table_name = 'FSI_D_MORTGAGES'
and column_property_cd = 82 and column_name = 'OPTION_COST';


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.