My Oracle Support Banner

Error ORA-01722 When Runing Ediupack Batch (Doc ID 2815249.1)

Last updated on OCTOBER 21, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to upload EDI PO Acknowledgment files with Acknowledge type = 'AP',the following error occurs.
" ediupack_1~20210804171113~process_item~item_loc~-1722~ORA-01722: invalid number~CURSOR OPEN: cursor = c_ranged_ind, ref_item = 468130064"


Steps To Recreate:
1. Create a file for ediupack batch with location type = 'WH' and Acknowledge type = 'AP'
2. Load the file via ediupack batch.
3. Note the above error.

Changes

 

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
Changes
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.