My Oracle Support Banner

Autoinvoice Import Program Running into Error - JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number (Doc ID 1597582.1)

Last updated on JUNE 12, 2023

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.
Currency Check relevance verified on: 28-Jul-15

Symptoms

On : 12.1.3 version, India AR Localizations

When attempting to run Auto Invoice Import, it runs into error and the log shows the following error message:
the following error occurs.

ERROR
-----------------------
raafds()- Current system time is 20-SEP-2013 15:20:22
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX for transaction 17801876
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into loop for transaction 17801876
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id 162963532
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_inv_and_suppl()
Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_inv_and_suppl()
lv_return_code UE
lv_return_message Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX for transaction 17801875
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into loop for transaction 17801875
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX get trx line id 162963531
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX into pop_jai_inv_and_suppl()
Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Process in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX out pop_jai_inv_and_suppl()
lv_return_code UE
lv_return_message Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
Encountered an error in JAI.PLSQL.JAI_TAX_PROCESSING_PKG.IMPORT_DOCUMENT_WITH_TAX Encountered an error in JAI_AR_IMPORT_POPU_PKG.POP_JAI_INV_AND_SUPPL Encountered an error in JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number
ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N)->India Local Receivables
2. Run the Autoinvoice Import for the Property Manager Source.
3. Observe that the program is running into error with the specified error message

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot interface Property Manager Invoices to AR.

Note:
-------
The issue is observed to be coming only for the AR transactions created from the Property Manager source.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.