There will be scenarios when you forget to unlock a locked object in the Application Designer, which can create unwanted confusions within the team.
The ultra simple SQL below will help to identify and resolve that issue part. The query gives the details about the locked objects in the application designer by a User ID.
SELECT * FROM PSCHGCTLLOCK WHERE OPRID='USERID'
The object type value can be referenced to the table below.
| Object Type ID | PeopleSoft Object |
| 0 | Record |
| 1 | Index |
| 2 | Field |
| 3 | Field Format |
| 4 | Translate Value |
| 5 | Panel/Page |
| 6 | Menu |
| 7 | Panel Group/Component |
| 8 | Record PeopleCode |
| 9 | Menu Item |
| 10 | Query |
| 12 | Tree |
| 13 | Access Group |
| 14 | Color |
| 15 | Style |
| 16 | Not Used |
| 17 | Business Process Definition |
| 18 | Workflow Activity |
| 19 | Security Role |
| 20 | Process Definition |
| 21 | Process Scheduler Server Definition |
| 22 | Process Type |
| 23 | Job |
| 24 | Job schedule |
| 25 | Message Catalog Definition |
| 26 | Dimension |
| 27 | Cube Definition |
| 28 | Cube Instance Definition |
| 29 | Business Interlink |
| 30 | SQL Definition |
| 31 | File Layout Definition |
| 32 | Component Interface |
| 33 | Application Engine Program |
| 34 | Application Engine Sections |
| 35 | IB Message Node |
| 36 | Message Channel/Queue |
| 37 | IB Message |
| 38 | Approval Rule Set |
| 39 | Unknown: Relates to IB |
| 40 | Subscription PeopleCode |
| 41 | Unknown |
| 42 | Component Interface Method |
| 43 | Application Engine PeopleCode |
| 44 | Page PeopleCode |
| 45 | Page Field PeopleCode |
| 46 | Component PeopleCode |
| 47 | Component Record PeopleCode |
| 48 | Component Record Field PeopleCode |
| 49 | Image |
| 50 | Portal Style Sheet |
| 51 | HTML |
| 52 | Not User |
| 53 | Permission List |
| 54 | Portal Definition |
| 55 | Portal Registry Definition |
| 56 | URL Definitions |
| 57 | Application Package |
| 58 | Application Package Peoplecode |
| 59 | ortal Registry User Homepage |
| 60 | Problem Type |
| 61 | Archive Templates |
| 62 | XLST |
| 63 | Portal Registry User Favorite |
| 64 | Mobile Page |
| 65 | Relationships |
| 66 | Component Interface Property Peoplecode |
| 67 | Optimization Models |
| 68 | File References |
| 69 | File Type Codes |
| 70 | Archive Object Definitions |
| 71 | Archive Templates (Type 2) |
| 72 | Diagnostic Plug In |
| 73 | Analytic Model |
| 79 | Service |
| 80 | Service Operation |
| 81 | Service Operation Handler |
| 82 | Service Operation Versions |
| 83 | Service Operation Routing |
| 85 | XMLP Template Definition |
| 86 | XMLP Report Definition |
| 87 | XMLP File Definition |
| 88 | XMLP Data Source Definition |
| 89 | WSDL |
| 90 | Message Version |
| 255 | Project |
No comments:
Post a Comment