My Oracle Support Banner

R11i: PA: PAIGEN And PARGDR Have Slow Performance Since Upgrade To 11gR2 (Doc ID 1673797.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Project Billing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

On : 11.5.10.2 version, Misc Billing Issues

ACTUAL BEHAVIOR
---------------
PAIGEN and PARGDR slow performance since upgrade to 11gR2

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
PAIGEN and PARGDR both have slow performance since our upgrade to 11gR2. Our longest Draft Invoice used to average 16 minutes before the upgrade and now averages 30 minutes, Draft Revenue used to average 8 minutes, now averages 14. This is a significant increase to us because we have to make them incompatible with themselves and run them consecutively and we also have to run them for each individual shipment, so they get backed up.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Our upgrade occured last weekend (Nov 15, 2013) - since then we have been experiencing slower run times (average 41% slower) for both Draft Invoice and Draft Revenue. Since we have to run these consecutively and not concurrently and we have to run them individually for each shipment that is made, this increase in run time becomes a significant factor since there are so many submitted each day and they have to run one at a time.

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.