Unable to Apply AD/TXK Delta 14 Patch: adgrants.sql Does Not Create EBS_SYSTEM Schema


Error:

While applying AD/TXK Delta 14 Patch on Oracle E-Business Suite 12.2.7, the script adgrants.sql fails to create the required EBS_SYSTEM schema. This leads to the following error:


ORA-01917: user or role 'EBS_SYSTEM' does not exist

Reason

The issue occurs because the Oracle profile in use has PASSWORD_VERIFY_FUNCTION enabled, which prevents the creation of the EBS_SYSTEM user when adgrants.sql is executed.

 Symptoms

  • @adgrants.sql APPS fails with ORA-01917
  • adgrants.out log does not include any mention of EBS_SYSTEM creation
  • Execution appears to proceed, but silently skips the schema creation step

Example log (partial):


Start granting from SYS to EBS_SYSTEM
Completed granting and checking privileges
...
No mention of "New user EBS_SYSTEM has been created"

Solution

Step 1: Disable Password Verify Function

Connect to the PDB as SYS and run:


ALTER PROFILE <your_profile_name> LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Replace <your_profile_name> with the profile assigned to the default users. This is often DEFAULT or TESTPWD.

Step 2: Re-run adgrants.sql


sqlplus "/nolog"
@adgrants.sql APPS

After successful execution, your adgrants.out should now show:


***************** ATTENTION *************************
* New user EBS_SYSTEM has been created             *
...
* ALTER USER EBS_SYSTEM ACCOUNT UNLOCK;            *
*****************************************************

Step 3: Re-enable Password Policy (if required)

If you need to enforce password verification again, reapply the policy:


ALTER PROFILE <your_profile_name> LIMIT PASSWORD_VERIFY_FUNCTION <function_name>;






Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment