My Oracle Support Banner

Performance Issue with Dealinc Batch Process (Doc ID 1666585.1)

Last updated on MARCH 05, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.1.4.4 and later
Information in this document applies to any platform.

Symptoms

During the performance testing phase found the following issues in dealinc process.


1.  dealinclib.pc->function actual_income_calc()
C_get_turnover_cur CURSOR, in library dealinclib is being executed  several times for same combination deal_id,deal_detail_id,reporting_date
- As the cursor is executed multiple times with same parameters the hint /*+ RESULT_CACHE */ will improve the performance


2.  dealinc.pc->function income_prorate()
The process is using un-successful loop inside another loop which is causing performance issues. Inside the function income_prorate there are two similar selects that are executed in to loop (one inside the other).

3.  dealinc.pc->function income_prorate()
The process is recalculating the income to all the deals in each execution including closed deals.


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.