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 18.104.22.168 to 22.214.171.124 [Release 11.5.10]
Information in this document applies to any platform.
-- Problem Statement:
On 126.96.36.199 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:
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