Does anyone know of a good reference manual/resource for WorkFlow? ______________________________________________________...
Frank Cowley
fcowley@...
Nov 1, 1999 3:45 pm
2830
I do not know any reference manul but i have created a workflow with help of folio views Sitansh...
Sitansh Kadakia
sitanshk@...
Nov 1, 1999 3:48 pm
2831
I'm having trouble getting Folio (peoplebooks and help) to work from within Peopletools. It works fine from the shortcut but causes an 'invalid viewer path'...
sweins3@...
Nov 1, 1999 4:40 pm
2832
Is there an easy way to create multiple copies of an SQR report ? We are using SQR V4.3.2.2 and PeopleSoft 7.51 HR/Payroll....
dbianchi@...
Nov 1, 1999 5:58 pm
2833
Hi, The peoplebook on workflow (including Business process design) is pretty good. I also found the "Training Participation guide" (which you get when you ...
surbm1@...
Nov 1, 1999 6:15 pm
2834
Hello All, I had created a Database Agent Query. I created a DBAgent process in the process scheduler and ran it. The bind variable in the DBAgent query...
srinivasan.seetharama...
Nov 2, 1999 10:30 am
2835
Hello All - This is a great board! Has anybody had success running SQR the window using the -KEEP:WP flag? Has anybody tried to? Thanks ...
Arnold E. Foelster
afoelster@...
Nov 2, 1999 2:46 pm
2836
Morning Folks: We are in the final stages of Unit testing PeopleSoft 7.5.2 Financials, (GL/AP), with implementation scheduled for April 3rd 2000. Do any of...
bob_boisvert@...
Nov 2, 1999 4:23 pm
2837
Hi there. Just curious if anyone knows if adding the -S SQR flag degrades SQR performance by getting cursor statuses, especially ones that process a lot of...
bendip@...
Nov 2, 1999 5:56 pm
2838
It works fine - you might want to use the -NOLIS command too and get a better viewer than sqrw. We've used Swiftview and it works a treat for getting...
Pamela
pclark@...
Nov 2, 1999 7:42 pm
2839
Hi all, In the process of running our final "dress rehearsal" for our upgrade from HRMS 6.02 to 7.5, we discovered that several tables we populated from our...
Ackerson, Glenn
Gsacker@...
Nov 2, 1999 8:12 pm
2840
Glenn... This should work... select YADA, count(*) from TABLE group by YADA having count(*) > 1 order by YADA Sam <<< "Ackerson, Glenn" <Gsacker@...>...
Sam Spritzer
SSpritzer@...
Nov 2, 1999 8:20 pm
2841
Hi Sam, Thanks for the tip! I'll give that a try and let you know how it works. I appreciate your taking the time to reply! Glenn ...
Ackerson, Glenn
Gsacker@...
Nov 2, 1999 8:22 pm
2842
Lots of unposted journals are making our journal detail reports really messy. Has anyone created views for inquiring on journal detail which eliminate unposted...
Debbie Ross
dross@...
Nov 2, 1999 8:27 pm
2843
A quick and dirty way to find and resolve duplicate keys in PS_COMPANY_TBL (in Oracle, for example): Find dupes <column list should include all primary...
Davidson, Chris
davidson@...
Nov 2, 1999 8:32 pm
2844
You were able to run SQR output directly to the screen as though it were a crystal report? ... ______________________________________________________...
Arnold E. Foelster
afoelster@...
Nov 2, 1999 8:57 pm
2845
What a perfect timing of this posting! We can also benefit from any tips. I think we loaded duplicate 'persons' from the SSS Load. ... Cherry Hsieh SIS...
Cherry Hsieh
chsieh@...
Nov 2, 1999 9:18 pm
2846
Hi, We are on HRMS Commercial 7.51& MSSQL 6.5..Trying to add the Payroll Security in the Query Tool, .. The query hangs.... Please advise.. Ravi...
vreddy@...
Nov 3, 1999 12:44 pm
2847
how often should a sqr commit? after 100 updates? 250? 500? after 100 inserts? 250? 500? all of the programs i have written bore now were small and this was...
cbthompson@...
Nov 3, 1999 12:45 pm
2848
If you are using PeopleSoft, you should follow their commit procedures first. The worse that could happen is if you overfill the buffer and SQR bombs, you can...
Sam Spritzer
SSpritzer@...
Nov 3, 1999 12:50 pm
2849
If you are using Oracle, there is a parameter in the ENABLE clause that says: ENABLE PRIMARY KEY..... EXCEPTIONS INTO some table. The exceptions table has to...
Michel Keable
Michel.Keable@...
Nov 3, 1999 1:43 pm
2850
I've alway's used 200 ... ______________________________________________________...
Arnold E. Foelster
afoelster@...
Nov 3, 1999 3:47 pm
2851
Hello! We are on PS Apps 7.02 PS Tools 7.05 Oracle 8.0 We are testing Y2K as well as upgrades to these three pieces (as well as SQR and Crystal and Tuxedo). We...
Joe Johnson
jejohn1216@...
Nov 3, 1999 4:17 pm
2852
Hi all, Thanks to those of you who generously offered your tips for finding duplicate records in a table - some of the techniques suggested were quite unique....
Ackerson, Glenn
Gsacker@...
Nov 3, 1999 5:18 pm
2853
Send reply to: psusers@egroups.com Date sent: Tue, 02 Nov 1999 10:55:50 -0800 From: cbthompson@... To:...
Ackerson, Glenn
Gsacker@...
Nov 3, 1999 5:49 pm
2854
Hello, We have scheduled several processes in a Job definition. Recently one of them seems to be running out of order... ie the third job started before the...
cmorriso@...
Nov 3, 1999 6:11 pm
2855
On the issue of "commits", I am not sure about the recommendations posed in the Peoplesoft installation table as our shop uses CSS HRizon 8.0 [CSS] w/Oracle....
Krishnan Sarangarajan
ksaranga@...
Nov 3, 1999 6:11 pm
2856
Hi Craig, In your job definition from (Process Scheduler->Use->Job definition panel), did you select "Serial" for the Job Run Mode item? If you want each...
Anne-Marie Matula
amatula@...
Nov 3, 1999 6:23 pm
2857
PS 7.51, Tools 7.56, Oracle 8.x, NT We are nearing the final months of our implementation, and have determined that the PeopleSoft Process Scheduler is not ...
Robinson, Shawn
srobinson@...
Nov 3, 1999 6:41 pm
2858
FYI - When the archive log file directory becomes full, this will stall the entire database until space is freed up by moving to tape old archive logs which...