Column Missing from Alternate Rate Output Mapping Screen When UDP Set Correctly
(Doc ID 2526554.1)
Last updated on OCTOBER 02, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 18.104.22.168 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
In Oracle Financial Services Funds Transfer Pricing (FTP) 22.214.171.124, 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.
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