E-AE: How to Rebuild All Temporary Tables for Application Engine Programs
Last updated on AUGUST 11, 2017
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?
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