ORA-20001 The LDAP APPS DN ldap password has expired when creating oracle accounts in EBS.

Tip of the week
Issue: ora-20001 The LDAP APPS DN ldap wrapper error message when trying to create oracle accounts in EBS R12.1.3 integrated with IDM 11g.

Solution: you can reset the password using the following command. But you need to get the DN and APPS_DN password.

1. To get DN, run the following from the apps user in EBS node

SQL> select fnd_preference.get(‘#INTERNAL’, ‘LDAP_SYNCH’,’USERNAME’) Apps_Instance_OID_Account from dual;
APPS_INSTANCE_OID_ACCOUNT
——————————————————————————–
orclApplicationCommonName=”Instance”,cn=”EBusiness”,cn=Products,cn=OracleContext,dc=company,dc=com

2. Get current password for appsDN user:

SQL> select fnd_preference.eget(‘#INTERNAL’, ‘LDAP_SYNCH’,’EPWD’,’LDAP_PWD’) Apps_Password from dual;
APPS_PASSWORD
——————————————————————————–
current_password

3. Run the following command.

$ORACLE_HOME/bin/ldapmodify -h <oid_host> -p <oid_port> -D cn=orcladmin -w <passwd> -v <<EOF
dn: orclapplicationcommonname=prd1, cn=ebusiness,cn=products,cn=oraclecontext,cn=ddi,cn=net
changetype: modify
replace: userpassword
userpassword: <existing_APPS_DN_password>
EOF
4. Redo the “ldapbind” test and ensure that it is successful.
PS: You can do this while all the services are up and running.
Reference docs: How To Change AppsDN Password For E-Business Suite In OID 11g (Doc ID 1902514.1)

Implementing Simplified Chinese or other languages in Oracle EBS R12

Tip of the week: Implementing Simplified Chinese or other languages in Oracle EBS R12
One of the requests I recently came across was to eliminate ambiguity on implementing a new language. Furthermore, many folks wanted to ensure their existing Oracle E-Business Suite language packs are in sync with the primary applications language American English.
Now you can hit both the sparrows in one stone, as they say.
In the past, we apply the language specific 4440000 patches and then apply the relevant language patches. Now that has become history, Oracle has considerably enhanced yet streamlined the process to address the requirement.
So where do you start?
Identify the language that you wanted to install and activate it using Oracle Applications Manager’s (OAM) License Manager.
Oracle recommends that you run maintain multi-lingual tables from the Maintain Applications Database Entities menu in adadmin.
To be on safer side, run the maintain snapshots from adadmin.
Now you have set your environment to install the new language pack.
Oracle provides scripts to generate the manifest of your R12 EBS environment, Output of those scripts needed to be uploaded to https://updates.oracle.com/TransSync .
In 2-4 hours you will start receiving emails for each language in your environment from Translation Synchronization Notification team. Similar to the below.
Dear Customer,
Your R12 Translation Synchronization patch 12345678 for Simplified Chinese is available at:
https://updates.oracle.com/ARULink/SimpleSearch/process_form?search_type=patch&patch_number=12345678&plat_lang=14L
 The current authorization password is "hello2323". It is valid for 7 days from the date of this email. You may access all your Translation Synchronization patches at any time, with up-to-date passwords, at the following URL:
https://updates.oracle.com/TransSync
 Contact Oracle Support if you have any issue or concern with this patch.
 You just have to download the patches and apply in the appropriate instance using adpatch. Thats it :)
Useful MOS note: Requesting Translation Synchronization Patches [ID 252422.1]