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

Last updated on AUGUST 09, 2017

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

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.

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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms