My Oracle Support Banner

Unable To Delete The Price List Lines After Enabled The Attachments In Price List (Doc ID 2447378.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms


Currently applied <Patch 24506264> This patch resolves the issues caused when Attachments are attached to Price List and Modifiers form

When there is an attachment on a price list line, the price list line can eventually be deleted but receive following error:

ORA-01403: no data found in package QP_Price_List_Line_Util Procedure Query_Rows



STEPS TO REPRODUCE THE ISSUE
Pricing Responsibility
1. pull up price list = <price_list>
2. Create price list line with item = <item>
3. Attach attachment
4. save
5. Now delete the line with item = <item>
6. receive error:   

ORA-01403: no data found in package QP_Price_List_Line_Util Procedure Query_Rows

7. delete a second time and see at bottom of form: 2 records applied and saved

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.