My Oracle Support Banner

PDOI - Cannot Load a Closed Purchase Order (Doc ID 227973.1)

Last updated on JUNE 26, 2022

Applies to:

Oracle Purchasing - Version 11.5.10 and later
Information in this document applies to any platform.
ConcurrentProgram:POXPOPDOI - Import Standard Purchase Orders

Symptoms

Cannot load a closed PO through via PDOI 

Error:
PO_PDOI_INVALID_VALUE error on CLOSED_CODE
" CLOSED_CODE must have a value of CLOSED."
 

Example of uploaded document:
insert into po_headers_interface
(interface_header_id,
action,
document_type_code,
document_num, -- po_number
agent_id,
vendor_name,
vendor_site_code,
closed_code)
values
(po_headers_interface_s.nextval,
'ORIGINAL',
'STANDARD',
xx,
yy,
'GMR TEST',
'zz',
'CLOSED')
/
insert into po_lines_interface
(interface_line_id,
interface_header_id,
line_num,
item,
item_description,
uom_code,
quantity,
unit_price,
closed_code)
values
(po_lines_interface_s.nextval,
po_headers_interface_s.currval,
1,
'RED BALL',
'Description of Red Ball',
'EA',
1,
32.99,
'CLOSED')

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution

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