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

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