PCG 7.3.2: Log File of Upgrade from 7.3.1 to 7.3.2 Shows Following Error "ORA-01720: grant option does not exist for....".
(Doc ID 1943017.1)
Last updated on OCTOBER 10, 2023
Applies to:
Oracle Preventive Controls Governor - Version 7.3.1 and laterInformation in this document applies to any platform.
Symptoms
On : 7.3.2 version, Install, Migration, Upgrade
When attempting to Upgrade PCG 7.3.1 to PCG 7.3.2 DB component,
the following error occurs.
ERROR
-----------------------
Exception :
SQL Message : ORA-01720: grant option does not exist for 'XXLAAPPS.LA_BR_RULES_B'
FROM LAA_CONFLICT_RULES LCR
*
ERROR at line 7:
ORA-01720: grant option does not exist for 'XXLAAPPS.LA_BR_RULES_B'
LAA_GROUPS
*
ERROR at line 10:
ORA-01720: grant option does not exist for 'XXLAAPPS.LAA_GROUPS_B'
ERROR at line 73:
ORA-01720: grant option does not exist for 'XXLAAPPS.LAAF_PROCESS_FLOWS_B'
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Make sure application is at PCG 7.3.1 level.
2. Run Db component of PCG 7.3.2.
3. Check the log and error file of install.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot complete the upgrade.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |