Performance Issue with Dealinc Batch Process

(Doc ID 1666585.1)

Last updated on FEBRUARY 01, 2018

Applies to:

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


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.


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms