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