POPULATE_UACCESS IS INVALID WHEN 17.10 DB NLS_CHARACTERSET = WE8MSWIN1252 (Doc ID 2335275.1)

Last updated on FEBRUARY 09, 2024

Applies to:

Symptoms

When attempting to login to P6 Professional 17.10 or 17.11, using a non-admin user account, the following error occurs:

ERROR

Exception TDBXError in module PM.exe at 00000000003628DF,
ORA-06550: line 2, column 18:
PLS-00905: object P6_PRD_TAR_ADM.UACCESS_MAINTAIN_FOR_USER is invalid
ORA-06550: line2, column 3:
PL/SQL: Statement ignored

ADDITIONAL INFORMATION

The issue occurs when the database is upgraded from 17.7 to 17.10 OR 17.11, using the patchset 10 OR 11 EPPM media (Patchset 10 = p26899023_170000_Generic.zip / Patchset 11 = p27048196_170000_Generic.zip) and the following steps to duplicate:

1. Run manual_script_before_install
2. Run manual_script_before_upgrade
3. Run DBSetup.bat

The upgrade is successful.  However, POPULATE_UACESS procedure becomes invalid.

The same issue occurs from a NEW 17.10 or 17.11 database, created using DBSetup.bat from the respective patchset media.

Login to P6 Professional 17.10 or 17.11 as an admin user is successful, because an admin user does not access that procedure.

The issue ONLY occurs when the NLS_CHARACTERSET is equal to WE8MSWIN1252. However, this characterset is listed in the tested configuration document:  https://docs.oracle.com/cd/E80667_01/96413.htm

The issue occurs on both Oracle 12.1.0.2.0 and 12.2.0.1.

STEPS

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

1. Create or upgrade to a 17.10 OR 17.11 database that has a NLS_CHARACTERSET equal to WE8MSWIN1252.
2. Login to P6 Professional 17.10 OR 17.11 as a non-admin user.
3. Observe the reported error.
4. Observe the POPULATE_UACESS shows as invalid within SQL Developer.

Cause

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