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.
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
From trace - INSERT INTO ZX_TRANSACTION_LINES_GT
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