My Oracle Support Banner

Error "Unexpected error occurred, Please check the log." Shows When Picking A Large Number of Lots (Doc ID 2613138.1)

Last updated on NOVEMBER 20, 2019

Applies to:

Oracle Warehouse Management - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Problem Statement
When attempting to load many Lots (in Customer's case, 250 Lots in one sales order line)
the following error occurs.

Error shown in MSCA/WMS Mobile
Unexpected error occurred, Please check the log.

Error shown in INV Debug log
WMS_TASK_LOAD: Other exception raised : ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Steps to Reproduce

  1. Create the sales order
  2. Pick Release the sales order
    250 lots are allocated to one line of the sales order
  3. Pick Load the allocated 250 lots

 

INV Debug log:

when picking the last lot is loaded successfully, see:

[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_att_trx_qty: 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_trx_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_att : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_satt :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_sqoh :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_pri_uom : EA
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_sec_uom :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_trx_uom : EA
[28-JUN-19 01:12:16] WMS_TASK_LOAD: primary uom is same as transaction uom
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_att_trx_qty : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_trx_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_att_trx_sec_qty:
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_trx_sec_qoh :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: PRINTING L_LOT_V LENGTH5360
[28-JUN-19 01:12:16] WMS_TASK_LOAD: inserting into global temp table for serial is non allocated....
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_mtlt_lot_number : 000HU9162D5.0U004
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_mtlt_primary_qty : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_mtlt_secondary_qty: 0

when picking the lot which is causing the issue, see:

[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_att_trx_qty: 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_trx_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_att : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_satt :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string l_sqoh :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_pri_uom : EA
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_sec_uom :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: before the vector string p_trx_uom : EA
[28-JUN-19 01:12:16] WMS_TASK_LOAD: primary uom is same as transaction uom
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_att_trx_qty : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_trx_qoh : 4000
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_att_trx_sec_qty:
[28-JUN-19 01:12:16] WMS_TASK_LOAD: l_trx_sec_qoh :
[28-JUN-19 01:12:16] WMS_TASK_LOAD: Other exception raised : ORA-06502: PL/SQL: numeric or value error: character string buffer too small

 

 

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.