myPeopleSoft

PeopleSoft Community Network

Forum Discussions (168)

Sort by: View

Discussions	Replies	Latest Activity
Reset Peoplesoft password from backend Here is a script one can use against thier base account where one know the password and reset some target user’s password to match mine so… Started by Darin Disalvo in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Set Control Table Hi all,Plz Explain the purpose of Stt Control Table...!I am having issue in the upgrade project.. the SETID returned from the set control t… Started by Dale Kittel in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Consuming .NET webservices in PeopleSoft Hi Guys,I am a donet developer, i want to develop a webservice which returns an Array of Bytes. Can people soft get this array of bytes fro… Started by Darin Disalvo in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Upgrade to 9.0 from 8.8 PSQuery Whenever we are adding a prompt field to a query in version 9 we are loosing the Query title in the "run" page. Any Clues? Started by Clementine Grimshaw in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
What can we do if a page load too slow? Hi all, I've made a customization (ps-fn) and works fine in our dev. area. My supervisor created a training area which copied everything fr… Started by Gerald Kimmer in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Query to determine which records user can see. Query to determine which records user can see SELECT DISTINCT B.TREE_NODE, Z.RECDESCRFROM PSTREEDEFN A,PSTREENODE B,PS_SCRTY_ACC_GRP C,PSTR… Started by Wendell Duppstadt in PeopleSoft Functional Queries	3	Jul 9, 2017 Reply by kristen
Project Object Finder SQL !! SELECT PROJECTNAME,CASE OBJECTTYPEWHEN 0 THEN CASE NVL((SELECT RECTYPE FROM PSRECDEFN WHERE RECNAME =I.OBJECTVALUE1), 99)WHEN 0 THEN 'SQL T… Started by Mitchell Mahi in PeopleSoft Technical Queries	1	Jul 9, 2017 Reply by kristen
Peoplesoft translate value mapped to a page SQL. Select p.*,xlat.descr_string from (SELECT FIELDNAME ,rtrim(MAX(SYS_CONNECT_BY_PATH(descr,'~~')),'~~') as descr_stringFROM(SELECT FIELDNAME,… Started by Man Musser in PeopleSoft Technical Queries	2	Jul 9, 2017 Reply by kristen
360 degree view of component. SELECT A.PNLGRPNAME, A.PNLNAME, A.ITEMLABEL, B.RECNAME,b.fieldname,b.occurslevel, B.LBLTEXT,A.MARKET,B.PNLNAME,B.PNLFLDID,objectvalue1,obje… Started by Adalberto Leverich in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Keys on component interface /LevelNo\|Iskey\|RecordName\|FieldName\|ParentRecName/ SELECT A.BCSCROLL \|\| '\|' \|\| DECODE(B.FIELDNAME , NULL , 'FALSE' , 'TRUE') \|\| '\|' \|\| A.… Started by Allie Alderson in PeopleSoft Technical Queries	1	Jul 9, 2017 Reply by kristen