Peoplesoft HR/HCM Tables

List of Peoplesoft HCM Tables.

PS_EMPLOYEES, PS_JOB,PS_PERSONAL_DATA, PS_EMPLOYEES_LNG, PS_EMPLOYMENT, PS_EMPLOYMENT_LNG, PS_EMPLOYMENT_LNG1, PS_EMPLOYMENT_LNG2, PS_EMPLOYMENT_LNG3, PS_HS_EMPLOYMENT, PS_HS_EMPL_REL_CAN, PS_HS_EMPL_REL_LNG, PS_HS_EMPL_SUB_CAN, PS_HS_EMPL_SUB_LNG, PS_INJ_CLMADDR_CAN, PS_JOB, PS_PERSONL_DTA_LNG, PS_PERS_DATA_AET, PS_PERS_DATA_EFFDT, PS_PERS_DTAEFF_LNG, PS_PERS_NID, PS_JOB_EARNS_DIST, PS_JOB_APPROVALS, PS_BEN_PROG_PARTIC

Problem invoking WLST - java.lang.RuntimeException: Could not find the OffLine WLST class

When instlling Webserver on Tools 8.51 and Applicaion 9.1, the PIA  failed to configure by saying,

Problem invoking WLST - java.lang.RuntimeException: Could not find the OffLine WLST class 

I googled for the problem tried the all the solutions no luck!!.

Resolution:

The problem found while installing I dint Selected the Products
       Web 2.0 HTTP Pub Servers and Weblogic Server Clients.
So I reinstalled without uninstllaing existing weblogic by selecting only previously unselected options (as above mentioned).

Now webserver onfigruration installed properly..

-:)

Peopletools 8.51 on VM Ware

Today, a bit of struggle installed Peopletools 8.51 and HRCS 9.1 on VM Ware..

Configuration on VM ware:-
HardDisk: 50GB
RAM: 1GB (out of my 3GB)

Softwares
Windows XP SP3
Micrsoft SQL Server 2008
Weblogic 10.3.1
Tuxedo 10gR3PeopleTools 8.51 (3 Parts)
HRMS 9.1
Firefox 3.5x or IE7/8/9.


Overall the performance is good. the more performance I see after increasing my RAM 1GB to 1.5 GB.(2GB it is very good for to work)

Now the time to research...!!!!!!!!! :-)

PSAdmin: Failed to query Windows Registry for TUXDIR & NLSPATH

In PeopleTools 8.51
When I open appserver(psadmin.exe) to configure :
It Says:
ERROR: Failed to query Windows Registry for TUXDIR environment variable.
ERROR: Failed to query Windows Registry for NLSPATH environment variable.

To Resolve this, go to Regedit.exe

Create new registry keys(String) for TUXDIR & NLSPATH as shown below.

Peoplesoft Installation on VM Ware

Now a days lot of abuz going on  for virtualization of operating systems - like virtual machines, cloud computing.etc.

So I thought let me try the new technlogy of virtual maachine using VM Ware on my machine.
Started googling for VM Ware: found very interesting.

What is VM Ware (in Simple): Its virtualisation of software to create seperate OS in the existing OS(windows 7 or any other) by sharing the physical devices(ram,usb,hard disk..etc).

1. Downloaded the VM Ware 7.x (Evaluation version) it comes around apprx550MB.
2. Installed the VM Ware on windows 7.
3. In the VM ware I've created a new virtual machine. So creating the virtual machine(VM) means, blank hard disk with no operating system. The size of the Virtual machine set to 25GB.The VM shares the RAM size. Let say I've total 3GB of RAM and I've assinged 1.5 GB of RAM to virtual machine and 1.5 GB to Windows 7.

4. Started installing windows XP on the virtual machine. Installed successfully.
5.For testing purpose installed Peopletools 8.49 and HCM 9.0 with SQL Server 2005 db.

Out of 25 GB the whole installation took 21 GB space.

its got worked!!!!! able to have different versions of peoplesoft in single machine for better R&D .

The  best advantage I see is the backup is very portable & we can expand the size of VM whenever required and we can even compact the size of VM.


This experience gave me the boost to further research on VM ware with Oracle 11g..Next couple of days..

Let's see how it goes..

^-^

Oracle 11g - Pivot and UnPivot - Split rows into Multiple colums or vice versa

Transposing rows into columns (pivot) or columns into rows (unpivot) to generate results in crosstab format. Pivoting is a very useful technique, especially for reporting.



 I/P:

--------- Table1



Location    Month      Balances

------------------ -----------

A1               1                 100

A1               2                 200

A1               3                 300

A1               4                 400

A1               5                 500

A1               6                 600

A1               7                 800


 Output

----------------



Location         1           2           3          4        5        6        7

----------     ---        ----         ---       ---        ---     ----    -----
 A1             100       200         300      400     500      600     800



Sample Sql :
------------

 SELECT location,month,balances from table 1
  PIVOT (balances           -- pivot_clause
         FOR month         -- pivot_for_clause
         IN  (1,2,3,4,5,6,7)  -- pivot_in_clause
        );



 UNPIVOT:-
 --------

 Try it: same as pivot (instead of Pivot use Unpivot)

Oracle 11g-Listagg - Merge Rows into Single Columns

The LISTAGG analytic function was introduced in Oracle 11g Release 2, making it very easy to aggregate strings.

Sample Sql: 

select listagg(''''||NAME||'''',',') within group (order by NAME) from PS_PERSON 

I/P

---

Name

------

A

B

C

D

E

The Output as

-----------------

'A','B','C','D','E'


:-)

Oracle's First Customer to Deploy PeopleSoft Enterprise 9.1

Ricoh Electronics is Oracle's First Customer to Deploy PeopleSoft Enterprise 9.1

 Read More :  http://www.oracle.com/us/corporate/press/065271 

 :-)

Oracle : Delete & Update Queries Using Joins

The SQL's are consutructed using dummy table.. below are the just framework. 

Modify according to your  requirement

Delete Query :-

---------------------

Delete from table1 A
where exists (select * from  table2 B
WHERE A.EMPLID = B.EMPLID AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND
B.Col5 = 6556 AND B.Col_status = 'S')

Update Query:-

-------------

update table2 A set A.STATUS = 'V'
where exists (Select * from table1 B
WHERE A.EMPLID = B.EMPLID AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND
B.col5 = 6556 AND B.col_status = 'S')

Thanks

Srinivas