Delete User - Referenced by Requisition Action


(system) #1
Check Material Management>Purchase Management>Setup>Requisition Actions. One of the actions most likely has the user referenced as an authorized user. Remove them from the Selected Users list and you should be able to delete the user (if that's the only reference). Other areas that may stop you from deleting a user are buyers, workforce, and person/contact. Once all references are deleted, users can be deleted.

Sue


---In vantage@yahoogroups.com, <cchang@...> wrote :

#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {font-family:Wingdings;panose-1:5 0 0 0 0 0 0 0 0 0;} #ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} #ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {font-family:Verdana;panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808MsoNormal, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808MsoNormal, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;font-family:"Times New Roman", "serif";} #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 a:link, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808MsoHyperlink { color:blue;text-decoration:underline;} #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 a:visited, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808MsoHyperlinkFollowed { color:purple;text-decoration:underline;} #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p {

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 code
{
font-family:“Courier New”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 pre
{

margin:0in;margin-bottom:.0001pt;font-size:10.0pt;font-family:“Courier New”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 tt
{
font-family:“Courier New”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808cat
{}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808ct
{}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808attach, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808attach, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808attach
{

margin-right:0in;margin-left:0in;font-size:9.0pt;font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808bold, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808bold, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808bold
{

margin-right:0in;margin-left:0in;font-size:10.0pt;font-family:“Arial”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808green, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808green, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808green
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;color:#628C2A;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808replbq, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808replbq, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808replbq
{
margin:3.0pt;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808ad, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808ad, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808ad
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808underline, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808underline, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808underline
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808yshortcuts
{}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808ad1, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808ad1, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808ad1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808ad2, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808ad2, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808ad2
{

margin-right:0in;margin-bottom:7.5pt;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 p.ygrps-yiv-1890900122ygrps-yiv-2023662808underline1, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 li.ygrps-yiv-1890900122ygrps-yiv-2023662808underline1, #ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808underline1
{

margin-right:0in;margin-left:0in;font-size:12.0pt;font-family:“Times New Roman”, “serif”;text-decoration:underline;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808yshortcuts1
{
font-family:“Verdana”, “sans-serif”;font-weight:bold;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808yshortcuts2
{
font-family:“Verdana”, “sans-serif”;font-weight:normal;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 span.ygrps-yiv-1890900122ygrps-yiv-2023662808EmailStyle36
{
font-family:“Calibri”, “sans-serif”;color:#1F497D;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 .ygrps-yiv-1890900122ygrps-yiv-2023662808MsoChpDefault
{
font-size:10.0pt;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 div.ygrps-yiv-1890900122ygrps-yiv-2023662808WordSection1
{}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808
filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {
}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Symbol;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:“Courier New”;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 filtered #ygrps-yiv-1890900122ygrps-yiv-2023662808 {

font-family:Wingdings;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 ol
{margin-bottom:0in;}
#ygrps-yiv-1890900122 #ygrps-yiv-1890900122ygrps-yiv-2023662808 ul
{margin-bottom:0in;}

We are trying to delete a User Account but an error indicates that we cannot delete it because it is ‘Referenced by at least one Requisition Action.’  Where do we look to complete or delete this Requisition Action?


(system) #2
<!-- #ygrps-yiv-72392834 _filtered #ygrps-yiv-72392834 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-72392834 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-72392834 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-72392834 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} _filtered #ygrps-yiv-72392834 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} #ygrps-yiv-72392834 #ygrps-yiv-72392834 p.ygrps-yiv-72392834MsoNormal, #ygrps-yiv-72392834 li.ygrps-yiv-72392834MsoNormal, #ygrps-yiv-72392834 div.ygrps-yiv-72392834MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-72392834 a:link, #ygrps-yiv-72392834 span.ygrps-yiv-72392834MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-72392834 a:visited, #ygrps-yiv-72392834 span.ygrps-yiv-72392834MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-72392834 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 code
{
font-family:“Courier New”;}
#ygrps-yiv-72392834 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-72392834 tt
{
font-family:“Courier New”;}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834cat
{}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834ct
{}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834attach, #ygrps-yiv-72392834 li.ygrps-yiv-72392834attach, #ygrps-yiv-72392834 div.ygrps-yiv-72392834attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834bold, #ygrps-yiv-72392834 li.ygrps-yiv-72392834bold, #ygrps-yiv-72392834 div.ygrps-yiv-72392834bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834green, #ygrps-yiv-72392834 li.ygrps-yiv-72392834green, #ygrps-yiv-72392834 div.ygrps-yiv-72392834green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834replbq, #ygrps-yiv-72392834 li.ygrps-yiv-72392834replbq, #ygrps-yiv-72392834 div.ygrps-yiv-72392834replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834ad, #ygrps-yiv-72392834 li.ygrps-yiv-72392834ad, #ygrps-yiv-72392834 div.ygrps-yiv-72392834ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834underline, #ygrps-yiv-72392834 li.ygrps-yiv-72392834underline, #ygrps-yiv-72392834 div.ygrps-yiv-72392834underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834yshortcuts
{}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834ad1, #ygrps-yiv-72392834 li.ygrps-yiv-72392834ad1, #ygrps-yiv-72392834 div.ygrps-yiv-72392834ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834ad2, #ygrps-yiv-72392834 li.ygrps-yiv-72392834ad2, #ygrps-yiv-72392834 div.ygrps-yiv-72392834ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-72392834 p.ygrps-yiv-72392834underline1, #ygrps-yiv-72392834 li.ygrps-yiv-72392834underline1, #ygrps-yiv-72392834 div.ygrps-yiv-72392834underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-72392834 span.ygrps-yiv-72392834EmailStyle36
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-72392834 .ygrps-yiv-72392834MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-72392834 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-72392834 div.ygrps-yiv-72392834WordSection1
{}
#ygrps-yiv-72392834
_filtered #ygrps-yiv-72392834 {
}
_filtered #ygrps-yiv-72392834 {

font-family:Symbol;}
_filtered #ygrps-yiv-72392834 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
_filtered #ygrps-yiv-72392834 {

font-family:Wingdings;}
#ygrps-yiv-72392834 ol
{margin-bottom:0in;}
#ygrps-yiv-72392834 ul
{margin-bottom:0in;}
–>

We are trying to delete a User Account but an error indicates that we cannot delete it because it is ‘Referenced by at least one Requisition Action.’ Where do we look to complete or delete this Requisition Action?


(system) #3
From my experience it seems if you do anything with a user it is not possible to delete.

(system) #4
If you want to check against the database directly where the User ID has been used, you can use this stored procedure. I was in the same position looking for a user that was in our workforce as a salesperson that we've never heard of, and couldn't remove because it was referenced somewhere. Someone provided this to me, and it works a dream =).

Create the stored procedure and then use it by entering EXEC [dbo].[SearchAllTables] 'UserID'

Cheers!
USE [E10]

go

SET ansi_nulls ON

go

SET quoted_identifier ON

go

CREATE PROC [dbo].[Searchalltables] (@SearchStr NVARCHAR(100))
AS
BEGIN
CREATE TABLE #results
(
columnname NVARCHAR(370),
columnvalue NVARCHAR(3630)
)

  SET nocount ON

  DECLARE @TableName  NVARCHAR(256),
          @ColumnName NVARCHAR(128),
          @SearchStr2 NVARCHAR(110)

  SET @TableName = &#39;&#39;
  SET @SearchStr2 = Quotename(&#39;%&#39; + @SearchStr + &#39;%&#39;, &#39;&#39;&#39;&#39;)

  WHILE @TableName IS NOT NULL
    BEGIN
        SET @ColumnName = &#39;&#39;
        SET @TableName = (SELECT Min(Quotename(table_schema) + &#39;.&#39;
                                     + Quotename(table_name))
                          FROM   information_schema.tables
                          WHERE  table_type = &#39;BASE TABLE&#39;
                                 AND Quotename(table_schema) + &#39;.&#39;
                                     + Quotename(table_name) &gt; @TableName
                                 AND Objectproperty(Object_id(Quotename(
                                                              table_schema
                                                              ) +
                                                              &#39;.&#39;
                                                              + Quotename(
                                                              table_name
                                                              )),
                                     &#39;IsMSShipped&#39;) =
                                     0)

        WHILE ( @TableName IS NOT NULL )
              AND ( @ColumnName IS NOT NULL )
          BEGIN
              SET @ColumnName = (SELECT Min(Quotename(column_name))
                                 FROM   information_schema.columns
                                 WHERE  table_schema = Parsename(@TableName,
                                                       2
                                                       )
                                        AND table_name =
                                            Parsename(@TableName,
                                            1)
                                        AND data_type IN ( &#39;char&#39;, &#39;varchar&#39;
                                                           ,
                                                           &#39;nchar&#39;,
                                                           &#39;nvarchar&#39; )
                                        AND Quotename(column_name) &gt;
                                            @ColumnName)

              IF @ColumnName IS NOT NULL
                BEGIN
                    INSERT INTO #results
                    EXEC ( &#39;SELECT &#39;&#39;&#39; + @TableName + &#39;.&#39; + @ColumnName +
                    &#39;&#39;&#39;, LEFT(&#39; +
                    @ColumnName
                    + &#39;, 3630)

FROM ' + @TableName + ' (NOLOCK) ' + ' WHERE ' +
@ColumnName
+
' LIKE '
+
@SearchStr2 )
END
END
END

  SELECT columnname,
         columnvalue
  FROM   #results

END