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')
cheeseburger
ReplyDelete