Hints, Tips & Gotchas

Forum » Forum / Hints, Tips & Gotchas
Number of threads: 146
Number of posts: 175
rss icon RSS: New threads | New posts
Snippets of information that may help you out.
Order by:
Last post date
Thread starting date
Create a new thread
page 1 of 8123...78next »
Thread name Started Posts Recent post
This is useful when we want to get different translate values. instead of using peopleosft PIA just through a query
by: RahulAgrawalRahulAgrawal
07 Feb 2010 00:29
2 by RahulAgrawalRahulAgrawal
26 Feb 2020 04:49 Jump!
Data finder across all tables for given column and value. this is useful in data migration and mass updates. we identify tables which are relevant based on key value
by: RahulAgrawalRahulAgrawal
25 Feb 2020 08:51
2 by RahulAgrawalRahulAgrawal
25 Feb 2020 10:38 Jump!
recurse and provide as many subpanels as possible, you can use the following (Oracle Syntax) SQL:
by: RahulAgrawalRahulAgrawal
20 Feb 2020 23:30
1  
Sample html page for auto login for peopelsoft environment, useful when we have to switch between different user and multiple non prod environment
by: RahulAgrawalRahulAgrawal
20 Feb 2020 05:52
1  
Below query may help to get the sql executed by SQR, it works best only when single process running on the process scheduler
by: RahulAgrawalRahulAgrawal
05 Dec 2019 12:13
1  
by: RahulAgrawalRahulAgrawal
04 Dec 2019 09:47
1  
by: RahulAgrawalRahulAgrawal
20 Jun 2013 10:16
2 by RahulAgrawalRahulAgrawal
04 Dec 2019 06:54 Jump!
helpful in finding where the data exist, useful for analysis
by: RahulAgrawalRahulAgrawal
09 Aug 2019 08:51
1  
helpin cleaning up large files from report repository if required
by: RahulAgrawalRahulAgrawal
28 Mar 2019 04:26
1  
this help in getting how process type are shared across the process scheduler servers
by: RahulAgrawalRahulAgrawal
28 Mar 2019 04:22
1  
Replace FSUSER with ownername e.g sysadm
by: RahulAgrawalRahulAgrawal
28 Mar 2019 04:20
1  
Database Driver Error. (30,11) when running a PeopleSoft Query.
by: PrajPraj
02 Dec 2008 01:15
2 by CherrysourCherrysour
23 Mar 2018 04:57 Jump!
by: PrajPraj
19 Nov 2014 05:32
2 by jcmayjcmay
17 Apr 2015 17:39 Jump!
Some Nice to have SQL Scripts
by: RahulAgrawalRahulAgrawal
03 Apr 2015 06:41
1  
by: PrajPraj
30 Mar 2015 01:41
1  
by: PrajPraj
26 Mar 2015 11:04
1  
by: PrajPraj
16 Feb 2015 08:16
1  
by: PrajPraj
22 Jan 2015 06:38
1  
by: PrajPraj
22 Nov 2014 12:22
1  
by: PrajPraj
01 Nov 2014 05:30
1  
page 1 of 8123...78next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License