Price Engine Generates Error ORA-1422 CANNOT SAVE/BOOK SERVICE ITEM PACKAGE When Item Belongs Multiple Price List Item Categories (Doc ID 1964766.1)

Last updated on AUGUST 08, 2017

Applies to:

Oracle Order Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Pricing Engine

When attempting to enter an order line for an item that exists in multiple item categories
the following error occurs.

ERROR
-----------------------
ORA-01422 exact fetch returns more than requested number of rows in Package OE_Holds_PUB Procedure evaluate_holds_post_write


STEPS
-----------------------

  1.  Responsibility: Order Management Super User
  2.  Orders, Return
  3.  Enter requied Header Information
  4.  At the Line, enter an item which exists in two different item categories
  5.  Click on actions price line > Observe ORA-01422 Error.

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