PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
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.
PeopleSoft Developers
121 members
Description
PeopleSoft Developers will showcase the knowledge and experience required to help developers tweak and program development and configuration of PeopleSoft engines
PeopleSoft Application Engine Drop Temp Tables & re-Create
by Major Tooley
Dec 16, 2013
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...