Blogs | Hexaware

Blogs


Latest Post
I was composing this post when there was a comment from "Spamboy" for my previous post where he provided the SQL to identify the portal navigation. Thanks for your comments!! In this post I will share the SQL I use when I want to determine the portal navigation. Here it is ... SELECT LPAD('--',2*(LEVEL-1)) || PORTAL_LABEL "NAVIGATION" FROM (SELECT PORTAL_LABEL, PORTAL_PRNTOBJNAME, PORTAL_OBJNAME, PORTAL_URI_SEG2 FROM PSPRSMDEFN A WHERE PORTAL_NAME = 'EMPLOYEE' ) B WHERE B.PORTAL_PRNTOBJNAME != ' ' START WITH (B.PORTAL_URI_SEG2 IN (SELECT D.PNLGRPNAME FROM PSMENUITEM A, PSMENUDEFN B, PS_PRCSDEFNPNL C, PSPNLGROUP D WHERE A.MENUNAME=B.MENUNAME AND A.PNLGRPNAME = C.PNLGRPNAME AND A.PNLGRPNAME…
Posted by Nitin Pai
Comments (0)
August 23rd, 2007
While working on my previous projects, I had some difficulties identifying the menu navigation for a process or report in PeopleSoft. So I developed this SQL that will help determine the navigation. select distinct b.menugroup||' > ' ||b.menulabel|| ' > '||barlabel||' > '||a.itemlabel||' > ' ||d.pnlgrpname||' - '||prcstype||' - '||prcsname“Navigation” from psmenuitem a, psmenudefn b, ps_prcsdefnpnl c, pspnlgroup d where a.menuname=b.menuname and a.pnlgrpname = c.pnlgrpname and a.pnlgrpname = d.pnlgrpname and prcsname like upper('&prcsname') group by b.menuname, b.menugroup, b.menulabel, barlabel, a.itemlabel, d.pnlgrpname, prcstype, prcsname / Navigation ---------------------------------------------------------------------------- Mana&ge Assets > &Interface Asset Information > &Process > &Transaction Loader > RUN_AMIF1000 -…
Posted by Nitin Pai
Comments (4)
August 21st, 2007
As an Oracle DBA administering a PeopleSoft database, we would like to ensure that all PeopleSoft queries (PRIVATE or PUBLIC) are optimized. There is always a possibility of introducing a HINT to tune the SQL generated by PeopleSoft in Query Manager. Here are the steps to add the HINT. 1. Create a new expression 2. Click“Add Field” and select the first field that is used in the query 3. Add your HINT before the field name in the expression 4. Click Ok 5. Select the Expression as a field in the query and move it as the first column 6.…
Posted by Nitin Pai
Comments (1)
August 17th, 2007
Last week, I had been to a get-together wherein my friends had arranged for a meeting. People from different technology backgrounds were amongst the young energetic crowd. I remember discussing about some of the technical aspects in the present corporate world. One of the discussion was about archiving data : There was a wide misconception that performing database backups were referred to as data archival,... Infact that's only one of the true factors. Moving on to the reasons behind archival is not only the need for a backup but for improving the performance. As a first step people tend to…
Posted by Pon ArunKumar Ramalingam
Comments (0)
August 17th, 2007
Business Intelligence practitioners tend to have lot of respect and reverence for transaction processing systems (OLTP), for without them the world of analytical apps simply does not exist. That explains my previous blog in introducing the first enabler for BI Utopia – The Evolution of OLTP systems to support Operational BI. In this post, I introduce the second enabler in the “Power of Ten” – Real Time Data Integration Data Integration in the BI sense, is all about, extracting data from multiple source systems, transforming them using business rules and loading it back into data repositories built to facilitate analysis,…
Posted by Karthikeyan Sankaran
Comments (2)
August 16th, 2007
Continuing from my previous post, here are the steps to load the upg.sqc data relevant for our manipulation into the Oracle database. 1. Create record HX_COMP_TBL in App Designer as shown below. 2. Build/create the table 3. Add it to Query Security if you need to access it using PeopleSoft Query Manager. 4. Create upg_sqc.txt file 5. Create SQL*Loader control file as shown below. load data infile '/export/home/npai/psprojectitem/upg_sqc.txt' into table PS_HX_CMP_TBL fields terminated by " " optionally enclosed by '"' (OBJ_DESCR2, OBJNAME, VAL1) 6. Execute sqlldr command to load the file sqlldr sysadm/sysadm@ftest control=sqlld.ctl 7. Use it in query through…
Posted by Nitin Pai
Comments (0)
August 13th, 2007
As a DBA, I do not always trust Application Designer when it comes to following tasks. Merging projects – typical example is migration of 2 or more bundles using a merged project. Quickly changing the update flags based on KEEP/DROP decisions on a huge project Any other manipulations Interpreting data in PSPROJECTITEM can help you get one step closer to sailing through some of the above mentioned problems. The following columns provided me with significant information to understand the data in PSPROJECTITEM table. Column Name PROJECTNAME OBJECTTYPE OBJECTVALUE1 OBJECTVALUE2 OBJECTVALUE3 OBJECTVALUE4 SOURCESTATUS TARGETSTATUS UPGRADEACTION TAKEACTION COPYDONE The translation for OBJECTTYPE,…
Posted by Nitin Pai
Comments (0)
August 9th, 2007
Couple of weeks back, the google news portal was crawling in almost many a news source pages about Kronos and its upperhand than that of the renowned Peoplesoft's Time and Labour Module. I was surprised to see the once market leader in Human Resources is being overthrown by the Kronos Workforce Central Suite. Yes, the reason being ,.. Kronos had worked hardly in identifying the end user's concerns and various other problems that they were facing with Peoplesoft. For example : The Time and Labour module contains a feature in which the employee work hours are being tracked and fed…
Posted by Pon ArunKumar Ramalingam
Comments (0)
August 9th, 2007
In the world of Formula One Racing, 'Pit Stop' is a common term. During the race day and pit stops, One could see almost all the components of the car being maintained/changed by the crew . Ranging from the nuts and bolts to the engine, everything is under quick and fast maintenance. Similarily, in the corporate world - each and every company acts as a race car and to improve their performance and to grow quicker: they are in need of such Pit Stop Crew. In the real-time, it would contain a variety of software products that supports their Company…
Posted by Pon ArunKumar Ramalingam
Comments (0)
August 9th, 2007
There are many approaches to monitor the PeopleSoft process scheduler. One of the options that come to mind is to have a script running on the OS hosting the process scheduler to monitor the OS process. But having process schedulers running on multiple OS (PSUNX and PSNT) will need development of scripts running on both servers. My preferred method is to use the below SQL to monitor all the process schedulers running on the database. SELECT A.SERVERNAME, B.XLATSHORTNAME,B.FIELDNAME,B.FIELDVALUE,TO_CHAR(B.EFFDT,'YYYY-MM-DD') FROM PSSERVERSTAT A, PSXLATITEM B WHERE B.EFFDT = (SELECT MAX(B_ED.EFFDT) FROM PSXLATITEM B_ED WHERE B.FIELDNAME = B_ED.FIELDNAME AND B.FIELDVALUE = B_ED.FIELDVALUE AND…
Posted by Nitin Pai
Comments (14)
August 2nd, 2007
Contact Us