PO Upload To RMS Process Throws ORA-06502: Numeric Or Value Error

(Doc ID 2406251.1)

Last updated on JUNE 06, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.

Symptoms

Following error is noted when uploading PO using Induction template.

ORA-06502: PL/SQL: numeric or value error: number precision too large returned by program unit CORESVC_PO.OHE_WORKSHEET

Steps To Reproduce:

  1. Make sure SVC_ORDER_PARAMETER_CONFIG table configured as max_chunk_size=15, max_order_no_qty=15, max_threads=1.
  2. Have at least 12-15 Approved PO in RMS. Download them using the Download PO functionality.
  3. Change the status to "Worksheet" on ORDHEAD tab in the ods file.
  4. Upload data to RMS tables directly using PO Upload To RMS screen.
  5. Note the error on Data Loading status screen.

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