Need query Last Supplier Payment >2 years

Hello,

I would like to run a query in Oracle Fusion SCM but I keep receiving an error code “ORA-00907: missing right parenthesis”. I’m not sure if it’s because of an error in my query or because of missing privileges.

I would like to retrieve a list of supplier sites and their payment statuses; Supplier sites with no transactions or transactions older than 2 years are considered "Not paid," while suppliers with recent transactions are considered "Paid."

Query:

SELECT

VENDOR_ID,

VENDOR_SITE_ID,

CASE

WHEN MAX(t.transaction_date) IS NULL THEN 'Not paid'

ELSE 'Paid'

END AS PAYMENT_STATUS