E-AE: How to Rebuild All Temporary Tables for Application Engine Programs

(Doc ID 1267436.1)

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