Orders Cannot Be Deleted When Created From Sales Agreements - ORA-01403: no data found in Package OE_Blkt_Release_Util Procedure Cache_Blanket

(Doc ID 2398900.1)

Last updated on MAY 16, 2018

Applies to:

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

Symptoms

Orders cannot be deleted when they are created from sales agreements

STEPS TO REPRODUCE THE ISSUE
a. Open a Sales Agreement
b. Select Create Releases
c. Provide header and line information
d. Save the order
e. Click on delete button from top bar
f. Save
g. An error message is displayed:

ORA-01403: no data found in Package OE_Blkt_Release_Util Procedure Cache_Blanket

 

Debug file shows following error message:

Decrement qty/amt for old blanket num :50907
Enter cache blanket
lock :Y
blanket number :50907
blanket number :1
blanket line id :1476785
query blanket line
LEAVING OE_MSG_PUB.ADD
3. ret sts of unexp error

If line information are not provided, then the order is successfully deleted. 

 

Cause

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 hundreds of Community platforms