R12: "Import Standard Purchase Order" Program Throwing Error: PO_HEADER_ID There should be at least one line per document (Doc ID 1477687.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Purchasing - Version 12.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.
POXPOPDOI - Import Standard Purchase Orders
POXPDOI - Import Price Catalogs

Symptoms

The issue is encountered with both 'Import Price Catalogs' and 'Import Standard Purchase Orders'. When attempting to import a large number of records, the programs throw the following error:
    "PO_HEADER_ID There should be at least one line per document."


After running the import program, not all records are imported. Upon re-running the import program, the records that were not imported the first time are imported, without making any changes to the interface tables prior to re-running the import program.

Steps to reproduce:

1. Insert a large number of records into PO_HEADERS_INTERFACE and PO_LINES_INTERFACE for processing
2. Purchasing Responsibility > Requests > Query the program 'Import Price Catalogs' or 'Import Standard Purchase Orders' as required > Submit
3. Find that not all records are imported.

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