Hints, Tips & Gotchas
Snippets of information that may help you out.
| Thread name | Started | Posts | Recent post |
|
Find the sql triggered by peoplesoft process associated with Process instance, useful in debugging and trouble shooting,
|
by: 30 Jan 2023 03:10 |
1 | |
|
performance analysis for peoplesoft given process for last 360 days
|
by: 27 Jan 2023 09:43 |
1 | |
|
Compare reports of peoplesoft output to tables for quicker analysis , useful during large compare e.g patch application or upgrade
|
by: 11 Jan 2023 06:22 |
1 | |
|
Sql to psprojecitem with upgrade status flag
|
by: 26 Jul 2022 02:53 |
1 | |
|
Identify sql executing for peoplesoft batch process good for performance tuning
|
by: 07 Jul 2022 09:01 |
1 | |
|
SQL To List Project Items in PeopleSoft
|
by: 13 Jun 2022 08:12 |
1 | |
|
Useful for support guys who run the batch and be ready for potential issues
|
by: 26 Aug 2020 06:52 |
1 | |
|
Simple liner regression analysis for how long next process+runcontrol will run based on past trend in peoplesoft
https://en.wikipedia.org/wiki/Linear_regression#Machine_learning
https://docs.oracle.com/cd/B19306_01/server.102/b14200/functions132.htm
https://stackoverflow.com/questions/55134697/forecasting-time-series-data-in-oracle-sql
|
by: 07 Aug 2020 08:30 |
1 | |
|
Execute the below sql in oracle and then again output should be executed in oracle to get the customizations
|
by: 02 Jun 2020 02:18 |
1 | |
|
Peoplesoft question and answers for self learning. May be helpful in interview preparation as well.
|
by: 25 May 2020 17:04 |
1 | |
|
statistical model to identify problem process in your peoplesoft system, the model is developed to give recent run more weight over old run.
|
by: 20 May 2020 17:40 |
1 | |
|
Quickly cloning setid when we want to rollout new implementation without modifying existing set id
Some issues around when record control is a view.
|
by: 19 May 2020 15:31 |
1 | |
|
Decoding the table set control, when you move to some kind of support , cloning from golden template.
|
by: 19 May 2020 14:50 |
1 | |
|
in peoplesoft historically analyze why jobs are failing by taking log of error message from process scheduler.
|
by: 19 May 2020 01:09 |
1 | |
|
• Functional complexity based on number of setid it uses for business unit..
• People code complexity based on character size.
• SQL code complexity based on character size.
• Query complexity based on number of where clause.
• TBD
o Batch Process
o External objects like SQR etc
|
by: 18 May 2020 16:33 |
1 | |
|
Print AE flow , SQLs, and record objects with various level of nesting
|
by: 08 May 2020 13:17 |
1 | |
|
|
by: 12 Mar 2020 06:23 |
1 | |
|
Peoplesoft schedule item query
|
by: 02 Mar 2020 10:09 |
1 | |
|
Peoplesoft setup task sequence for given module in example below i have taken for accounts payable.
|
by: 02 Mar 2020 09:15 |
1 | |
|
oracle stats update in a SQR useful in performance tuning
|
by: 27 Feb 2020 01:03 |
1 |