Release From an Existing Blanket Purchase Agreement (BPA) by Using Purchasing Document Open Interface (PDOI) Gets an Error With &vendor_doc_num (Doc ID 2036626.1)

Last updated on DECEMBER 03, 2015

Applies to:

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

Symptoms

When replace a exist BPA by using PDOI at the second, the following error occurs in po_interface_errors table.

Error:
Multiple catalogs can be found with the same document number(&VENDOR_DOC_NUM)

i.e.
  po_headers_all
    SEGMENT1  VENDOR_ORDER_NUM  START_DATE                  END_DATE
            1               TEST-150206-01        2015-02-01 00:00:00  2099-12-31 00:00:00
            2               TEST-150206-01        2015-01-01 00:00:00  2015-01-31 00:00:00    -- past date

  PO_HEADERS_INTERFACE
    ACTION    EFFECTIVE_DATE  EXPIRATION_DATE  VENDOR_DOC_NUM
    REPLACE        2015-05-01              2099-12-31          TEST-150206-01

  PO_LINES_INTERFACE
    ACTION    ITEM_ID  unit_price
    REPLACE  1183034       10

Steps to Reproduce:

  1. Create a BPA using PDOI with VENDOR_DOC_NUM
  2. REPLACE the BPA using PDOI at the first time : PO_HEADERS_INTERFACE.ACTION = 'REPLACE', updated the END_DATE of existed BPA and created a new BPA with the START_DATE and END_DATE
  3. REPLACE the BPA using PDOI at the second time : PO_HEADERS_INTERFACE.ACTION = 'REPLACE' -- the error occurs

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms