PeopleSoft Community Network
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.