FPR_PRINT Database Package Gets Error Due To Exceeding Variable Length

(Doc ID 2403143.1)

Last updated on MAY 29, 2018

Applies to:

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

Symptoms

When attempting to reprint FPR container label, the following error occurs.

ERROR:
  1. CQ -6502 DFR 10/04/2018 14:41:46 fpr_print mark_unmark_for_print
  ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  2. CQ 0 DFR 10/04/2018 14:41:46 hh_fpr_print_labels_s validate_pallet
  "ORA-06502: PL/SQL: numeric or value error: character string buffer too small
  ORA-06512: at ""ADMRWMS.FPR_PRINT"", line 578 ORA-0000: normal, successful completion"


Steps to Reproduce:
1. Have a container in 'P'rinted status for FPR w/details appt.
2. Try to reprint FPR container label.
3. Notice the 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