Date Prompt Question

Summary

As Of Date Prompt Query

Content

Hi,

I have a number of reports that use the SET VARIABLE PARAM_EFFECTIVE_DATE ='@{AsOfDate}'; that work correctly up to a certain point.

My organisation recently acquired a new legal entity in April but when I enter an AsOf Date for Jan I can see this Legal Entity

included in the headcount figures - it wasn't part of Oracle then so it should be excluded.

Any ideas how I can get a true snapshot of the headcount that predates this new acquisition?

I am using Workforce Management - Worker Assignment Real Time for these headcount report.