Performance With Import Purchase Orders After Applying PDOI patches (Doc ID 1910793.1)

Last updated on MARCH 07, 2017

Applies to:

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

Symptoms

Performance issue with POXPOPDOI : Import Standard Purchase Orders Program


Trace file show performance with the following select statement

 

The performance issue is seen after applying patch 18636732:R12.PO.B PDOI CONSOLIDATION PATCH FOR 12.1.3+
or any patch that delivers  PO_PDOI_LINE_LOC_PROCESS_PVT.plb version 120.26.12010000.32  - 120.26.12010000.35



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms