Home / Errors/Workarounds-GL / Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML”

Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML”

ERROR

Unable To Create New Legal Entities – ORA-06512: at “CTXSYS.DRVDML” , ORA-06512: at “HR.DR$HR_LOCATIONS_N1TC

 

SOLUTION

Run The Following Query

SELECT TRIGGER_NAME, STATUS
FROM all_triggers
WHERE TABLE_NAME in (‘PER_ADDRESSES’, ‘HR_LOCATIONS_ALL’)
ORDER BY table_name;

If you see triggers with name DR$HR_LOCATIONS_N1TC or DR$PER_ADDRESSES_N4TC please drop these, then see if you can now create the Legal Entity.

Disable Trigger DR$HR_LOCATIONS_N1TC
Disable Trigger DR$PER_ADDRESSES_N4TC

Reference Note:  Doc ID 1516486.1)

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

An Introduction to Financial Statement Generator (FSG)

An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) …

Leave a Reply

Skip to toolbar