12.2 Patch 17909318 Fails For Script afpubfix.sql With Error 'FAILED: file afpubfix.sql on worker 1.' Due To Grant Privilege Issues (Doc ID 2083856.1)

Last updated on DECEMBER 02, 2015

Applies to:

Oracle Applications Manager - Version 12.2.3 to 12.2.5 [Release 12.2]
Oracle Applications DBA - Version 12.2.3 to 12.2.5 [Release 12.2]
Linux x86-64

Symptoms

E-Business Suite 12.2.3, Patch Application Issues

When attempting to apply <Patch 17909318> - R12.ATG_PF.C.delta.4 the following error occurs:

ERROR
-----------------------
ATTENTION: All workers either have failed or are waiting:

  FAILED: file afpubfix.sql on worker 1.

ATTENTION: Please fix the above failed worker(s) so the manager can continue.

Worker 1:
========
sqlplus -s APPS/***** @/u01/yep/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/u01/yep/fs1/EBSapps/appl/fnd/12.0.0/patch/115/sql/afpubfix.sql &un_pub &un_apps &un_fnd &pw_fnd'
Connected.

PL/SQL procedure successfully completed.

Privileges Granted by 'APPS'
GRANT SELECT ON FND_LOOKUPS TO APPLSYSPUB
GRANT SELECT ON FND_LANGUAGES_VL TO APPLSYSPUB
GRANT SELECT ON FND_APPLICATION_VL TO APPLSYSPUB
GRANT EXECUTE ON FND_WEBFILEPUB TO APPLSYSPUB
GRANT EXECUTE ON FND_SECURITY_PKG TO APPLSYSPUB
GRANT EXECUTE ON FND_PUB_MESSAGE TO APPLSYSPUB
GRANT EXECUTE ON FND_MESSAGE TO APPLSYSPUB
GRANT EXECUTE ON FND_DISCONNECTED TO APPLSYSPUB

8 rows selected.

Declare
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant
ORA-06512: at line 43

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply <Patch 17909318>.

2. Confirm the worker failure as documented above.

Changes

Changes were made related to grants, specifically with privileges provided for APPS to APPLSYSPUB on the APPLSYS tables.

Review the following script for more details:

fnd patch/115/sql afpubfix.sql 120.1.12020000.6 from <Patch 17909318>.

For example:

/home/test/bug/22108028/afpubfix.sql.sav APPLSYSPUB
APPS APPLSYS APPS

Privileges Granted by ''APPS''
GRANT SELECT ON FND_LOOKUPS TO APPLSYSPUB
GRANT SELECT ON FND_LANGUAGES_VL TO APPLSYSPUB
GRANT SELECT ON FND_APPLICATION_VL TO APPLSYSPUB
GRANT EXECUTE ON FND_WEBFILEPUB TO APPLSYSPUB
GRANT EXECUTE ON FND_SECURITY_PKG TO APPLSYSPUB
GRANT EXECUTE ON FND_PUB_MESSAGE TO APPLSYSPUB
GRANT EXECUTE ON FND_MESSAGE TO APPLSYSPUB
GRANT EXECUTE ON FND_DISCONNECTED TO APPLSYSPUB

8 rows selected.

Declare
*
ERROR at line 1:
ORA-01927: cannot REVOKE privileges you did not grant
ORA-06512: at line 43

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms