Purchasing Documents Open Interface (PDOI) Deliver To Person - Error: Deliver to Person (Value = ######) is not a valid deliver-to person as defined in purchasing. (Doc ID 2851047.1)

Last updated on FEBRUARY 27, 2022

Applies to:

Symptoms

On : 12.2.10 version, Purchasing Processes

When attempting to create a purchase order via purchasing document open interface (PDOI), import standard purchase orders program completed with error and po_interface_errors table output shows the following error.

Error:

Error: Deliver to Person (Value = 49515) is not a valid deliver-to person as defined in purchasing.


Replication Steps:
The issue can be reproduced at will with the following steps:

1. Populate PDOI interface tables with the required data elements i.e. po_headers_interface, po_lines_interface and po_distributions_interface.
2. Populate deliver_to_person_full_name in po_distributions_interface table, where there exists two employee records for the person full name (in this case it is S*****, KE******), one is inactive and other one is active.
3. Run Import Standard Purchase Orders program.
4. The records are not processed and po_interface_errors table output shows reported error.

The following note can assist with the purchasing documents open interface:
<Note 2014101.1> - Vision Demo - How To Import Standard Purchase Orders Using the Purchase Document Open Interface PDOI (12.2 and 12.1.3 Enhanced PDOI)

Changes

 Upgrade has taken place.

Cause

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