My Oracle Support Banner

PO_AUTO_SRC Abended at Step PO_REQINSIS9000.Step09 (Doc ID 2547357.1)

Last updated on DECEMBER 06, 2019

Applies to:

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

Symptoms

When running concurrent instances of PO_AUTO_SRC getting the following error: 

"File : /vob/peopletools/src/psappeng/aedebug.hSQL error Stmt #: 1708 Error Position: 22 Return: 54 - ORA-00054: Resource busy and acquire with NOWAIT specified or timeout expired Failed SQL stmt: TRUNCATE TABLE SYSADM.PS_PO_IBU_QTY_TMP2. Process abended at Step PO_REQINSIS9000.Step09 (SQL)- RC = 54. "


The issue can be reproduced at will with the following steps:

  1.  Create a three different requisitions
  2.  Sign in with three different users
  3.  Run 3 concurrent instances of PO_AUTO_SRC



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.