My Oracle Support Banner

G-Invoicing - PA_7600B_XML: MGT: Generate 7600B Report Performance Is Poor (Doc ID 3025500.1)

Last updated on JUNE 24, 2024

Applies to:

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

Symptoms

The MGT: Generate 7600B Federal Report is taking 20 minutes or more to complete.

From AWR report the following SQL id is performing poor related to this report

4mraf4gpmzyhc - UPDATE fnd_lobs SET file_name = :1, file_data = :2 WHERE file_id = :3

 

Steps:
-------
1. Switch to Project Billing Superuser responsibility.
2. Run request - MGT:Generate 7600B Federal Report.

 

 

 

Changes

 

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
Changes
Cause
Solution
References


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