Home › Discussions › Questions & Answers › Unique Constraint Violation during Package Recompile

Unique Constraint Violation during Package Recompile

Avatar photoCustomer Questions & Answers 3 replies

Our installation log shows ORA-00604: error occurred at recursive SQL level 1 and ORA-00001: unique constraint (SYS.I_OBJAUTH1) violated when re-compiling a package. What is the cause and the manual workaround?

3 replies

  • Support Enginatics

    This violation occurs during recursive SQL execution while granting privileges in the compilation process. The solution is to manually drop and recreate the failing package.

  • Avatar photoCustomer

    If the package is `XXEN_UTIL`, what are the steps?

  • Support Enginatics

    You must connect as APPS and execute `drop package XXEN_UTIL;`, followed by running the package specification and body scripts (`@XXEN_UTIL.pks` and `@XXEN_UTIL.pkb`) from the installer’s SQL directory.

  • You must be logged in to reply to this post.