Schema Validation Tool Reports Missing Synonyms (SETTINGS_READ_STRING, SETTINGS_WRITE_STRING, ADD_DATABASE_JOB, INITIALIZE_BACKGROUND_PROCS, SYSTEM_MONITOR, DATA_MONITOR) for the Background-Job Schema User in an Oracle Database (Doc ID 2166427.1)

Last updated on JULY 25, 2017

Applies to:

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

Symptoms

The validate.bat (.sh) Schema Validation tool reports the following synonyms are missing from the P6 EPPM database (Oracle Schema):

The issue can be reproduced at will with the following steps:

  1. Run the validate.bat utility
  2. View the 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