Tuesday, July 23, 2013

Track the Locked Objects in Application Designer


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

0 comments:

Post a Comment

Total Pageviews

Copyright © Tech & Management Notes