Search the web
Sign In
New User? Sign Up
psusers · PeopleSoft Users
  • Members Only
  • Files
  • Photos
  • Links
  • Database
  • Polls
  • Groups Labs (Beta)
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Want your group to be featured on the Yahoo! Groups website? Add a group photo to Flickr.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

   Messages Help
Message #
Search:
Advanced
Messages 1 - 32 of 6037   Newest  |  < Newer  |  Older >  |  Oldest
Messages: Show Message Summaries   (Group by Topic) Sort by Date v  
#32 From: kelly.c.mcmullen@...
Date: Tue Feb 16, 1999 2:32 pm
Subject: Re: Custom PS tables and viewing in PS Query 		kelly.c.mcmullen@...
Send Email Send Email
  
I think that you need to add them to Query Security into the appropriate
query secruity group.

                                   n n n n



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#30 From: kelly.c.mcmullen@...
Date: Tue Feb 16, 1999 2:41 pm
Subject: Re: Custom PS tables and viewing in PS Query 		kelly.c.mcmullen@...
Send Email Send Email
  
If you add the table to the apporpriate access group within Tree Manager
and still don't see the item, make sure that the Query Security is set
correctly (see PeoplelTools - Utilities - Query Security - Query Profile).
The operator has to have access to the access group to which you add the
table.

                                   n n n n



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#29 From: kelly.c.mcmullen@...
Date: Tue Feb 16, 1999 2:11 pm
Subject: Re: Operator Security 		kelly.c.mcmullen@...
Send Email Send Email
  
Which version of the software are you working with?  The operator security
database structure has changed in version 7.0
(Embedded image moved to file: pic31555.pcx)
"Parijat Sahai" <parijatsahai@...>
02/12/99 09:12 PM GMT
Please respond to psusers@egroups.com

To:   psusers@egroups.com
cc:    (bcc: Kelly C. McMullen)
Subject:  [psusers] Re: Operator Security




Below is the list of all the Operator security setup tables I had
compiled some time back because we had to copy security from one
database to another every now and then. A SQL script would look at the
list of the tables and copy the contents of those tables from one
database to another.

You can write your own SQL scripts to perform security setup for all
operators in one shot for any/all objects of Peoplesoft. Of course, you
should remember to maintain referential integrity while doing that. If
you wish to know how and which of these tables are related, I can gladly
help you with that.

List of tables:
PSAUTHITEM
PSAUTHPRCS
PSAUTHSIGNON
PSBUSPROCSEC
PSHOMEPAGEOPR
PSHOMEPAGESEC
PSOPROBJ
PSOPRDEFN
PSPRCSPRFL
PSROLEUSER
PS_BUYER_TBL
PS_LED_AUTH_TBL
PS_MC_OPR_SECURITY
PS_MC_OPRID
PS_OPR_DEF_TBL_AM
PS_OPR_DEF_TBL_AP
PS_OPR_DEF_TBL_AR
PS_OPR_DEF_TBL_BD
PS_OPR_DEF_TBL_BI
PS_OPR_DEF_TBL_FS
PS_OPR_DEF_TBL_GL
PS_OPR_DEF_TBL_IN
PS_OPR_DEF_TBL_OLE
PS_OPR_DEF_TBL_OM
PS_OPR_DEF_TBL_OM2
PS_OPR_DEF_TBL_PC
PS_OPR_DEF_TBL_PM
PS_OPR_DEF_TBL_VND
PS_OPR_PO_RQSTR
PS_OPR_PO_BUYER
PS_PM_PROD_OPR
PS_PM_PROP_OPR
PS_PRCR_PRF_OPR
PS_REQUESTOR_TBL
PS_REQUESTOR_CAT
PS_ROLEXLATOPR
PS_RTE_CNTL_RUSER
PS_SCRTY_QUERY
PS_SCRTY_ACC_GRP
PS_SEC_AN_GRP_CLS
PS_SEC_AN_GRP_OPR
PS_SEC_BOOK_CLS
PS_SEC_BOOK_OPR
PS_SEC_BUBOOK_CLS
PS_SEC_BUBOOK_OPR
PS_SEC_BU_CLS
PS_SEC_BU_OPR
PS_SEC_LEDGER_CLS
PS_SEC_LEDGER_CLSW
PS_SEC_LEDGER_OPR
PS_SEC_LEDGER_OPRW
PS_SEC_PC_TREE_CLS
PS_SEC_PC_TREE_OPR
PS_SEC_PROJ_CLS
PS_SEC_PROJ_OPR
PS_SEC_PYCYCL_CLS
PS_SEC_PYCYCL_OPR
PS_SEC_SETID_CLS
PS_SEC_SETID_OPR
PS_SEC_VIEW_NAMES
PS_WF_MON_OPRID
SYSUSERS           (System Table)


>Reply-To: psusers@egroups.com
>Date: Fri, 12 Feb 1999 08:45:56 -0600
>From: "Kathy Mason" <kmason@...>
>To: psusers@egroups.com
>Subject: [psusers] Operator Security
>
>Hello!  I have a question for this group regarding Operator Security.
>Does anyone out there have a method for updating operator security
>across the board?  I have asked our consultants and they tell me that
>the only way to update operator security is on-line.  I was just
>wondering if anyone had set-up and SQR or SQL routine or some other
>method to update operator security in instances where all users should
>be given access to a particular item.  Any Help is appreciated.
>
>Kathy
>
>
>------------------------------------------------------------------------
>Fresh flowers are the perfect way to say "I love you".
>Shipped direct from the grower, Proflowers.com has
>arrangements from $29.95 plus S&H.
>Click here: http://offers.egroups.com/click/216/0
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>
>


______________________________________________________

------------------------------------------------------------------------
Fresh flowers are the perfect way to say "I love you".
Shipped direct from the grower, Proflowers.com has
arrangements from $29.95 plus S&H.
Click here: http://offers.egroups.com/click/216/0

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com





                                   n n n n


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (9)
#28 From: kelly.c.mcmullen@...
Date: Tue Feb 16, 1999 2:02 pm
Subject: Re: Operator Security 		kelly.c.mcmullen@...
Send Email Send Email
  
What version are you using?  If you are using version 7.0 or higher, you
should set up operator classes and assign all of your users to the
appropriate classes.  Then you modify the access rights to each class.  If
you need to add things 'across the board' you should have a class for all
users and just maintain that item.


                                   n n n n



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (9)
#27 From: *Sehat Rosny <SRosny@...>
Date: Tue Feb 16, 1999 1:46 pm
Subject: Performance 		SRosny@...
Send Email Send Email
  
Hello

I have tried to track people code execution time from level 1 scroll
bar to level 3 scroll bar.
method that I have tried using application Reviewer :
write global variable in people code (by assigning %datetime)
  and keep pressing F5, to see the output.
I am working with People Soft 5.12. Is any body has other method ?
The other method is to output to the file, and can see the list of
execution time.
(I have not tried this method yet).
Thanks in advance
Bye
Sehat Rosny


Sehat Rosny
PeopleSoft and SQR Developer
The Ohio State University
e-mail: rosny.1@...



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (2)
#26 From: "shibu joys" <shibujoys@...>
Date: Tue Feb 16, 1999 5:30 am
Subject: Re: Apply fixes 		shibujoys@...
Send Email Send Email
  
Each and every application fix comes along with instructions and pre-
requisites. It depends on whether its a SQR fix or application engine
fix or peoplcode or cobol fix or DMS. Each has a different way of
applying. You can go thru' them and make a customized one.


>Reply-To: psusers@egroups.com
>Date: Tue, 16 Feb 1999 08:08:56 +0100
>To: psusers@egroups.com
>Cc: fdario@...
>From: Francisco Darío Sánchez Díaz <fdario@...>
>Subject: [psusers] Apply fixes
>
>Hi,
>
>    I know there are a document which explain how do you apply fixes in
>PeopleSoft. I don´t find it in PeopleSoft' web. I need this document
>because I'm a PeopleSoft instructor and i like have it to give it the
>students. Anybody have it? Thanks.
>
>Francisco Darío Sánchez Díaz
>Infortec Consultores Informáticos
>
>http://www.infortec-consultores.com
>
>
>------------------------------------------------------------------------
>What's everyone looking at? Check out the Top40 most requested stocks!
>Plus quotes, charts, news, portfolios, mutual funds, and discussion.
>All free, fast, and easy.   Visit:    http://www.stockmaster.com/?a=f5
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>


______________________________________________________

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (2)
#25 From: "shibu joys" <shibujoys@...>
Date: Tue Feb 16, 1999 5:23 am
Subject: Re: Custom PS tables and viewing in PS Query 		shibujoys@...
Send Email Send Email
  
Hi,

The table that you have defined in the database, you have to define this
as a record in the application designer. Its always advisable to create
the record in application designer first and then create it in the
database. Then you have to use the tree manager to add this new record
to the access group that you want this record to be in.

Take Care,

Shibu


>Reply-To: psusers@egroups.com
>Date: Mon, 15 Feb 1999 18:09:11 -0500
>From: "Guy Simonian" <SIMOGUY@...>
>To: psusers@egroups.com
>Subject: [psusers] Custom PS tables and viewing in PS Query
>
>Have got custom tables that were added to PeopleSoft.  Can see the
tables =
>from the Application Developer and from Oralce SQL/Plus.
>
>What do I need to do so that my Operator class can see the new table in
PS =
>Query?
>
>Guy
>PS FInancials, PeopleTools 7.51, Oracle 7.3.4
>
>
>
>
>
>------------------------------------------------------------------------
>Tired of waiting for your stock quotes and charts to load?
>StockMaster is super-fast for quotes, charts, news, and portfolios.
>Markets don't wait, why should you?  http://www.stockmaster.com/?a=f9
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>
>


______________________________________________________

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#24 From: Sam Spritzer <SSpritzer@...>
Date: Tue Feb 16, 1999 1:12 pm
Subject: Re: Custom PS tables and viewing in PS Query 		SSpritzer@...
Send Email Send Email
  
Marilee,
I don't have access so I am working from memory here.  Go to the tree editor and
look for the Query Access tree.  Then you can add the table as a node to that
tree.  Make sure you log out and then back in order for you to "see" the table.
Sam

>>> "Mowinski, Marilee" <Marilee.Mowinski@...> 02/16 7:44 AM >>>
How do you add tables to the PS-Query tree?

Marilee Mowinski
Marilee.Mowinski@...


> -----Original Message-----
> From: jhill@... [SMTP:jhill@...]
> Sent: Monday, February 15, 1999 9:21 PM
> To: psusers@egroups.com
> Subject: [psusers] Re: Custom PS tables and viewing in PS Query
>
>
>
> Guy -
>
> You need to add the tables to your PS-Query tree.
>
> Jeff Hill
> AG Consulting, an ADP  Company
> jhill@...
>
>
>
>
> "Guy Simonian" <SIMOGUY@...> on 02/15/99 03:09:11 PM
>
> Please respond to psusers@egroups.com
>
> To:   psusers@egroups.com
> cc:    (bcc: Jeffrey Hill/Application Group)
> Subject:  [psusers] Custom PS tables and viewing in PS Query
>
>
>
>
> Have got custom tables that were added to PeopleSoft.  Can see the tables
> from the Application Developer and from Oralce SQL/Plus.
>
> What do I need to do so that my Operator class can see the new table in PS
> Query?
>
> Guy
> PS FInancials, PeopleTools 7.51, Oracle 7.3.4
>
>
>
>
>
> ------------------------------------------------------------------------
> Tired of waiting for your stock quotes and charts to load?
> StockMaster is super-fast for quotes, charts, news, and portfolios.
> Markets don't wait, why should you?  http://www.stockmaster.com/?a?
>
> eGroup home: http://www.eGroups.com/list/psusers
> Free Web-based e-mail groups by eGroups.com
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------
> Too much effort to find the stock info you want each day? StockMaster
> lets you enter a company name and quickly shows you a daily quote,
> chart, and news all on one page. Free!    http://stockmaster.com/?a=f7
>
> eGroup home: http://www.eGroups.com/list/psusers
> Free Web-based e-mail groups by eGroups.com
>

------------------------------------------------------------------------
What's everyone looking at? Check out the Top40 most requested stocks!
Plus quotes, charts, news, portfolios, mutual funds, and discussion.
All free, fast, and easy.   Visit:    http://www.stockmaster.com/?a=f5

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com




------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#23 From: "Mowinski, Marilee" <Marilee.Mowinski@...>
Date: Tue Feb 16, 1999 12:44 pm
Subject: Re: Custom PS tables and viewing in PS Query 		Marilee.Mowinski@...
Send Email Send Email
  
How do you add tables to the PS-Query tree?

Marilee Mowinski
Marilee.Mowinski@...


> -----Original Message-----
> From: jhill@... [SMTP:jhill@...]
> Sent: Monday, February 15, 1999 9:21 PM
> To: psusers@egroups.com
> Subject: [psusers] Re: Custom PS tables and viewing in PS Query
>
>
>
> Guy -
>
> You need to add the tables to your PS-Query tree.
>
> Jeff Hill
> AG Consulting, an ADP  Company
> jhill@...
>
>
>
>
> "Guy Simonian" <SIMOGUY@...> on 02/15/99 03:09:11 PM
>
> Please respond to psusers@egroups.com
>
> To:   psusers@egroups.com
> cc:    (bcc: Jeffrey Hill/Application Group)
> Subject:  [psusers] Custom PS tables and viewing in PS Query
>
>
>
>
> Have got custom tables that were added to PeopleSoft.  Can see the tables
> from the Application Developer and from Oralce SQL/Plus.
>
> What do I need to do so that my Operator class can see the new table in PS
> Query?
>
> Guy
> PS FInancials, PeopleTools 7.51, Oracle 7.3.4
>
>
>
>
>
> ------------------------------------------------------------------------
> Tired of waiting for your stock quotes and charts to load?
> StockMaster is super-fast for quotes, charts, news, and portfolios.
> Markets don't wait, why should you?  http://www.stockmaster.com/?a?
>
> eGroup home: http://www.eGroups.com/list/psusers
> Free Web-based e-mail groups by eGroups.com
>
>
>
>
>
>
>
>
>
> ------------------------------------------------------------------------
> Too much effort to find the stock info you want each day? StockMaster
> lets you enter a company name and quickly shows you a daily quote,
> chart, and news all on one page. Free!    http://stockmaster.com/?a=f7
>
> eGroup home: http://www.eGroups.com/list/psusers
> Free Web-based e-mail groups by eGroups.com
>

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#22 From: Francisco Darío Sánchez Díaz <fdario@...>
Date: Tue Feb 16, 1999 7:08 am
Subject: Apply fixes 		fdario@...
Send Email Send Email
  
Hi,

     I know there are a document which explain how do you apply fixes in
PeopleSoft. I don´t find it in PeopleSoft' web. I need this document
because I'm a PeopleSoft instructor and i like have it to give it the
students. Anybody have it? Thanks.

Francisco Darío Sánchez Díaz
Infortec Consultores Informáticos

http://www.infortec-consultores.com


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (2)
#21 From: "Andrew J. Jankowski" <andrew.jankowski@...>
Date: Tue Feb 16, 1999 2:31 am
Subject: Modifying the PeopleSoft ECIN0001.SQR 		andrew.jankowski@...
Send Email Send Email
  
I am in the process of creating an interface from a SQLBase application to PS/PO
tables.  I would like to run this interface through PeopleSoft's EDI manager (to
leverage the built-in error checking functionality) without creating a
PeopleSoft business document.  I believe this can be done by modifying the
ECIN0001.SQR to read directly from the SQLBase tables instead of a PeopleSoft
Business Document.
If anyone has ever tried this, or something similar, I would appreciate any
knowledge/advice you can pass along.
Thanks in advance.

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#20 From: ksenthil@...
Date: Tue Feb 16, 1999 12:24 am
Subject: AE performance 		ksenthil@...
Send Email Send Email
  
How can we add optimizer hints to AE programs, Its seems lot of SQL statements
building at run time . What are diiferent
steps to optimize Application Engine
process?

TIA



-----------------------------------------------
FREE! The World's Best Email Address @email.com
Reserve your name now at http://www.email.com

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#19 From: jhill@...
Date: Tue Feb 16, 1999 2:21 am
Subject: Re: Custom PS tables and viewing in PS Query 		jhill@...
Send Email Send Email
  
Guy -

You need to add the tables to your PS-Query tree.

Jeff Hill
AG Consulting, an ADP  Company
jhill@...




"Guy Simonian" <SIMOGUY@...> on 02/15/99 03:09:11 PM

Please respond to psusers@egroups.com

To:   psusers@egroups.com
cc:    (bcc: Jeffrey Hill/Application Group)
Subject:  [psusers] Custom PS tables and viewing in PS Query




Have got custom tables that were added to PeopleSoft.  Can see the tables
from the Application Developer and from Oralce SQL/Plus.

What do I need to do so that my Operator class can see the new table in PS
Query?

Guy
PS FInancials, PeopleTools 7.51, Oracle 7.3.4





------------------------------------------------------------------------
Tired of waiting for your stock quotes and charts to load?
StockMaster is super-fast for quotes, charts, news, and portfolios.
Markets don't wait, why should you?  http://www.stockmaster.com/?a?

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com









------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#18 From: Kenny Melton <KMELTO1@...>
Date: Mon Feb 15, 1999 11:24 pm
Subject: Re: Custom PS tables and viewing in PS Query 		KMELTO1@...
Send Email Send Email
  
Guy,
You need to go to the specific Access Group Query Tree in Tree Manager and
add the tables to the tree.  You should then be able to see the tables in
Query provided you have access to that Query Tree.

Kenny Melton
Senior Technical Architect
Tandy Information Services


-----Original Message-----
From: Guy Simonian [mailto:SIMOGUY@...]
Sent: Monday, February 15, 1999 5:09 PM
To: psusers@egroups.com
Subject: [psusers] Custom PS tables and viewing in PS Query


Have got custom tables that were added to PeopleSoft.  Can see the tables
from the Application Developer and from Oralce SQL/Plus.

What do I need to do so that my Operator class can see the new table in PS
Query?

Guy
PS FInancials, PeopleTools 7.51, Oracle 7.3.4





------------------------------------------------------------------------
Tired of waiting for your stock quotes and charts to load?
StockMaster is super-fast for quotes, charts, news, and portfolios.
Markets don't wait, why should you?  http://www.stockmaster.com/?aù

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#17 From: "Guy Simonian" <SIMOGUY@...>
Date: Mon Feb 15, 1999 11:09 pm
Subject: Custom PS tables and viewing in PS Query 		SIMOGUY@...
Send Email Send Email
  
Have got custom tables that were added to PeopleSoft.  Can see the tables from
the Application Developer and from Oralce SQL/Plus.

What do I need to do so that my Operator class can see the new table in PS
Query?

Guy
PS FInancials, PeopleTools 7.51, Oracle 7.3.4





------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (8)
#16 From: "Brian Nice" <bnice@...>
Date: Mon Feb 15, 1999 1:42 pm
Subject: Re: Auditing tree tables 		bnice@...
Send Email Send Email
  
In the Data Designer, go under change - record use, and their is a spot there to
designate an audit record. The audit record has to have three fields I think,
audit_oprid,
audit_stamp, and audit_actn and then you can add the other fields that you want
to
track.

Brian

>>> "Parijat Sahai" <parijatsahai@...> 02/12/99 03:30PM >>>
How do you add audit at field level or record level in version 6? All I
know about Audit is the integrity audit for Tools in Utilities - Process
- System Audit.

Sorry about posing a question instead of answering one. I'm quite a
green horn as far as working with audits is concerned.

Parijat.

>Reply-To: psusers@egroups.com
>Date: Fri, 12 Feb 1999 09:41:07 -0500
>From: "Brian Nice" <bnice@...>
>To: <psusers@egroups.com>
>Subject: [psusers] Auditing tree tables
>
>Hello
>I am trying to fgure out when a tree gets changed in the PS tree
manager.  =
>We have
>a lot of nodes which change very frequently, and every time that the
tree =
>changes, we=20
>don't create a new effective dated tree because we really don't need
the =
>history.
>
>Anyway, I have tried adding audits on the field level on the pstreenode
=
>table, and at
>the record level on pstreenode, but can't seem to get those to work. Am
I =
>working with
>the wrong underlying table? I would prefer to have it at the record
level, =
>because basically
>we just want to know when a node has changed (its position, name,
etc...)
>
>We are on PeopleSoft 6.1
>
>Thanks for the help!
>
>
>/****************************
>* Brian Nice
>* ABBA Systems Inc.
>* Orlando, FL
>*****************************/
>
>
>------------------------------------------------------------------------
>Fresh flowers are the perfect way to say "I love you".
>Shipped direct from the grower, Proflowers.com has
>arrangements from $29.95 plus S&H.
>Click here: http://offers.egroups.com/click/216/0
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>
>


______________________________________________________

------------------------------------------------------------------------
Fresh flowers are the perfect way to say "I love you".
Shipped direct from the grower, Proflowers.com has
arrangements from $29.95 plus S&H.
Click here: http://offers.egroups.com/click/216/0

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com




------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (6)
#15 From: "Brian Nice" <bnice@...>
Date: Mon Feb 15, 1999 1:40 pm
Subject: Re: Auditing tree tables 		bnice@...
Send Email Send Email
  
I tried this but it didn't seem to work. It probably is something to do with it
being a special
tool.  We ended up creating a database trigger and doing it that way. I didn't
try the
audit on the PS_DEPT_TBL like someone suggested so I am not sure if that works
or
not.

Thank you for the help and quick responses!

Brian

>>> "Robert Goshko" <robert.goshko@...> 02/12/99 05:29PM >>>
Brian, you should be able to turn the tracing on in the record definition
for the PSTREENODE field (in the properties for the record).  this will
generate audit information in the PSAUDIT table.  It is possible though,
that since the tree is processed through a special PeopleTool, that the
auditing does not work like the regular panel processor.

.....Rob
_________________________________________________
Robert Goshko <mailto:robert.goshko@...>
Owner
Axis Developments
System Consulting Services
Sherwood Park, Alberta, Canada
http://www.axis-dev.com/


-----Original Message-----
From: Brian Nice [mailto:bnice@...]
Sent: Friday February 12, 1999 7:41 AM
To: psusers@egroups.com
Subject: [psusers] Auditing tree tables


Hello
I am trying to fgure out when a tree gets changed in the PS tree manager.
We have
a lot of nodes which change very frequently, and every time that the tree
changes, we
don't create a new effective dated tree because we really don't need the
history.

Anyway, I have tried adding audits on the field level on the pstreenode
table, and at
the record level on pstreenode, but can't seem to get those to work. Am I
working with
the wrong underlying table? I would prefer to have it at the record level,
because basically
we just want to know when a node has changed (its position, name, etc...)

We are on PeopleSoft 6.1

Thanks for the help!


/****************************
* Brian Nice
* ABBA Systems Inc.
* Orlando, FL
*****************************/


------------------------------------------------------------------------
Fresh flowers are the perfect way to say "I love you".
Shipped direct from the grower, Proflowers.com has
arrangements from $29.95 plus S&H.
Click here: http://offers.egroups.com/click/216/0

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com





------------------------------------------------------------------------
Why are most stock sites so slow and annoying to use?  StockMaster.com
is fast, easy, powerful, and free!   Use company names, not ticker
symbols.  Track your portfolio.  Visit:   http://stockmaster.com/?a=f6

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com




------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (6)
#14 From: "Robert Goshko" <robert.goshko@...>
Date: Fri Feb 12, 1999 10:29 pm
Subject: Re: Auditing tree tables 		robert.goshko@...
Send Email Send Email
  
Brian, you should be able to turn the tracing on in the record definition
for the PSTREENODE field (in the properties for the record).  this will
generate audit information in the PSAUDIT table.  It is possible though,
that since the tree is processed through a special PeopleTool, that the
auditing does not work like the regular panel processor.

.....Rob
_________________________________________________
Robert Goshko <mailto:robert.goshko@...>
Owner
Axis Developments
System Consulting Services
Sherwood Park, Alberta, Canada
http://www.axis-dev.com/


-----Original Message-----
From: Brian Nice [mailto:bnice@...]
Sent: Friday February 12, 1999 7:41 AM
To: psusers@egroups.com
Subject: [psusers] Auditing tree tables


Hello
I am trying to fgure out when a tree gets changed in the PS tree manager.
We have
a lot of nodes which change very frequently, and every time that the tree
changes, we
don't create a new effective dated tree because we really don't need the
history.

Anyway, I have tried adding audits on the field level on the pstreenode
table, and at
the record level on pstreenode, but can't seem to get those to work. Am I
working with
the wrong underlying table? I would prefer to have it at the record level,
because basically
we just want to know when a node has changed (its position, name, etc...)

We are on PeopleSoft 6.1

Thanks for the help!


/****************************
* Brian Nice
* ABBA Systems Inc.
* Orlando, FL
*****************************/


------------------------------------------------------------------------
Fresh flowers are the perfect way to say "I love you".
Shipped direct from the grower, Proflowers.com has
arrangements from $29.95 plus S&H.
Click here: http://offers.egroups.com/click/216/0

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com





------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (6)
#13 From: Richard_McCutcheon@...
Date: Fri Feb 12, 1999 9:30 pm
Subject: Re: Operator Security 		Richard_McCutcheon@...
Send Email Send Email
  
Try looking at the PSAUTH  type tables.  There are a couple  (psauthitem,
psauthsignon, etc.)

You can manipulate the data there with an SQR.  Good luck.

ps - we update logon times for lockout purposes during a payroll run.



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (9)
#12 From: "Parijat Sahai" <parijatsahai@...>
Date: Fri Feb 12, 1999 1:12 pm
Subject: Re: Operator Security 		parijatsahai@...
Send Email Send Email
  
Below is the list of all the Operator security setup tables I had
compiled some time back because we had to copy security from one
database to another every now and then. A SQL script would look at the
list of the tables and copy the contents of those tables from one
database to another.

You can write your own SQL scripts to perform security setup for all
operators in one shot for any/all objects of Peoplesoft. Of course, you
should remember to maintain referential integrity while doing that. If
you wish to know how and which of these tables are related, I can gladly
help you with that.

List of tables:
PSAUTHITEM
PSAUTHPRCS
PSAUTHSIGNON
PSBUSPROCSEC
PSHOMEPAGEOPR
PSHOMEPAGESEC
PSOPROBJ
PSOPRDEFN
PSPRCSPRFL
PSROLEUSER
PS_BUYER_TBL
PS_LED_AUTH_TBL
PS_MC_OPR_SECURITY
PS_MC_OPRID
PS_OPR_DEF_TBL_AM
PS_OPR_DEF_TBL_AP
PS_OPR_DEF_TBL_AR
PS_OPR_DEF_TBL_BD
PS_OPR_DEF_TBL_BI
PS_OPR_DEF_TBL_FS
PS_OPR_DEF_TBL_GL
PS_OPR_DEF_TBL_IN
PS_OPR_DEF_TBL_OLE
PS_OPR_DEF_TBL_OM
PS_OPR_DEF_TBL_OM2
PS_OPR_DEF_TBL_PC
PS_OPR_DEF_TBL_PM
PS_OPR_DEF_TBL_VND
PS_OPR_PO_RQSTR
PS_OPR_PO_BUYER
PS_PM_PROD_OPR
PS_PM_PROP_OPR
PS_PRCR_PRF_OPR
PS_REQUESTOR_TBL
PS_REQUESTOR_CAT
PS_ROLEXLATOPR
PS_RTE_CNTL_RUSER
PS_SCRTY_QUERY
PS_SCRTY_ACC_GRP
PS_SEC_AN_GRP_CLS
PS_SEC_AN_GRP_OPR
PS_SEC_BOOK_CLS
PS_SEC_BOOK_OPR
PS_SEC_BUBOOK_CLS
PS_SEC_BUBOOK_OPR
PS_SEC_BU_CLS
PS_SEC_BU_OPR
PS_SEC_LEDGER_CLS
PS_SEC_LEDGER_CLSW
PS_SEC_LEDGER_OPR
PS_SEC_LEDGER_OPRW
PS_SEC_PC_TREE_CLS
PS_SEC_PC_TREE_OPR
PS_SEC_PROJ_CLS
PS_SEC_PROJ_OPR
PS_SEC_PYCYCL_CLS
PS_SEC_PYCYCL_OPR
PS_SEC_SETID_CLS
PS_SEC_SETID_OPR
PS_SEC_VIEW_NAMES
PS_WF_MON_OPRID
SYSUSERS           (System Table)


>Reply-To: psusers@egroups.com
>Date: Fri, 12 Feb 1999 08:45:56 -0600
>From: "Kathy Mason" <kmason@...>
>To: psusers@egroups.com
>Subject: [psusers] Operator Security
>
>Hello!  I have a question for this group regarding Operator Security.
>Does anyone out there have a method for updating operator security
>across the board?  I have asked our consultants and they tell me that
>the only way to update operator security is on-line.  I was just
>wondering if anyone had set-up and SQR or SQL routine or some other
>method to update operator security in instances where all users should
>be given access to a particular item.  Any Help is appreciated.
>
>Kathy
>
>
>------------------------------------------------------------------------
>Fresh flowers are the perfect way to say "I love you".
>Shipped direct from the grower, Proflowers.com has
>arrangements from $29.95 plus S&H.
>Click here: http://offers.egroups.com/click/216/0
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>
>


______________________________________________________

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (9)
#11 From: Richard_McCutcheon@...
Date: Fri Feb 12, 1999 8:43 pm
Subject: Third-party tools to move TREES, Security Defns, etc ?????? 		Richard_McCutcheon@...
Send Email Send Email
  
Hi everyone.

I'm looking for info on any third-party tools that could be used to move
Security definitions, Query Trees, subsets of data, and other miscellaneous
objects from one PeopleSoft database to another.

What we want to do is make the creation of a number of test databases
easier for ourseves while being able to move static controlled subsets of
data and ensuring our query access, and security classes are in sync with
production.  This can be a huge job if we had to manually pass the security
etc across databases.

An associate of mine attended the PSoft conference in San Francisco this
year and saw booths for a number of such tools, but the line-ups were so
long that he wasn't able to get any of the info. for them.

Any info, help, discussion would be greatly appreciated.
Later.
Richard McCutcheon
PeopleSoft Support
Honda of Canada Mfg.



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#10 From: David Anderson <DANDERS1@...>
Date: Fri Feb 12, 1999 8:35 pm
Subject: Auditing tree tables -Reply 		DANDERS1@...
Send Email Send Email
  
Try placing audits on the PS_DEPT_TBL.  The department security tree
(which is what I am assuming you are trying to track) is built from
PS_DEPT_TBL from a process (the number escapes me).  If you audit the
changes to PS_DEPT_TBL you may be able to capture the information you
are looking for.

Dave Anderson
Computer Associates
frmly:  Computer Management Sciences, Inc.


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#9 From: "Parijat Sahai" <parijatsahai@...>
Date: Fri Feb 12, 1999 12:30 pm
Subject: Re: Auditing tree tables 		parijatsahai@...
Send Email Send Email
  
How do you add audit at field level or record level in version 6? All I
know about Audit is the integrity audit for Tools in Utilities - Process
- System Audit.

Sorry about posing a question instead of answering one. I'm quite a
green horn as far as working with audits is concerned.

Parijat.

>Reply-To: psusers@egroups.com
>Date: Fri, 12 Feb 1999 09:41:07 -0500
>From: "Brian Nice" <bnice@...>
>To: <psusers@egroups.com>
>Subject: [psusers] Auditing tree tables
>
>Hello
>I am trying to fgure out when a tree gets changed in the PS tree
manager.  =
>We have
>a lot of nodes which change very frequently, and every time that the
tree =
>changes, we=20
>don't create a new effective dated tree because we really don't need
the =
>history.
>
>Anyway, I have tried adding audits on the field level on the pstreenode
=
>table, and at
>the record level on pstreenode, but can't seem to get those to work. Am
I =
>working with
>the wrong underlying table? I would prefer to have it at the record
level, =
>because basically
>we just want to know when a node has changed (its position, name,
etc...)
>
>We are on PeopleSoft 6.1
>
>Thanks for the help!
>
>
>/****************************
>* Brian Nice
>* ABBA Systems Inc.
>* Orlando, FL
>*****************************/
>
>
>------------------------------------------------------------------------
>Fresh flowers are the perfect way to say "I love you".
>Shipped direct from the grower, Proflowers.com has
>arrangements from $29.95 plus S&H.
>Click here: http://offers.egroups.com/click/216/0
>
>eGroup home: http://www.eGroups.com/list/psusers
>Free Web-based e-mail groups by eGroups.com
>
>
>


______________________________________________________

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (6)
#8 From: "Kathy Mason" <kmason@...>
Date: Fri Feb 12, 1999 2:45 pm
Subject: Operator Security 		kmason@...
Send Email Send Email
  
Hello!  I have a question for this group regarding Operator Security.
Does anyone out there have a method for updating operator security
across the board?  I have asked our consultants and they tell me that
the only way to update operator security is on-line.  I was just
wondering if anyone had set-up and SQR or SQL routine or some other
method to update operator security in instances where all users should
be given access to a particular item.  Any Help is appreciated.

Kathy


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (9)
#7 From: "Brian Nice" <bnice@...>
Date: Fri Feb 12, 1999 2:41 pm
Subject: Auditing tree tables 		bnice@...
Send Email Send Email
  
Hello
I am trying to fgure out when a tree gets changed in the PS tree manager.  We
have
a lot of nodes which change very frequently, and every time that the tree
changes, we
don't create a new effective dated tree because we really don't need the
history.

Anyway, I have tried adding audits on the field level on the pstreenode table,
and at
the record level on pstreenode, but can't seem to get those to work. Am I
working with
the wrong underlying table? I would prefer to have it at the record level,
because basically
we just want to know when a node has changed (its position, name, etc...)

We are on PeopleSoft 6.1

Thanks for the help!


/****************************
* Brian Nice
* ABBA Systems Inc.
* Orlando, FL
*****************************/


------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (6)
#6 From: David Anderson <DANDERS1@...>
Date: Thu Feb 11, 1999 10:02 pm
Subject: Re: Disable Workflow -Reply 		DANDERS1@...
Send Email Send Email
  
I seem to remember in release 5.x there was some errant workflow
messages even though the client was not utilizing workflow.  You need
to be sure all workflow roles are set to null.  Sorry if this is fuzzy, but it
was about two years ago.

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#5 From: "Robert Goshko" <robert.goshko@...>
Date: Thu Feb 11, 1999 8:34 pm
Subject: Re: Disable Workflow 		robert.goshko@...
Send Email Send Email
  
You will need to comment out the "workflow" PeopleCode calls on the job
record to make this stop.  We have done this at my current client under 7.01
HRMS Public Sector.

.....Rob
_________________________________________________
Robert Goshko <mailto:robert.goshko@...>
Owner
Axis Developments
System Consulting Services
Sherwood Park, Alberta, Canada
http://www.axis-dev.com/


-----Original Message-----
From: nobody@... [mailto:nobody@...]
Sent: Thursday February 11, 1999 8:38 AM
To: psusers@egroups.com
Subject: [psusers] Disable Workflow


Hi.  This forum is going to be a great asset.

Thought I'd post a quick question that's been bugging me.  I'm currently
using PeopleSoft 7.5 HRMS and every time a term or hire an employee in the
job panels and save it I get annoying messages telling me that I have no
memebrs in the Hr group or Payroll group and that no activities were found
for this action.  I'm assumimng this has to do with Work flow, which we
don't want to use.  How do I get rid of these messages.  Any ideas?

Thanks in advance.

Mark Livingstone
Decision Technologies

------------------------------------------------------------------------
Fresh flowers are the perfect way to say "I love you".
Shipped direct from the grower, Proflowers.com has
arrangements from $29.95 plus S&H.
Click here: http://offers.egroups.com/click/216/0

eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com





------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#3 From: "HALE, Nicole" <NHALE@...>
Date: Thu Feb 11, 1999 7:16 am
Subject: Big hello and many thanks for setting up this list. 		NHALE@...
Send Email Send Email
  
Just a quick note to say hello to the new list. Thanks to Jim Hardesty for
his effort in making this happen.

Nicole Hale
Analyst / Programmer
British Aerospace Australia
Contractors Area, East Avenue, DSTO Salisbury, SA  5108
PO BOX 1068, Salisbury, SA 5108
Tel: +61 8 8290 7506 Fax: +61 8 8290 8866
E-mail: nhale@... <mailto:nhale@...>



------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#2 From: Jim Hardesty <jhardest@...>
Date: Wed Feb 10, 1999 9:16 pm
Subject: Welcome 		jhardest@...
Send Email Send Email
  
Just so we aren't all wondering if this is working....

I am pleasantly suprised to see we are up to 26 members
already.  I guess there really was some demand for a group
like this.

Eventually we my need to split into seperate technical and
function groups.  I bet right now we are all sqr developers at
least part time.  I guess we'll wait and see how the
discussions go and worry about that later.

Anyway...welcome, thanks for joining and lets not be shy.

jim

------------------------------------------------------------------------
eGroup home: http://www.eGroups.com/list/psusers
Free Web-based e-mail groups by eGroups.com

Reply | Forward | Messages in this Topic (1)
#1 From: "Jim Hardesty" <jhardest@...>
Date: Wed Feb 10, 1999 3:02 pm
Subject: Welcome to the psusers E-Mail Group 		jhardest@...
Send Email Send Email
  
The PeopleSoft Users discussion group.

Group Manager: psusers-owner@egroups.com

To subscribe, send a message to psusers-subscribe@egroups.com or go to the
e-group's home page at http://www.egroups.com/list/psusers

Reply | Forward | Messages in this Topic (1)
Messages 1 - 32 of 6037   Newest  |  < Newer  |  Older >  |  Oldest
Message #
Search:
Advanced
Add to My Yahoo!      XML What's This?
Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help