All FTP Processes Fail to Complete Processing With No Transfer Rate Generated and Incomplete Log Files (Doc ID 1573191.1)

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)

Symptoms

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.

ACTUAL BEHAVIOR
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
select OFSA_CATALOG_OF_IDS.sys_id_num,
OFSA_CATALOG_OF_IDS.id_type, OFSA_CATALOG_OF_IDS.id_desc_short,
OFSA_CATALOG_OF_IDS.id_desc_long,
OFSA_CATALOG_OF_IDS.leaf_num_id, OFSA_CATALOG_OF_IDS.table_name,
OFSA_CATALOG_OF_IDS.access_code, OFSA_CATALOG_OF_IDS.access_name,
OFSA_CATALOG_OF_IDS.folder_name, OFSA_CATALOG_OF_IDS.chg_app,
OFSA_CATALOG_OF_IDS.chg_login, OFSA_CATALOG_OF_IDS.chg_date,
OFSA_CATALOG_OF_IDS.chg_time
from OFSA_CATALOG_OF_IDS
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,
batch_run_id)
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
HostIP... 111.222.333.77
Port... 6500
Host IP--> 111.222.333.77
HostIP... 111.222.333.77
Port... 6500
[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.

EXPECTED BEHAVIOR
Rates to be written to TRANSFER_RATE column.

The issue can be reproduced at will with the following steps:
1. Run any 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