Some of the panels in our system take a long time (minutes) to bring up data and we are planning to improve the performance of these panels (leave and...
g1joshi@...
Jun 1, 1999 8:52 am
920
We setup environment variables associated with our various environments (eg development, test, production) and the individual PCs and use the following ...
Ivory, Wayne
wayne.ivory@...
Jun 1, 1999 11:56 am
921
Hi We recently told our users to run processes (SQR and COBOL) on unix server, as it is more powerful and runs processes very fast. However after doing that,...
Ketan Kothari
ketan@...
Jun 1, 1999 11:57 am
922
Welcome back from the long weekend (US subscribers only). Two things: one - egroups claims to have fixed the problem causing subscribers to suddenly stop...
Jim Hardesty
jhardest@...
Jun 1, 1999 2:12 pm
923
We have set up a job to run several process, which include crystal reports. When the crystal reports run on the server that require additional parameters, the...
David M. Thelen
ddthelen@...
Jun 1, 1999 2:33 pm
924
I am considering using PAYUPDT.SQR to upload regular earnings from an external time & attendance system into the paysheets. However, this seems to add rows to...
zshroff@...
Jun 1, 1999 3:06 pm
925
Hello To improve panel performance a. Use sqlexec in people code as rarely as possible b. Use view instead of table in search dialog box. (if new panel ...
*Sehat Rosny
SRosny@...
Jun 1, 1999 3:15 pm
926
When loading time or amounts using the delivered Payupdt.sqr, you need to decide how you want the time generated for payment. If all time and amounts are to...
Harry Oxrider - Centu...
hoxrider@...
Jun 1, 1999 4:20 pm
927
Hello all, We're in the process of upgrading to HRMS E & G version 7.5, and the step I just ran hit a speed bump on the view PS_APPLICANTS. The error I get...
Ackerson, Glenn
Gsacker@...
Jun 1, 1999 5:21 pm
928
I have used this many times to update time data and yes REG earnings are loaded to the PAY OTH EARNS table. This causes no problem in the PS system with this...
jhill@...
Jun 1, 1999 5:41 pm
929
do the columns in your record definition match the columns in the SQL View Select Statement? ... From: Ackerson, Glenn [mailto:Gsacker@...] Sent:...
Arellano, Larry
lrarell@...
Jun 1, 1999 5:55 pm
930
... Larry, As it turns out, the Select sql code associated with the view wasn't the problem - the record definition was. Somehow, the record definition didn't...
Ackerson, Glenn
Gsacker@...
Jun 1, 1999 7:06 pm
931
We've created a run-control panel to run a complex SQR report based on one of several user-specified values. We've also set up some of the input parms as ...
david.a.smith@...
Jun 1, 1999 8:00 pm
932
HRMS 7.01 PeopleTools 7.03 HPUX 10.20 PeopleTools 7 PeopleBook claims that canceling a processing process request is now fully support in UNIX: "Canceling a...
Jim Hardesty
jhardest@...
Jun 1, 1999 8:37 pm
933
Hi Jim. If I understand ok your sqr is initiating a new sqr on the unix. The problem is (if this is the situation) that PeopleSoft cancel a process on unix ...
Juan Jose Breuer
jbreuer@...
Jun 1, 1999 9:00 pm
934
Thanks for your response Jeff. The process you outlined seems to work except for 1 thing - if holiday or vacation time comes into the picture, paycalc seems to...
zshroff@...
Jun 1, 1999 9:43 pm
935
we are seeing the same thing. we get around by killing the process. this is not a good thing. we have never called this into PS as only developers run SQR on...
S+A Sills
ssills@...
Jun 1, 1999 9:45 pm
936
Jim, We found this same problem recently and reported it to PeopleSoft. They responded with the following incident (see below). In short, there are many bugs...
Mark Polette
markpolette@...
Jun 1, 1999 10:35 pm
937
... 1) make sure that the X:\HR700SU\SQLBASE directory is in your path 2) make sure the flags are set correctly in the SQR.INI file SQRDIR=X:\HR700SU\sqrbinw ...
Greg Hesla
ghesla@...
Jun 1, 1999 11:28 pm
938
Zubin - You can modify the SQR, but I found that it is one of PS's more complicated SQR's to modify. I'm not quite certain of what you're talking about in...
jhill@...
Jun 2, 1999 12:45 am
939
Hi All: I am unable to create a Requisition Posting in HR7.5.(7.5.3 Tools). (Develop Workforce/Recruit Workforce/Report/Requsition Posting) The SQR ...
psmith@...
Jun 2, 1999 10:56 am
940
Hello, Does anyone know of a way to change a vendor number on a "disatched" PO? The PO hasn't actually been sent out. It does have many line items, so the...
alan@...
Jun 2, 1999 12:03 pm
941
Create a new PO using the copy from PO feature. Cancel the old PO, change the vendor on the new PO and then dispatch it. alan@... 06/01/99 10:51 PM GMT ...
diwakar.v.bhatt@...
Jun 2, 1999 12:17 pm
942
Hi, I wrote an SQR program that gets data from the oracle DB and it writes to an Excel file. When it writes, it doesn't write the leading zeros. I tried to ...
Dianderas-1, Edgardo
Edgando.Dianderas-1@...
Jun 2, 1999 12:23 pm
943
No, we are not using our sqr to kick off another sqr. We are simply using the delivered ps process sched to run a delivered ps job. What happens is that the...
Jim Hardesty
jhardest@...
Jun 2, 1999 12:29 pm
944
I had the same problem until I started using silk formatted files. This sounds a lot more complicated than it is. It is a format that allows you to specify ...
Kimberly_Lawrence@...
Jun 2, 1999 12:29 pm
945
Not sure how you are writing to an XLS file. But, if you are importing the data from a flat file (ie, TXT, CSV, etc...) identify the columns as TEXT. This...
David Anderson
DANDERS1@...
Jun 2, 1999 12:50 pm
946
take a look at the psusers vault. the dbf sqc can be used to write .dbf files that will present leading zero text and date fields correctly when opened with...
Sills, Scott
sillssc@...
Jun 2, 1999 1:10 pm
947
Paul, Review the Word document macro set up. PeopleSoft provides generic Word macro command lines. You will need to review the Word macro variables Empty.doc...
Harry Oxrider - Centu...
hoxrider@...
Jun 2, 1999 1:31 pm
948
Did you verify your configuration ? Open your Configuration Manager go to Process Scheduler Tab Check the winword executables path (check that in that path you...