PeopleSoft Tips and Tricks

1) Change the Branding System Options: Navigation:  Main Menu > PeopleTools > Portal > Branding > Branding System Options Change the "Default Branding Theme" from DEFAULT_THEME_FLUID to DEFAULT_THEME_TANGERINE_ALT. 2) Update the default homepage from Fluid to Classic: Navigation: Main Menu > PeopleTools > Personalization > Personalization Options Search for User Option Value of "HPPC" (PTHOMEPAGE)  Click on "Set Option Default Value" link and Then Change the Value to Classic.

SELECT projectname, objecttype, DECODE(objecttype, '0', 'Record', '1', 'Index', '2', 'Field', '3', 'Field Format', '4', 'Translate Value', '5', 'Page', '6', 'Menu', '7', 'Component', '8', 'Record PeopleCode', '9', 'Menu PeopleCode', '10', 'Query', '11', 'Tree Structure', '12', 'Tree', '13', 'Access Group', '14', 'Color', '15', 'Style', '16', 'Business Process Map', '17', 'Business Process', '18', 'Activity', '19', 'Role', '20', 'Process Definition', '21', 'Process Server Definition', '22', 'Process Type Definition', '23', 'Process Job Definition', '24', 'Process Recur...

Attached is the Document with step by step guide for adding a Pagelet, Adding a WorkCenter Dashboard Link and Adding the Pagelet to WorkCenter Dashboard Link. Step By Step Guide to Add a Pagelet to WorkCenter Dashboard

How to set the default password for all users or a specific user in PeopleSoft? 1)       Run the below SQL to set the default password for all User IDs: UPDATE PSOPRDEFN SET OPERPSWD = ‘New Password’ , ENCRYPTED = ‘0’; 2)       Run the below SQL to set the default password for a specific User ID  or group of user ids: UPDATE PSOPRDEFN SET OPERPSWD = ‘New Password’ , ENCRYPTED = ‘0’ WHERE OPRID IN (‘ User ID List’ ); 3)       Run the below Script using data mover to Encrypt the Password: Here's an example of how to encrypt a single user password (FS) already listed in PSOPRDEFN: ENCRYPT_PASSWORD FS ; To encrypt all user passwords in PSOPRDEFN, enter: ENCRYPT_PASSWORD *; Both Update Password and Encrypt Password script can be run together using Data Mover. For All Users: UPDATE PSOPRDEFN SET OPERPSWD = ‘New Password’ , ENCRYPTED = ‘0’; ENCRYPT_PASSWORD *; For Single Us...

--SQL will show the Query Security Tree Name and Permission it is associated with for a specific Table Name. SELECT A.TREE_NAME, A.DESCR, B.PARENT_NODE_NAME, B.TREE_NODE, B.TREE_NODE_TYPE, C.CLASSID, B.TREE_NODE_NUM, B.PARENT_NODE_NUM, C.ACCESS_GROUP, C.ACCESSIBLE FROM PSTREEDEFN A, PSTREENODE B, PS_SCRTY_ACC_GRP C WHERE ( A.SETID = ' ' AND A.TREE_STRCT_ID = 'ACCESS_GROUP' AND A.SETID = B.SETID AND A.SETCNTRLVALUE = B.SETCNTRLVALUE AND A.TREE_NAME = B.TREE_NAME AND B.TREE_NODE = :1 AND B.TREE_NAME = C.TREE_NAME ) ORDER BY 7, 8, 6 ; --Below SQL will give the List of Queries that is exist in the system, but some of the Records used in Query in not available in the Query Security Tree SELECT A.QRYNAME, A.DESCR   FROM PSQRYDEFN A, PSQRYRECORD B   WHERE ( A.OPRID = B.OPRID      AND A.QRYNAME = B.QRYNAME      AND NOT EXISTS (SELECT 'X'   FROM PSTREEDEFN C, PSTREENODE D   WHERE C.EFFDT =       ...

CFO tool https://apexapps.oracle.com/pls/apex/f?p=10319:18:0