My Oracle Support Banner

PO Import Performance Issue After 12.2.11 Upgrade For Huge Data Volume Or When Using Autocreate (Doc ID 2944833.1)

Last updated on JULY 11, 2023

Applies to:

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

Symptoms

After upgrading to 12.2.11 version, when running Purchase Order Interface import program (PDOI), there are now performance issues -  when importing a large volume of data.
This also happen when using Autocreate functionality in the core application.

Replication Steps:
1. Login to the E-Business Suite and choose the Purchasing Module.
2. Load huge amount of data into Interface tables
3. Submit the  Purchase Order Interface import program (PDOI)
4. Takes very long time to for this process to complete

Changes

 Upgrade has taken place to 12.2.11.

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.