My Oracle Support Banner

Trying to Remove Line From Quote Error:"ORA-01086: savepoint 'DELETE_LINE_RLTSHIP_PVT' never established in this session or is invalid" (Doc ID 1330942.1)

Last updated on JUNE 29, 2018

Applies to:

Oracle Quoting - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Error while trying to delete a configured model from quote line, after adding a line level modifier.


Error:

Error returned in ASO_LINE_RLTSHIP_PVT.Delete_line_rltship.
error while deleting LINE_RLTSHIP
Error returned in ASO_QUOTE_LINES_PVT.Delete_quote_line.
ORA-01086: savepoint 'DELETE_LINE_RLTSHIP_PVT' never established in this session or is invalid ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62 ORA-06512: at "APPS.ASO_LINE_RLTSHIP_PVT", line 770 ORA-06510: PL/SQL: unhandled user-defined exception
Error returned in ASO_QUOTE_LINES_PVT.Delete_quote_line.
ORA-01086: savepoint 'DELETE_LINE_RLTSHIP_PVT' never established in this session or is invalid ORA-06512: at "APPS.ASO_UTILITY_PVT", line 62 ORA-06512: at "APPS.ASO_LINE_RLTSHIP_PVT", line 770 ORA-06510: PL/SQL: unhandled user-defined exception
An unexpected error has occured during processing of the ASO_QUOTE_HEADER AFTER DELETE information.

 

Steps to reproduce:

 1) Create a quote with a model item CN97444.
 2) Configure the model item.
 3) Manually modify the price of CFG item.
 4) Modified line duplicates in aso_line_relationships table, corrupting the data in that table.

Changes

 

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
Changes
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.