Error Occurs While Updating The Purchase Order - APP-PO-14142: get_break_price-380: ORA-20001:

(Doc ID 2266117.1)

Last updated on JULY 24, 2017

Applies to:

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

Symptoms

On :  12.2.5 version, Purchase Order

When attempting to update Purchase Order shipment - Ship-To Location, the following error occurs:

Error:
Error: APP-PO-14142: get_break_price-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 itme and uom BX.

Cause: A SQL error has occurred in get_break_price. The SQL error is ORA-20001: An error has occured during advanced pricing call. please report following error to your system administrator.

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

Replication Steps:
The issue can be reproduced at will with the following steps:
1.  Purchase Order is queried in the Enter Purchase Order form.
2.  The line then shipment button is used to navigate to the shipment
3.  Upon updating the ship to location on the purchase order, an error is encountered.

Advanced Pricing and price lists are NOT being used for calculating the prices in the Purchasing Module. 

_______________________________________________________________________


SQL Used in attempts to fetch the price list data, all resulting in no rows returned.  The purchase order was having a Contract Agreement Reference.

select qph.name price_list_name, qpl.list_line_id price_list_line_id, qpl.product_attribute_context, qpl.product_uom_code,
poh.segment1, qpl.product_attr_value, qpl.*
from qp_secu_list_headers_v qph, qp_list_lines_v qpl, qp_qualifiers_v qpv,
po_headers_all poh
where
qph.list_header_id = qpl.list_header_id and
qph.list_header_id = qpv.list_header_id and
qpv.qualifier_attr_value = to_char(poh.po_header_id) and
poh.type_lookup_code = 'CONTRACT' and
poh.po_header_id = &contract_agreement_po_header_id_from_po_line;

_______________________________________________________________________

 

FND logging showed the following -

po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.260
l_price_status_code = NMS
po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.260
l_price_status_text = Price was not found on price list for this item and uom BX.
po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.END End of subprogram.
po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.300 x_return_status = E
po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.300 x_base_unit_price is null
po.plsql.PO_ADVANCED_PRICE_PVT.GET_ADVANCED_PRICE.300 x_unit_price is null
po.plsql.PO_SOURCING2_SV.GET_BREAK_PRICE.380 After Call Advanced Pricing API(CPA)

fnd.plsql.APP_EXCEPTION.RAISE_EXCEPTION.dict_auto_log An error has occured during
Advanced Pricing Call. Please report following error to your System Administrator.

Price was not found on price list for this item and uom BX. po.plsql.po_message_s.get_break_price.380.EXCEPTION ;

SQLERRM = ORA-20001: An error has occured during Advanced Pricing Call. Please report following error to your System Administrator.

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

po.plsql.po_message_s.get_break_price.000.EXCEPTION
;SQLERRM = ORA-0000: normal, successful completion

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