Auto Invoice Import Error JAI_AR_IMPORT_POPU_PKG.PROCESS_ORDER ORA-01722: invalid number

(Doc ID 2231875.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Financials for India - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.4 version, 

When Auto invoice Import program is run , it is failing due to which AR Invoices are not getting generated.|

ERROR
-----------------------
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
ZX_API_PUB.import_document_with_tax.Exception FND_API.G_EXC_UNEXPECTED_ERROR
:
:
Error calling raapic()


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Raise an OM Order with India Localization Taxes. Now , complete the rest steps .
2. Run Autoinvoice for Batch source OM_IMPORT , it is failing with error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot import the AR transaction order

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms