Error ORA-06502 While Performing Flexible Pallet Receipt For PTS Flow (Doc ID 2266995.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Retail Warehouse Management System - Version 14.1 to 14.1.3 [Release 14.1]
Information in this document applies to any platform.

Symptoms

In Retail Warehouse Management System (RWMS), when performing a Flexible Pallet Receiving (FPR) appointment for a PTS flow, ORA-06502 error occurs.


Steps To Recreate:

  1. In RWMS GUI create FPR appointment (with or without details)
  2. Assign allocated Purchase Order(PO) to the appointment
  3. Schedule the appointment
  4. In RWMS HandHeld (HHT), navigate to Receiving > Receiving
  5. Enter appointment number and door
  6. Open the appointment
  7. Perform receiving
  8. Check CONTAINER table > received containers should be in status "D" (distributed) and destination should be internal destination
  9. Check RECEIPT_TO_UPLOAD table that the dest_id for flow through pre-dist FPR containers is the internal dest_id
  10. Check RIB_MESSAGE and RIB_MESSAGE_FAILURE tables on RMS

Receipt message fails in RMS with ORA-06502 error.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms