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 SEPTEMBER 10, 2024
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 8.0.7.4.0 and laterInformation 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:
- 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
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 |