OID 11g DIP Mapping With Trunc Function Validation Fails Due to Case Sensitivity. Error: Invalid Mapping Expression (Doc ID 1340899.1)

Last updated on FEBRUARY 19, 2019

Applies to:

Symptoms

AD->OID synchronization on OID 11g.

Synchronization or Bootstrap using specific mapping rule with trunc function can fail because trunc does a case-sensitive string match.

Error: Invalid Mapping Expression

For Example:
Domain mapping rules are:
OU=Users1,DC=t1,dc=<COMPANY>,dc=com:ou=ADUsers,cn=users,dc=<COMPANY>,dc=com
OU=groups,DC=t1,dc=oracle,dc=com:cn=groupsAD,cn=groups,dc=<COMPANY>,dc=com

Attribute rule:
member: : :group:uniquemember: :groupofuniquenames:trunc(member,",ou=")+",ou=ADUsers,cn=users,dc=<COMPANY>,dc=com"
Validates fine.

After bootstrap:
syncProfileBootstrap -h <HOSNAME> -p 7005 -D weblogic -pf <ProfileName>
In OID afterwards:
The example user that was bootstrapped.  dn: cn=user\, my,ou=adusers,cn=users,dc=<COMPANY>,dc=com

The example group:
cn=<GROUPNAME>,ou=security,cn=groupsAD,cn=groups,dc=<COMPANY>,dc=com
Has member:
cn=user\, my,ou=users1,dc=t1,dc=<COMPANY>dc=com,ou=adusers,cn=users,dc=<COMPANY>,dc=com
-- (It should be cn=user\, my,ou=adusers,cn=users,dc=<COMPANY>,dc=com)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.