My Oracle Support Banner

Purchasing Documents Open Interface(PDOI)/Import Price Catalogs Issue, Organization Code Is Populated for the Imported Quotation Price Break But Not Showing Up on the Imported Quotation (Doc ID 2023659.1)

Last updated on APRIL 20, 2023

Applies to:

Oracle Purchasing - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


While attempting to import Quotations, the Organization Code field in the Price Breaks is being populated so that the specific organization will only be used for the price break.

The records for the Quote are not erroring but simply being inserted without the given Organization in the Price Break table/screen.


Sample insert into the PO_LINE_LOCATIONS_INTERFACE table which corresponds to Price Breaks, notice the field "SHIP_TO_ORGANIZATION_ID" is being populated and eventually should appear on the Price Break screen with the other information.  

 The expectation is that based on the data inserted as illustrated above, the Organization Code should be populated on this screen(and in the table).


  1. Insert PDOI data for a quote-as illustrated above populate the data for a Price Break on the quote with the organization populated
  2. Run the Import Price Catalogs program
  3. Examine the Quote and the price break records on the quote


 There were no changes done


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.