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!!!!

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!!

True User Centered Design Process

Follow

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!!!!!

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!!!