My Oracle Support Banner

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.


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.

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


  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.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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