Importing Purchase Orders Using Purchasing Docs Open Interface(PDOI) has PO_PDOI_INVALID_VAR_ACCT Error
(Doc ID 2551287.1)
Last updated on AUGUST 16, 2023
Applies to:
Oracle Purchasing - Version 12.2.3 and laterInformation in this document applies to any platform.
Symptoms
Using Purchasing, Version 12.2.3
ACTUAL BEHAVIOR
---------------------
Loading the PDOI interface tables to create po's
We are getting issue to generate po in Oracle R12. Data present in Interface tables. We found error in PO_interface_error table as below:
Error:
-------
Interface type: PO_DOCS_OPEN_INTERFACE
COLUMN NAME: VARIANCE_ACCOUNT_ID
ERROR MESSAGE: Error: Variance Account (Value = 0) is not a valid variance account. and Error: Generation of Variance Account failed.
ERROR MESSAGE Name: PO_PDOI_VARIANCE_FAILED and PO_PDOI_INVALID_VAR_ACCT
TABLE NAME: PO_DISTRIBUTIONS_INTERFACE
Steps to Reproduce the Issue
-----------------------------------
1. Login to a PO Responsibility with Setup Access (PO Superuser ,etc)
2. Pre-load the PDOI tables with data to import
3. Run the "import standard po" program
4. examine the errors in the po interface tables
BUSINESS IMPACT
-----------------------
Due to this issue, PO's will not import to Purchasing
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 |
Cause |
Solution |
References |