My Oracle Support Banner

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 8.0.6.1.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)

Symptoms

On FTP 8.0.6, FTP process is failing with the following error:

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: [4] - oexec(),
oexn() SQL Function: [34] - 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);
end;


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.

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.