How to find the Navigation of the Peoplesoft Component and Process.

Sometimes it is very typical to find the navigation of the component or page though application designer. For each component in application designer we use the ‘Find Definition Reference ‘to find Menu and dig the portal registry.

There are some tables that are helpful to find the navigation

1. PSPRSMDEFN

2. PSMENUDEFN 

3. PSMENUITEM 

4. PSPNLGROUP

For process like Application Engine, SQR etc.

5.PS_PRCSDEFN

6.PS_PRCSDEFNPNL

I construct some SQL Queries with the help of Jim's PeopleSopft Journal and people books to find the peoplesoft online navigation when we know the name of the component.

Query 1

SELECT PRS.PORTAL_NAME,  --- PORTAL NAME

PRS.PORTAL_LABEL,        --- LABEL NAME

PRS.PORTAL_OBJNAME,      --- PORTAL OBJECT NAME

PRS.PORTAL_PRNTOBJNAME,  --- PAENT PORTAL OBJECT NAME

PRS.PORTAL_URI_SEG1,     --- MENU NAME

PRS.PORTAL_URI_SEG2,     --- COMPONENT

PRS.PORTAL_URI_SEG3      --- MARKET

FROM PSPRSMDEFN PRS WHERE PRS.PORTAL_URI_SEG2=’COMPONENT NAME’

In the above SQL query provide the name of the component in where clause to get the content referance of your component.

Query 2

Run the below SQL to find the navigation of  your component

Provide the componment name in where clause and run the query to get the navigation.

(SQL is created in respect of Micorsoft SQL server )

SELECT D.PORTAL_LABEL + ' > ' + C.PORTAL_LABEL +' > '

+B.PORTAL_LABEL + ' > '  +  A.PORTAL_LABEL  as  'Navigation'

FROM PSPRSMDEFN A

, PSPRSMDEFN B

, PSPRSMDEFN C

, PSPRSMDEFN D

WHERE

A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME

AND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAME

AND C.PORTAL_PRNTOBJNAME =D.PORTAL_OBJNAME

AND A.PORTAL_NAME = B.PORTAL_NAME

AND B.PORTAL_NAME =C.PORTAL_NAME

AND C.PORTAL_NAME =D.PORTAL_NAME

AND A.PORTAL_URI_SEG2=’COMPONENT NAME’

Query 3

If we know the process name like Application Engine, SQR and don’t know the Run Control page navigation to run the process.

In the below SQL provide the process name in where clause to get the navigation.

SELECT D.PORTAL_LABEL + ' > ' + C.PORTAL_LABEL +' > ' 

+B.PORTAL_LABEL + ' > '  +  A.PORTAL_LABEL  as  'Navigation'

FROM PSPRSMDEFN A

, PSPRSMDEFN B

, PSPRSMDEFN C

, PSPRSMDEFN D

WHERE

 A.PORTAL_PRNTOBJNAME = B.PORTAL_OBJNAME

AND B.PORTAL_PRNTOBJNAME = C.PORTAL_OBJNAME

AND C.PORTAL_PRNTOBJNAME =D.PORTAL_OBJNAME

AND A.PORTAL_NAME = B.PORTAL_NAME

AND B.PORTAL_NAME =C.PORTAL_NAME

AND C.PORTAL_NAME =D.PORTAL_NAME

AND A.PORTAL_URI_SEG2 in ( SELECT distinct

PNL.PNLGRPNAME

FROM PSMENUDEFN MENU,

PSMENUITEM ITEM,

PS_PRCSDEFNPNL PNL,

PS_PRCSDEFN PRCS

WHERE MENU.MENUNAME = ITEM.MENUNAME

AND ITEM.PNLGRPNAME = PNL.PNLGRPNAME

AND PNL.PRCSTYPE = PRCS.PRCSTYPE

AND PNL.PRCSNAME = PRCS.PRCSNAME AND PRCS.PRCSNAME ='PROCESS NAME')

Brief Introduction about PeopleSoft Architecture

What is PeopleSoft:-

Oracle PeopleSoft is the ERP product designed to provide the comprehensive business and industry solutions, accelerate the business performance and increase the business productivity.

Let discuss about technical part of PeopleSoft.

Brief introduction about People Tools

PeopleSoft People Tools provides a comprehensive development toolset that supports the development and runtime of PeopleSoft applications. By leveraging metadata and other efficiencies within the toolset, application developers build and customize the PeopleSoft applications quickly and easily.  

Brief Introduction about PeopleSoft Internet Architecture:-

PeopleSoft internet Architecture introduced in PeopleSoft 8 is completely focused on internet to provide the new functionality to access the PeopleSoft applications and their integration.

PeopleSoft Internet Architecture comprises the Client –Server centric concept that enables the secure access of PeopleSoft applications. End user can access the application from any internet enables device that uses the standard internet technologies like HTML, XML, HTTP, HTTPS etc.

Client – any computer that can access information “served” on the server. The client requests a service from the server.

Server – the central computer that stores files accessed by every person on the Network. The server provides the service requested by the client.

 High Level functionality and interaction between various internet architecture components as