My Oracle Support Banner

Intragovernmental Groups For Agency Interface Program Performance Issue (Doc ID 3045461.1)

Last updated on SEPTEMBER 03, 2024

Applies to:

Oracle Purchasing - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.9 version, G-Invoicing

ACTUAL BEHAVIOR
---------------
Intragovernmental Groups for Agency Interface Program performance issue

STEPS
---------------
1. "Intragovernmental Groups for Agency Interface Program" spawns hundreds of child "Intragovernmental TAS-BETCs for Group Interface Program" requests.These high volumes of requests are causing performance issues in system.
2. The Query with query id bfyh6kab9jyr3 from this program is consuming HIGH CPU and it always cranks up CPU with potential on system impact
3. The Table igt_document_requests has two big LOB segment and they are getting updated. This is getting triggered from seeded Oracle program.


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
References


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