My Oracle Support Banner

ORA-01086: savepoint 'COMPUTE_PRICE' never established in this session or is invalid Error Attempting to Add Products (sublines) In Service Contracts (Doc ID 1554586.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Service Contracts - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

In Contracts Billing/Termination, find that it is not possible to add products (sublines) in service contracts.
The below error message shows when we try to add the product in service contracts.

Error:
ORA-01086: savepoint 'COMPUTE_PRICE' never established in this session or is invalid
ORA-06512: at "APPS.OKS_QP_INT_PVT", line 2631
ORA-06510: PL/SQL: unhandled user-defined exception

FRM-40735: ON-INSERT trigger raised unhandled exception ORA-01086.


Steps to Reproduce:

1. (R) Service Contract

2. Open a contract > Navigate to Lines tab> Pricing /Product: add a product in service contract.


Business impact:

Due to this the customer is not able to complete the contract and in turn not able to bill the customer for the service

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.