How to Find Unused Permission List in PeopleSoft SELECT * FROM PSCLASSDEFN A WHERE NOT EXISTS ( SELECT ‘X’ FROM PSUSERCLASSVW B WHERE A.CLASSID = B.CLASSID ) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.OPRCLASS) AND NOT EXISTS (SELECT ‘X’ FROM PSOPRDEFN B WHERE A.CLASSID = B.PRCSPRFLCLS) AND NOT EXISTS […]
Continue readingNote: Some of the information related to setup and installation may no longer be valid due to ever changing Operating Systems and application versions/architecture. If you have any specific doubts, please post it in the comment section. 1) What are the PSDBA responsibilities? Installation of PeopleSoft, upgrades, administration, applying tools& Application patches,fixes &service packs, refreshes of database ,supports PS […]
Continue reading1. Overview Following are a few major 3rd Party tools that are supported by PeopleSoft Applications. Changes are occasionally made to the delivered code in order to suit the business needs as per the customer’s requirements. COBOL SQR nVision Crystal As part of standard requirements, COBOL and SQR program migration needs to be done at […]
Continue reading1.What is an Upgrade? A PeopleTools Upgrade updates the underlying PeopleTools tables ( and files ) only. No changes are made to Application data, only PeopleSoft system data is changed. Normally this is a PSAdmin project which does not require Application specialists. Since application data remains untouched, most user would not even know the […]
Continue readingIn Peoplesoft, many times we face the error like the reports are in queued staus for a long time & even if we run more reports, they also go in the same status. There could be number of reasons for it: Process Scheduler could be down. Check the status in Process Monitor> Server List If […]
Continue reading