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

Last updated on AUGUST 21, 2016

Applies to:

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

Symptoms

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

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