Oracle PeopleSoft

Application Engine: Releasing Temporary Tables

I was trying to debug an Application Engine and noticed that the debugger had hung. I restarted Application Designer and re-ran the debugger for the Application Engine. Since there was only one instance assigned to each temporary table, I noticed that the previous failed run had not released the temporary tables. I managed to work around this by deleting from the following tables:

The following are the SQL Statements that I used:

If you’re sure that nobody else is using the system you can just run the following:

Note: TRUNCATE does not require a commit as it is a DDL statement.

Leave a Reply

Your email address will not be published. Required fields are marked *