My Oracle Support Banner

Not Able To Apply AD/TXK Delta 14 Patch: script adgrants.sql doesn't create EBS_SYSTEM schema (Doc ID 2908016.1)

Last updated on APRIL 10, 2023

Applies to:

Oracle Applications DBA - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
Not Able To Apply AD/TXK Delta 14 Patch: adgrants.sql is not creating EBS_SYSTEM schema

Apply Delta 14 patch on EBS 12.2.x as per Doc ID 1617461.1.
Following the steps "3.2 Path B: Existing Release 12.2 customers (below AD-TXK Delta 14 codelevel)" from the above document

"@adgrants.sql APPS" failing with the error " ORA-01917: user or role 'EBS_SYSTEM' does not exist ",

It's not creating the new EBS_SYSTEM user when running the adgrants.sql from patch_33600809

 

adgrants.out will look as bellow: information about EBS_SYSTEM has been created is missing entierelly

===================================================

Current user is SYS

---------------------------------------------------
--- adgrants.sql started at 2022-11-04 13:11:03 ---
---------------------------------------------------
Removing logs from prior runs of adgrants.sql
-
Start granting from SYS to EBS_SYSTEM

Completed granting and checking privileges

Generating list of ERRORS and WARNINGS to print out

PRINT_ERROR
-------------
:current_user

CURRENT_USER
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SYS user ERRORS and WARNINGS will report at end of script

Creating PL/SQL profiler objects.

---------------------------------------------------
--- profload.sql started at 2022-11-04 13:11:04 ---

....

===================================================

 

 

Changes

 Customer have enabled PASSWORD_VERIFY_FUNCTION, prior to run adgrants.sql from patch 33600809

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.