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

Last updated on AUGUST 22, 2017

Applies to:

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

Symptoms


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

 

 

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