How to restrict File Types (extensions) in PeopleSoft

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 list of file types, by file extensions which either can accept or reject when you do file attachments to your system. In our example below we have allowed .DOC, .DOCX .PNG and .PDF extensions. The option of Absolute tells the system which extensions are explicitly enumerated and have a status of accept.

In the second step we will add the TEST_FILE_EXTENSION_LIST to the URL properties on the Voucher attachment URL. We will use the FILE_EXT_LIST Property.

We can test this by adding an invalid file to an expense report and see the error.

Hope you found this useful!

Changing tablespace values in PeopleSoft

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);

Unified Navigation refresh SQL Script

I am using Unified Navigation in my Portal (Interaction Hub) environment. When a database that is refreshed from production I needed a quick way to update the Unified Navigation configuration information with SQL. Here is the updates I have found useful in my environment. 

--Interaction Hub Unified Navigation refresh:

--Remote Content

UPDATE PS_PTUN_DDMENUCFG

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'), 

DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%'),

PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'

WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

UPDATE PS_PTUN_DDMENUCFG

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'), 

DESCR30 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%'),

PORTAL_OBJNAME1 = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'

WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Message Nodes

--HCM Node

UPDATE PSUN_CFGHNODE

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE MSGNODENAME = '<HR_PRODUCTION_NODE>';

--Campus Node

UPDATE PSUN_CFGHNODE

SET MSGNODENAME = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE MSGNODENAME = '<CS_PRODUCTION_NODE>';

--Structure & Content

UPDATE PSPRSMDEFN 

SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE PORTAL_CNTPRV_NAM = '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMDEFN 

SET PORTAL_LABEL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE PORTAL_CNTPRV_NAM = '<CS_PRODUCTION_NODE>';

--Folder Attributes

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%')

WHERE PORTAL_ATTR_VAL LIKE '<HR_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%')

WHERE PORTAL_ATTR_VAL LIKE '<CS_PRODUCTION_NODE>';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'CS%') || ':PORTAL_ROOT_OBJECT'

WHERE PORTAL_ATTR_VAL LIKE 'CS%ROOT%';

UPDATE PSPRSMSYSATTRVL 

SET PORTAL_ATTR_VAL = (SELECT MSGNODENAME FROM PSTRUSTNODES WHERE MSGNODENAME LIKE 'HR%') || ':PORTAL_ROOT_OBJECT'

WHERE PORTAL_ATTR_VAL LIKE 'HR%ROOT%';

VirtualBox PUM Image PIA not running due to lack of space

I have been running a new VirtualBox HR PUM Image for several weeks. I've recently been unable to login into the image even though it appears to be running. I ran across an article on MOS that talked about the disk becoming full and that was my problem.

Over time you will have log and core files that will build up and not allow the PIA and other processes to start due to a lack of space for the log files. You can log in to the Image as the root user and run the "df -k" command to view available space.





The solution is to remove core dump files (core.*), trace files, log files and cache files from
the directories. I removed all of these files from the following directories:

/home/psadm2/psft/pt/8.55/appserver/APPDOM
/home/psadm2/psft/pt/8.55/appserv/prcs/PRCSDOM
/home/psadm2/psft/pt/8.55/appserv/prcs/PRCSDOM/LOGS
/home/psadm2/psft/pt/8.55/webserv/peoplesoft/applications/peoplesoft/PORTAL.war/ps/cach


I restarted the Image after I removed these files and the Application Server and PIA domain started normally. I use an FTP client to connect to the PUM Image.

Unified Navigation in PeopleTools 8.55

I recently installed Unified Navigation in a 8.55 fluid environment. I installed the workcenter from the latest IH PUM Image (Doc ID 1641843.2). Here are some import/export DMS scripts and a App Designer project to help in migrating this to your environment. Big thanks to Simon Chiu for assistance with the Unified Nav functionality.

1) Run your export script (Click here to download) in IH PUM Image 3 to create the DAT file
2) Run the import script (Click here to download) in your IH environment to import the workcenter and activity guide
3) Copy the app designer project (Click here to download) into your IH environment
4) Bounce your app/web server for changes to take effect
5) From the Navigator menu go to Portal Administration->Unified Navigation Workcenter
    -Note: You might have to add the Portal security role to your security if you get an error          

PSAdmin.io Deployment Package course

Dan Iverson has put together a new course on the PeopleSoft DPK. He does a very nice job explaining how to build out a PeopleSoft infrastructure.

PSAdmin.io DPK course

Heap Size for Change Assistant

My use of Change Assistant has increased while doing regular PUM updates in 9.2 environments. I've recently realized how to change the heap size for the Change Assistant and have seen improvement in performance. In my case I set the maximum heap size to 2048. Here's how I did it.

1) Right click on the CA desktop shortcut and choose Properties

2) In the Target text box append -Xmx2048m to the end. It will look like this: