TL8.x: AppEngine/Temp Table Allocation Errors in Time Administration
Last updated on DECEMBER 14, 2017
Applies to:PeopleSoft Enterprise HRMS 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.
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