Hi every one i am a junior web admin at a company we have a new server the ask me that they want a good performance regardless of money wise so i ask you which...
Only PeopleTools cannot be migrated from 8.18 to 8.4x. You would also require to upgrade your application, which is compatible with 8.4x tools release. Just...
Question below from one of my users - I appreciate any help you can provide. "I have two new Pre-tax deduction codes that I am sure need to be singled out on...
Look whether there is any table which is causing the processes to queue for a lock on that table. How many instances have you defined for your temp table. ... ...
Here's the query I wrote to do find invalid ssn: SELECT A.EMPLID, A.COUNTRY, A.PRIMARY_NID, A.NATIONAL_ID_TYPE, A.NATIONAL_ID, SUBSTR(A.NATIONAL_ID,1,3),...
I work for the California State University system. This is a finance sqr, it uses tables we built, and they are all indexed. What do you mean by 'indexes for...
It sounds great, do you have anything for Oracle?? ... almost ... have to ... rows ... you ... anyways) ... in ... spend a ... SQL ... (probably not ... ...
That's what I plan to do next. The problem is that there are tons of bind variables that get extracted and manipulated and then other calls made. ... I would...
Hi Franklin, How are you? Where are you right now. Iam in Albany, NY. Send me your contact. I was on PS fans and saw your message. Iam not sure if you can do a...
That's and idea, I'll have to research how to run the explain. ... changes ... an ... order ... do ... it ... bottleneck ... overloaded. ... extract...
We have hired a contractor that has two rates - one for work at home and one for work on-site. My HR/Payroll dept is not clear on how to set him up in...
The Crystal thing is tricky. With 8. ... um .45 I think, but definitely as of .46, PeopleSoft delivers two Crystal pieces: The first piece is the same old...
Allen, If your main select has been tested / explained, and appears to be running okay... Then I would probably put 'show' statements in the lower-level...
Busy day, my third post asking for help... We have an automated script for stopping/starting our environments (web server, app server, proc scheduler). The...
'Show' with the system time, I like that, thanks ... be running okay... ... selects ('calls'?) to determine where your bottle-neck is. ('show' the system time...
We are currently on PeopleSoft 8 Financials and HRMS. We have several NT Process Schedulers for nVision reporting purposes. Some of the nVision reports take a...
hi, can somebody please explain me what exactly is a workflow. thanks. __________________________________ Start your day with Yahoo! - Make it your home page! ...
All, We have just ran our open enrollment, and have sent our our confirmation statements. A few of them are wrong. In the confirmation statement, it is...
I once wrote a little function that took the following parameters: -Procedure name -Procedure SQL ID -Start or end and then used the show statement to display...
Hi! I have a permanent position located in Bloomington, IL for a Senior Business Systems Analyst working with PeopleSoft 8.8/8.9. If you or anyone you know of...
Hi, We are haivng some dynamic prompt table fields using derived edittable fields and the prompt tables are configured using some custom pages. If the prompt...
Well, kind-of, there is one table, but it's not easy to get. Here is some SQL that will help find the path, given a component. ACCEPT I_PORTAL_LABEL PROMPT...
We are upgrading to HCM 8.9 and I understand there is now a person model. This is to hold any type of person not just employees. I would like to know how many...
Hello, I was wondering if this SQL script might help you. The column named PORTAL_URI_SEG1 is the menu name. The column PORTAL_URI_SEG2 is the component...
Hi Gurus, Is there any query to find all the locked definitions in PeopleSoft? One way is that we can find it out in Application Designer by going to ...
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.
