SQL Language (MOSC)

MOSC Banner

ORA-01861: literal does not match format string

edited Nov 11, 2018 4:05AM in SQL Language (MOSC) 12 commentsAnswered

I am getting error ORA-01861: literal does not match format string while running below query.

If I comment last condition then I am getting 23 records (invoices).if I pass the invoice_num with last condition then I don't get error.

Please suggest how to eliminate this error.

select aia2.invoice_num, aia2.attribute6, aia2.invoice_date

from ap_invoices_all aia

,ap_invoices_all aia2

,ap_invoice_lines ail

,ap_invoice_payments aip

where aia.invoice_id = aip.invoice_id(+)

AND aia.invoice_id = ail.invoice_id

AND aia.source = 'GLOBAL_INTERCOMPANY'

AND NVL (aia.attribute1, aia.source) <> 'CONCUR EXPENSES'

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