PeopleSoft Database
Shared Templates allows you to use the PeopleSoft application Database as your file storage Drive.
Requirements and Setup
When you select the PeopleSoft application Database as the preferred Shared Templates Drive type, a database table must be created to store the Shared Templates files.div>To create the Shared Templates Drive database table, execute the script ‘sysadm.ps_e4a_shared_templates_tbl.sql’ on your PeopleSoft database. You can find the script file under directory ‘db’ in the installation package. The following changes can be made to the script:
- You can modify the script to change the ownership of the table. If you choose to do so, ensure the database user used to create thedatasourceconnection has SELECT, UPDATE and DELETE privileges on the table and create the required synonym to allow the database user to access the table without having to fully qualify the table name using the table owner.
- The tablespace (PTTLRG) used in the script can be modified to suit your system.
Ensure you maintain sufficient free space in the selected Tablespace.