R12: "Import Standard Purchase Order" Program Throwing Error: PO_HEADER_ID There should be at least one line per document
Last updated on FEBRUARY 12, 2018
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.
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