My Oracle Support Banner

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

Last updated on MARCH 27, 2019

Applies to:

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


After upgrading from Oracle Financial Services Funds Transfer Pricing (FTP) 6.1.1 to, 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.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,
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,
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.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.