Oracle 21c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE invoice (data_run_date, fiscal_quarter, invoice_id, invoice_type) AS
SELECT DATE '2022-07-01', 'Q4', 12345, 'Paid'     FROM DUAL UNION ALL
SELECT DATE '2022-07-01', 'Q4', 12345, 'Paid'     FROM DUAL UNION ALL
SELECT DATE '2022-01-01', 'Q1', 12345, 'Not Paid' FROM DUAL UNION ALL
SELECT DATE '2022-07-01', 'Q4', 12678, 'Paid'     FROM DUAL UNION ALL
SELECT DATE '2022-01-01', 'Q1', 12678, 'Not Paid' FROM DUAL;
5 rows affected

DELETE FROM /*db.*/invoice
WHERE ROWID IN (
  SELECT ROWID
  FROM   (
    SELECT ROW_NUMBER() OVER (
             PARTITION BY data_run_date, fiscal_quarter, invoice_id, invoice_type
             ORDER BY NULL
           ) AS rn
     FROM  /*db.*/invoice
  )
  WHERE rn > 1
)
1 rows affected

SELECT * FROM invoice;


DATA_RUN_DATE
FISCAL_QUARTER
INVOICE_ID
INVOICE_TYPE


01-JUL-22
Q4
12345
Paid

01-JAN-22
Q1
12345
Not Paid

01-JUL-22
Q4
12678
Paid

01-JAN-22
Q1
12678
Not Paid

DATA_RUN_DATE	FISCAL_QUARTER	INVOICE_ID	INVOICE_TYPE
01-JUL-22	Q4	12345	Paid
01-JAN-22	Q1	12345	Not Paid
01-JUL-22	Q4	12678	Paid
01-JAN-22	Q1	12678	Not Paid