BI Publisher (MOSC)

MOSC Banner

The Query is showing more duplicate records for single person

edited Oct 8, 2023 4:19AM in BI Publisher (MOSC) 1 commentAnswered

Hi all,

We have made only one change but in report it is showing more than 100 data which are not correct, we need to remove duplicate records in final output.

WITH pay_roll


  AS (SELECT py.payroll_name,


        pt.hr_term_id


    FROM  pay_payroll_terms pt,


        pay_assigned_payrolls_dn apd,


        pay_all_payrolls_f py


    WHERE 1 = 1


        AND pt.payroll_term_id = apd.payroll_term_id


        AND pt.payroll_term_id = apd.payroll_term_id


        AND py.payroll_id = apd.payroll_id)


SELECT DISTINCT PAPF.person_number,


        ppnf.full_name,


        To_char(asg.effective_start_date, 'DD-MON-YYYY')


        START_DATE,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center