OE_ORDER_PUB Gives Error When Adding Line Without Passing Price_list_id After 12.2.10 Upgrade (Doc ID 2753373.1)

Last updated on MARCH 30, 2024

Applies to:

Symptoms

On : 12.2.10 version, Transaction Entry

OE_ORDER_PUB gives error when adding line without passing price_list_id after 12.2.10 upgrade

For many years (on 12.1.3) we run a custom program using OE_ORDER_PUB to add lines to an order.
After upgrading to 12.2.10 we get the error Unit List Price is required on a booked order line.

  l_new_line_tbl(ln_return_line_counter) := oe_order_pub.g_miss_line_rec;
  l_new_line_tbl(ln_return_line_counter).operation := oe_globals.g_opr_create;
  l_new_line_tbl(ln_return_line_counter).return_reason_code := 'NO REASON';
  l_new_line_tbl(ln_return_line_counter).line_category_code := 'RETURN';
  l_new_line_tbl(ln_return_line_counter).line_type_id := l_order_type_id;
  l_new_line_tbl(ln_return_line_counter).header_id := l_orig_header_rec.header_id;
  l_new_line_tbl(ln_return_line_counter).inventory_item_id :=
  l_new_line_tbl(ln_return_line_counter).ordered_quantity :=
  l_new_line_tbl(ln_return_line_counter).unit_selling_price :=
  l_new_line_tbl(ln_return_line_counter).calculate_price_flag := 'N';
  l_new_line_tbl(ln_return_line_counter).CONTEXT := l_order_type_id;

ERROR
-----------------------
Unit List Price is required on a booked order line.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.