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 MAY 08, 2023

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)

Symptoms

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

There is no data output to FSI_PROCESS_ERRORS.

Cause

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
Symptoms
Cause
Solution
References


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