You don't say what database platform you are on. That would be helpful information. We had similar problems running paycalcall in HRMS 8.3, Tools 8.19, approx...
Set and run a cobol & sql trace isolate the offending query/queries and tune. ... From: rayvan27406 [mailto:rayvan27406@...] Sent: Tuesday, November 30,...
We are in the process of upgrading from 7.5 to 8.8. Our functional team wants to roll out ONLY rapid time entry. They feel that it's the simplest way to enter...
Hi Debra, I added the peopletools role plus a couple of others and now it's working, thanks. Allen ... But, it sounds like you have object security problems....
There really are any repercussions, I keep about 30 days in there. The users need to understand how to filter their view to the last x days or they return a...
I've been tasked with generating some data that I know where it resides in the database, but am not sure how to retrieve it. The record is PS_EARNINGS_BAL. I...
Bob, I just composed this query, hope it is close to what you need. select * from ps_earnings_bal a where balance_year= (select max(balance_year) from ...
Bob, this was extracted from pay003.sqr (paycheck print). You'll want to use the same subquery logic found on the criteria line for EB.BALANCE_PERIOD. It...
Create your select using max(year) select a.emplid from ps_earnings_bal a where a.balance_year = (select max(a1.balance_year) from ps_earnings_bal a1 where...
You need to use subqueries to get max quarter and max period for the year. Here is the sql for one I just did that prompts for a year, plan type, benefit...
Ah the joy of doing a subquery in PS Query..... on your criteria, choose BALANCE_PERIOD equal to Subquery. Then select the EARNINGS_BAL table. select...
We are trying to implement LDAP with the Psoft Portal and HR. We have added an external link to Kronos out Time and Labor side. Everthing works fine within...
Bob, Simple solution that may work for you and requires no subqueries or max period logic. EARNINGS _BAL table keeps balances by year, quarter, and month....
Is it possible to copy cache files from one application to another? We have a problem with an application engine program in production that appears to be a...
We keep ours for 30 days too, and we also had to train users how to filter the results. We also have a special archive for reports they want kept longer -...
We have our process scheduler purge jobs after only seven days, but we keep our report repository output for 90. ... filter the results. We also have a...
Thanks for the insight Steve! Of the 130 users we have 5 power users. One for each module (AP, AM, GL, PO, IN). When I say "power user" I really mean that my...
Hi Folks Our users do not like having to press the apply schedule button for every employee they're posting time for. We do not want to run a job to...
Hello all, PeopleSoft HRMS 8.8, PeopleTools 8.42, SQL Server 2000 The print check process is not printing the barcodes? We do have the MIKA fonts installed on...
If its a cache problem, just delete the cache. Since it is a Process scheduler problem, you don't even need to shut down the application. Just watch the...
COBOL dms scripts are not used by process scheduler at all. They are run in data mover to load the COBOL stored statements into a table in the database, I...
I think you must be asking if the SQL Statement table cached by the process scheduler since DMS scripts are never used directly by the COBOL programs. I'm...
We're on Rel 8.8 SP1 using Recruitment and Position Management. We have a common situation where we know employees are moving to other positions in the future...
Good luck. I was in the same boat at my former company. They decided they didn't need any in house support at all for PeopleSoft and laid me off. They...
Brigitte, We implemented T&L during our initial rollout using group timekeepers who enter time using the Manager Self Service pages. All of our employees are...
Hi All, We are looking to enforce our password policy onto PeopleSoft (v 8.3, tools 8.17, Oracle). Our rules are : 1. Minimum length of password 2. Password...
Hi all, I work on SQR program, and I would like to know if it is possible to make more than one connection to a database, for exemple one connection on DEV ...
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.
