RMS Only Recognizes Numeric Characters In The BOL For Transfers Between Warehouses. (Doc ID 2964417.1)

Last updated on JULY 31, 2023

Applies to:

Symptoms

RMS only recognizes numeric characters in the BOL for transfers between warehouses.

When a transfer was made between warehouses 190 to 390 the information travelled correctly to the legacy system in Manhattan and the reception of the transfer could be made, but the status of the transfer in RMS (Application) has not been updated, it remained in "Approved" and it has not been received nothing.

The transfer receipt arrives at RMS, but remains in error at RIB Hospital with the below error message.



This error occurs because in transfers between warehouses, Manhattan (legacy system) is sending the BOL number (M000050579) as the receipt identifier (receipt_nbr). This also happens today in our production environment:


  
  <v1:dc_dest_id>390
  <v1:po_nbr>3002328602
  <v1:document_type>T
  <v1:asn_nbr>M000050579
  
  <v1:item_id>000000003
  <v1:unit_qty>20
  <v1:receipt_xactn_type>R
  <v1:receipt_date>2023-07-10T15:53:49
  <v1:receipt_nbr>M000050579
  <v1:container_id>00009999990022392116
  <v1:to_disposition>ATS
  
  <v1:receipt_type>SK
  


However, RMS expects this identifier to be numeric only. This is causing the bug in a new validation of the RMSSUB_STKORD_RECEIPT package added in the 34942248 bug patch in the Jan/23 cumulative (Patch 34972625 - RMS_16.0.3_CUMULATIVE_HF_JAN_2023_2).

When the alphabetic character is removed and only the receipt number is left, this receipt processes successfully, confirming that this is the cause of the error.

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character to number conversion error@2RMSSUB_STKORD_RECEIPT.CONSUME




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Transfer between warehouses.
2. Make the reception sending the BOL number (M000050579) as the receipt identifier (receipt_nbr).
3. RIB Hospital with the following message:

ORA-06502: PL/SQL: numeric or value error: character to number conversion error@2RMSSUB_STKORD_RECEIPT.CONSUME

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.