R11i: PA: PAIGEN And PARGDR Have Slow Performance Since Upgrade To 11gR2
Last updated on FEBRUARY 09, 2018
Applies to:Oracle Project Billing - Version 18.104.22.168 and later
Information in this document applies to any platform.
On : 22.214.171.124 version, Misc Billing Issues
PAIGEN and PARGDR slow performance since upgrade to 11gR2
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.
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.
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