My Oracle Support Banner

Performance Issue With POM Batch - IBCALC_JOB (Doc ID 2956805.1)

Last updated on JUNE 22, 2023

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
We are seeing a performance issue with the POM batch IBCALC_JOB in CFS DEV1.

The IBCALC_JOB completed within 1 min till 16th Jan nightly cycle. As part of 17th Jan nightly cycle the IBCALC_JOB took 5 mins for completion. As part of 18th Jan nightly cycle the IBCALC_JOB took 17 mins for completion. It continued for couple of days and as part of 24th Nightly cycle the job ran for around 49 mins. As of today the job is running from 50mins to 1hr.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1) Open nightly cycle from above link
2) Execute the IBCALC_JOB
3) Observe the perforance issue of the job


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.