Duplicate records while retrieving data
We recently migrated our Oracle R12 to Oracle Fusion. We have developed some custom reports in our Old Oracle R12, we need to develop
it in Oracle Fusion. We have developed a query in Oracle R12 which retrieves correctly, but in Oracle Fusion we are retrieving duplicate records for every records. Please help me with this below query.
SELECT DISTINCT msi.item_number c_item_name, tca_party.party_name Vendor_Name, ppf.full_name c_emp_name_no,
poh.po_header_id, pol.po_line_id, pol.line_num, poh.segment1 c_po_number,
TRUNC (poh.creation_date) c_po_date,