Friday, August 12, 2011

How to Unlock PeopleTools Objects from Back End using SQL

Sometimes Application designer does not allow to Unlock or Lock the People Tools Objects such as Pages, Record Structures and Fields etc.

Execute following query to check the Lock of the Object:

SELECT * FROM PSCHGCTLLOCK WHERE OPRID='<OPRID>';

Excecute following querries to Unlock of the Object:

DELETE FROM PSCHGCTLLOCK WHERE OPRID='<OPRID>';
COMMIT;

1 comment: