Monday, February 2, 2015

script to see who has locked the workplan

You can run the following script .

select locked_by_person_id from pa_proj_elem_ver_structure ps,pa_projects_all ppa,fnd_user fu
where ps.lock_status_code='LOCKED'


If you know the project than you can run the following

select locked_by_person_id from pa_proj_elem_ver_structure ps,pa_projects_all ppa,fnd_user fu
where ps.lock_status_code='LOCKED' and  ppa.project_id = &enterprojectid;

Using the Project Super User responsibility Workplan tab | Maintain Versions there should be a icon of a lock on that page ('Change Control' icon). Please hit the lock icon.  This allows other users to access the workplan.

No comments: