Robin Smith
  • Male
  • United States
Share on Facebook
Share

Robin Smith's Discussions

10 top SQL only for PeopleSoft

Started this discussion. Last reply by kristen Jul 9. 4 Replies

Hi,on HRCM91, Tools 8.52, On Oracle DB 11G R2,how to query Oracle DB to have 10 top SQL only for PeopleSoft ?Effectively in v$sqlarea there are all sql texts. How to choose only those of PeopleSoft…Continue

Tags: CRM, ERP, PeopleSoft

Gifts Received

Gift

Robin Smith has not received any gifts yet

Give a Gift

 

Robin Smith's Page

Latest Activity

kristen replied to Robin Smith's discussion 10 top SQL only for PeopleSoft
"it's a pleasure to meet you. I am USA Army personnel, i have an important thing to discus with you.Please write me on my email (captkristen899@gmail.com)"
Jul 9
Chun Student replied to Robin Smith's discussion SFS - Peoplesoft Windows Client Installation Steps in the group Peoplesoft SFS
"Thanks for sharing your knowledge."
Oct 14, 2013
Apr 25, 2013
Robin Smith joined Andy Reading's group
Thumbnail

Peoplesoft Practices

PeopleSoft practices will showcase entire knowledge value and tips to use and configure PeopleSoft ERP – sharing knowledge from experienced consultants and ERP expertsSee More
Apr 4, 2013
Robin Smith added a discussion to the group Peoplesoft SFS
Thumbnail

SFS - Peoplesoft Windows Client Installation Steps

The SFS Windows client is only used by DoIT developers, UWSA SFS support staff, and UW System wide nVision power users who create and execute nVision reports. You will need an SFS application account that has the UW_SEC_PSPASS_AUTH_ALLOWED role assigned to it. You will also need an account on the sfsclient.ad.doit.wisc.edu server before you can map to that server and install the client. If you do not have access, please contact your local SFS support person to start the approval…See More
Apr 4, 2013
Robin Smith joined Auldrin Nazareth's group
Thumbnail

Peoplesoft SFS

PeopleSoft SFS (Shared Financial System) group is aimed at understanding the financial query engine tool with knowledge insights and tips from experienced consultants.See More
Apr 4, 2013
Robin Smith replied to Alexa Anderson's discussion How to Hide the 'National ID' Field On the RC CASE Page...
"Check to see if the particular country is setup as a different BU/Set ID. Then make changes for the appropriate display template. Else you need to code."
Mar 14, 2013
Robin Smith replied to Paula Schmitz's discussion Query Manager Subtotal
"Are you looking to print a list and then show a sub total or are you trying to list a bunch of fields and then display the sub-total for that You can't do the first one directly in Query. You can take the data into BI Publisher and do it…"
Mar 14, 2013
Robin Smith replied to Auri Gray's discussion Feature Summary Cannot Display Webpage
"My resolution in case this comes up for someone else- When we did our upgrade from 9.04 to 9.05 the help files for our upgrade were never installed. After installed the help files, everything worked perfectly!"
Mar 14, 2013
Robin Smith replied to Katya Phillips's discussion PeopleSoft Certification
"Hi, Oracle offers online web certifications. Check www.oracle.com/peoplesoft - you'll get quite a lot of knowledge ocean there."
Mar 14, 2013
Auri Gray replied to Robin Smith's discussion 10 top SQL only for PeopleSoft
"it should be a criteria to limit the following query to PeopleSoft : However, if the queries are not reported in AWR to be important enough, then you may ignore them as they are insignificant on your system. Don't they ? But, on a Peoplesoft…"
Mar 14, 2013
Paula Schmitz replied to Robin Smith's discussion 10 top SQL only for PeopleSoft
" Run AWR and then look for sysadm and if it has some TOP SQL. I should gather this information (10 Top SQL , among those have been run by PeopleSoft) every week. it should be a criteria to limit the following query to PeopleSoft : SELECT *…"
Mar 14, 2013
Ricky Johnson replied to Robin Smith's discussion 10 top SQL only for PeopleSoft
"You can use AWR and ADDM reports. This would advice you what was running for SYSADM schema (PeopleSoft) from the record names. you will find several other details as well."
Mar 14, 2013
Robin Smith posted a discussion

10 top SQL only for PeopleSoft

Hi,on HRCM91, Tools 8.52, On Oracle DB 11G R2,how to query Oracle DB to have 10 top SQL only for PeopleSoft ?Effectively in v$sqlarea there are all sql texts. How to choose only those of PeopleSoft ?Thank you.See More
Mar 14, 2013
Robin Smith replied to Ricky Johnson's discussion URL of Worklist throwing error not authorised to access Page.
"Are you using Approval Framework or Activities for workflow?"
Mar 14, 2013
Mar 13, 2013

Comment Wall (1 comment)

At 8:03am on December 10, 2014, abiola said…

Good day,

I picked interest on you after going through your short profile and demand it necessary to write you immediately. I have something very vital to disclose to you, but I found it difficult to express myself here, since it's a public site.Could you please get back to me on(abiolabawuah2@gmail.com) for the full details.

Have a nice day.
Mrs.Abiola

You need to be a member of myPeopleSoft to add comments!

Join myPeopleSoft

 
 
 

PeopleSoft Jobs in US

Videos

  • Add Videos
  • View All

© 2017   Created by Maisam Agha.   Powered by

Badges  |  Report an Issue  |  Terms of Service