My Oracle Support Banner

FAQ: Purchasing Documents Open Interface (Doc ID 224031.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Purchasing - Version 10.7 and later
Information in this document applies to any platform.


PURCHASE ORDERS: Purchasing Document Open Interface (PDOI) - Release 10.7, 11.0, 11.5, 12

Questions and Answers

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
Questions and Answers
 Where can I find example scripts to be used with the PDOI process - for importing various document types?
 What should I do if the Purchase Document Open Interface (PDOI) process  fails?
  How do I to get the log file for the PDOI run?
  How to view/purge and correct the errors tables?
 What do I do when POs are not being picked up by PDOI and these records remain in pending status?
 How should I populate the project and task information in PDOI?
  What should I do if PDOI errors out with "po_pdoi_invalid_dest_type destination type (value = expense) is not valid" for expense items?
 How and when are the Blanket effective dates updated though PDOI?
 What should I do if PDOI errors out with "ship to organization id (value=XXX) specified is inactive or invalid" when creating new items on the fly?
  Why are supply records are not created for standard purchase orders?
  Can you update documents via PDOI which were created manually?
 When using encumbrance accounting I want the funds to be reserved and encumbrance entries created in gl_bc_packets?
  Why does PDOI error out with "ora-00001 unique constraint violation in po_headers_u2"?
 What should I do when PDOI creates approved standard purchase orders but no charge account is being generated?
  How do we debug when PDOI does not create any POs?
  I had submitted the PDOI concurrent request for updating the unit_price of a blanket purchase agreement line with an action of "UPDATE". PDOI instead of updating the line, has created a new line with new price. Every updated line is being created multiple times. How can this be avoided?
  How is data deleted from the interface tables after it has been loaded?
  Is there an example script to load new blanket, new item and new sourcing rule?
  I had loaded all the data into the interface tables and with process_code as 'PENDING'.  I run the PDOI program, but data is not getting picked up by PDOI. The records remain in status 'PENDING' in the interface tables. What do I do?
  I want to update header of a document. Is it possible via PDOI?
  I am trying to update item description through PDOI. The program is updating the item description at the line level but is not updating the same at item master.
 Can we use Purchasing Document Open Interface (PDOI) to load complex milestone based purchase order (PO) from external source?
 What documents types are supported ?
 What Actions are supported?
 To create new sourcing rules, populate the following columns in the po_lines_interface:
 Which document types can be updated by using Purchasing Document Open interface?
 What document can be viewed after running purchasing document open interface with records rejected?
 How are new blankets/quotations, new items and new sourcing rules added at the same time?
 How is existing line information updated in the po_lines_all table for Blanket or Quotation.
 How are new lines added to an existing blanket and quotation?
 How is quantity populated in po_lines_interface?
 How is an existing blanket or quotation replaced?
 How are the default rules applied?
 Is there an example script to load new blanket, new item, new sourcing rule?
 How is data deleted from the interface tables after it has been loaded ?
 When trying to update blanket purchase agreement (Amount limit ) using interface PO_HEADERS_INTERFACE concurrent completed successfully with process_code REJECTED and nothing in PO_INTERFACE_ERRORS the concurrent complete successfully. Why we are unable to Update Amount limit using PDOI?

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