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

    SQL Query for element pay values getting duplicated

    edited Jul 22, 2024 4:53PM in Payroll and Global Payroll Interface (GPI)

    Summary:

    Dear All

    I am trying develop a BIP Report which will fetch the values for elements processed on certain period of time , I prepare the Query for overtime , but when I run I am getting duplicate values , I mean I am getting two rows of same values and total amount is doubled ,Please refer the attached query , am I missing anything or any joints

    SELECT prrv.RESULT_VALUE "OVERTIME" ,PAPF.PERSON_ID,ppa.effective_date,PPA.PAYROLL_ACTION_ID,pet.element_name

    		   FROM 	pay_element_types_tl pet,
    		            PAY_RUN_RESULTS prr,
    							PAY_RUN_RESULT_VALUES prrv,
    							PAY_PAYROLL_REL_ACTIONS ppra,
    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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