My Oracle Support Banner

PDOI Failing To Insert and Instead Updates When Item Has Same Description (Doc ID 2297179.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


Customer is attempting to use the Import Price Catalog (PDOI) to update an existing Blanket Purchase Order by creating a new line different part and description is same as already existing part in line number 1.

Error Occurs:


The line process gets changed to UPDATE instead of NEW and then an error occurs as it thinks an update should happen:

PO_DOCS_OPEN_INTERFACE 62,646 Error: Effective Dates on Price Breaks are not allowed for Cumulatively Priced Blanket Lines PO_PDOI_CUMULATIVE_FAILED PO_LINE_LOCATIONS_INTERFACE


Steps to Reproduce the Issue

  1. Locate or create a BPA with 1 line or more
  2. Insert PDOI records to update the same BPA and insert a new line (Header is Updte, Line is Create) with same item description as an existing line
  3. Run the IMPORT PRICE CATALOGS program
  4. The "Action" column is switching from "ORIGINAL" to "UPDATE" and a new line is not inserted






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

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