My Oracle Support Banner

SCCEXT Batch Aborts With an Error "ORA-22813: Operand Value Exceeds System Limits" (Doc ID 2613629.1)

Last updated on NOVEMBER 29, 2019

Applies to:

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

Symptoms

SCCEXT batch aborts with following error, when more volume of data is mapped to single cost change.
 


Steps to Recreate:

  1. Choose supplier which is having more number of records in ITEM_SUPP_COUNTRY_LOC table  and create a cost change against that supplier, create it with at least 700000 items.
  2. Run the batch SCCEXT, it aborts with an error.

 

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.