Patch 19030202:12.1.0 (RPC2) - Fails With ORA-01720: grant option does not exist for 'SYS.DUAL'
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: