E-AE: How to Rebuild All Temporary Tables for Application Engine Programs
(Doc ID 1267436.1)
Last updated on DECEMBER 05, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.22 to 8.51 [Release 8.2 to 8.4]
Information in this document applies to any platform.
***Checked for relevance on 17-Aug-2012***
***Checked for relevance on 03-JUL-2014***
When running an Application Engine (AE) program AMIF1000, it failed with the following message,
File: E:\pt84927b-retail\peopletools\SRC\PSAPPENG\psaesql.cp pSQL error. Stmt #: 2676 Error Position: 0 Return: 601 - [ Microsoft][SQL Native Client][ SQL Server]Cannot find the obj ect "PS_ASSET_ACQ_TMP6" because it does not exist or you do not have permissions.
The message is indicating a required temp table is missing from the database, how to rebuild all the temp tables for the Application Engine program?
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