myPeopleSoft

PeopleSoft Community Network

PeopleSoft Functional Queries (136)

Sort by:

Discussions	Replies	Latest Activity
No Buffer Error on Profile Management Hi everyone,has anyone got an error "No Buffer Error" on the 9.0 profile management when they try to open a person profile? if so, can you… Started by Madge Mun	1	Jul 9, 2017 Reply by kristen
Issue with transferred assets Hi experts Issue in peoplesoft asset management module. i got two assets which are still depreciating even after making inter unit transfer… Started by raj kumar	1	Jul 9, 2017 Reply by kristen
Useful DBA query to find out queries in background !! SELECT NVL(b.oprdefndesc,'Blank'),a.CLIENT_INFO,a.OSUSER,a.machine,a.PROGRAM,a.LOCKWAIT,a.LOGON_TIME,'ALTER SYSTEM KILL SESSION '''\|\| a.SID… Started by Mindi Laino	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 Mitchell Mahi	1	Jul 9, 2017 Reply by kristen
Slow Query - Help Needed This query used to run fast but lately has timed out often. Does anyone have any suggestions as to ways to improve the query run time? Than… Started by Allie Alderson	3	Jul 9, 2017 Reply by kristen
FSCM9.2 on PT 8.53 Hello All,I did a fresh installation of FSCM9.2 database on PT 8.53 . My installation details are below.O/s Windows 7 64 bitDB : Oracle 11g… Started by Fidelia Freel	5	Jul 9, 2017 Reply by kristen
Top big tables by rows in peoplesoft SELECT table_name,num_rows,rank() over (order by num_rows DESC ),recdescrFROM all_tables, PSRECDEFNWHERE instr(table_name,'PS_',1) >0 an… Started by Boyd Sumter	2	Jul 9, 2017 Reply by kristen
Field Alignment through peopleCode Hi, If anyone knows how to align fields through peoplecode, please share it. Thanks in advance. Started by Dori Charlie	3	Jul 9, 2017 Reply by kristen
Command Line SQR When running a PeopleSoft process from the process scheduler, you can find the process id and the process status at the process monitor. If… Started by Britteny Pike	5	Jul 9, 2017 Reply by kristen
How to read DataSelection and DataSequencing of report? I am building a report which will print DataSelection and Data Sequencing for all the reports.This information is stored in Central Objects… Started by Nyla Rhoades	1	Jul 9, 2017 Reply by kristen