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

Direct join between Benefit and Element tables issue

Summary:

Hi,

I am building a report where I need to show the CONTRIBUTION_PERCENTAGE (BEN_PRTT_RT_VAL.ANN_RT_VAL) from Benefit and CONTRIBUTION_AMOUNT (pay_element_entry_values_f.screen_entry_value) from Element.

I am joining Benefit table to Element table via per_assignment_secured_list_v.But the Assignment ID and Person ID is creating a cross join and I am getting unwanted records.Is there a way, I can directly join BENEFIT with ELEMENT table and pull ANN_RT_VAL,screen_entry_value ?


Below is the join conditions.

BEN_BENEFIT_RELATIONS_F.REL_PRMRY_ASG_ID = per_assignment_secured_list_v.ASSIGNMENT_ID 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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