hi sorry i can't comment on Work definitions as don't use that but the audits tables return same info as UI for what we've enabled

Hi Audit tables have an underscore suffix. Eg if turned audit on for Salary changes, then the salary table is CMP_SALARY therefore the audit changes are in CMP_SALARY_

Sorry I have't used OAC

hello - I'm sure there are a few possibilities.. This is one way Not sure what your 1st column is so below I've used Assignment type instead, but principal is the same. Create separate metrics for each gender : i) Female : sum(case when "Person Legislative Information"."Sex" = 'Female' then "Person"."Person Count" end by…

Just click on options and choose whats appropriate for the LOV. eg can select "specific column values" and just enter the values you want or "SQL results" to include some logic to what you want returning etc

You looked at Historical Reported Time cards subject area? Think this will give you what you need

hi i can't comment on that specific use case, but i would say normally when combine Subject Areas, its to bring in Measures, not Dimensions. The Invoice Recieved Date dimension probably doesnt conform with the other ones from AP, hence why not getting the data. I think answer might be to have to create/amend the logicial…

Mark that URL to the documentation should help as it has examples of when stuff is purged… We've got the purge job running, but we dont have the requirement to look at old tasks, so i've not looked into this in great detail. Maybe someone else can help on here..

thats the reason then…its purging the data?

Have you got the schedule process "Archive and Purge Journey Data" running? https://docs.oracle.com/en/cloud/saas/human-resources/24d/faijh/examples-of-assigned-journeys-archive-and-purge.html#Example-1

Each time you create a new OTBI report you are starting with a blank canvas - that is the funcitonality of the product. If you always have say 5 fields in most reports - obviously you can always save this report as and use this has a "template" ie the starting position for new reports. For filters - If you are always…

Formula looks fine. Is your Legal Employer status definatley "A" ? Add it into the query so can see what values it contains. For me it is returning "Active" so this formula works for me case when "Legal Employer"."Status" = 'Active' then "Legal Employer"."Name" end

ah ok..apologies I’ve misunderstood then. So running simple hierarchy report returns correct results..if so then what is the scenario / query that isn’t working ?

Have you ran the Refresh hierarchy schedule process? Refresh Manager Hierarchy - Doc ID 2898242.1

See the Syntax error - you have a closing bracket but not an opening one

just add a max round your case statment max(case when "Person Phones"."Phone Type" = 'Home Phone' then "Person Phones"."Phone Number" end)

Or just a simple CASE statement Case when Legal Employee Active Status = 'Active' then Legal Employer name End

You don't need to use "is prompted": Create a filter on the required column > Add more options > select presentation variable and enter the name of the variable. So if your filtering on say a Year column and your pres variable is called "Var_year", then your filter will then look like: Year is equal to / is in @{Var_year}

If you look at the SQL that has been generated when you've ran the report .. if this shows "and 1=2"…. then this means you don't have a role that grants access. If you have the required role, you will see "and 1=1"