My Oracle Support Banner

DLYPRG_JOB Batch Job Failing as art of Nightly Batch (Doc ID 2816931.1)

Last updated on JUNE 22, 2023

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version 19.3 to 19.3 [Release 19.3]
Information in this document applies to any platform.


The DLYPRG_JOB batch job is failing as part of the night batch.
It is throwing the following exception:

2021-06-23T15:43:12,862 [[ACTIVE] ExecuteThread: '35' for queue: 'weblogic.kernel.Default (self-tuning)'] ERROR AbstractPOMBatchlet - An exception occurred Forked process failed, returned exit code(255).
java.lang.RuntimeException: Forked process failed, returned exit code(255).
at oracle.retail.apps.poam.ext.jobadmin.batchlet.AbstractPOMBatchlet.throwRuntimeException( [PomJobAdminExtensions.jar:?]
at oracle.retail.apps.poam.ext.jobadmin.batchlet.custom.BatchShellCommandRunnerBatchlet.doWork( ~[PomJobAdminExtensions.jar:?]
at oracle.retail.apps.poam.ext.jobadmin.batchlet.AbstractPOMBatchlet.process( [PomJobAdminExtensions.jar:?]
at []

For reference, this is what is showing on JOB_AUDIT_LOGS for this execution:

Connection established successfully.
Started by default user
dlyprg_1~20210623154311~del_item~ITEM_MASTER~-20001~ORA-20001: ~CLOSE cursor C_ITEM in package DEL_ITEM ITEM: , key_value=101
CLOSE cursor C_ITEM in package DEL_ITEM ITEM: , key_value=101
Thread 1 - Aborted in process.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.