FTP Process Failed without Errors in FSI_PROCESS_ERRORS and ofstp Debug Referenced FSI_D_PAYMENT_SCHEDULE (Doc ID 1559858.1)

Last updated on APRIL 04, 2024

Applies to:

Symptoms

When attempting to run Funds Transfer Pricing (FTP) Process with only Transfer Rate checked in the calculation selection,
the process failed without any errors in FSI_PROCESS_ERRORS and debug log shows reference to FSI_D_PAYMENT_SCHEDULE at the end of the file.

Steps to Replicate:
1. Run FTP process with only Transfer Rate checked in the Calculation.
2. The process failed or hanged almost immediately.
3. Checked errors in FSI_PROCESS_ERRORS.

select * from FSI_PROCESS_ERRORS where PROCESS_SYS_ID = 203552;

No record found.

4. Checked ofstp debug log and found the following at the end of the file:

Module Logging OFS Access module data: select
select FSI_D_PAYMENT_SCHEDULE.id_number,
FSI_D_PAYMENT_SCHEDULE.payment_date,
FSI_D_PAYMENT_SCHEDULE.instrument_type_cd,
FSI_D_PAYMENT_SCHEDULE.amount
from FSI_D_PAYMENT_SCHEDULE
where FSI_D_PAYMENT_SCHEDULE.instrument_type_cd = 170.00000
and id_number = ' 10780723381'
order by FSI_D_PAYMENT_SCHEDULE.payment_date

5. Re-run the process using the command line and found Memory Fault error or just hang.

Running TP, Process ID: 203552
Memory fault

Cause

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