My Oracle Support Banner

Purchasing Documents Open Interface (PDOI) Only Importing Upto 5000 Lines - Limitation (Doc ID 1439795.1)

Last updated on FEBRUARY 06, 2019

Applies to:

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


When attempting to Import Price Catalogs through Purchasing Documents Open Interface (PDOI) for more than 10,000 lines it is getting processed without any error - however it has only updated the first 5000 records.

Replication Steps:
1. Insert 5000+ lines of data into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE for processing
2. Purchasing Responsibility > Requests > Query the program " Purchasing Open Document Interface " > Submit
3. Find that only the first 5000 lines are processed




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.