Missing Synonyms, Views and Grants Showing In A Schema Validation Report For an Oracle Database After Importing To A New Instance Using P6 EPPM r15.x or Later (Doc ID 2081425.1)

Last updated on JUNE 23, 2017

Applies to:

Primavera P6 Enterprise Project Portfolio Management - Version 15.1.0.0 and later
Primavera P6 Professional Project Management - Version 15.1.0.0 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR
---------------
After importing the Oracle database there are multiple synonyms, grants and views missing in the validation report.

EXPECTED BEHAVIOR
-----------------------
After importing the Oracle database there should be no missing objects in the validation report, thus validating the database.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Import database using Oracle IMP or IMPDP feature.
2. Run the validate.bat
3. Missing objects are displayed in the validation report.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms