ORA-20001: Unabled to call fnd_ldap_wrapper.update_user, ORA-06512: at "APPS.APP_EXCEPTION"

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: ORA-20001: Unabled to call fnd_ldap_wrapper.update_user, ORA-06512: at "APPS.APP_EXCEPTION"





Symptoms:
Failed to update password. Oracle error 20001: java.sql.SQLException: ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason:
ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason: An unexpected error occured.Please contact System Administrator.. ORA-
06512: at "APPS.APP_EXCEPTION", line 72 ORA-06512: at "APPS.FND_USER_PKG", line 3955 ORA-06512: at "APPS.FND_USER_PKG", line 3981 ORA-06512: at
"APPS.FND_WEB_SEC", line 1351 ORA-06512: at "APPS.FND_WEB_SEC", line 1379 ORA-06512: at "APPS.FND_WEB_SEC", line 1460 ORA-06512: at "APPS.FND_WEB_SEC",
line 1250 ORA-06512: at line 1 has been detected in SessionManager.changePassword(String, String, String, String, Connection).

Log files:
debug.log
[Jul 20, 2010 6:52:41 AM EDT]:1279623161188:Thread[Thread-140,10,main]:6:730315229:jebuap02.dubaiworld.ae:172.30.112.12:8140:16400:ERROR:[fnd.common.ErrorStack]:java.sql.SQLException: ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason:
ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason:
An unexpected error occured. Please contact System Administrator..
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_PKG", line 3955
ORA-06512: at "APPS.FND_USER_PKG", line 3981
ORA-06512: at "APPS.FND_WEB_SEC", line 1351
ORA-06512: at "APPS.FND_WEB_SEC", line 1379
ORA-06512: at "APPS.FND_WEB_SEC", line 1460
ORA-06512: at "APPS.FND_WEB_SEC", line 1250
ORA-06512: at line 1

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:590)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1973)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1119)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2191)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:2064)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2989)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:658)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:736)
at oracle.apps.fnd.security.SessionManager.changePassword(SessionManager.java:2616)
at oracle.apps.fnd.security.SessionManager.changePassword(SessionManager.java:4199)
at oracle.apps.fnd.sso.SessionMgr.changePassword(SessionMgr.java:294)
at oracle.apps.fnd.sso.SSOAccessEnabler.changePassword(SSOAccessEnabler.java:69)
at _oa__html._AppsChangePassword._jspService(_AppsChangePassword.java:472)
at oracle.jsp.runtime.HttpJsp.service(HttpJsp.java:119)
at oracle.jsp.app.JspApplication.dispatchRequest(JspApplication.java:417)
at oracle.jsp.JspServlet.doDispatch(JspServlet.java:267)
at oracle.jsp.JspServlet.internalService(JspServlet.java:186)
at oracle.jsp.JspServlet.service(JspServlet.java:156)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
at org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
at org.apache.jserv.JServConnection.run(JServConnection.java:294)
at java.lang.Thread.run(Thread.java:595)

[Jul 20, 2010 6:52:41 AM EDT]:1279623161201:Thread[Thread-140,10,main]:6:730315229:jebuap02.dubaiworld.ae:172.30.112.12:8140:16400:STATEMENT:[fnd.sso.html.AppsChangePassword.jsp[$Revision: 115.42 $]]:password change failed Oracle error 20001: java.sql.SQLException: ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason:
ORA-20001: Unabled to call fnd_ldap_wrapper.update_user due to the following reason:
An unexpected error occured. Please contact System Administrator..
ORA-06512: at "APPS.APP_EXCEPTION", line 72
ORA-06512: at "APPS.FND_USER_PKG", line 3955
ORA-06512: at "APPS.FND_USER_PKG", line 3981
ORA-06512: at "APPS.FND_WEB_SEC", line 1351
ORA-06512: at "APPS.FND_WEB_SEC", line 1379
ORA-06512: at "APPS.FND_WEB_SEC", line 1460
ORA-06512: at "APPS.FND_WEB_SEC", line 1250
ORA-06512: at line 1
has been detected in SessionManager.changePassword(String, String, String, String, Connection).


Solution:



1. Please set the profile "Application SSO Change Password URL"/APPS_SSO_CHANGE_PWD_URL to oiddas change password page:
e.g.
http://.:/oiddas/ui/oracle/ldap/das/mypage/ChgPwdMyPage

2. Bounce apache

3. Retest

Run the following diagnostic tests to figure out the issue
1) Login to the E-Business Suite locally as sysadmin:
http://server:port/OA_HTML/AppsLocalLogin.jsp
2) Select responsibility "CRM HTML Administration" from the Navigator's left pane
3) Select function "Diagnostics" from the Navigator's right pane. This will launch a new window (make sure you've turned off any pop up blockers)
4) Click on the "Basic" tab
5) Choose "Application Object Library" from the Applications drop down
6) Click on "SSO Setup Tests" - Click on "Run Without Pre-Requisite"
7) Click on the "Report" icon for each test and verify the results
8) Repeat the same steps for the "OID Setup"
9) Click on the "Advanced" tab
10) Click on "SSO Setup Tests" > "E-Business account SSO Information"
11) Type any user name for which you want information and then click "Run Test"

Get Oracle Certifications for all Exams
Free Online Exams.com