Instant Peoplesoft Cloning Refresher Kit

Here are the instant refresher steps for performing a peoplesoft clone.

• The target system – the system to which the Peoplesoft Instance to be cloned.
• The source system – the system from which the Peoplsoft Instance is cloned.
• Oracle Application 9i with the patch at version 7 is installed in the target system.
• Application and Web Server is also installed in the target system
• The Database structure files from PSHOME from the source system is copied to the target system’s separate drive.
• Update the domain names and coordinates in the TNS Listener files
• Configure the application and web server domain names

Points to Ponder

• Before initializing the activity, the very first step would be to shutdown the source database using
  • Set Oracle_SID = Domain Name, and
  • Connect Sys as Sysdba shutdown immediate
• Shutdown the Application Server in the Source system
• Shutdown the Web Server in the Source system
• Access the Oracle\Oradata\Domainname and copy the *.dat files to the target system
• Make sure all the control files, data files and redo log files are in place in the destination system
• Execute the ‘alter database backup control file to trace’ in the source system
• Make sure that the file is created under Udump folder as a result of the above script
• Make the necessary changes in the file and save it as *.sql
• Copy the parameter file names initdomainname.ora under oracle\ora92\database and edit the coordinates and parameters in order to reflect the target system’s features
• Startup Nomount; and execute the script generated from the source system
• Update PSDBOWNER Set DBNAME =”New Domain Name”
• Use NET Configuration Assistant wizard to configure the listener with the parameters for TNS, Host Name, IP Address, System Name(Target System) and perform a test
• Using the configuration assistant, test for the access of Peoplesoft Application Designer , Data Mover with the same user access credentials of the Source system database
• Configure the Web Server by providing the domain name, Peoplesoft web site name and startPIA.exe; Make sure that the environment variables are also set for JavaHome.

Workforce Modelling and Intelligence

Login to the url http://helix.hexaware.com/Innovation/ and navigate to the menu HRIT>SOD>Thursday forums to view the presentation as well as the video of Princeton Softec’s Optim and Human Concepts Workforce Modelling and Intelligence tool – Orgplus.

To know More About: Enterprise Solution

Peoplesoft Time and Labor Vs Kronos Workforce Timekeeper Part II

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 may need to make an adjustment to payable time that has already been paid by Payroll. This type of adjustment is called a Record Only Adjustment and is made using the Adjust Paid Time page. When you make an adjustment of this type, it is for record keeping purposes only. The time you add / adjust is not processed by Time and Labor nor is the time sent to payroll.

Using the Adjust Paid Time page, one can add / delete time, or change existing payable time that has already been processed by the payroll system and has a payable status of Distributed. All the time reporting fields appear on the Adjust Paid Time page for editing. You can change any field except the Payable Status, and TRC Type fields. After you make adjustments using this page, the system does not process the time further. It does not run it through Time Administration or send the time to payroll. Time and Labor does publish the payable time to your Project Costing application.

For further details please refer the People soft People books.

Please Visit to learn about: Kronos Workforce

Application Service Provider Vs Software As A Service (ASP Vs SAAS)

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 in their inhouse is not necessary.
Eventhough there is a cost reduction for customers who go for software as a service model, the rise of open source components that are available in the market makes this tough. And moreover for customers who require a lot of customizations, the ASP model is still leading the chart.
Whatever the changes are,.. It seems that in the near future the world leaders in software industry will be the ones who are operating based on the demands,..based on the software as a service model.

Learn More Visit: Pitstop

Rise of Data Transformation Services – DTS Packages

Interoperability and communication between applications plays a vital role in today’s emerging business needs.One such component which helps the business to transfer data between different system is the Data Transformation Service Packages famously known as DTS packages.This pasage will cover the differences between SQL Server 2000 and SQL Server 2005 with respect to the DTS Packages.Enterprise Manager of the Microsoft SQL Server 2000 provides an inbuilt menu within its IDE and the dts packages are accessed using the SQL Server 2000 DTS Designer IDE.

The DTS Designer 2000 allows us to perform the following tasks over a package such as 1. Designing 2. Executing and 3.Scheduling.

In SQL Server 2005, the DTS packages cannot be accessed the same way as we use to access it in SQL Server 2000. The reason being the advent of Microsoft SQL Server Integeration Services (SSIS) in the 2005 version. The two main IDE of the SQL Server 2005 are

• SQL Server Management Studio, and
• SQL Server Business Intelligence Development Studio.

Unlike the DTS Designer 2000 that was used to access the DTS Packages, the SQL Server Business Intelligence Development Studio supports the packages with its SSIS. Microsoft also provides a backward compatibility method of accessing the DTS Packages that were created in SQL Server 2000. Even after the migration of the database from SQL Server 2000 to SQL Server 2005, the DTS Packages which were originally created in the SQL Server 2000 environment can also be migrated to the 2005 Server. Since the DTS Packages are Server specific, by 1. opening the SQL Server 2000 Enterprise Manager and by 2. accessing the SQL Server Management Studio, the DTS Packages can be opened by DTS Designer 2000 through the SQL Server 2005 environment.

Read More about  Data Transformation Services(DTS)

Learning Management System drives a Company’s Growth

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 Training, Knowledge Sharing, Mentoring, and Self-Learning by their employees. One of the aspects that drives these activities is the Learning Management System that the company uses. It’s the LMS (acronym for Learning Management System) that drives the growth of an organisation.

Lets have a look at the Docent Enterprise Suite which was rated as the leader in the Learning Management System by Gartner a couple of years ago. The suite comprises of Learning Management System – LMS, Content Delivery System – CDS, Authoring Tool – Docent Outliner,..to take care of the learning activity as well as the performance evaluation of a particular or group of people within an organisation.

Friends, I have just given a gist about the Docent – Learning Managment System. Leave me your queries as a comment to continue further discussion about the system