Last updated on JULY 24, 2017
Applies to:Oracle Purchasing - Version 12.2.5 and later
Information in this document applies to any platform.
On : 12.2.5 version, Purchase Order
When attempting to update Purchase Order shipment - Ship-To Location, the following error occurs:
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..
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,
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 -
l_price_status_code = NMS
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.
;SQLERRM = ORA-0000: normal, successful completion
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms