ORA-00972: identifier is too long
I have never come across an "ORA-00972: identifier is too long" error before, and I couldnt see any reason why.
When I execute the below I get this error, any idea why?
My query is:
SELECT DISTINCT c.customer_name “Name”, p.address1 “Address”, p.postal_code “Zip Code”, round(nvl(sum(decode(f.invoice_currency_code, 'GBP', nvl(f.amount_due_remaining,0), nvl(f.amount_due_remaining * f.exchange_rate, 0))),0),2) "Current Debt"
FROM ar_payment_schedules_all f, ra_customers c, hz_parties p
WHERE c.customer_id = f.customer_id
AND p.party_id = c.party_id
AND f.status = 'OP'
AND f.org_id = 0
GROUP BY c.customer_name, p.address1, p.postal_code
HAVING round(nvl(sum(decode(f.invoice_currency_code, 'GBP', nvl(f.amount_due_remaining,0), nvl(f.amount_due_remaining * f.exchange_rate, 0))),0),2) >= 500
ORDER BY customer_name ASC