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.
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
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
| Goal |
| Solution |
| References |