Peoplesoft translate value mapped to a page…Select p.*,xlat.descr_string from (SELECT FIELDNAME ,rtrim(MAX(SYS_CONNECT_BY_PATH(descr,'~~')),'~~') as descr_stringFROM(SELECT FIELDNAME,FIELDVALUE||' '||B.XLATLONGNAME||' '||B.XLATSHORTNAME AS DES…DiscussionPeoplesoft translate value mapped to a page…2 LikesReset Peoplesoft password from backendHere 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 one can login as them.
UPDATE PSOPRDEFNSET OPERPSWD = (SELEC…DiscussionReset Peoplesoft password from backend4 LikesSet Control TableHi all,Plz Explain the purpose of Stt Control Table...!I am having issue in the upgrade project.. the SETID returned from the set control table is a wrong when compared with the previous version.wher…DiscussionSet Control Table4 LikesTalent SummaryvideoTalent Summary32 LikesMisapplied PaymentsWhat would be the best, most efficient way to handle transferring misapplied payments from one customer to another? It doesn't seem to be the Transfer Worksheet, but any suggestions would be helpful.…DiscussionMisapplied Payments6 LikesQuery to determine which records user can se…Query to determine which records user can see
SELECT DISTINCT B.TREE_NODE, Z.RECDESCRFROM PSTREEDEFN A,PSTREENODE B,PS_SCRTY_ACC_GRP C,PSTREENODE E,PSROLECLASS X,PSROLEUSER Y,PSRECDEFN ZWHERE A.SETID…DiscussionQuery to determine which records user can se…5 LikesPeoplesoft ISISGroupPeoplesoft ISIS41 Likes
April 2013
What's new in PeopleTools 8.52 - Part 1videoWhat's new in PeopleTools 8.52 - Part 123 LikesData convertion for person profileI Have any one worked on the data convertion for person profile module (under profile management ) for HCM 9.0 using component Interface? If so can you please share some idea/details?We tried using t…DiscussionData convertion for person profile6 LikesPeopleSoft with .NETHello I have a Webbase application in .NET and I'm trying to run a COM API from peoplesoft. Has anyone donde this?
First I have to define the OSession variable with the word New otherwise it will hav…DiscussionPeopleSoft with .NET4 LikesPeoplesoft PracticesGroupPeoplesoft Practices36 LikesPeopleTools iPad CertificationvideoPeopleTools iPad Certification13 Likes
March 2013
What is the Difference between Datenow() fun…What is the Difference between Datenow() function and SYSDATE in SQR?DiscussionWhat is the Difference between Datenow() fun…4 LikesPeoplesoft FinancialGroupPeoplesoft Financial41 LikesPeoplesoft AdministratorsGroupPeoplesoft Administrators35 LikesOracle Open World PeopleSoftGroupOracle Open World PeopleSoft30 Likes