FTP Process Is Not Generating Any Transfer Rate (Doc ID 2959842.1)

Last updated on AUGUST 03, 2023

Applies to:

Symptoms

After executing the FTP standard process with Average Life cashflow TP method on selected loan product, FTP process is not generating an output in TP rate(transfer_rate) and average life(tp_average_life) in loan instrument table.

Filename Transfer_Pricing_Engine_OFSAAINFO_239809_EXEC_20220131_3_Task1.log ends with the following:

Module Logging OFS calculation module data: select

select distinct a.ISO_CURRENCY_CD, a.PRODUCT_ID
from FSI_D_LOAN_CONTRACTS a
where (((a.PRODUCT_ID = 10001)
and (a.PRODUCT_ID = 100010)))
and as_of_date = to_date('01/ 31/ 2022', 'mm/ dd/ yyyy')
and LEGAL_ENTITY_ID = 1500
order by a.ISO_CURRENCY_CD, a.PRODUCT_ID

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
)

Cause

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