My Oracle Support Banner

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 JANUARY 27, 2022

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


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.




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.