My Oracle Support Banner

Getting ORA-00001 on FSI_O_PROCESS_CASH_FLOWS For An FTP Process With Only an Adjustment Rule (Doc ID 2784834.1)

Last updated on JUNE 25, 2021

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)

Symptoms

After upgrading to FTP 8.0.7.4, with the the Audit Option enabled, you get an ORA-00001 on FSI_O_PROCESS_CASH_FLOWS when running an FTP Process.  The FTP Process has the following characteritics:

The following error is output to the FTP Engine log from /<ftpshare>/logs/<AsofDate>/<Infodom>/Transfer Pricing Engine:

Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Error: 1 ORA- 00001: unique
       constraint (<ATOMIC SCHEMA>.XAK1FSI_O_PROCESS_CASH_FLOWS) violated SQL:
insert into FSI_O_PROCESS_CASH_FLOWS(result_sys_id,
       product_leaf_node, org_leaf_node, iso_currency_cd, id_number,
       record_sequence, cash_flow_sequence, scenario_num,
       financial_elem_id, cash_flow_date, cash_flow_cd, float_value,
       calc_source_cd)
values (:result_sys_id, :product_leaf_node, :org_leaf_node,
       :iso_currency_cd, :id_number, :record_sequence,
       :cash_flow_sequence, :scenario_num, :financial_elem_id,
       :cash_flow_date, :cash_flow_cd, :float_value, :calc_source_cd )
 

The FTP Process ends in a status of Failed.

You can workaround the issue by un-selecting the Audit option.

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.