My Oracle Support Banner

E-AE: How to Rebuild All Temporary Tables for Application Engine Programs (Doc ID 1267436.1)

Last updated on MARCH 01, 2024

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. *** ***


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.