All FTP Processes Fails After Installing FTP 6.1.1.1 on IBM AIX (Doc ID 2171974.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 6.1.1.1 to 6.1.1.1 [Release 6]
IBM AIX on POWER Systems (64-bit)
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

After upgrading from Oracle Financial Services Funds Transfer Pricing (FTP) 6.1.1 to 6.1.1.1, in an IBM AIX environment, you cannot run FTP Processes.  When you execute the FTP process, it runs for a few seconds and ends with a "Success" message but no Transfer Rate is created.  The log files from $FIC_DB_HOME/log/FusionApps are much smaller than normal.  All of the FTP logs are the same size and all end after a select from ofsa_catalog_of_ids and an insert into fsi_process_errors:

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 = 201460.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
        )

Module Logging OFS Access module data: Engine execution successful

You also installed Patch 23180352 - FTP CONSOLIDATED ONE-OFF FOR 6111 but still have the same issue.

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