You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

OTBI Added formula column and filter stopped working

edited Mar 12, 2025 7:50PM in Reporting and Analytics for HCM 4 comments

Summary:

I added a column from the Subject Area Recruiting - Recruiting Events Real Time of:

CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_POSTING' THEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Event Date" ELSE NULL END

But now it is ignoring my filter from the Subject Area

Recruiting - Recruiting Events Real Time

of:

"Job Application - Progression"."Current Phase" is equal to/is in HR

How do I fix that?

I also tried:

CASE WHEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Phase Code" = 'REQUISITION_POSTING' AND "Recruiting - Recruiting Events Real Time"."Job Application - Progression"."Current Phase" = 'HR' THEN "Recruiting - Recruiting Events Real Time"."Job Requisition History - Event Details"."Event Date" ELSE NULL END

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!