Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood 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
Tagged:
0