Primary Permission List Defaults - Revision history

WikiSysop at 21:12, 27 May 2015

2015-05-27T21:12:01Z

← Older revision		Revision as of 21:12, 27 May 2015
Line 1:		Line 1:
-	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. Each Permission List used as a Primary Permission List should have a set of HR defaults set.	+	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. Each Permission List used as a Primary Permission List should have a set of HR defaults set.

	If these are defaults are not set, you may see the following effects:		If these are defaults are not set, you may see the following effects:

WikiSysop at 17:12, 23 July 2014

2014-07-23T17:12:31Z

← Older revision		Revision as of 17:12, 23 July 2014
Line 16:		Line 16:
	2: Add the defaults here:		2: Add the defaults here:

-	Set Up HRMS > Foundation Tables > Org Defaults by Permission List	+	Set Up HRMS > Foundation Tables > Organisation > Org Defaults by Permission List

	To find all the Primary Permission Lists missing, use the following SQL:		To find all the Primary Permission Lists missing, use the following SQL:

WikiSysop at 23:10, 17 November 2010

2010-11-17T23:10:40Z

← Older revision		Revision as of 23:10, 17 November 2010
Line 2:		Line 2:

	If these are defaults are not set, you may see the following effects:		If these are defaults are not set, you may see the following effects:
-		+	<ul>
-	o Hire and Job Component Interfaces fail to save	+	<li>Hire and Job Component Interfaces fail to save
-		+	</li>
-	o Employee Self Service users cannot add a new address (the address page does not appear)	+	<li>Employee Self Service users cannot add a new address (the address page does not appear)
-		+	</li></ul>

	The solution is to:		The solution is to:

WikiSysop at 23:09, 17 November 2010

2010-11-17T23:09:29Z

← Older revision		Revision as of 23:09, 17 November 2010
Line 20:		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:

-	<~~code~~>select distinct OPRCLASS	+	<pre>select distinct OPRCLASS
	from PSOPRDEFN o		from PSOPRDEFN o
	where		where
Line 28:		Line 28:
	where		where
	d.OPRCLASS=o.OPRCLASS		d.OPRCLASS=o.OPRCLASS
-	)</~~code~~>	+	)</pre>
	To find operators missing a Primary Permission List:		To find operators missing a Primary Permission List:

Line 34:		Line 34:
	from PSOPRDEFN o		from PSOPRDEFN o
	where		where
-	o.OPRCLASS is ~~not~~ null</pre>	+	o.OPRCLASS is null</pre>

WikiSysop at 23:07, 17 November 2010

2010-11-17T23:07:55Z

← Older revision		Revision as of 23:07, 17 November 2010
Line 31:		Line 31:
	To find operators missing a Primary Permission List:		To find operators missing a Primary Permission List:

-	<~~nowiki~~>select OPRID	+	<pre>select OPRID
	from PSOPRDEFN o		from PSOPRDEFN o
	where		where
-	o.OPRCLASS is not null</~~nowiki~~>	+	o.OPRCLASS is not null</pre>

WikiSysop at 23:07, 17 November 2010

2010-11-17T23:07:27Z

← Older revision		Revision as of 23:07, 17 November 2010
Line 20:		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:

-	<~~nowiki~~>select distinct OPRCLASS	+	<code>select distinct OPRCLASS
	from PSOPRDEFN o		from PSOPRDEFN o
	where		where
Line 28:		Line 28:
	where		where
	d.OPRCLASS=o.OPRCLASS		d.OPRCLASS=o.OPRCLASS
-	)</~~nowiki~~>	+	)</code>
	To find operators missing a Primary Permission List:		To find operators missing a Primary Permission List:

WikiSysop at 23:06, 17 November 2010

2010-11-17T23:06:50Z

← Older revision		Revision as of 23:06, 17 November 2010
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>

WikiSysop: 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..."

2010-11-17T23:05:07Z

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..."

New page

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. Each Permission List used as a Primary Permission List should have a set of HR defaults set.

If these are defaults are not set, you may see the following effects:

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)

The solution is to:

1: Discover the Primary Permission List of the operator:

PeopleTools > Security > Operators

2: Add the defaults here:

Set Up HRMS > Foundation Tables > Org Defaults by Permission List

To find all the Primary Permission Lists missing, use the following SQL:

select distinct OPRCLASS
from PSOPRDEFN o
where
o.OPRCLASS not in (
select d.OPRCLASS
from PS_OPR_DEF_TBL_HR d
where
d.OPRCLASS=o.OPRCLASS
)

To find operators missing a Primary Permission List:

select OPRID
from PSOPRDEFN o
where
o.OPRCLASS is not null