Defines the record definition as a temporary table. Temporary images of the table can be created specified by the PeopleTools Options Page. Temporary tables are used for running Application Engine batch processes. Temporary tables can store specific data to update without risking your main application table.
Temp tables are mainly used for Parrellel processing. Also you take the data you want for manipulation into your Temp table and you can play with that. Finally when you get the desired data you can update the main tables.
One important thing when dealing with temp tables. When you use PeopleCode to call the app-engine it runs synchronously and also it doesn't use any temporary table instances created for batch processing instead it uses the instances created for online processing which by default is 3.
temporary tables are used by PF_RESOLVER in EPM. The source data will be resolved based on the run time parameters and inserted into the temporary table instance based on the record suite ID.
AE programs run in batch mode so the multiple instances of the same program gets created and due to this the deadlock situation can come. To avoid this situation peoplesoft provides the concept of temp tables i.e. the data that needs to be updated by the AP program is stored in the temp tables. This avoids the situation where the programs fetches the row one by one process it and then send the updated data back. By creating temp tables you can store the data that is effected by business logic in the temp table and then you can perform the opertaions on it instead of the main table. Once the processing is completed you can send the data back to the main table.
