My Oracle Support Banner

TL8.x: AppEngine/Temp Table Allocation Errors in Time Administration (Doc ID 610933.1)

Last updated on MARCH 04, 2022

Applies to:

PeopleSoft Enterprise HCM Time and Labor - Version 8 and later
Information in this document applies to any platform.
Time and Labor, Time and Labour, TL8, T&L, Commercial, Federal, Public Sector, Education & Government, Student Administration, PeopleSoft 8, Time Administration, Release 8, 8SP1, Service Pak 1

This document was previously published as Customer Connection Solution 705521


For any application engine process that is run in Time and Labor there is a potential to have the process abend with no success and a message like:
Application ended due to a problem encountered during the internal housekeeping of Temporary Tables.

The possible failure points are as follows:
C++ Memory allocation for adding new temp tables to the existing internal array.

SQL processing errors for one of the following:
Update to PSAELOCKMGR error
SELECT to get available instance number.
INSERT to PSAETEMPTBLMGR to reserve the instance number.
TRUNCATE/DELETE for the temp table name chosen error.


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.