Performance Issue with Dealinc Batch Process
Last updated on FEBRUARY 01, 2018
Applies to:Oracle Retail Merchandising System - Version 184.108.40.206 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