POPULATE_UACCESS IS INVALID WHEN 17.10 DB NLS_CHARACTERSET = WE8MSWIN1252
Last updated on FEBRUARY 13, 2018
Applies to:Primavera P6 Enterprise Project Portfolio Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
When attempting to login to P6 Professional 17.10 or 17.11, using a non-admin user account, the following error occurs:
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
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:
- Run manual_script_before_install
- Run manual_script_before_upgrade
- 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 18.104.22.168.0 and 22.214.171.124.
The issue can be reproduced at will with the following steps:
- Create or upgrade to a 17.10 OR 17.11 database that has a NLS_CHARACTERSET equal to WE8MSWIN1252.
- Login to P6 Professional 17.10 OR 17.11 as a non-admin user.
- Observe the reported error.
- Observe the POPULATE_UACESS shows as invalid within SQL Developer.
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