Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

Path 17350769 VCP12.1.3.9.1 failing on msddem.odf, "ORA-01720: grant option does not exist SYS.DUAL"

edited Jun 28, 2018 11:23AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 1 commentAnswered

We are on 11.2.0.4.4 Database couple of weeks back upgraded the Database from 11.2.0.4.0 to 11.2.0.4.4

Right now while applying Patch : 17350769    scp_pf    VCP 12.1.3.9.1 PATCH ,

We getting following ERRORS:

FAILED: file msddem.odf   on worker  1.

Workers logs says:

ORA-01720: grant option does not exist for 'SYS.DUAL'

occurred while executing the SQL statement:

CREATE OR REPLACE FORCE VIEW APPS.MSD_DEM_CONSTRAINED_FORECAST_V

("PLAN_ID", "SUPPLY_PLAN", "ITEM_CODE", "ORG_CODE", "SITE_CODE  ............

---- All workers log file and patch log file attached. -----------------------

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center