Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

oracle.xdo.servlet.data.DataException: ORA-01722: invalid number

edited May 13, 2020 8:34AM in Reporting and Analytics for ERP 3 comments

Summary

oracle.xdo.servlet.data.DataException: ORA-01722: invalid number

Content

Hi

i have below error in Data model

Parameter name: p_JV_NUM oracle.xdo.servlet.data.DataException: ORA-01722: invalid number ; Data source: ApplicationDB_FSCM; Query: select distinct gjb.name JV_NUMBER FROM ap_invoices_all aia, ap_invoice_lines_all aila, AP_INVOICE_DISTRIBUTIONS_ALL aida, GL_JE_BATCHES GJB, GL_IMPORT_REFERENCES GIR, poz_suppliers_v pz, HR_ALL_ORGANIZATION_UNITS hou where 1=1 and aia.invoice_id=aila.invoice_id and aida.invoice_id=aila.invoice_id and aida.INVOICE_LINE_NUMBER=aila.LINE_NUMBER AND aia.vendor_id = pz.vendor_id AND aia.org_id = hou.organization_id AND hou.name = 'ETG Integrated Services Ltd Ghana' AND UPPER (aia.INVOICE_TYPE_LOOKUP_CODE)not in('CREDIT','DEBIT') AND AIDA.ACCOUNTING_EVENT_ID = GIR.REFERENCE_6 --AND UPPER (AILA.DESCRIPTION) NOT LIKE 'DISCOUNT%' AND GIR.JE_BATCH_ID = GJB.JE_BATCH_ID and gjb.name not like 'Opening Balances%'

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!