My Oracle Support Banner

HSTPRG JOB Failing With ORA-06502 Error (Doc ID 2449597.1)

Last updated on SEPTEMBER 27, 2018

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 16.0 and later
Information in this document applies to any platform.

Symptoms

When attempting to run HSTPRG_JOB the following error occurs.

ERROR
-----------------------
hstprg_1~20180725192141~purge_item_loc_hist~~103~RET-0103: generic function processing error~Package failed: Unhandled error raised in SQL_LIB.BATCH_MSG procedure: ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Steps to reproduce :

1. Run the hstprg batch.
2. Verify that the batch is failing with the above error.

Changes

 

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
Changes
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.