FAQ: Purchasing Documents Open Interface
(Doc ID 224031.1)
Last updated on JULY 23, 2024
Applies to:
Oracle Purchasing - Version 10.7 and laterInformation in this document applies to any platform.
Purpose
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
Purpose |
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? |
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 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 ? |
References |