Pricing Issue Ora-01427 Using Ignore Pricing For Order Lines Custom Hook
Last updated on JULY 19, 2017
Applies to:Oracle Order Management - Version 184.108.40.206 to 220.127.116.11 [Release 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 06-DEC-2013 ***
-- Problem Statement:
On 18.104.22.168 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:
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.
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