While integrating OID 220.127.116.11 with EBS 12.2 (Reference Doc), the command got completed but with below error:-
[email@example.com <PATCH> ]$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -registeroid=yes -provisiontype=3 -rdbmsdn=cn=OracleContext You are registering this instance with LDAP Server. Enter LDAP Host name? oid.oraworld.local Enter the LDAP Port on Oracle Directory server? 3060 Enter the LDAP Directory Administrator (orcladmin) Bind password? Enter the instance password that you would like to register this application instance with? Enter Oracle E-Business apps database user password? *** Log File = /ebs01/inst/fs1/inst/apps/ebs01_oraworld01.local/logs/appl/rgf/TXK/txkSetSSOReg_Wed_Sep_13_16_49_05_2017.xml Beginning input parameter validation for LDAP Directory registration. Input parameters validation for LDAP Directory registration completed. BEGIN LDAP DIRECTORY REGISTRATION: Beginning to register Application and Service containers if necessary. Application and Service containers were created successfully if necessary. Beginning to register application in the LDAP Directory. Registration of application in LDAP Directory completed successfully. [info] -> LOADING: /ebs01/applmgr/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp Sep 13, 2017 4:49:28 PM oracle.ldap.util.LDIFLoader loadOneLdifFile INFO: -> LOADING: /ebs01/applmgr/fs1/EBSapps/appl/fnd/12.0.0/admin/template/AppsOIDRegistration.tmp Beginning to register provisioning profile in the LDAP Directory. Registration of provisioning profile in the LDAP Directory completed successfully. Application is now registered successfully with provisioning in the LDAP Directory. *** ERROR : java.sql.SQLException: ORA-06576: not a valid function or procedure name
Upon analysis I found out, that procedure fnd_sso_util.enableLDAPIntegration() was not found.
<message>FAILED : fnd_sso_util.enableLDAPIntegration() failed to execute.</message>
The issue has been documented in the following defect:
<Bug 25058349> – UNABLE TO REGISTER OID ON 12.2.5 WITH DELTA 8 DUE TO MISSING FND_SSO_UTIL
The issue results due to Patch 22504894:R12.TXK.C, as the patch has dependencies on an FND patch which is missing in 12.2.5.
For 12.2.6 – Patch 21882506:R12.FND.C patch was included in R12.FND.C.delta.6, so we should not see the above error message for OID registration.
For 12.2.5 and lower – FND one off Patch 24691100:R12.FND.C is available and provides the required file to resolve the dependency issue.
To resolve the issue, I downloaded and installed Patch 24691100 along with any required prerequisite patches.
Hope it helps.