This content has been marked as final. Show 3 replies
I am getting this error when migrating the Responsibility.How do you migrate the responsibility?
Please mention your application release and the database version.
This XXAT_ORG_ACCESS_TRG01 is a system trigger, I guess.This looks like as a custom trigger, so please confirm.
Thanks for the reply...
The EBS version is 126.96.36.199
The trigger code is like this:
CREATE OR REPLACE TRIGGER XXAT_ORG_ACCESS_TRG01
BEFORE INSERT ON org_access
FOR EACH ROW
DELETE FROM org_access
WHERE organization_id = :NEW.organization_id
AND resp_application_id = :NEW.resp_application_id
AND responsibility_id = :NEW.responsibility_id;
So while migrating the Responsibilities, this org_access table is geeting updated and the mutating error is coming.
We cannot edit this trigger as it this is system trigger.
We cannot edit this trigger as it this is system trigger.The trigger name "XXAT_ORG_ACCESS_TRG01" sounds like a custom trigger, so you should be able to disable it. You may log a SR and confirm this with Oracle support.