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 AUGUST 30, 2021
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 18.104.22.168 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