Gross To Net Summary (PDF) Poor Performance After R12 RUP6 Patch Applied (Doc ID 1607526.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, UK Payroll, on test instance patched to HR PF12.1 HRMS RUP6.

ACTUAL BEHAVIOR
---------------
When running the gross to net summary report, after upgrade to RUP6, a performance issue is found with the following sql:


When running the report, with the above code present, it has never completed before the report has been terminated.


EXPECTED BEHAVIOR
-----------------------
Report should complete in 5 mins.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade instance to RUP6
2. Run gather schema stats process, at 20 for HR schema
3. Run the gross to net summary report.



Cause

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