OID Experts anyone
- From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
- To: "Oracle-L Freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 18 Oct 2007 15:44:45 +0100
I've been struggling with OID directory integration for a couple of days
now, not least because of the paucity of documentation and the inaccuracy of
the docs as well - posting as an example a sqlstatement that won't even
compile is pretty poor really. Anyway If anyone could help me out with Apps
HR to OID integration I'd be very grateful - my problem statement is below.
I've been researching this for a couple of days now with limited success. I
have OID 10.1.4.0.1 setup on windows and am trying to provision users from
an ebusiness suite HR installation. I have performed the following steps so
far
1. Got the sample synchronisation to work from the documentation
I need however to synchronise my own information from HR rather than the
supplied sample configuration. Since some of the data comes from tables you
can't map directly I am attempting to use a custom sql statement in the
configuration file. So I next did
2. Follow note 352816.1 from metalink and successfully get their sample sql
statement to work.
3. Modify the sqlstatement to return the data that I want. Run odihragent
manually as follows.
C:\oracle\10.2.0\IM\ldap\odi\conf>C:\oracle\10.2.0\IM\ldap\odi/bin/odihragent
SQLHRAgent connect=<tnsnames entry> login=apps pass=<pass>
date=20000101000000 - this generates a .dat file with the correct data in
it.
4. enable the dip profile for SQLHRAgent and start odisrv. This runs but no
entries are created in OID, The trace file for the profile reads as follows
-------------------------------------------------------------------------------
Trace Log Started at Thu Oct 18 15:21:44 BST 2007
-------------------------------------------------------------------------------
Executing Agent Command:ldap/odi/bin/odihragent SQLHRAgent
connect=<TNSNAMES> login=apps pass=<PASSWORD> date=20000101000000
Return Status : 0
Command exec succesful
Current ConDirChangeNumber (Rec #) : 0
Reader Initialised !!
LDAP URL : (HOSTNAME:389 cn=odisrv+orclhostname=HOSTNAME,cn=registered
instances,cn=directory integration platform,cn=products,cn=oraclecontext
Specifying binary attributes: mpegvideo objectguid objectsid guid
usercertificate orclodipcondirlastappliedchgnum
LDAP Connection success
Writer Initialised!!
Writer proxy connection initialised!!
MapEngine Initialised!!
Filter Initialised!!
Assuming Change Numbers Not Present in File
Search Changes Done
Setting Change Success Count : 0
Setting Change Failure Count : 0
Replacing Attribute orclodipLastSuccessfulExecutionTime in the Profile with
value : 20071018152144
Removed Existing attribute
RePopulated Attribute..
Updated Attributes
orclodipLastExecutionTime: 20071018152144
orclodipConDirLastAppliedChgNum: 0
orclOdipSynchronizationStatus: Synchronization Successful
orclodipLastSuccessfulExecutionTime: 20071018152144
Ending Mapping execution.
I assume therefore that there may be some mapping or matching error - does
anyone know how to further troubleshoot this.
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
Other related posts:
