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 APRIL 27, 2023

Applies to:

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:

• Only includes an Adjustment Rule
• Adjustment Rule uses the TP Method from Selected TP Rule option

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

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