My Oracle Support Banner

Unable To Edit / Add Item To Merchandise Invoice (Doc ID 2958772.1)

Last updated on JULY 05, 2023

Applies to:

Oracle Retail Invoice Matching Cloud Service - Version 19.3 and later
Information in this document applies to any platform.

Symptoms

Error occurs when trying to add / edit item details for invoices and there exists a non-numeric supplier in Inject tables.

ERROR
-----------------------
ORA-01722: invalid number@2REIM_DOCUMENT_SQL.VALIDATE_ITEM_NON_CONSIGNMENT

Steps to Recreate:

  1. Create a merchandise invoice against a supplier with non-numeric id.
  2. Go to Item tab.
  3. Default the items from order.
  4. Choose to edit the item details.
  5. Edit unit cost / quantity and click OK.
  6. Notice error 'An application error occurred'.

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.