OTBI - Workforce Management - Worker Assignment Event Real Time Not Showing The Correct Job Name (Doc ID 2173281.1)

Last updated on DECEMBER 16, 2016

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.10.0.0 version, Technology Management - BI & Reporting

ACTUAL BEHAVIOR
---------------
OTBI - Workforce Management - Worker Assignment Event Real Time not showing the date effective Job Name but rather showing the Job Name as at sysdate.

For example say for JOB id : 1111
Effective start date / Effective end date / Name
2013-10-15 / 2014-07-26 / Staff augmentation onsite (NA)
2014-07-27 / 2015-03-01 / Staff augmentation onsite
2015-03-02 / 4712-12-31 / Staff Aug Onsite Desk

 

Assignment Data for person :XYZ with logical query :

SELECT
0 s_0,
"Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Effective End Date" s_1,
"Workforce Management - Worker Assignment Event Real Time"."Assignment Event Details"."Effective Start Date" s_2,
"Workforce Management - Worker Assignment Event Real Time"."HR Action Reason"."Action Reason" s_3,
"Workforce Management - Worker Assignment Event Real Time"."HR Action"."Action Code" s_4,
"Workforce Management - Worker Assignment Event Real Time"."Job"."Job Name" s_5,
"Workforce Management - Worker Assignment Event Real Time"."Worker"."Assignment ID" s_6,
"Workforce Management - Worker Assignment Event Real Time"."Worker"."Employee Name" s_7,
"Workforce Management - Worker Assignment Event Real Time"."Worker"."Person Number" s_8,
DESCRIPTOR_IDOF("Workforce Management - Worker Assignment Event Real Time"."Job"."Job Name") s_9
FROM "Workforce Management - Worker Assignment Event Real Time"
WHERE
("Worker"."Person Number" = '12345')

 

will return following:

Name Action Code Effective Start Date Effective End Date

Staff Aug Onsite Desk TRANSFER 5/1/2015 7/31/2015
Staff Aug Onsite Desk TRANSFER 4/30/2015 4/30/2015
Staff Aug Onsite Desk ASG_CHANGE 3/1/2015 4/29/2015
Staff Aug Onsite Desk TRANSFER 1/23/2015 2/28/2015
Staff Aug Onsite Desk ASG_CHANGE 1/1/2015 1/22/2015
Staff Aug Onsite Desk REN_CWK 4/18/2014 12/31/2014

 

So as seen it always return current job name. It should show the job name which was effective on those days instead of current

 

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