Reset The Last Applied Change Number in a Provisioning Profile

Issue faced
EBS provisioning profile trying to retrieve number of changes are more than size limit. Time to search all changes taken more than 3600ms i.e maximum time allowed for a search to complete.

image

You can check above configuration from enterprise manager or check “orcltimelimit “ “orclsizelimit” in cn=oid,cn=osdldapd,cn=subconfigsubentry

Verification

ldapsearch -h <hostname> -p <port> -D cn=orcladmin -w xxxxxx -b “” -s base “objectclass=*” lastchangenumber

ldapsearch -h <hostname> -p <port> -D cn=orcladmin -w xxxxxx -b “cn=provisioning profiles,cn=changelog subscriber,cn=oracle internet directory” -s sub objectclass=* | grep orcllastappliedchangenumber

lastchangenumber – orcllastappliedchangenumber > Maximum number of entries to be returned by search

Solution

Reset the last applied change number in provisioning profile.

oidprovtool operation=modify ldap_host=”<hostname>” ldap_port=”<port>” \
ldap_user_dn=”cn=orcladmin” ldap_user_password=”xxxx” application_dn= \
“orclApplicationCommonName=PROD,cn=EBusiness,cn=Products,cn=OracleContext,dc=domain”\
lastchangenumber=”XXXX”

At prompt, enter following details
Interface Connection information –> <Apps_DB_host>:<Apps_DB_Port>:<Apps_SID>:<Apps_schema_user>:<apps_password>

Advertisements

OID provisioning profile apps password change

After changing apps password on EBS with FNDCPASS or AFPASSWD perform below steps to change password in OID provisioning profile.

Execute below command on OID server

oidprovtool operation=modify ldap_host=<OID_HOSTNAME> ldap_port=<OID_PORT> ldap_user_dn=<OID_ADMIN_USER> application_dn=<APPLICATION_DN>

application_dn = Run the following query as the APPS user
SELECT * FROM fnd_user_preferences WHERE preference_name = ‘USERNAME’

On prompt enter OID admin user password and interface_connect_info as below

<db_host>:<db_port>:<SID>:apps:<new_apps_password>

If your EBS is integrated with OAM for SSO check EBS accessgate datasource. If user used in datasource is apps, update the datasource with new apps password.