Blogs | Hexaware

Blogs


Latest Post
In my development environment, I had a request to create 30 new OPRID’s cloning an existing developer id template. I was not interested in logging into PeopleSoft, navigating to PeopleTools > Security > User Profiles > Copy User Profiles, and creating the clone 30 times. Hmm… So here is what I did. 1.Create a dummy table create table hx_clone_ids (oprid varchar2(30)); 2.Insert all desired OPRID values. For example, INSERT INTO HX_CLONE_IDS SELECT 'HX_NPAI_'||ROWNUM FROM PSOPRDEFN WHERE ROWNUM < 31; 3.Execute below SQL’s (OPRID to be cloned is NPAI). INSERT INTO PSOPRALIAS SELECT HX.OPRID, OPRALIASTYPE, OPRALIASVALUE, SETID, EMPLID, CUST_ID, VENDOR_ID, APPLID,…
Posted by Nitin Pai
Comments (4)
October 1st, 2007
In this series, I will cover some of the Oracle features that can be easily implemented to optimize our PeopleSoft environment. Resumable Space In todayworld, we will hardly find a database that is not monitored for space usage. But there is still a possibility for our process failing because it ran out of space in the UNDO tablespace or user defined tablespace or the DBA was too late to allocate the required space. Majority of PeopleSoft processes have restart capability. However, there might be instances where you just cannot afford to let the process fail and restart from the last…
Posted by Nitin Pai
Comments (0)
September 25th, 2007
Most of the leading products like Informatica, DataStage support all the three ways of lookup process in their product architecture. The following table lists ‘when to use’ and ‘when not to use’ the particular type of lookup process. Lookup When To Use When Not To Use Direct Query (Uncached lookup in Informatica) When the lookup process is to be invoked only once or a very few times The ETL server and the database are co-located or well connected Reading in large volume of source records and executing lookup queries for every incoming record can be costly in terms network load,…
Posted by Muneeswara C Pandian
Comments (0)
September 18th, 2007
Ever had problems connecting to your server hosting the NT process scheduler or App Server using Remote Desktop and not being able to use“psadmin” to perform administrative tasks? Here is what happens when you connect to the server using remote desktop and invoke psadmin. You will receive the above message when you try to check the status of process scheduler. So, how do you determine if you NT process scheduler is running? There are multiple ways to determine if your process scheduler is running. 1.Look at the task manager 2.Look at the log files 3.Check status using psadmin In this…
Posted by Nitin Pai
Comments (4)
September 17th, 2007
Sometime back, I had this question from my team mentioning – How do we determine when and who had customized this particular Record PeopleCode? The compare report showed that the PeopleCode was customized but there were no comments (bad practice!) in the code to show who touched it last. In Application Designer the properties button is grayed out when you open the peoplecode. Also, the properties at the record level will not answer this question. Here is the SQL you can use to determine who last updated the code and when. SELECT A.OBJECTVALUE1 RECORD, A.OBJECTVALUE2 FIELD, A.OBJECTVALUE3 EVENT, TO_CHAR(A.LASTUPDDTTM,'YYYY-MM-DD- HH24.MI.SS."000000"'),…
Posted by Nitin Pai
Comments (0)
September 11th, 2007
The “Power of Ten” introduced earlier in this forum is a list of pre-requisites to deliver the real promise of BI. We have already seen the first two – Changes to OLTP systems and Real time Data Integration. The third enabler in the list is ‘Data Governance’. With increasing volumes of data coupled with regulatory compliance issues, the topic of Data Governance is very much in vogue, to the extent that anybody can look intelligent (beware!) by coining new terms like Data Clarity, Data Clairvoyance etc. Data Governance at a very fundamental level is all about understanding the data generated…
Posted by Karthikeyan Sankaran
Comments (0)
September 10th, 2007
I have had change control call me several times in the past to restore a table because it was accidentally dropped when executing the SQL script generated using Application Designer. Whenever you use Application Designer to generate a script with "Alter by Table Rename" option checked, the script will have the following SQL's -- Start the Transaction -- Create temporary table -- Copy from source to temp table -- CAUTION: Drop Original Table -- Rename Table -- Done The risk of running this script As-Is is that if any of the above SQL encounters an error then the script will…
Posted by Nitin Pai
Comments (4)
September 6th, 2007
It was Lewis Hamilton - the young player in the formula one championship who managed a tough fought win against other players in the recently held Hungarian F1 Grand Prix. Looking back into his performance, there are a lot of features that had made him to win the race. Similarily, young players in the corporate world are growing at a pace of 200% when compared to their counterparts. There are a lot of influential aspects for a company's growth, one being their talent of maintaining the talent pool and the other by nurturing their talent pool. Yes,...It is achieved by…
Posted by Pon ArunKumar Ramalingam
Comments (0)
September 5th, 2007
Sometime back, I was approached with a request from a developer who had created a new record in Application Designer but was not able to view this record in Query Manager. So in this post, I will demonstrate the steps required to view a new or existing record in Query Manager. Below steps are from Tools version 8.47.02. New record HX_TEST has been created and we would like to use it in our PS Query. Navigate to PeopleTools > Security > Query Security > Query Access Manager Search for the Tree which should have access to this record. Click on…
Posted by Nitin Pai
Comments (1)
September 3rd, 2007
One of the basic ETL steps that we would use in most of the ETL jobs during development is ‘Lookup’. We shall discuss further on what lookup is? when to use? how it works ? and some points to be considered while using a lookup process. What is lookup process? During the process of reading records from a source system and loading into a target table if we query another table or file (called ‘lookup table’ or ‘lookup file’) for retrieving additional data then its called a ‘lookup process’. The ‘lookup table or file’ can reside on the target or…
Posted by Muneeswara C Pandian
Comments (0)
August 29th, 2007
Contact Us