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:

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

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