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

Last updated on JULY 19, 2017

Applies to:

Oracle Order Management - Version 11.5.10.0 to 11.5.10.3 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 06-DEC-2013 ***

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 White Paper : 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.

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