Hints, Tips & Gotchas
Snippets of information that may help you out.
| 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: 07 Feb 2010 00:29 |
2 |
by 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: 25 Feb 2020 08:51 |
2 |
by 25 Feb 2020 10:38 Jump! |
|
recurse and provide as many subpanels as possible, you can use the following (Oracle Syntax) SQL:
|
by: 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: 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: 05 Dec 2019 12:13 |
1 | |
|
|
by: 04 Dec 2019 09:47 |
1 | |
|
|
by: 20 Jun 2013 10:16 |
2 |
by 04 Dec 2019 06:54 Jump! |
|
helpful in finding where the data exist, useful for analysis
|
by: 09 Aug 2019 08:51 |
1 | |
|
helpin cleaning up large files from report repository if required
|
by: 28 Mar 2019 04:26 |
1 | |
|
this help in getting how process type are shared across the process scheduler servers
|
by: 28 Mar 2019 04:22 |
1 | |
|
Replace FSUSER with ownername e.g sysadm
|
by: 28 Mar 2019 04:20 |
1 | |
|
Database Driver Error. (30,11) when running a PeopleSoft Query.
|
by: 02 Dec 2008 01:15 |
2 |
by 23 Mar 2018 04:57 Jump! |
|
|
by: 19 Nov 2014 05:32 |
2 |
by 17 Apr 2015 17:39 Jump! |
|
Some Nice to have SQL Scripts
|
by: 03 Apr 2015 06:41 |
1 | |
|
|
by: 30 Mar 2015 01:41 |
1 | |
|
|
by: 26 Mar 2015 11:04 |
1 | |
|
|
by: 16 Feb 2015 08:16 |
1 | |
|
|
by: 22 Jan 2015 06:38 |
1 | |
|
|
by: 22 Nov 2014 12:22 |
1 | |
|
|
by: 01 Nov 2014 05:30 |
1 |
