My Oracle Support Banner

Retrobill Lines Concurrent Request Error: ORA-01422: exact fetch returns more than requested number of rows (Doc ID 2238522.1)

Last updated on MAY 02, 2018

Applies to:

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


When attempting to create a Retro Bill order, Retrobill Lines concurrent request, the following error occurs.



Step 1) Go to Oracle Pricing Manager, Global Responsibility - Price Lists - Price List Setup

Step 2) Query for the required price list coressponding to the retrobill order and change the prices

Step 3) Save the changes

Step 4) Go to Order Management Super User responsibility - Orders,Returns - Retrobilling - Retrobill Organizer- Retrobill:Find

Step 5) Query for the retrobill order and run the concurrent program "Retrobill Lines"

Step 6) This results in the above mentioned warning.




To view full details, 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 a vibrant support community of peers and Oracle experts.