My Oracle Support Banner

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 04, 2023

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

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.

EXPECTED BEHAVIOR

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:

  1. Import database using Oracle IMP or IMPDP feature.
  2. Run the Schema Validation utility (~\database\validate.bat (.sh)).
  3. Observe the Missing objects displayed in the Schema Validation report.

Changes

 

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
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.