Referencing Doc ID 1641066.1 We Also See A Record Locked Indefinitely And The DBA Must Intervene

(Doc ID 2312840.1)

Last updated on OCTOBER 17, 2017

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 and later
Information in this document applies to any platform.

Goal

On : 9.2 version, Performance

We also see a record locked indefinitely and the DBA must intervene.
Referencing Doc ID 1641066.1, we have experienced this issue with PO_AUTO_SRC and a couple of other purchasing related jobs. We have seen on our side if two users are kicking off the same job or a job that hits the same record, a record lock occurs but never releases. We have had the database administrator on our side kill the lock and the job in the process monitor will continue normally. Have you seen this issue reported in addition to what has been documented in Doc ID 1641066.1 ?
 

Solution

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