My Oracle Support Banner

ORA-01403 Error When Attempting To Add New Line In Price List (Doc ID 2719586.1)

Last updated on APRIL 03, 2024

Applies to:

Oracle Advanced Pricing - Version 12.2.5 and later
Information in this document applies to any platform.


On : 12.2.5 version, Price List

When attempting to add new lines in an existing pricelist (using automation), the below mentioned error occurs and the BOT fails each time this issue occurs.

ORA-01403: no data found.
ORA-01403: no data found in package QP_Price_list_line_util Procedure Query_Rows

As a workaround, user has been deleting the line that threw the error, saving the pricelist , close it, re-open it, and continue where the user left off. However, because user has been automating the process of pricelist entry, this is becoming very cumbersome when automation fails each time

1. Login to Oracle Applications
2. Go to Responsibility - Oracle Pricing Manager - Pricelists - Price List Setup
3. Query for Price List "XXXXXXX"
4. Attempt to add a line




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.