With PeopleSoft

Sunday, January 24, 2010

Restore Deleted User profile : PS

while installing peoplesoft i issued a command by mistake..

Drop user PS cascade;

its deleted all the chain records..

to restore PS user again,

for eg SYSADM/SYSADM

run the script @/script/nt/dbowner.sql;

login to datamover as SYSADM/SYSADM run the following script

INSERT INTO PS.PSDBOWNER VALUES('HRDEMO', 'SYSADM');
UPDATE PSSTATUS SET OWNERID = 'SYSADM';
UPDATE PSOPRDEFN SET SYMBOLICID = 'SYSADM1', OPERPSWD = OPRID, ENCRYPTED = 0;
UPDATE PSACCESSPRFL SET ACCESSID = 'SYSADM', SYMBOLICID = 'SYSADM1', ACCESSPSWD = 'SYSADM', VERSION = 0, ENCRYPTED = 0;

ENCRYPT_PASSWORD *;

TON!!!!

Tuesday, January 12, 2010

Oracle SQL Developer 2.1

To Download, Follow

http://www.oracle.com/technology/software/products/sql/index.html

New Feaures in 2.1, Follow

http://www.oracle.com/technology/products/database/sql_developer/files/newfeaturelist21.htm

T on!!

Sunday, January 10, 2010

True User Centered Design Process

T on!!

PeopleTools 8.40 to 8.49 Cumulative Features

Follow the link to find the changes in PeopleTools 8.40 to 8.49.

http://www.oracle.com/applications/peoplesoft/tools_tech/ent/ptools/peopletools-840-849-cumulative-feature-overview.pdf

T on!!!!!

Sunday, January 3, 2010

Copying bin folder will not work peopletools 8.50 in Client side

pTo work peopletools on client side before 8.49 we used to copy bin folder and will configure the environment.

But in PeopleTools 8.50 if you copy bin folder, Peopletools will not work. it will give error as
"Environment is not configured".

So, in PeopleTools we need to run first the ps_home

/setup/vrcdist/vcredist_x86.exe

.
(This exe contains Visual C++ runtime files)

Follow:-

http://forums.oracle.com

T On!!!

Thursday, December 31, 2009

Wish you a Happy New Year !!!

Wish Your NEW YEAR is bright with joy and good cheer tool. ^-^