My Oracle Support Banner

ASNOut Message Failure In RIB Due To Alphanumeric BOL Number (Doc ID 2697277.1)

Last updated on JULY 22, 2022

Applies to:

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

Symptoms

ASNOut message is failing in RIB due to alphanumeric bill of landing - BOL (if using only numbers it does not fail):

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


Steps to reproduce:

  1. Create shipment to generate an ASNOut message while containing alphanumeric BOL number
  2. Observe message is failing on RICS for RMFCS (RMSSUB_ASNOUT.CONSUME) side with error.

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.