Intermediary Table FSI_TP_CATERPILLAR_INTRMDIATE for Caterpillar FTP Method Writing Rates Incorrectly Divided By 100 (Doc ID 2986887.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Symptoms

On FTP 8.1.2.2, it appears that in the intermediary table of the Caterpillar FTP method, FSI_TP_CATERPILLAR_INTRMDIATE, the rates are being written divided by 100.

ACTUAL BEHAVIOR
Have noticed that in the intermediary table of the Caterpillar FTP method the rates are being written divided by 100.  For example, if the rate on the IRC is 0.123456, the rate in the caterpillar table is being written as 0.001234.  If there would be an initial processing when only initial strips are originating, the rate written back on account level would be correct because the engine even if it is writing in the caterpillar table the rate as divided by 100, on instrument level it is writing the rate correctly undivided by 100 with the exact decimals as picked up from the IRC, as in this example 0.123456.

The issue is that in the second processing when the engine is blending the FTP rates between old un-matured and new strips, the FTP rate of the old strips is used as divided by 100 which is losing the correct precision of those FTP rates. For example, if the rate should have been 0.123456 but the engine is using it as 0.001234 when blending, the last two digits are being lost.

EXPECTED BEHAVIOR
Expect that the FTP rates in the intermediary table of Caterpillar are calculated in percentage format, just like all other FTP methods are writing results.

Changes

Cause

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