Adding New Object OwnerId

The following steps is required to add new object ownerid.


Step1: open the field OBJECTOWNERID.
Step2: Add new translate value.
Step3: save the field.

PIA Navigation for a Component

The following query is used to get the PIA Navigation for a component:

SELECT DISTINCT Rtrim (Reverse (Sys_connect_by_path (Reverse (portal_label),

                                ' > ')), ' > ')

                "PIA NAVIGATION"

FROM   psprsmdefn

WHERE  portal_name = 'EMPLOYEE'

       AND portal_prntobjname = 'PORTAL_ROOT_OBJECT'

START WITH portal_uri_seg2 = 'COMPONENT_NAME'

CONNECT BY PRIOR portal_prntobjname = portal_objname; 

Important MetaSQL of SQL- Action in AE

%ProcessInstance    - To get the PROCESS_INSTANCE
%OperatorId           - To get the Operator Id i.e UserId
%RUNCONTROL - To get the RuncontrolId

Applying Patch to NT Server

The following steps describes how to apply patch in NT server using VM Ware:

1. Open the vmware and select the server.
2. Download patch.
3. Stop Process Scheduler.
   <>/appserver/psadmin.exe
4. Install patch.
5. Restart  the server.
6. Start the Process Scheduler.
   <>/appserver/psadmin.exe

Change Homepage Logo

Open the following defination and changed them.
1. NEW_PS_LOGO (Image Type) - To change the logo.
2. PORTAL_UNI_HEADER_NS4X (Html Type) - Change logo name on mouse over.
3. PORTAL_UNI_HEARDER_NNS (Html Type)
4. PT_BRANDING (Application Package Type) - Deals to manipulate homepage and portal look.

Note: Dont change image name in PT_BRANDING application package. Have a backup of original Image type as NEW_PS_LOGO1 and update NEW_PS_LOGO with your image.

PeopleSoft OBJECTTYPE

PeopleSoft OBJECTTYPE:

0	Record	PSRECDEFN
1	Indexes	PSKEYDEFN
2	Fields	PSDBFIELD
3	Field Formats	PSFMTDEFN
4	Translates	PSXLATITEM
5	Pages	PSPNLDEFN
6	Menus	PSMENUDEFN
7	Components	PSPNLGRPDEFN
8	Record PeopleCode	PSPCMPROG
9	Menu PeopleCode	PSPCMPROG
10	Queries	PSQRYDEFN
11	Tree Structures	PSTREESTRCT
12	Trees	PSTREEDEFN
13	Access Groups	PS_ACCESS_GRP_TBL
14	Colours	PSCOLORDEFN
15	Styles	PSSTYLEDEFN
17	Business Processes	PSBUSPROCDEFN
18	Activities	PSACTIVITYDEFN
19	Roles	PSROLEDEFN
20	Process Definitions	PRCSDEFN
21	Server Definitions	PS_SERVERDEFN
22	Process Type Definitions	PS_PRCSTYPEDEFN
23	Job Definitions	PS_PRCSJOBDEFN
24	Recurrence Definitions	PS_PRCSRECUR
25	Message Catalog Entries	PSMSGCATDEFN
26	Dimension Definition	PS_DIMENSION
27	Cube Definition	TO_Find
28	Cube Instance Definition	TO_Find
29	Business Interlink	PSIODEFN
30	SQL	PSSQLDESCR
31	File Layout Definitions	PSFLDDEFN
32	Component Interfaces	PSBCDEFN
33	Application Engine Programs	PSAEAPPLDEFN
34	Application Engine Sections	PSAESECTDEFN
35	Message Nodes	PSMSGNODEDEFN
36	Message Channels	PSMSGCATDEFN
37	Message Definitions	PSMSGDEFN
38	Approval Rule Set	APPR_RULE_HDR
39	Message PeopleCode	PSPCMPROG
40	Subscription PeopleCode	PSPCMPROG
42	Comp. Interface PeopleCode	PSPCMPROG
43	Application Engine PeopleCode	PSPCMPROG
44	Page PeopleCode	PSPCMPROG
46	Component PeopleCode	PSPCMPROG
47	Component Record PeopleCode	PSPCMPROG
48	Component Rec Fld PeopleCode	PSPCMPROG
49	Images	PSCONTDEFN
52	File References	PSFILEREDEFN
53	Permission Lists	PSCLASSDEFN
54	Portal Registry Definitions	TO_Find
55	Portal Registry Structures	PSPRSMDEFN
56	URL Definitions	PSURLDEFN
57	Application Packages	PSPACKAGEDEFN
58	Application Package PeopleCode	PSPCMPROG
60	Analytic Types	TO_Find
62	XSLT	TO_Find
64	Mobile Pages	PSMPDEFN
68	File References	PSFILEREDEFN
69	File Type Codes	PSTYPECODEDEFN
72	Dignostic Plug Ins	TO_Find
73	Analytic Models	TO_Find
79	Service	PSSERVICE
80	Service Operation	PSOPERATION
81	Service Operation Handler	PSOPRHDLR
82	Service Operation Version	PSOPRVERDFN
83	Service Operation Routing	SIBRTNGDEFN
84	IB Queues	SIBQUEUEINST
85	XLMP Template Definition
86	XLMP Report Definition
87	XMLP File Definition
88	XMPL Data Source Definition