Hints, Tips & Gotchas

Forum » Forum / Hints, Tips & Gotchas
Number of threads: 137
Number of posts: 163
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
Thread name Started Posts Recent post
Component to peoplesoft field description. useful in analyzing records on field.
by: RahulAgrawalRahulAgrawal
24 Apr 2013 10:50
1  
good for data migration
by: RahulAgrawalRahulAgrawal
04 Apr 2013 12:31
1  
by: PrajPraj
19 Nov 2012 23:22
1  
search string on peoplecode
by: RahulAgrawalRahulAgrawal
25 Sep 2012 12:41
1  
by: darko_djdarko_dj
09 Nov 2008 02:41
2 by BryOnRyeBryOnRye
13 Sep 2012 12:54 Jump!
This query is faster than previous posted by me. Its helpful in undestand a component . E.g fields, process, and query associated.
by: RahulAgrawalRahulAgrawal
09 Aug 2012 07:33
1  
find out objects modified after certain date. Please not that it assumes that obhects are included as part of some project.
by: RahulAgrawalRahulAgrawal
14 May 2012 08:02
3 by RahulAgrawalRahulAgrawal
03 Aug 2012 09:29 Jump!
by: darko_djdarko_dj
09 Nov 2008 05:34
3 by PrajPraj
26 Jul 2012 20:31 Jump!
Searching on long edit field in oracle 10 for peoplesoft Below example is using a cursor.
by: RahulAgrawalRahulAgrawal
01 May 2012 05:18
1  
by: PrajPraj
19 Apr 2012 08:13
1  
Mapping of records used in AE to record navigation. It does not iclude peoplecode statement or Sections called by it. I have to work on it to include it in next version.
by: RahulAgrawalRahulAgrawal
26 Mar 2012 07:02
1  
Identifying the tables and pages for given module which have data, so we can find out what is actually used in peoplesoft instance
by: RahulAgrawalRahulAgrawal
26 Mar 2012 06:49
1  
Find out records used in App Engine SQL's
by: RahulAgrawalRahulAgrawal
16 Mar 2012 08:10
1  
Extending verity search for Peoplesoft. Verity search work on portal registry. I have made simple query based on field labels. PORTAL_URLTEXT will be the value to be replaced in browser toolbar for navigation. It helps to quicky idenitfy functional setups
by: RahulAgrawalRahulAgrawal
27 Feb 2012 14:03
2 by RahulAgrawalRahulAgrawal
16 Mar 2012 07:23 Jump!
Is there a quick way to input invoices
by: PeoplesofterPeoplesofter
06 Feb 2012 16:48
1  
by: PrajPraj
31 Jan 2012 21:28
1  
by: PrajPraj
23 Jan 2012 10:05
1  
Denormalize peoplesoft navigation and page(including subpages) and records behind it. The advantage is we can quickly refer to pages behind the records. Take a dump in text file and search by keywords. If you know a record find navigation for it quickly.
by: RahulAgrawalRahulAgrawal
15 Sep 2011 07:39
4 by RahulAgrawalRahulAgrawal
23 Nov 2011 07:51 Jump!
oftehn where we take over existing peoplesoft project . We want to understand how much scope of the implemenation. one of the way is to use row count in different tables
by: RahulAgrawalRahulAgrawal
17 Oct 2011 05:01
2 by RahulAgrawalRahulAgrawal
18 Nov 2011 02:36 Jump!
Some usefil sql for peoplesoft although not created by me. I just collected them toegther RenameQueries.sql " " RenameQueries.sql " " SetQryVersion.sql " " ShowActiveSQL.sql " " ShowActiveSQLG.sql " " ShowAppEngine.sql " " ShowComponentNavigation.sql " " ShowComponentRecords.sql " " ShowDB.sql " " ShowDBLocks.sql " " ShowDBLocksG.sql " " ShowDBWaits.sql " " ShowMaint.sql " " ShowPageRecords.sql " " ShowPRCS.sql " " ShowProcessNavigation.sql " " ShowProject.sql " " ShowQueryLog.sql " " ShowRecordComponents.sql " "
by: RahulAgrawalRahulAgrawal
17 Nov 2011 05:51
1  
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License