capital-it.blogspot.com
Notes from PeopleSoft: November 2013
http://capital-it.blogspot.com/2013_11_01_archive.html
SQL to Group or Chunk Date Time Fields by n Minutes. Posted by Michael Nitschke. On Tuesday, 26 November 2013. Say you want to chunk some statistics data into 10 minute intervals. as of Oracle 11g you can use the extract(). Function that will pull out hours, minutes and the like from a DateTime column. Note the 0.1 bit that handles the range of results, up to that point spanning from 0 to 6. We can't have nn. 60 as a vaild DateTime. This is also why we have the -10 part. A breakdown of the entire line:.
rajaguru-paramasamy.blogspot.com
PeopleSoft Administrator - Rajaguru: December 2008
http://rajaguru-paramasamy.blogspot.com/2008_12_01_archive.html
PeopleSoft Administrator - Rajaguru. Saturday, December 13, 2008. 1 http:/ www.peoplesoftadministrator.net/. Wednesday, December 10, 2008. 1 http:/ asktom.oracle.com/pls/asktom/f? 2 http:/ www.erpassociates.com/peoplesoft-corner-wiki/peoplesoft-administration/change-assistant.html. 3 http:/ www.oracle.com/technology/pub/articles/saternos scripting.html. 4 http:/ laurentschneider.com/. 5 http:/ download-west.oracle.com/docs/cd/B19306 01/rac.102/b14197/toc.htm. 6 http:/ edelivery.oracle.com/.
harshachowdaryworld.blogspot.com
PeopleSoft World: June 2009
http://harshachowdaryworld.blogspot.com/2009_06_01_archive.html
Please do post your comments and suggestions for me to improve on chowdary1105@gmail.com. Monday, June 29, 2009. To overwrite search record on component by using peoplecode. Provide the search keys values in searchinit event. Make sure, in the component properties,"Force Search processing" is switched off. Labels: To overwrite search record on component by using peoplecode. Code to print a image in SQR. Let $imgpath = $DB Server Path 'logo.jpeg'. Labels: Code to print a image in SQR. Reports – Simp...
capital-it.blogspot.com
Notes from PeopleSoft: Impact List for Projects
http://capital-it.blogspot.com/2008/02/impact-list-for-projects.html
Impact List for Projects. Posted by Michael Nitschke. On Thursday, 28 February 2008. 1 Copy the results. 2 Paste into Word then: Table/Convert/Text to Table. 3 You may need copy and paste formatting from other cells. Define projectName = 'GUFNGL018'. Type, ' '. AOBJECTVALUE1 decode(A.OBJECTVALUE2, ' '. AOBJECTVALUE2) decode(A.OBJECTVALUE3, ' '. AOBJECTVALUE3 decode(A.OBJECTVALUE4, ' '. Component Rec Fld Peoplecode'. Portal registry User Favourites'. PeopleSoft are being smart again with - '. Menu Path Po...
capital-it.blogspot.com
Notes from PeopleSoft: June 2013
http://capital-it.blogspot.com/2013_06_01_archive.html
Posted by Michael Nitschke. On Monday, 3 June 2013. Some useful tables when something somewhere has a table locked:. This blog is a scrap book of code snippets and tricks that I find interesting or reusable. One day I may find enough time to format it all in a more presentable manner but for now it serves as a useful, searchable reference point. Feel free to use whatever you find. Find a Component in the Portal. App Application Package PeopleCode syntax. App Engine Text Export. James Court Medina Canberra.
capital-it.blogspot.com
Notes from PeopleSoft: PeopleCode to get a Sibling RowSet
http://capital-it.blogspot.com/2014/04/peoplecode-to-get-sibling-rowset.html
PeopleCode to get a Sibling RowSet. Posted by Michael Nitschke. On Monday, 28 April 2014. For some reason this just took me far too long to figure out. Must be getting old. Writing down for reference. Let's say you have a page with a Record structure like this:. And you want some code/event on Sibling 1 to change the data in Sibling 2. Place the following in something like SIBLING 1.Field1.SaveEdit(). Local Rowset &rsSIBLING 2 = GetRowset().ParentRow.GetRowset(Scroll.SIBLING 2);. App Engine Text Export.
capital-it.blogspot.com
Notes from PeopleSoft: May 2014
http://capital-it.blogspot.com/2014_05_01_archive.html
Application Engine Log File. Posted by Michael Nitschke. On Wednesday, 7 May 2014. Handy little library to open Application Engine log files, based on whether running on client while developing, or on server. Import YOUR PACKAGE:Utilities:FuncLib:*; Component File &logFile; &cbTestingMode = (create YOUR PACKAGE:Utilities:FuncLib() .isTestingMode(YOUR STATE RECORD AET.PROCESS INSTANCE); &logFile = (create YOUR PACKAGE:Utilities:FuncLib() .GetFile(&cbTestingMode, "log.txt", "W");. App Engine Text Export.
capital-it.blogspot.com
Notes from PeopleSoft: April 2014
http://capital-it.blogspot.com/2014_04_01_archive.html
PeopleCode to get a Sibling RowSet. Posted by Michael Nitschke. On Monday, 28 April 2014. For some reason this just took me far too long to figure out. Must be getting old. Writing down for reference. Let's say you have a page with a Record structure like this:. And you want some code/event on Sibling 1 to change the data in Sibling 2. Place the following in something like SIBLING 1.Field1.SaveEdit(). Local Rowset &rsSIBLING 2 = GetRowset().ParentRow.GetRowset(Scroll.SIBLING 2);. This blog is a scrap boo...
capital-it.blogspot.com
Notes from PeopleSoft: December 2014
http://capital-it.blogspot.com/2014_12_01_archive.html
Component Field Find and Replace. Posted by Michael Nitschke. On Thursday, 4 December 2014. Sometimes you just want to find a field and replace its value no matter where it is in the Component. This blog is a scrap book of code snippets and tricks that I find interesting or reusable. One day I may find enough time to format it all in a more presentable manner but for now it serves as a useful, searchable reference point. Feel free to use whatever you find. Find a Component in the Portal. XML Publisher in...
SOCIAL ENGAGEMENT