When Trying to Access the Structures Page From the Projects Form, the Following Error Is Received: OAException: java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_250_TBL_TYPE
(Doc ID 3015507.1)
Last updated on APRIL 09, 2024
Applies to:
Oracle Project Foundation - Version 12.2.5 and laterInformation in this document applies to any platform.
Symptoms
When trying to access the Structures page from the Projects form, get the error page:
The Exception Details shows the error stack below:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_250_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.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.pa.util.webui.Security.checkUserPrivilegeAndReg(Security.java:866)
...
## Detail 0 ##
java.sql.SQLException: invalid name pattern: SYSTEM.PA_VARCHAR2_250_TBL_TYPE
at oracle.jdbc.oracore.OracleTypeADT.initMetadata(OracleTypeADT.java:599)
Steps
=====
Using Projects Costing Superuser responsibility
1. Navigate: Projects
2. Open an existing project
3. Under Options, click 'Details' button on the 'Structures' option.
4. Get the error page: "You have encountered an unexpected error. Please contact your System Administrator for assistance."
5. The Error Page Exception Details shows error "invalid name pattern: SYSTEM.PA_VARCHAR2_250_TBL_TYPE"
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |