My Oracle Support Banner

Invalid Number Returned By Salesprocess For Apha Numeric Customer Orders (Doc ID 2756679.1)

Last updated on MARCH 04, 2021

Applies to:

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

Symptoms

Processing POSU file by salesprocess for online sales with alpha numeric customer order is failing with error:

"ORA-01722: invalid number returned by program unit STKLEDGR_SQL.BUILD_TRAN_DATA_INSERT. "

Steps to reproduce:
1. Upload RTLOG from OMS with sales against customer order having following details: Customer order no is in alpha numeric and sourced from store, (fulfullment_loc_type = 'ST' and fulfillment_location = physical store location)
2. Export transaction in posu file by running saexprms
3. Upload posu file in RMS by running uploadsales and salesprocess jobs
4. Observe file failed in file_upload_status table with 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.