Temp Table (PS_CNTRCT_AUC_T) Is Kept Aside From The List Of Temporary Tables On The PO_AUTO_SRC Program (Doc ID 2167680.1)

Last updated on AUGUST 01, 2016

Applies to:

PeopleSoft Enterprise SCM Purchasing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Most of the “No Success” related to PO_AUTO_SRC process are around a No Wait on truncating temporary table PS_CNTRCT_AUC_T.
This table is a temporary table but not added to the list of temporary tables on the program PO_POCREATE. So every time this program is truncating base table of PS_CNTRCT_AUC_T and in some cases when other parallel processes are working on the table, we are getting No Wait error.


Steps to reproduce the issue:
1. Temp table PS_CNTRCT_AUC_T is not part of the temporary table
2. Run the PO_AUTO_SRC process and it may run t no success because of this table.

Cause

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