PS_AETEMPTBLMGR

PS_AETEMPTBLMGR – is the table that stores references (AE_APPLID) to the temporary PeopleSoft tables (_TAO,_TMP) used when running a specific Application Engine. The table contains, also, the process instance of the application engine run on a certain environment, the user (OPRID) that runs the AE,the time of run (RUNDDTM), the possibility of restarting the application engine and the current used temporary table instance. In order to unlock/release a temporary table instance one can issue the following command in the database:                                �
DELETE FROM PS_AETEMPTBLMGR WHERE PROCESS_INSTANCE=’xxxxxx’;
but this is not usually recommended before a thorough analysis of the generating situation.