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 |