myPeopleSoft

PeopleSoft Community Network

Forum Discussions (168)

Sort by: View

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 in PeopleSoft Functional Queries	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 in PeopleSoft Functional Queries	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 in PeopleSoft Functional 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 Mitchell Mahi in PeopleSoft Functional Queries	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 in PeopleSoft Functional Queries	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 in PeopleSoft Functional Queries	5	Jul 9, 2017 Reply by kristen
PeopleSoft Single Sign-on -- Capture Network ID or IP address for Batch ID We have Single Sing-on enable and configured with LDAP server. We have common PeopleSoft User ID that is primarily used for batch processi… Started by InfoStar in PeopleSoft Technical Queries	1	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 in PeopleSoft Functional Queries	2	Jul 9, 2017 Reply by kristen
Get high level list of peoplesoft Customisation.. SELECT *FROM(SELECT DECODE(recdescr,' ',''''\|\|recname\|\|'''',recdescr),recname ,rcount,'Select '''\|\|DECODE(recdescr,' ',recname,recdescr)\|\|'… Started by Gilberto Going in PeopleSoft Technical Queries	1	Jul 9, 2017 Reply by kristen
Component to peoplesoft field description SELECT DISTINCT RECNAME,Fieldname,lbltext,DECODE(bitand(fielduse, 1), 1, 'On', 'Off') DISPLAY_ONLY,DECODE(bitand(fielduse, 2), 2, 'On', 'Of… Started by Madge Mun in PeopleSoft Technical Queries	1	Jul 9, 2017 Reply by kristen