Missing Synonyms, Views and Grants Are Listed in a Schema Validation Report for a P6 EPPM r15.x or Later Oracle Database After Importing It to a New Instance
(Doc ID 2081425.1)
Last updated on SEPTEMBER 09, 2020
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 126.96.36.199 and later
Primavera P6 Professional Project Management - Version 188.8.131.52 and later
Information in this document applies to any platform.
After importing a P6 EPPM 15.1 or later Oracle database, multiple synonyms, grants and views are listed as Missing in the ~\database\validate.bat (.sh) Schema Validation report.
There should be no Missing objects in the Schema Validation report after importing the database.
The issue can be reproduced at will with the following steps:
- Import database using Oracle IMP or IMPDP feature.
- Run the Schema Validation utility (~\database\validate.bat (.sh)).
- Observe the Missing objects displayed in the Schema Validation report.
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