R12:AP/XLA: Create Accounting Program Returning With an Error - ORA-01017: invalid username/password (Doc ID 2186701.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

When attempting to run Create Accounting, the following error occurs.

ERROR
-----------------------
Exception in static block of jtf.cache.CacheManager. Stack trace is: java.lang.ExceptionInInitializerError
at oracle.apps.jtf.base.resources.Architecture.createWebAppsContext(Architecture.java:441)
at oracle.apps.jtf.base.resources.Architecture.createAppsContext(Architecture.java:434)
at oracle.apps.jtf.base.resources.Architecture.createAppsContext(Architecture.java:343)
at oracle.apps.jtf.cache.ArchitectureWrapper.createAppsContext(ArchitectureWrapper.java:92)
at oracle.apps.jtf.cache.appsimpl.AppsCacheRuntime.getProfileValue(AppsCacheRuntime.java:807)
...
... 31 more

Caused by: oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:937)
at oracle.apps.fnd.security.AppsConnectionManager.getGwyuidConn(AppsConnectionManager.java:1016)
at oracle.apps.fnd.security.AppsConnectionManager.makeGuestConnection(AppsConnectionManager.java:814)
at oracle.apps.fnd.security.DBConnObj.<init>(DBConnObj.java:230)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at oracle.apps.fnd.common.Pool.createObject(Pool.java:1273)
... 31 more
Caused by: oracle.apps.fnd.common.AppsException: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1573)
at oracle.apps.fnd.security.ConnectionManager.dbConnect(ConnectionManager.java:1469)
at oracle.apps.fnd.security.AppsConnectionManager.makeGwyuidConn(AppsConnectionManager.java:919)
... 39 more
Caused by: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

...
oracle.apps.xdo.oa.cp.JCP4XDODataEngine
Program exited with status 1

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot perform any accounting.

Cause

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