All FTP Processes Fail to Complete Processing With No Transfer Rate Generated and Incomplete Log Files
Last updated on AUGUST 09, 2017
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 6.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
On Oracle Financial Services Funds Transfer Pricing (FTP) 6.0.3, in a new installation instance, after running a non cash flow FTP process (Spread from Interest rate code, Spread from note rate), FTP does not complete and the FTP debug log file ends before even reading FSI_M_TP_PROCESS_RULE table.
The FTP Process does not complete processing. No TP rate is generated and the log file is incomplete. The FTP Debug log file ends with:
Module Logging OFS Access module data: /* 121: *io_cid::GetCatalogIDs*/
Module Logging OFS Access module data: select
where OFSA_CATALOG_OF_IDS.sys_id_num = 200041.00000
order by OFSA_CATALOG_OF_IDS.sys_id_num
Module Logging OFS Access module data: /*inside TP_Context class isContinue=1 */
Module Logging OFS Access module data: insert
insert into FSI_PROCESS_ERRORS(process_sys_id, id_number,
sequences, field_name, field_value, corrected_value,
default_value, severity, error_date, error_time, table_name,
error_description, error_code, num, leaf_num_id, leaf_node, sim,
values (:process_sys_id, :id_number, :sequences, :field_name,
:field_value, :corrected_value, :default_value, :severity,
:error_date, :error_time, :table_name, :error_description,
:error_code, :num, :leaf_num_id, :leaf_node, :sim, :batch_run_id
No errors are written to FSI_PROCESS_ERRORS and no errors displayed if running from command line.
/ofsaa/ficdb/bin>1_EXEC TP TASK1 20131231 200041 BMOFSAA <
Warning: iso88951 does not exist.
Rem = 0Host IP--> 111.222.333.77
Host IP--> 111.222.333.77
[AESCryptorImpl.handleJVM]->INFO: JVM created successfully...
[LOG] Starting up.....
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
| strBatchId : INFODOM_200041_EXEC | strComponentId : TP | Process ID : 200041 | User ID : BMOFSAA | AS_OF_DATE : 12/31/2013
Connection to the following database was successful: ofsaadb
Running TP, Process ID: 200041
INFORM : Engine execution Successful.
Rates to be written to TRANSFER_RATE column.
The issue can be reproduced at will with the following steps:
1. Run any FTP process.
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