Hints, Tips & Gotchas

Forum » Forum / Hints, Tips & Gotchas
Number of threads: 160
Number of posts: 189
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
Useful for support guys who run the batch and be ready for potential issues
by: RahulAgrawalRahulAgrawal
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: RahulAgrawalRahulAgrawal
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: RahulAgrawalRahulAgrawal
02 Jun 2020 02:18
1  
Peoplesoft question and answers for self learning. May be helpful in interview preparation as well.
by: RahulAgrawalRahulAgrawal
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: RahulAgrawalRahulAgrawal
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: RahulAgrawalRahulAgrawal
19 May 2020 15:31
1  
Decoding the table set control, when you move to some kind of support , cloning from golden template.
by: RahulAgrawalRahulAgrawal
19 May 2020 14:50
1  
in peoplesoft historically analyze why jobs are failing by taking log of error message from process scheduler.
by: RahulAgrawalRahulAgrawal
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: RahulAgrawalRahulAgrawal
18 May 2020 16:33
1  
Print AE flow , SQLs, and record objects with various level of nesting
by: RahulAgrawalRahulAgrawal
08 May 2020 13:17
1  
by: RahulAgrawalRahulAgrawal
12 Mar 2020 06:23
1  
Peoplesoft schedule item query
by: RahulAgrawalRahulAgrawal
02 Mar 2020 10:09
1  
Peoplesoft setup task sequence for given module in example below i have taken for accounts payable.
by: RahulAgrawalRahulAgrawal
02 Mar 2020 09:15
1  
oracle stats update in a SQR useful in performance tuning
by: RahulAgrawalRahulAgrawal
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: 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  
page 1 of 8123...78next »
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License