
Jeff's PeopleSoft Blog
292 FOLLOWERS
Blog to share and discuss PeopleSoft knowledge.
Jeff's PeopleSoft Blog
5y ago
I recently had a requirement to only allow certain types of files to be uploaded to PeopleSoft.
I wanted a solution that didn't require custom PeopleCode and didn't have to!
The File Extension List allows to specify allowed file extensions and attach this list
to the URL with a FILE_EXT_LIST property.
For this example I will be attaching a file to an expense report using the Financials/Supply Chain PUM Image 35.
In the first step we will create the File extension list:
Navigate to PeopleTools, Utilities, Administration, Administer File Processing, File Extension List
Here you can set up ..read more
Jeff's PeopleSoft Blog
5y ago
I recently had a project where I had an issue having to change the tablespaces for many records. Here is a handy script that will allow you to change the tablespace value and avoid build errors. Enjoy! Update PSRECTBLSPC SET DDLSPACENAME = '<New_TablespaceName>' WHERE DDLSPACENAME = '<Old_TablespaceName>' and RECNAME IN (Select A.OBJECTVALUE1 from PSPROJECTITEM A, PSRECDEFN B Where A.PROJECTNAME = '<PROJECTNAME>' and A.OBJECTTYPE = 0 and A.OBJECTID1 = 1 and A.OBJECTVALUE1 = B.RECNAME and B.RECTYPE =0 ..read more