Home » Applications » Oracle Fusion Apps & E-Business Suite » ORA-02055: distributed update operation gailed; rollback required. ORA-20001: Database contraint vio
ORA-02055: distributed update operation gailed; rollback required. ORA-20001: Database contraint vio [message #196707] Fri, 06 October 2006 12:32
rsury
Messages: 26
Registered: May 2005
Junior Member
This is the sequence of step. Please let me know where I go wrong.

We enter an emp/assign in Oracle HR and a trigger is used to move the data to another db to use the emp. detail there.

There is no constraint except for primary key (a sequence number) in the table where the trigger insert the data in another database.

There is no problem when I enter and Save Employee and Assignment.

Whereas when I try to enter and save from People -> Maintain using Templates -> Enter Employees.

The exact error message is
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
FRM-40735: On-Insert trigger raised unhandled exception ORA-02055.
-----------------------------------------
ORA-02055: distributed update operation gailed; rollback required
ORA-20001: Database contraint violated.

The database check or unique contraint PK_HRDATAFEED has been violated. Please contact your system administrator quoting the package procedure per_per_shd. constrint_error and constraint PK_HRDATAFEED.
ORA-06512: at "APPS.PER_QH_MAINTAIN_UPDATE", line 2623.
~~~~~~~~~~~~~~~~~~~~~
Previous Topic: Disable Close Other Forms Menu (URGENT PLZ !!!!!!!!)
Next Topic: Req: Oracle Applications Site for Free Login
Goto Forum:
  


Current Time: Thu Dec 08 08:43:08 CST 2016

Total time taken to generate the page: 0.11418 seconds