OFSAA FTP Process Fails With No Errors FTP Debug Log Ends on IRC Query (Doc ID 2295609.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Symptoms

On FTP 6.1.0.3, FTP process is failing for one specific month - 31-mar-2017, but where it is getting executed for other months successfully. The following error may appear in the $FIC_DB_HOME/bin/nohup.out or if executing from command line:

ERROR

successfully read all database details
Connection to the following database was successful: <user>
Running TP, Process ID: 359018
ID_TYPE = 204
Memory fault(coredump)

ACTUAL BEHAVIOR
OFSAA ftp process is failing for one specific month - 31-mar-2017, but where its getting executed for other months successfully. Debug FTP Log file ends abruptly on queries for rates:

Module Logging OFS Access module data: select
select FSI_IRC_RATE_HIST.interest_rate_cd,
FSI_IRC_RATE_HIST.effective_date,
FSI_IRC_RATE_HIST.interest_rate_term,
FSI_IRC_RATE_HIST.interest_rate_term_mult,
FSI_IRC_RATE_HIST.interest_rate
from FSI_IRC_RATE_HIST
where FSI_IRC_RATE_HIST.interest_rate_cd = 10978.00000
and FSI_IRC_RATE_HIST.effective_date <= '03/ 31/ 2017'
order by FSI_IRC_RATE_HIST.interest_rate_cd,
FSI_IRC_RATE_HIST.effective_date,
FSI_IRC_RATE_HIST.interest_rate_term_mult,
FSI_IRC_RATE_HIST.interest_rate_term

EXPECTED BEHAVIOR
Expect process to be successful as previous month.

The issue can be reproduced at will with the following steps:
1. Run production FTP process.

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.