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.
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
g. An error message is displayed:
Debug file shows following error message:
Decrement qty/amt for old blanket num :50907
Enter cache blanket
blanket number :50907
blanket number :1
blanket line id :1476785
query blanket line
3. ret sts of unexp error
If line information are not provided, then the order is successfully deleted.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!