Primary Permission List Defaults

From TekiWiki

Jump to: navigation, search

This whole wiki has now moved to http://www.springboardsolutions.com/wiki

Go to this page Primary Permission List Defaults

(Created page with "Primary Permission List Defaults (previously known as Operator Defaults) are essential to PeopleSoft HRMS. Your operator (user) has (or should have) a Primary Permission List set...")
Line 4: Line 4:
o Hire and Job Component Interfaces fail to save
o Hire and Job Component Interfaces fail to save
 +
o Employee Self Service users cannot add a new address (the address page does not appear)
o Employee Self Service users cannot add a new address (the address page does not appear)
 +
The solution is to:
The solution is to:
Line 18: Line 20:
To find all the Primary Permission Lists missing, use the following SQL:
To find all the Primary Permission Lists missing, use the following SQL:
-
select distinct OPRCLASS  
+
<nowiki>select distinct OPRCLASS  
from PSOPRDEFN o
from PSOPRDEFN o
where
where
Line 26: Line 28:
where  
where  
d.OPRCLASS=o.OPRCLASS
d.OPRCLASS=o.OPRCLASS
-
)
+
)</nowiki>
-
 
+
To find operators missing a Primary Permission List:
To find operators missing a Primary Permission List:
-
select OPRID  
+
<nowiki>select OPRID  
from PSOPRDEFN o
from PSOPRDEFN o
where
where
-
o.OPRCLASS is not null
+
o.OPRCLASS is not null</nowiki>

Revision as of 23:06, 17 November 2010

Personal tools