Temp Table (PS_CNTRCT_AUC_T) Is Kept Aside From The List Of Temporary Tables On The PO_AUTO_SRC Program
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.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms