My Oracle Support Banner

Changing the Pricing Date On Sales Order Line Results In Error - ORA-01422 (Package OE_Default_Line Procedure Default_Active_Agr_Revision) (Doc ID 2564483.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Order Management - Version 12.2.3 and later
Information in this document applies to any platform.


On : 12.2.3 version, Trx Changes & Cancellations

When attempting to Change the Pricing Date on the Sales Order Line,
the following error occurs.

ORA-01422: exact fetch returns more than requested number of rows in Package OE_Default_Line Procedure Default_Active_Agr_Revision

The issue can be reproduced at will with the following steps:
1. Create two or more different Price Agreement with the same Agreement Name ( different users can do it no knowing about it)

A. Create a Pricing Agreement with name like 3333 with No as 88888 and revision as 1.
B. Create another Pricing Agreement with name like 33333 with No as 99999 and revision as 2.
C. Now change the name of 33333 to 3333 and save. Some error will occur but it will be saved.

Please note that these Pricing Agreement Names are mentioned as examples and these do not represent the actual data.

2. Save these Agreements (the system allows);
3. Create Sales Order indicated such Agreement Name.
4. Try to update Pricing Date.
5. Get the error ORA-01422




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.