| 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.
~~~~~~~~~~~~~~~~~~~~~
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
