Workforce Management - Worker Assignment Real Time: pulling Active and inactive assignment statuses

Rama123-Oracle

How to get the current assignment status of worker using "Workforce Management - Worker Assignment Real Time" , it is showing both inactive and active assignment statuses of active worker as of today(especially in case of global transfer).. attached cataglog and excel with sample data..

Worker - realtime for 1 emp (1).xlsx

Worker - realtime for 1 emp.catalog

if we filter using inactive status, it won't pull active employees code..

Please suggest.

gclampitt

Can't you just add a filter : Assignment Status = Active - Payroll Eligible
then will just pick the current record and not the previous one that is now inactive?

Rama123-Oracle

no, we wanted to get the all employees current assignment statuses - for few employees, the current status is inactive..

MandeepGupta

https://community.oracle.com/products/oracleanalytics/discussion/24400/workforce-management-worker-assignment-real-time-pulling-active-and-inactive-assignment-statuses

You can make use of RANK or RCOUNT function to pull only the latest record.

Check below threads for samples:

Duplicated records on OTBI Report linked to different assignments on Person data — Cloud Customer Connect

How to get the latest record in OTBI — Cloud Customer Connect

Thanks.

gclampitt

Yep mandeeps solution works.

Can also use a subquery to achive the same:
Create a report whch will be used as a subquery report which returns the person number and max(assignment number). - so that will return "E1-2"

Then in you main report add a filter on assignment number and reference the Max assignment number in the subquery report.
Main Report Filter : Assignment number = Max(assignment number) from SQ report

Nathan CCC

Hi Rama,

1. "How to get the current assignment status of worker"?

It is already getting all the "current" assignments. To get the current assignments you need to do nothing.

If you view log you will see this subject area default is the effective as at today. So unless you have changed the session variable you are already getting the latest version in any one day of all all the current work assignments effective as at today. Your historic work assignments with effective end dates in the past are already filtered out. If you are getting assignments with status type INACTIVE then that is because they are in fact "Current" because their effective end date is in the future.

2."if we filter using inactive status, it won't pull active"?

I think you are mistaken. not sure why you said that. I think you will find that if you filter where status type <> INACTIVE, SUSPENDED then it WILL get the ACTIVE assignments.

gclampitt

Nathan
re: Effective dates - this is the issue with Global transfers - the old pre-transfer record is still active (end date 31/12/4712) - which is why both records then get returned - they are both "current" so nothing to do with changing the session variable etc.
Oracle provide the GT functionality but we've had so many issues with processes over the last few years which just don't work with GTs.

re : Active - I think rama said he cant filter on Active becauses there are some people who are inactive that he needs to return.