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

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Billing - Version 11.5.10.2 and later
Information in this document applies to any platform.
***Checked for relevance on 01-DEC-2016***

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

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