Blogs | Hexaware

Blogs


Latest Post
Peoplesoft Time and Labor Vs Kronos Workforce TimeKeeper Kronos Workforce Timekeeper The process of making historical edits using Timekeeper 5.0 is much the same as it was in Timekeeper 3.4. Add Historical Amount (formerly "New Historical Amount" in TK v3.4) Required fields (note these in the screenshot below): Historical Date (formerly "Apply to Date" in TK v3.4) Pay Code Amount (hh:mm) Include in Totals for Effective Date (formerly "Add to selected timeframe" in TK v3.4) Selecting this option ensures the information is sent to payroll for processing and payment. Impact Accruals Peoplesoft Time and Labor: Adjustments to Payable Time We…
Posted by Pon ArunKumar Ramalingam
Comments (1)
November 22nd, 2007
In this series of posts on Business Intelligence Utopia, I have presented some thoughts around 5 key technology enablers that in my view will take BI to the next level. They are: 1. Proliferation of transactions systems that support the analytical feedback loop Real-time / Right-time 2.Data Integration 3.Data Governance 4.Service Oriented Architecture 5.Extensible Data Models All of these put together answer the question of “Where do you want to see BI in the future”? I have 5 more to go to complete the discussion on the “Power of Ten” key enablers. At this point, I felt that the question of…
Posted by Karthikeyan Sankaran
Comments (0)
November 19th, 2007
Here is the scenario… You do not have access to PeopleSoft Security Administration pages to reset the password. You want to log on to PeopleSoft using your id and you have forgotten your password or you want to log on as some other operator id (without being detected). Hmmm… This is possible “IF” (the BIG IF) You are the DBA You are not the DBA but your generous DBA has provided you SELECT and UPDATE access to PS tools tables Here is an example. 1.  I want to logon to F89XXXX but I do not remember my password. I sent…
Posted by Nitin Pai
Comments (0)
November 15th, 2007
As a DBA you might be receiving a lot of calls from users asking some of the questions listed below. - What their process is currently executing? - How long will it take? - Should I cancel my process? In this post, I will cover some steps that will help you quickly respond to the above questions. I have executed the below SQR Report in my environment and want to know what is happening. What their process is currently executing? 1.Use the below SQL to correctly identify the Oracle session SELECT CLIENT_INFO, PROGRAM, SID, SERIAL#, SQL_ADDRESS FROM V$SESSION WHERE CLIENT_INFO…
Posted by Nitin Pai
Comments (0)
November 5th, 2007
A few weeks back a developer posed a question“Can I use an Oracle Function in PS Query Manager?” Yes, you can and here are the steps. 1.Create your function in Oracle DB CREATE OR REPLACE FUNCTION TEMP_FUNC(VAR1 IN NUMBER) RETURN VARCHAR2 IS VAR2 VARCHAR2(48); BEGIN SELECT NVL(PROGRAM,'NULL') INTO VAR2 FROM V$SESSION WHERE AUDSID=USERENV('SESSIONID'); RETURN(VAR2); END; 2.Create a view in PeopleSoft CREATE VIEW PS_TEMP_VW AS SELECT TEMP_FUNC(10) VARIABLE_NAME FROM DUAL; 3.That’s it! Use your view in Query Manager as shown below.
Posted by Nitin Pai
Comments (0)
November 2nd, 2007
In Part II we discussed ‘when to use’ and ‘when not to use’ the particular type of lookup process, the Direct Query lookup, Join based lookup and the Cache file based lookup. Now we shall see what are the points to be considered for better performance of these ‘lookup’ types. In the case of Direct Query the following points are to be considered Index on the lookup condition columns Selecting only the required columns In the case of Join based lookup, the following points are to be considered Index on the columns that are used as part of Join conditions…
Posted by Muneeswara C Pandian
Comments (0)
November 2nd, 2007
Service Oriented Architecture or SOA as it is popularly known is a logical evolution of component based architecture and distributed computing, both of which were prevalent in the 1990s. Today SOA is on the threshold of maturing into a design technique that helps align business with IT initiatives and leverage this alignment to get various benefits. The travel industry, particularly airlines, has always been on the leading edge of adopting IT into core business. The likelihood of Travel Industry being an early adopter of SOA appears very high. What makes it imminent for the travel and hospitality industry to adopt…
Posted by Reji George
Comments (0)
October 30th, 2007
In this post I will share a tuning tip that I used to improve the performance of the PeopleSoft Upgrade data conversion AE. Data Conversion AE was truncating the temporary table è Inserting 35 million rows into temporary table from transaction table è Updating stats The above steps combined took around 6hrs to complete. It ran in 30mins after the below changes to AE. þ We dropped the index on temporary table þ INSERT was modified to use APPEND hint þ Recreated the index using NOLOGGING Summary:PeopleSoft does not necessarily ship optimal code. We have to keep our eyes open…
Posted by Nitin Pai
Comments (0)
October 26th, 2007
While building an Inbound/Outbound interface, most of the time we may be in dilemma whether to use Application Engine (AE) or SQR. Here are the tips to build an efficient interface using either AE or SQR. If we use Application Engine, below points are to be taken into account If the interface is INBOUND, its better to go for Application Engine If the program fails, we can make use of Restart Control to restart the program from the position where it abends PeopleSoft - Business Process related Validation will be taken care automatically when we go for AE/CI. Parallel Processing…
Posted by Kannappan Krishnan
Comments (0)
October 25th, 2007
The traditional Application Service Provider - ASP Model is overrun by the upcoming Software as a service SaaS Model. Whether it is a deployment, upgrade or maintenence project - the onshore offshore model present in leading indian software companies were growing with a lot of money inflow as a result of ASP model. But In the present scenario, the companies like salesforce, workday are providing the software on demand services with client specific customizations based on the SAAS model also. In SaaS the customer pays for the services offered by the company/vendor and the cost involved in maintaining the application…
Posted by Pon ArunKumar Ramalingam
Comments (2)
October 25th, 2007
Contact Us