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 |