My Oracle Support Banner

Pricing Issue Ora-01427 Using Ignore Pricing For Order Lines Custom Hook (Doc ID 946035.1)

Last updated on JANUARY 29, 2022

Applies to:

Oracle Order Management - Version to [Release 11.5.10]
Information in this document applies to any platform.


-- Problem Statement:
On in Production:
Having implemented a custom hook to stop pricing calls for lines that have a zero price as detailed in the Oracle Technical Brief : Ignore Pricing for Order Lines –Custom Hook. Now while creating manually configured orders, when you select the nodes in the configurator and say Finish, the following error occurs:

ONT_PRICING_ERROR (ERR_TEXT=QP_PREQ_GRP.Update_Price_List_Information:
ORA-01427: single-row subquery returns more than one row)

This error is not seen during order import, it only occurs when the order is manually created via the UI.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Implement Custom Hook
2. Create Order and configure item
3. On return to Sales Order Form error is displayed

-- Business Impact:
The issue has the following business impact:
You are testing this Oracle suggested hook to improve the performance of order booking which involves a large number of nodes. Ability to minimize pricing calls
will improve the productivity.




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.