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

Last updated on DECEMBER 30, 2015

Applies to:

Oracle Purchasing - Version:
This problem can occur on 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',
33,
41,
'GMR TEST',
'ST LOUIS',
'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')

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