My Oracle Support Banner

MERCHAPI_EXT_ITEM_ADHOC_JOB Running More Than Exec Seconds Set In Batch Parameter (Doc ID 2922146.1)

Last updated on JANUARY 23, 2023

Applies to:

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

Symptoms

In DEV2 environment, MERCHAPI_EXT_ITEM_ADHOC_JOB running more than exec seconds set in batch parameter.
In this scenario, exec seconds was set to 3540 seconds (59 minutes) and sleep seconds was set to 300 seconds. The job ran for 1hr 25 minutes to process 63k item records. As per the job logs, the job was polled only once.

Need to know what could be the issue here?

Steps To Recreate:
1. Update item description of 63k records
2. Set parameter of batch to "exec_seconds":3540,"sleep_seconds":300,"uuid":4000000017
3. Run MERCHAPI_EXT_ITEM job
4. Monitor the job runtime and job would run for more than 59 minutes

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.