My Oracle Support Banner

Private Database User (PRIVUSER), Public Database User (PUBUSER), Background Job User (BGJOBUSER) Or Reporting Database User (PXRPTUSER) Not Listed In Dropdown When Using DBSETUP To Upgrade A P6 EPPM Database (Doc ID 2135070.1)

Last updated on MARCH 22, 2022

Applies to:

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


When attempting to upgrade P6 EPPM database (for example, from r8.3.2 to r16.1) using DBSETUP, any of the following conditions occur when required to select a P6 EPPM database user from the associated drop down fields:

When attempting to upgrade a P6 EPPM database using DBSETUP, for the required database users to be present in the dropdown fields.

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

  1. Run dbsetup.bat (or .sh) utility
  2. Provide database connection information on database connection screen, then select Next
  3. Enter the P6 EPPM schema owner, then select Next.
  4. On the two screens:
    1. First Screen, the Private, Public, Background job users may possibly not display the associated usernames in the dropdown fields.
    2. Second Screen, the Reporting database user may possibly not display the associated username in the dropdown field.

The issue has the following business impact:
Due to this issue, users cannot successfully upgrade the P6 EPPM database.


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

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