My Oracle Support Banner

Performance Issue with Dealinc Batch Process (Doc ID 1666585.1)

Last updated on APRIL 16, 2020

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.




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.