Password Case Sensitivity Lost During Extract And Import From EBS to OID

(Doc ID 951170.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Applications Technology Stack - Version: 11.5.10.2 to 12.1.1
This problem can occur on any platform.
This issue is encountered for the file AppsUserExport.class:
- For 11.5.10.2 with minimum RUP6 version is lower than 115.19
- For 12.0.4 or 12.0.6 version is lower than 120.4.12000000.10.
- For 12.1.1 version is lower than 120.11.12010000.2


You can use the commands like the following:
strings -a $JAVA_TOP/oracle/apps/fnd/oid/AppsUserExport.class |grep '$Header'

Symptoms

When implementing E-Business and AS10g SSO-OID integration, if the password is stored in FND_USER in case sensitive, when the users are bulk-loaded from Apps to OID, the password is migrated to lowercase and the case is not preserved.

EXPECTED BEHAVIOR
Expect the password to be migrated by preserving the case as mentioned by documentation:

Oracle® Applications System Administrator's Guide - Security Release 12.1 Part No. E12843-03
states :
Password Restrictions and Bulk Loading

• Passwords stored in Oracle Internet Directory are case-sensitive. Mixed-case
passwords in Oracle E-Business Suite are migrated with the case preserved.


The issue can be reproduced at will with the following steps:
1. Use AppsExport utility to export Apps users into an intermediary LDIF file
2. Use ldifmigrator to migrate the intermediary LDIF file to a final LDIF file
3. Use ldifmodify or bulkload utility to load the final LDIF file to load the apps user into OID
4. Login with the same user password in Apps via SSO. It is failing. However using the same password in lowercase it is working fine.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms