My Oracle Support Banner

8.0.4 FTP Process Completes But Does Not Calulate Transfer Rates in AIX Environment (Doc ID 2810563.1)

Last updated on OCTOBER 07, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.4 to 8.0.4 [Release 8]
IBM AIX on POWER Systems (64-bit)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)


In an 8.0.4 AIX environment with both FTP and ALM, a Batch containing FTP Processes completes but does not calculate any Transfer Rates.

Checking the ofstp logs in $FIC_DB_HOME/log/FusionApps, all logs end before processing data.  The following is at the end of each log:

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.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 = 200302.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

There is no data output to FSI_PROCESS_ERRORS.


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.