FTP Process Includes Update of ACCUM_CHG_CREDIT_TRATE Column When Option Not Selected
(Doc ID 2926955.1)
Last updated on FEBRUARY 17, 2023
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.1.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
In FTP 8.1.2, when executing an FTP Process, it is running slower than normal and the resulting SQL includes an update on the column ACCUM_CHG_CREDIT_TRATE even though "Charge Credit(TP) Accumulation" is not selected in the process "Calculation Selection" screen. Additionally, the column TP_CHARGE_CREDIT_ACCUM_FLAG = 0 in FSI_M_TP_PROCESS_RULE.
Example of SQL showing ACCUM_CHG_CREDIT_TRATE:
Module Logging OFS Access module data: update
update FSI_D_MORTGAGES a
set matched_spread_c = :matched_spread_c, transfer_rate =
:transfer_rate, charge_credit_trate = :charge_credit_trate,
ACCUM_CHG_CREDIT_TRATE = :ACCUM_CHG_CREDIT_TRATE, tp_average_life
= :tp_average_life, tp_duration = :tp_duration
where a.rowid = :0
The following options are selected in the Calculation Selection screen:
For Transfer Rate:
- Transfer Rate
- Instrument Charge/Credit (TP) - Monthly
You expect the update statement to not include the column ACCUM_CHG_CREDIT_TRATE if the option "Charge Credit(TP) Accumulation" is not selected in the user interface. The option appears when you select "Daily" for Instrument Charge/Credit (TP). Writing to an extra column can cause chained rows and excessive disk I/O.
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