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 with Redwood for Oracle Cloud HCM   Begin Now

To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.

OTBI Query not working with where clause in BI publisher

Summary: OTBI Query not working with where clause in BI publisher

We have query which works in BI Publisher with no where clause but when added with where clause the where clause is not effecitve and we don't see desired records.

Content (required):

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';

SELECT

  "Workforce Management - Work Relationship Real Time"."Job"."Job Code" "Job Code",

  "Workforce Management - Work Relationship Real Time"."Job"."PER_JOBS_DFF_INTERNAL_CONTROL_v" "Internal Control",

  "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Enterprise Hire Date" "Hire Date",

  "Workforce Management - Work Relationship Real Time"."Worker"."Assignment Category" "Assignment Category",

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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