My Oracle Support Banner

DLYPRG_JOB Job Is Failing In Nightly Cycle On Daily Basis (Doc ID 2930343.1)

Last updated on FEBRUARY 23, 2023

Applies to:

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

Goal

Why DLYPRG_JOB job is getting errored out daily in POM nightly cycle i.e., Batch failed with below error

dlyprg_1~20230216032846~del_item_loc~~0~ORA-0000: normal,
successful completion~@0PACKAGE_ERROR@1ORA-06502: PL/SQL: numeric or value error:
character to number conversion error@2VALIDATE_RECORDS_SQL.DEL_ITEM_LOC,
key_value=

Solution

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