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
Skip to content
  • 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

    in Reporting and Analytics for HCM 3 comments

    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:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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