R12: Error APP-PO-1412: get_price_break-380: ORA-20001 While Enter Requisition Line Sourced to Contract Purchase Agreement (Doc ID 2078902.1)

Last updated on AUGUST 17, 2017

Applies to:

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

Symptoms

In an environment when Advanced Pricing is licensed for Purchasing,
when attempt to enter non catalog request, or one-time requisition line details sourced to CPA, error occurs.

Error:

APP-PO-1412: get_price_break-380: ORA-20001: An error has occurred during
Advanced Pricing Call. Please report following error to your System
Administrator.

Price was not found on price list for this item and uom EA.

Cause: A SQL error has occurred in get_price_break. The SQL error is
ORA-20001: An error has occurred during Advanced Pricing Call.
Please report following error to your System Administrator.

Price was not found on price list for this item and uom EA.

Action: Take note of both this error number and the actions you were trying
to perform. Contact your system administrator for further assistance.

This issue occurs after application of <patch 21510787>:R12.QP.C

Note: Same error occurs for iProcurement Non Catalog Request (NCR) and one-item item requisition

Steps to reproduce:

1- Create CPA 1 - Supplier A.
2- Create CPA 2 - Supplier B.
3- Create Price List - PL1, Product Context = Item, Product Attribute = All Items, Product Value = All, add Qualifier = Supplier/Party Informatin = A .
4- In iProcurement, attempt to create NCR for UOM EA, enter CPA 1. Add to Card. No error.
5- In iProcurement, attempt to create NCR for UOM EA, enter CPA 2. Add to Card. Error occurs.
6- In Requisition entry form, attempt to create a description line for UOM EA, enter Supplier information, click Source Document, choose CPA 1 from LOV. No error.
7- In Requisition entry form, attempt to create a description line for UOM EA, enter Supplier information, click Source Document, choose CPA 2 from LOV. 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