Wednesday, November 24, 2010

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.

Friday, November 19, 2010

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; 

Wednesday, November 17, 2010

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

Friday, November 12, 2010

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

Tuesday, November 9, 2010

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:
0RecordPSRECDEFN
1IndexesPSKEYDEFN
2FieldsPSDBFIELD
3Field FormatsPSFMTDEFN
4TranslatesPSXLATITEM
5PagesPSPNLDEFN
6MenusPSMENUDEFN
7ComponentsPSPNLGRPDEFN
8Record PeopleCodePSPCMPROG
9Menu PeopleCodePSPCMPROG
10QueriesPSQRYDEFN
11Tree StructuresPSTREESTRCT
12TreesPSTREEDEFN
13Access GroupsPS_ACCESS_GRP_TBL
14ColoursPSCOLORDEFN
15StylesPSSTYLEDEFN
17Business ProcessesPSBUSPROCDEFN
18ActivitiesPSACTIVITYDEFN
19RolesPSROLEDEFN
20Process DefinitionsPRCSDEFN
21Server DefinitionsPS_SERVERDEFN
22Process Type DefinitionsPS_PRCSTYPEDEFN
23Job DefinitionsPS_PRCSJOBDEFN
24Recurrence DefinitionsPS_PRCSRECUR
25Message Catalog EntriesPSMSGCATDEFN
26Dimension DefinitionPS_DIMENSION
27Cube DefinitionTO_Find
28Cube Instance DefinitionTO_Find
29Business InterlinkPSIODEFN
30SQLPSSQLDESCR
31File Layout DefinitionsPSFLDDEFN
32Component InterfacesPSBCDEFN
33Application Engine ProgramsPSAEAPPLDEFN
34Application Engine SectionsPSAESECTDEFN
35Message NodesPSMSGNODEDEFN
36Message ChannelsPSMSGCATDEFN
37Message DefinitionsPSMSGDEFN
38Approval Rule SetAPPR_RULE_HDR
39Message PeopleCodePSPCMPROG
40Subscription PeopleCodePSPCMPROG
42Comp. Interface PeopleCodePSPCMPROG
43Application Engine PeopleCodePSPCMPROG
44Page PeopleCodePSPCMPROG
46Component PeopleCodePSPCMPROG
47Component Record PeopleCodePSPCMPROG
48Component Rec Fld PeopleCodePSPCMPROG
49ImagesPSCONTDEFN
52File ReferencesPSFILEREDEFN
53Permission ListsPSCLASSDEFN
54Portal Registry DefinitionsTO_Find
55Portal Registry StructuresPSPRSMDEFN
56URL DefinitionsPSURLDEFN
57Application PackagesPSPACKAGEDEFN
58Application Package PeopleCodePSPCMPROG
60Analytic TypesTO_Find
62XSLTTO_Find
64Mobile PagesPSMPDEFN
68File ReferencesPSFILEREDEFN
69File Type CodesPSTYPECODEDEFN
72Dignostic Plug InsTO_Find
73Analytic ModelsTO_Find
79ServicePSSERVICE
80Service OperationPSOPERATION
81Service Operation HandlerPSOPRHDLR
82Service Operation VersionPSOPRVERDFN
83Service Operation RoutingSIBRTNGDEFN
84IB QueuesSIBQUEUEINST
85XLMP Template Definition
86XLMP Report Definition
87XMLP File Definition
88XMPL Data Source Definition