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

MOSC Banner

Patch 19030202:12.1.0 (RPC2) - Fails With ORA-01720: grant option does not exist for 'SYS.DUAL'

edited Nov 5, 2014 8:58AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 2 commentsAnswered ✓

Hello Support,

We got error when we apply the patch:

AD Worker error:

The following ORACLE error:

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

occurred while executing the SQL statement:

CREATE OR REPLACE FORCE VIEW APPS.CE_999_TRANSACTIONS_V ("ROW_ID",

"MULTI_SELECT", "BANK_ACCOUNT_ID", "BANK_ACCOUNT_NAME",

This occurs for several ODFs that are failing

       FAILED: file csccc.odf    on worker  1.

       FAILED: file cevw.odf     on worker  2.

       FAILED: file csptrrq.odf  on worker  6.

       FAILED: file msddem.odf   on worker  8.

       FAILED: file msdsr.odf    on worker  9.

       FAILED: file pav0898.odf  on worker 10.

We have also tried the following and it did not fix the issue:

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