Leave a Comment:
20 comments
Hi Atul,
While creating a user I get the following error in Apps 11i:
Obsolete user exit call
Any thoughts on this error?
Thanks.
Reply[…] To know role of Application Framework Agent in 11i/R12-SSO registration Click Here […]
ReplyIn 11i we faced this issue on FNDSCAUS.fmx version 115.104 and got it resolved by applying the patch 7169718 gives form FNDSCAUS.fmb version 115.112.
ReplyIn 11i,
we faced this issue on FNDSCAUS.fmx version 115.104 and got it resolved by applying the patch 7169718 gives form FNDSCAUS.fmb version 115.112.
change user password or create a new user from define -> user
OBSOLETE USER EXIT CALL dialog box appeared.
ReplyThe above is for OBSOLTE USER EXIT CALL issue on DEFINE -> USER Form
ReplyHi,
I am getting following error while changing password –
Change Password
Error : Oracle error 6503: java.sql.SQLException: ORA-06503: PL/SQL: Function returned without value ORA-06512: at “APPS.FND_OID_PLUG”, line 1137 ORA-06512: at line 1 ORA-06512: at “APPS.FND_LDAP_WRAPPER”, line 1530 ORA-06512: at “APPS.FND_SSO_MANAGER”, line 244 ORA-06512: at “APPS.FND_WEB_SEC”, line 1425 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).
Change Password
* Indicates Required Field
*Current Password
*New Password
*Re-enter New Password
TIP Password must be at least 8 characters long.
PLEASE HELP ME….
ReplyHi Atul,
I am trying to integrate EBS 12.1.1 and Demantra 7.3.
I install the integration patch 8671721 after that I
login into the ebs as sysadmin/sysadmin and add the
Demand Management System Administrator responsibilty
to SYSADMIN
Now I navigate as the following to submit a request..
DMSA–>Other–>Requests–>Find request—Submit a new
Request—->Single request—>
then in the Name textbox I browse for “Update
Synonyms” then I press Submit…..
Here it is showing an error message……
ERROR: Enter a value for schema Name parameter…
but the parameter field was disabled…..
HOW To RESOLVE THIS ISSUE…?
And How to Know whether the patch installed successfully or not ?
Thanks & Regards,
Narendra.ch
You can try adadmin to update/recreate – Synonyms (raise an SR with Oracle for ERROR: Enter a value for schema Name parameter)
How to Know whether the patch installed successfully or not ?
Check patch log files (file entered during adpatch execution) and there should not be any errors reported in this log file.
ReplyDear Atul,
I have to Integrate OID with EBS R12 – 12.1.3, on solaris machine and db version is 11.2.0.2.0
I have 2 server one for application and another for DB.
How to start Integration, can you give some important details ( from which server i.e application or db server from where I can start 1st step), what need to setup first.
Thanks for your co-operation,
Best Regards,
Ather Hussain
Chennai – India
@ Ather,
Register it from any one node.
Do you want to register with just OID or any other integration requirement like SSO (OAM )
Check our R12 integration book at http://onlineappsdba.com/index.php/book/
This book covers installation of OID 11g, integration of EBS with OID 11g using DIP and OAM 11g integration for Single sign-On (step by step instructions).
ReplyHi Atul,
Thanks for quick reply,
I want to use OID to merely authenticate the user’s password via OID to be able to log into EBS (much like an LDAP server), with the rest of the security relying on what currently exists in EBS (responsibilities, etc). We won’t be doing SSO or automated logins or authentication of any kind. That is, as simple as possible.
I request you kindly give some details urgently to start.
As you refer to buy book, how can I buy book in India, they do shipping also ?
Thanks
Ather Hussain
@ Ather Hussain,
I am not sure what you are trying to achieve (validating username/password against OID and not FND_USER) can be done with-out single sign-on solution like OSSO or OAM.
Note: SSO solution is used for just authentication (with OID as user repository) and authroization still lies with EBS via responsibility.
My eBook doesn’t cover just login via OID (without any SSO solution) but includes solution using Oracle Access Manager 11g . I am cusrious to know if what you are trying to achive is possible without any customization and without any single sign-on product.
Book is not hard copy but a eBook (soft copy) in PDF with around 200 pages including screenshots.
Reply[…] Apps 11i/R12/12i Registration/Deregistration with OID/SSO … – Q. If you have multiple nodes with multiple URL’s (intapps.com , extapps.com..) in apps (11i/R12), how many times you have to run OID/SSO Registration Process ? Q. […]
ReplyHi Atul,
orclguid isnt mapping with fnd_guid at ebs end. We are getting the below error in logs. please assist..
Dec 21, 2016 12:59:02 PM oracle.apps.fnd.ext.sso.SsoUser updateUserGuid
SEVERE: SEVERE exception while updating user GUID –>
java.sql.SQLException: ORA-31203: DBMS_LDAP: PL/SQL – Init Failed.
ORA-06512: at “APPS.FND_OID_UTIL”, line 2320
ORA-06512: at line 1
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeCallable(QueryRunner.java:329)
at oracle.apps.fnd.ext.jdbc.utils.QueryRunner.executeNoOutCallable(QueryRunner.java:200)
at oracle.apps.fnd.ext.sso.SsoUser.updateUserGuid(Unknown Source)
at oracle.apps.fnd.ext.sso.FndSsoLogin.ssologin2(Unknown Source)
at oracle.apps.fnd.ext.sso.FndSsoLogin.doPost(Unknown Source)
at oracle.apps.fnd.ext.sso.FndSsoLogin.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:707)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.apps.fnd.ext.sso.FndSsoFilter.doFilter(Unknown Source)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3730)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3696)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2273)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2179)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1490)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
Dec 21, 2016 12:59:02 PM oracle.apps.fnd.ext.sso.FndSsoLogin ssologin2
SEVERE: SEVERE error==>
we run “$FND_TOP/bin/txkrun.pl -script=SetSSOReg -registersso=Yes ”
We are getting oracle.ias.repository.schema.SchemaException: Unable to establish connection to the Oracle Internet Directory Server ldap://pmegadboutros.mrs.com.br:389/. Base Exception : javax.naming.AuthenticationException: [LDAP: error code 49 – Invalid Credentials]
The values in the FND tables are over riding the command line LDAP server name entry.
Is there a way to test the LDAP connection the txkrun.pl script will utilize?
Hi, we have prod SSO and DEV SSO in different domain and after clone when we are running deregister in cloned DEV instance to de-register prod SSO and to continue with registering it against DEV SSO. While we do this step we are seeing the corresponding EBS PROD ldif file from OID goes off from tree causing the issues with production authentication. we have to manually import the ldif file exported before to fix the issue.
Any possible fix to avoid this issue?
Regards
Ranjit Kumar