Search Worker Does Not Return Results At Worker Component (Doc ID 1440198.1)

Symptoms

Search Worker Does Not Return Results At Worker Component.
Incorrect update of record PS_RD_WRKR_JOB cause Worker not able to search Worker from worker component.

The issue can be reproduced at will with the following steps:

1. Create or Search worker who will have multiple job records in HRMS
2. Make sure in CRM it will have same number of job records
3. Run below sqls in CRM database:
   • SELECT WRKR_ASGN_SEQ,EFFDT,WRKR_JOB_SEQ FROM PS_RD_WRKR_JOB WHERE BO_ID=<BO_ID_Number>;
   • SELECT WRKR_ASGN_SEQ,WRKR_JOB_SEQ FROM PS_RD_WRKR_ASGN WHERE BO_ID=<BO_ID_Number>;
4. Add new job record (5th job record) in HRMS with current in HRMS
5. In CRM it will show 5 job records as worker component
6. Run the same sqls again in CRM database, it will show record PS_RD_WRKR_JOB updated correctly
7. In HCM change the effective date of last job data to some previous date (for e.g. Change effective date from 4/13/212 to 4/12/2012) and save the data
8. In CRM run the same sqls again, note that WRKR_JOB_SEQ field update in-correctly in records PS_RD_WRKR_JOB
   • SELECT WRKR_ASGN_SEQ,EFFDT,WRKR_JOB_SEQ FROM PS_RD_WRKR_JOB WHERE BO_ID=<BO_ID_Number>;
   • SELECT WRKR_ASGN_SEQ,WRKR_JOB_SEQ FROM PS_RD_WRKR_ASGN WHERE BO_ID=<BO_ID_Number>;
9. Will not able to search the worker in CRM database as WRKR_JOB_SEQ field does not match value in records PS_RD_WRKR_JOB and PS_RD_WRKR_ASGN.

Another scenario:

If a row is updated for an Employee in HRMS, subscribing to WORKFORCE_SYNC causes the following three issues in CRM:

1. Column SYNCDTTM in table RD_WRKR_ASGN gets updated for all rows with today date, regardless the PersonID (while it should be updated only the row related to the Employee that has been modified)
2. Number of rows returned when querying RB_WORKER from a SQL Client tool is different (before subscription number of rows returned is higher than after subscription)
3. Number of results returned in Search Worker page in CRM also changes after subscription.

Cause

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