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

How to inner join 2 distinct groups in HCM Extract?

Summary:

How to inner join 2 distinct groups in HCM Extract?

Content (please ensure you mask any confidential information):

I have this structure:

and I want Person, Eval_Document, Eval_Tmplo_Periods to be populated only when Eval_Doc_Type is populated. At the moment this one seems in left join with its parents since some data are retrieved even though it is empty:

I'd like to know how to extract info from all groups only when all groups are populated.

Other useful screenshots from Eval_Doc_Type:

Other useful screenshots from Eval_Doc_Type_Details:


Thank you

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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