My Oracle Support Banner

PDOI Does Not Complete When There Are Many Lines To Import - Insert Into ZX_TRANSACTION_LINES_GT (Doc ID 2055870.1)

Last updated on SEPTEMBER 24, 2018

Applies to:

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

Symptoms

Having performance issues with importing standard purchase orders using Purchasing Document Open Interface (PDOI). If an import file has very many lines (usually more than 25) the import runs for hours. Depending on how many lines, sometimes it does not complete and must be terminated.

Steps to reproduce:

1. Populate the Purchase Order interface tables with many lines to import
2. Run the Import Standard Purchase Order concurrent program

Other:
From trace - INSERT INTO ZX_TRANSACTION_LINES_GT

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.