Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now ORA-01722: invalid number — Cloud Customer Connect
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 ORA-01722: invalid number

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

Summary ORA-01722: invalid number



i have below error in Data model

Parameter name: p_JV_NUM ORA-01722: invalid number ; Data source: ApplicationDB_FSCM; Query: select distinct 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 = '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 not like 'Opening Balances%'

Howdy, Stranger!

Log In

To view full details, sign in.


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