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 laterInformation 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 |