My Oracle Support Banner

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

Last updated on FEBRUARY 27, 2019

Applies to:

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


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

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.

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.


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.