PO Import Completes With Error Message PO_PDOI_INVALID_VALUE for AGENT_NAME (Doc ID 1968423.1)

Last updated on JUNE 30, 2017

Applies to:

Oracle Fusion Purchasing Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Purchasing - Version 11.1.11.1.0 and later
Information in this document applies to any platform.

Symptoms

In 11.1.9 Oracle Fusion Purchasing Cloud Services
Purchase Order import completes with error indicating PO_PDOI_INVALID_VALUE for AGENT_NAME

ERROR
Purchasing Document Import Errors Report

Interface Header Key Interface Line Key Interface Line Location Key Interface Distribution Key Load Request Id Column Name Column Value Error Message
Error Text 100 28172 AGENT_NAME Firstname Lastname PO_PDOI_INVALID_VALUE The value of the attribute is not valid.

STEPS TO REPRODUCE
1. Load the interface tables for purchase order import
Specify Agent Name = Firstname Lastname in the data file for PO_HEADERS_INTERFACE

2. Run the Import Orders process

Name = Import Orders
Procurement BU =  Canada BU
Default Buyer = Lastname, Firstname
Create or Update Item = No
Approval Action = Submit for Approval
Default Requisitioning BU = Canada BU

3. Review the Purchasing Document Import Errors Report
- see the error details

Users are not able to import Purchase Orders with the Agent Name populated.

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