Erman, the problem was solved (good tip), thank you so much for your help. The steps were as follows.
Run the query
Select * from ods.ct_uniquemember where upper (attrvalue) like '% APPL%'
There were 3 app entries
In the ODSM the entries were deleted, before doing an export of ldif
Cn = userproxyprivilege, cn = groups, cn = oraclecontext, dc = business, dc = com orclapplicationcommonname = APPL, cn = ebusiness, cn = products, cn = oraclecontext, dc = business, dc = com
Then I executed
A) $ FND_TOP / bin / txkrun.pl -script = SetSSOReg -removereferences = Yes
Output
You are removing all SSO-LDAP related preferences.
Enter Oracle E-Business apps database user password?
*** Log File = /u01/install/APPS/fs1/inst/apps/appl_serverlx/logs/appl/ rgf/TXK/txkSetSSOReg_Mon_Jan_ 23_14_07_42_2017.xml
Beginning input parameter validation for Removing Preferences.
Input parameter validation for Removing Preferences completed.
BEGIN REMOVING PREFERENCES:
Oracle Home Instance preferences removed successfully
Updated APPS_SSO profile with value SSWA successfully.
SSO Preferences Removed successfully.
Removing LDAP Directory References Started.
Removing LDAP Directory References Completed Successfully.
Custom DIT Preferences Removed Successfully.
REMOVING PREFERENCES COMPLETED.
B) $ FND_TOP / bin / txkrun.pl -script = SetSSOReg -deregisteroid = yes
Enter Oracle E-Business apps database user password?
Enter LDAP Host name? Oid.business.com
Enter the LDAP Port on Oracle Directory server? 3060
Enter the LDAP Directory Administrator (orcladmin) Bind password?
*** Log File = /u01/install/APPS/fs1/inst/apps/appl_server/logs/appl/ rgf/TXK/txkSetSSOReg_Mon_Jan_ 23_14_08_52_2017.xml
Beginning input parameter validation for LDAP Directory de-registration.
Input parameters validation for LDAP Directory de-registration completed.
BEGIN LDAP DIRECTORY DE-REGISTRATION:
Beginning to delete provisioning profile for this application.
Provisioning profile for this application has been deleted successfully.
Beginning to de-register this application from the LDAP Directory.
This application has been de-registered successfully from the LDAP Directory.
[Info] -> LOADING: /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/admin/ template/ AppsLDAPDeRegistration.tmp
Jan 23, 2017 2:09:21 PM oracle.ldap.util.LDIFLoader loadOneLdifFile
INFO: -> LOADING: /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/admin/ template/ AppsLDAPDeRegistration.tmp
Removing LDAP Directory References Started.
Removing LDAP Directory References Completed Successfully.
LDAP DIRECTORY DE-REGISTRATION COMPLETED.
C) run the query (there are no application entries)
* Select * from ods.ct_uniquemember where upper (attrvalue) like '% APPL%'
No rows selected
D) $ FND_TOP / bin / txkrun.pl -script = SetSSOReg -registeroid = yes
You are registering this instance with LDAP Server.
Enter LDAP Host name? Oid.business.com
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 = /u01/install/APPS/fs1/inst/apps/APPL_computerlx/logs/ appl/rgf/TXK/txkSetSSOReg_Mon_ Jan_23_14_11_38_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: /u01/install/APPS/fs1/EBSapps/appl/fnd/12.0.0/admin/ template/AppsOIDRegistration. tmp
Jan 23, 2017 2:12:07 PM oracle.ldap.util.LDIFLoader loadOneLdifFile
INFO: -> LOADING: /u01/install/APPS/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.
E) Run the query
There are 15 entries
Select * from ods.ct_uniquemember where upper (attrvalue) like '% APPL%'
If you reply to this email, your message will be added to the discussion below:http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/ DeregisterOID-RegisterOID- Error-tp1946p1989.html To start a new topic under EBS 12.2, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML
| Free forum by Nabble |