After Upgrade from 12.2.3 to 12.2.10, When Trying to Access Any of the Project's Self Service Pages, the Following Error is Received: OAException: java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_80_TBL_TYPE (Doc ID 2932127.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Project Foundation - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When trying to access the Project List page or any Project's Self Service pages, the following error stack is returned:

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_80_TBL_TYPE
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:998)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:818)
...

## Detail 0 ##
java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_80_TBL_TYPE
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:599)

Steps to Reproduce:

Project Super User responsibility | Project | Project List