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.

[edsanimate_start entry_animation_type= “fadeIn” entry_delay= “1” entry_duration= “0.5” entry_timing= “linear” exit_animation_type= “” exit_delay= “” exit_duration= “” exit_timing= “” animation_repeat= “infinite” keep= “yes” animate_on= “load” scroll_offset= “” custom_css_class= “”]

Reference Note:  Doc ID 1516486.1)

[edsanimate_end]