FTP Process Fails With ORA- 00001: unique constraint (PK_FSI_PROCESS_NODE_HEADER) violated ORA- 06512: at "CREATE_NEW_MAP_HEADER" Error
(Doc ID 2506908.1)
Last updated on AUGUST 20, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Enterprise Performance Management (EPM)
On FTP 8.0.6, FTP process is failing with the following error:
Module Logging OFS Access module data: /* ValidateNodeMap*/
Module Logging OFS Access module data: declare begin validate_node_map(211841.000000, 4); end;
Module Logging OFS errors: (203105) Oracle drv_oci error: OCI Function:  - oexec(),
oexn() SQL Function:  - PL/ SQL EXECUTE Oracle Error: ORA-
00001: unique constraint (PK_FSI_PROCESS_NODE_HEADER)
violated ORA- 06512: at "CREATE_NEW_MAP_HEADER", line 12
ORA- 06512: at "VALIDATE_NODE_MAP", line 192 ORA- 01403:
no data found ORA- 06512: at "ATOMIC.VALIDATE_NODE_MAP", line 140
ORA- 06512: at line 1 Driver Function: drv_oci::Execute() SQL
Statement: declare begin validate_node_map(211841.000000, 4);
The records are missing from the FSI_PROCESS_NODE_HEADER table but the 211841 process does not have a corresponding record on that table. We have tried to save the TP rule again and the issue still remains. Same issue occurs in another environment when creating a brand new transfer pricing rule.
The issue can be reproduced at will with the following steps:
1. Run monthly production FTP process.
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