OFSAA FTP Process Fails With No Errors FTP Debug Log Ends on IRC Query
(Doc ID 2295609.1)
Last updated on FEBRUARY 15, 2021
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 22.214.171.124 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
On FTP 126.96.36.199, 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:
successfully read all database details
Connection to the following database was successful: <user>
Running TP, Process ID: 359018
ID_TYPE = 204
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
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,
Expect process to be successful as previous month.
The issue can be reproduced at will with the following steps:
1. Run production FTP process.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document