My Oracle Support Banner

PAXINRVW Oracle Projects Invoice Review Form Search Performance Issue (Doc ID 2411878.1)

Last updated on AUGUST 22, 2023

Applies to:

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

Symptoms

When a specific user is querying for Project Invoices in 'Invoice Review' PAXINRVW form, it is taking 20 or more minutes to fetch the project invoice details and in some cases the form never returns data.
And at times, the returned lines are from any project even if one project was in query selection.
But with another user like SYSADMIN, it is taking 6 seconds to fetch the details based on the "Operating Unit' & 'Project Number'.

Steps:

  1. Responsibility: Projects Billing
  2. Navigation: Billing>Invoice Review

 

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!

In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.