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

Last updated on JUNE 26, 2022

Applies to:

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

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