6 Replies Latest reply on Jun 23, 2015 2:59 PM by 2754961

Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

2754961 Jun 22, 2015 8:07 PM

When i create a requisition or save i am getting pop up a error stating that "been reserved by another user", It would continue to spin when I clicked on save; or approve, and wouldn't approve the requisition.

Approval workflow database error occurs while approving Purchase Requisition #12345

Contact your system administrator to identify the problem and to use SQL*Plus or Workflow Monitor to reactivate the approval workflow where it left off.

Give your system administrator the following information:

PL/SQL procedure: PO_APPROVAL_LIST_WF1S.UPDATE_APP_LIST_RESP_SUCCESS
Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid
ORA-06512: at "APPS.PO_APPROVALLIST_S1", line 2600
ORA-01403: no data found

1. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

Emad Al-Mousa Jun 23, 2015 4:37 AM (in response to 2754961)

Hi,

what Oracle Product are you using ? and what is the release number ?
Like Show 0 Likes(0)

Actions
2. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

2754961 Jun 23, 2015 5:43 AM (in response to Emad Al-Mousa)

Oracle R12.1.3

Thanks in advance.
Like Show 0 Likes(0)

Actions
3. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

Srini Chavali-Oracle Jun 23, 2015 12:38 PM (in response to 2754961)

The error seems obvious - there are two forms users trying to update the same record
Like Show 0 Likes(0)

Actions
4. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

2754961 Jun 23, 2015 2:30 PM (in response to Srini Chavali-Oracle)

Can you please explain - what two forms?
Like Show 0 Likes(0)

Actions
5. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

Srini Chavali-Oracle Jun 23, 2015 2:35 PM (in response to 2754961)

Can you post the navigation path/steps to reproduce your issue "When i create a requisition or save i am getting pop up ..."
Like Show 0 Likes(0)

Actions
6. Re: Error: ORA-01086: savepoint 'UPDATE_RESPONSE' never established in this session or is invalid

2754961 Jun 23, 2015 2:59 PM (in response to Srini Chavali-Oracle)

user cant reproduce... if it happens again i will share. But i want to understand why this error.. how do we fix this
Like Show 0 Likes(0)

Actions

Go to original post