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

Symptoms

-- Problem Statement:
On 11.5.10.2 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:

ERROR
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.

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.