My Oracle Support Banner

Carton Level Receiving Using Alphanumeric ASN Number Is Failing (Doc ID 2696376.1)

Last updated on AUGUST 05, 2020

Applies to:

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

Symptoms

Transfer Receiving failing when ASN contains alphanumeric.

1. Create Transfer
2. Create ASN with alphanumeric ASN and BOL.
3. Receive at carton level with ASN
4. See the error in RIB Failure : 

  RMSSUB_ASNOUT.CONSUME(?,?,?,?)}: [E] Error ORA-01722:invalid number returned by program unit STOCK_ORDER_RCV_SQL.DETAIL_PROC_INNER.

 

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.