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 SEPTEMBER 23, 2024

Applies to:

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.

Changes

Cause

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