Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

eBusiness HRMS Trusted Reconciliation: Contingent Workers Recon in OIM

788860Dec 16 2010 — edited Dec 16 2010

Hi

I am not able to perform recon for contingent workers from HRMS. I am able to perform recon for full time users.

But the user exists in HMRS. I am able to query the user record in this table PER_ALL_PEOPLE_F.

i have modified the text in all the queries(ebsERQuery.properties) from 'Contingent Employee' to 'Contingent Worker' in this line WHERE PPT.USER_PERSON_TYPE IN('Employee','Contractor','Contingent Worker')

Then in the lookup Lookup.EBS.HRMS.PersonTypes, i have changed Contingent Employee to Contingent Worker.

But still OIM says no record found.

DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getResultList : ResultSetMetaData: oracle.jdbc.driver.OracleResultSetMetaData@3149fc4e
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getResultList : Row Count=0
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getResultList : Column List is empty
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getResultList:: FINISHED
ERROR QuartzWorkerThread-2 OIMCP.EBSER - ====================================================
ERROR QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getPagedRecords : No record found.
ERROR QuartzWorkerThread-2 OIMCP.EBSER - ====================================================

DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getPagedRecords:: FINISHED
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.common.dao.DBUtil : getFirstPage:: FINISHED
INFO QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.hrms.tasks.EmployeeReconciliationTask : execute : No records fetched
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.hrms.tasks.EmployeeReconciliationTask : execute : Update Reconciliation Last Execution Time
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.hrms.tasks.EmployeeReconciliationTask : updateReconLastExecutionTime:: STARTED
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.hrms.tasks.EmployeeReconciliationTask : updateReconLastExecutionTime:: FINISHED
DEBUG QuartzWorkerThread-2 OIMCP.EBSER - oracle.iam.connectors.ebs.hrms.tasks.EmployeeReconciliationTask : closeDBConnection:: STARTED

Pls help

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 13 2011

Added on Dec 16 2010

#identity-management, #identity-manager

3 comments

221 views