myPeopleSoft

PeopleSoft Community Network

Forum Discussions (168)

Sort by: View

Discussions	Replies	Latest Activity
Useful queries in peoplesoft "RenameQueries.sql"UPDATE PSQRYDEFN set qryname = replace(qryname,'XGL','ZGL') where qryname in (select objectvalue1 from psprojectitem whe… Started by Dale Kittel in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Flexible Information Access PeopleSoft Finacials Warehouse delivers packaged reports for Oracle BI Standard Edition (Discoverer). PeopleSoft Financials Warehouse also… Started by Buford Schanz in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Reports not Posting / Discussion I have a report that is stuck in Posting but in PS_CDM_LIST it is not listed as having a DISTSTATUS = 7. I have restarted the process sched… Started by Waneta Winkleman in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
3 Tier in 8.9 Does anyone know why, we have recently upgraded to 8.9 and now our 3 Tier Client is causing problems....DB2 temp space fills up quickly to… Started by Karl Ragusa in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Passing Javascript variable to PeopleCode Hi all,My goal:I want my users to be able to click the 'browse' button to select a file - and I want to programmatically retrieve the file… Started by Dale Kittel in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Web Service Monitoring Hello, I was wondering how to monitor web service calls.I have a sync request peoplecode via AE to an external web service. request is goin… Started by Wilbert Janusz in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Switching from a guest user to a authenticated user We have a Campus Solutions student application where a student can search for classes as a guest user. Based upon the information they ente… Started by Michel Anstett in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Create insert statement for tables Create insert statement for tables for data migration where ZZ84 is a new prefix for temporary tables. SELECT DECODE(COLUMN_ID ,1,'INSERT I… Started by Michale Johannsen in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
Searching on long edit field in oracle 10 for peoplesoft create or replace function getlong( p_tname in varchar2,p_cname in varchar2,p_rowid in rowid ) return varchar2asl_cursor integer default db… Started by Reyes Rodas in PeopleSoft Functional Queries	1	Jul 9, 2017 Reply by kristen
AFS structure within App. Configuration Hello PeopleSoft experts. This one is a bit tricky, and hence seeking your suggestions/ideasScenarioUser1, User2User1 has his sqrs located… Started by Allie Alderson in PeopleSoft Technical Queries	1	Jul 9, 2017 Reply by kristen