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:

Symptoms

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.