Hints, Tips & Gotchas
Snippets of information that may help you out.
Thread name | Started | Posts | Recent post |
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 | |
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 |