R12: Purchasing Documents Open Interface (PDOI) Import Performance Issue (Doc ID 1943601.1)

Last updated on AUGUST 11, 2017

Applies to:

Oracle Purchasing - Version 12.1.3 and later
Information in this document applies to any platform.
POXPDOI - Import Standard Purchase Order

Symptoms

After upgrading from 11.5.10 to 12.1.3, planning instance sends a huge number of PO changes
They are seeing high IO on table ZX_LINES_DET_FACTORS on PO Import (PDOI).
They use a legacy tax system so they have no requirement to use E-Business tax on Purchasing Documents.
Same data volumes import in timely manner in 11.5.10

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