Applying Patch 24690690 Failed With ORA-01720: Grant Option Does Not Exist For 'APPLSYS.FND_EID_ETL_AUDITS#'

(Doc ID 2337680.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Applications DBA - Version 12.1.3 to 12.2.6 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When Applying Patch 24690690, following error is generated:

Error message is: ORA-04020: deadlock detected while trying to lock object APPS.CST_END_TXN_REG_INV_V

WARNING: Unable to create view CST_END_TXN_REG_INV_V due to the error ORA-04020: deadlock detected while trying to lock object APPS.CST_END_TXN_REG_INV_V

Error message is ORA-01720: grant option does not exist for 'APPLSYS.FND_EID_ETL_AUDITS#'

Connecting to APPS......Connected successfully.

AD Worker warning:

Revoking the grants on object "APPS.OZF_ED_F_OPEN_CLAIMS_V" not given by "APPLSYS.FND_EID_ETL_AUDITS#" to APPS

AD Worker error:
aduoprcRevokeGrantsOnObject_err(): Error while executing statement

AD Worker error:
ORA-04063: view "APPS.OZF_ED_F_OPEN_CLAIMS_V" has errors
ORA-06512: at "APPS.AD_ZD_TABLE", line 2640
ORA-06512: at line 2

Changes

 Applying Patch 24690690

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