My Oracle Support Banner

Performance: POXPDOI: INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE (Doc ID 2459905.1)

Last updated on AUGUST 06, 2020

Applies to:

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

Symptoms

Actual Behavior
Poor performance is experienced with Import Price Catalogs.

Following query was captured in Trace file which consumed most of the time.

Expected Behavior
Performance of INSERT INTO PO_GA_ORG_ASSIGNMENTS_ARCHIVE is improved.

Steps to Reproduce

  1. Run Import Price Catalogs

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.