Performance Issue with Dealinc Batch Process
(Doc ID 1666585.1)
Last updated on APRIL 16, 2020
Applies to:Oracle Retail Merchandising System - Version 22.214.171.124 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