Several time based on the requirements we have to remove and rebuild the temp tables which are specified in AE. 

Below are the steps I followed to delete.

1. Find out the temp tables which are used by specific table using below query.

   select  table_name from all_tables where table_name like '%ABCTAO3%';
 
2. Using below sql generate the Drop Script.
 
     select 'DROP TABLE '||table_name||';' from all_tables where table_name like '%ABCTAO3%';



3. Execute the generated script in Database. I prefer to run these in DataMover.

Then build the table in Appdesigner.

Read Further: http://srinivasreddy18.blogspot.in/2013/04/peoplesoft-application-e...