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

Goal

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?

Solution

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