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 laterInformation 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 |