InjectorPriceEventBatch.sh Batch Failing With ORA-06502 Error

(Doc ID 1930206.1)

Last updated on JULY 11, 2017

Applies to:

Oracle Retail Price Management - Version 14.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 15-June-2017

Symptoms

InjectorPriceEventBatch.sh batch does not exit while injecting more than 9 promotion component details to a promotion component. However the promotions are approved in less than a minute populating RPM_FUTURE_RETAIL table as expected. It's just the batch that does not terminate.

An exception is raised from the RPM_BULK_CC_THREADING_SQL.DEAL_DELETE_CC function. 

The error is

 

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