WorkingScripts

Here is a link to an excellent presentation from Oracle of PeopleTools 8.50 features. PeopleSoft is really going Web 2.0!

peoplesoft_workspace_and_pt850.swf (application/x-shockwave-flash Object)

Also please see our previous post about Tools 8.50 overview

Continue reading

PeopleTools, Tips

There are a few people who mention different tools for Application Development in PeopleSoft. Over the past years I have tried many of the IDEs like TextPad, UltraEdit. For the past 6 months I have started extensively using Notepad++ and I absoltely love it. Unfortunately App Designer does not include a good syntax highlighting, Intellisense and other features that have been long implemented in other IDEs like Visual Studio, JBuilder, Eclipse. It seems that so far Notpad++ developers did a great job with developing enough options that the tool could be easily configured to support multiple languages, specifically SQR and PeopleCode. I have started by downloading initial syntax color scheme files from greysparling.com (they are always on the forefront of peoplesoft development). Then, I have played with options a little and voila – I finally have an IDE that makes it all easier – syntax highlighting, IntelliSense (I wish it could access AppDesigner API too). Below I would like to provide a 5 minute guide to configuring NOTEPAD++ for use:

1. Download Notepad++ from http://notepad-plus.sourceforge.net/
2. After install go to Settings and remove all languages that you are not using:

3. Download PeopleCode and SQR syntax and Intellisense files below

Paste Intellisense File below

into C:\Program Files\Notepad++\plugins\APIs\

and %appdata%\Notepad++\plugins

Download File – PeopleCode IntelliSense

Paste PeopleCode and SQR Syntax files attached below into %appdata%\Notepad++\

Download File – PeopleCode SQR Syntax Files

4. Configure Notpad++ to recognize sqr and peoplecode by following the instructions below:

Choose the desired language e.g. Peoplecode or SQR and change the color scheme to the way you like it. For PeopleCode I suggest specifying rem and / / as start and finish of the comment, because for some reason PeopleCode has more that 2 types of comments –

/+ your comment +/

/* your comment */

rem your comment

remark your comment

Enjoy – in my next post I will explain how Notepad++ can be effectively used for looking at PeopleCode Trace files.

Continue reading

peoplecode, PeopleSoft, SQR, utility

SELECT DISTINCT       ltrim (rtrim (a.classid))  AS classid, ltrim (rtrim (b.menuname))  AS       menuname, ltrim (rtrim (b.barname))  AS barname, ltrim          (rtrim (b.baritemname))  AS baritemname, ltrim(rtrim(d.pnlname))  AS       pnlname, ltrim (rtrim (d.itemlabel))  AS itemlabel, ltrim          (rtrim (e.itemlabel))  AS itemlabel, ltrim(rtrim(c.pageaccessdescr))         AS pageaccessdescr, b.displayonly, ltrim (rtrim (f.portal_label))  AS       portal_label, ltrim (rtrim (f.portal_objname))  AS portal_objname,       ltrim(rtrim(f.portal_uri_seg1))  AS portal_uri_seg1, ltrim (rtrim (f.portal_uri_seg2)       )  AS portal_uri_seg2, (SELECTCASE          WHEN ltrim(rtrim(descr)) = ''THEN             ltrim(rtrim(menulabel))ELSE             ltrim(rtrim(descr))ENDFROM psmenudefnWHERE menuname = b.menuname)       || ' > '       || ltrim(rtrim(f.portal_label))  AS pathFROM psroleclass a,       psauthitem b,       pspgeaccessdesc c,       pspnlgroup d,       psmenuitem e,       psprsmdefn f,       psprsmperm gWHERE a.classid = b.classidAND d.pnlgrpname = e.pnlgrpnameAND b.menuname = e.menunameAND b.barname = e.barnameAND b.baritemname = e.itemname--AND a.rolename LIKE 'GLIC_PO%'AND b.menuname NOT IN ('APPLICATION_DESIGNER',                              'CLIENTPROCESS',                              'DATA_MOVER ',                              'IMPORT_MANAGER ',                              'OBJECT_SECURITY ',                              'QUERY ',                              'PERFMONPPMI ')AND b.menuname NOT LIKE 'WEBLIB%'

AND B.PNLITEMNAME IN (SELECT DISTINCT PNLNAMEFROM PSFSSYS.PSPNLFIELDwhere RECNAME ='PYMNT_ADVICE')AND NOT EXISTS             (SELECT 'x'FROM psprsmsysattrvlWHERE portal_name = f.portal_nameAND portal_reftype = f.portal_reftypeAND portal_objname = f.portal_objnameAND portal_attr_nam = 'PORTAL_HIDE_FROM_NAV'AND f.portal_objname NOT IN ('CO_NAVIGATION_COLLECTIONS',                                                  'PORTAL_BASE_DATA'))AND b.authorizedactions = c.authorizedactionsAND f.portal_reftype = 'C'AND f.portal_cref_usgt = 'TARG'AND f.portal_name = g.portal_nameAND f.portal_reftype = g.portal_reftypeAND f.portal_objname = g.portal_objnameAND a.classid = g.portal_permnameAND b.classid = g.portal_permnameAND f.portal_name = 'EMPLOYEE'AND f.portal_uri_seg1 <> ' 'AND f.portal_uri_seg2 <> ' 'AND f.portal_uri_seg3 <> ' 'AND f.portal_uri_seg1 = b.menunameAND b.pnlitemname = d.itemname  WITH UR;

Continue reading

PeopleSoft, Portal, SQL

It seems that Oracle have caught on with the Virtual Documentation, not only lots of books are available in common formats, but they allow you to format your search results as a book as well. Now you can take just what you need and read it on your screen or printed and stapled. I guess they really want us to know know more about their products!

Here is a link to

Oracle Database Online Documentation 11g Release 1 (11.1)

And here PeopleBooks Link:

http://download.oracle.com/docs/cd/E12341_01/crm9pbr0_run2/eng/index.htm

Continue reading

Books, Oracle, PeopleSoft

If I had to choose a year for this program – this year would be it. Economy is doing so “great” that companies are saving on the electricity in halls, and not running all elevators in the buildings. Besides, I don’t think we’ll see a lot of people from Meryll, UBS and especially Lehman brothers.

Blogger Program Renewed for OpenWorld 2008 | The AppsLab

Continue reading

OpenWorld, Oracle

It seems that PeopleSoft is really becoming object oriented – now it has it’s own automated unit testing  tool, like JUnit – this one is called PSUnit. I hope this one is as good as it sounds. Check out the Wiki article below

Introducing PSUnit – Oracle Wiki

You can download the actual project file here:

http://blogs.oracle.com/peopletools/2009/03/psunit_unit_test_framework_for.html

Continue reading

PeopleTools. AppClass

Take a look at this great post by  Peter Slager about upcoming PeopleTools release

And here you can find the latest about PeopleTools 8.50 from Oracle – just an overview of things to come:

Release Value Propositions available

By matthew.haavisto on May 14, 2009 1:58 PM

Two new release value propositions are now available: one covers PeopleTools 8.50, another covers Enterprise Portal 9.1. Both documents provide an overview of the value proposition for the enhancements that are planned for PeopleTools 8.50 and Enterprise Portal 9,1. Both are intended to help you assess the business benefits of these products and to plan your information technology (IT) projects and investments.

PeopleTools RVP
Enterprise Portal RVP

And if you like pictures – then the older, but still valid presentation from last year’s OpenWorld would still do a goo job:

By jeff.robbins on September 24, 2008 5:26 AM

During Part 2 of the PeopleTools Roadmap presentation at OpenWorld, I promised to post the presentations and demo viewlets we used. The presentations are in PDF file and I’ll upload the viewlets later today.

Here is Part 1: Download file

Here is Part 2: Download file

Enjoy!

PeopleTools Roadmap Presentation at OpenWorld on Tuesday, Sep 23 (PeopleSoft Technology Blog)

Tags: PeopleTools, PeopleSoft

Continue reading

PeopleTools

As many PeopleSoft developers and managers I have suffered through my share of nVision Tuning efforts and until very recent we could not get our reports to run under 4 hours, until the recent change…
In any case here are a few points from my experience:
We experienced an almost almost 5 fold increase in performance when we did a PS_LEDGER reorg with PSCLEDGER index option as follows:

   1:  

   2: db2 "reorg table PSFSSYS.PS_LEDGER index PSFSSYS.PSCLEDGER allow read access indexscan"

   3: db2 "RUNSTATS ON TABLE PSFSSYS.PS_LEDGER FOR INDEX PSFSSYS.PSCLEDGER"

   4: db2 "reorgchk current statistics on table PSFSSYS.PS_LEDGER"

Also it is great to cleanup treeselectors, to make sure that static selectors did not get out of sync with trees, this can be done on a regular basis, see a sample script below. Please note that the number in the end of the treeselector name xx – corresponds to the chartfield length:

   1:  

   2: -- Delete TreeSelectors

   3: Delete from PSFSSYS.PSTREESELECT05;

   4: Delete from PSFSSYS.PSTREESELECT06;

   5: Delete from PSFSSYS.PSTREESELECT10;

   6:  

   7: -- Delete Tree Control table for the respective selectors above

   8: delete from PSFSSYS.pstreeselctl

   9: where length in (5,6,10);

For details about PeopleSoft nVision architecture and structure please make sure to read the Red Paper by clicking below

PeopleSoft nVision Red Paper

Tags: PeopleSoft nVisoin

Continue reading

nVisoin, PeopleSoft

After searching the Web, I have found that there is not enough documentation about IMAGE-SIZE of the PRINT-IMAGE command, or I have not done the search right ;-). Either way here it goes in plain English:
Excerpt from the Book:

   1: PRINT-IMAGE

   2: Syntax

   3: PRINT-IMAGE[image_name]position

   4: [TYPE={image_type_lit|_var|_col}]

   5: [IMAGE-SIZE=(width_num_lit|_var|_col,height_num_lit

   6: [SOURCE={file_name_txt_lit|_var|_col}]

IMAGE-SIZE – Specifies the width and height of the image. The width (width_num_lit) is specified in the font point-size that you have specified in the print command or ALTER-PRINTER. So putting:

alter-printer point-size=14 font=4

would affect your image size. Height (height_num_lit) – is specified in the line height. So changing

   1: DECLARE-LAYOUT

   2: [CHAR-WIDTH=char_width_num_lit[uom]]

   3: [LINE-HEIGHT=line_height_num_lit[uom]]

   4: END-DECLARE

   5: Would have an effect on the image width and height.

Enjoy!

Tags: PeopleSoft SQR

Continue reading

image, SQR