I thought permission lists were new to version 8. Did they exist in 7.5? We have not done a conversion yet, but were told in our Security class that each...
9854
yskulkarni@...
Aug 1, 2001 3:40 pm
Hi All, I have an sqr which accepts data from a flat file and makes changes to the accounts in the direct deposit tables(ps_direct_deposit and ...
9855
cyanberry@...
Aug 1, 2001 3:40 pm
I do not have "PeopleCode Guide". Are there any homepage, book, and data which are helpful in order to study PeopleCode?It teaches. from Yuji...
9856
raghu nandan
rbompelli@...
Aug 1, 2001 3:40 pm
Diane Thank you for sharing the info. At our site the values in the dept table are populated and still facing the problem. ... ...
9857
Powell, Frank
fpowell@...
Aug 1, 2001 3:40 pm
To the Ben Admin Gurus of the group: I am having a problem with the Event Class. My user is trying to rehire 2 former employees. An event class of Rehire was...
9858
Argy Rodriguez
argy_rodriguez@...
Aug 1, 2001 3:42 pm
I work at a huge (200,000 employees) HRMS installation holding HRMS 7.5 with PeopleTools 7.57. The installation is OS/390 with DB2/MVS 5.12. It has been a...
9859
Julia Koltyarker
julia.kotlyarker@...
Aug 1, 2001 3:42 pm
This question for those of you who are on UNIX: We have very weird problem with our AIX4.3/Informix 9.31UC3/ PeopleTools 8.13 environment. Every now and then...
9860
kewen huang
pskewen@...
Aug 1, 2001 3:42 pm
Hello, everyone, In PS Query Tools, we can not add Where Criteria to the aggregated field. How do you handle where clause likes this: SELECT...
9861
Sesh Kodavanti
skodav@...
Aug 1, 2001 3:42 pm
I am trying to forget 7.x terminology. They are classes in 7.x and that is correct each class in 7.5 will be converted to a permission list and a corresponding...
9862
arthur_anderson_2000@...
Aug 1, 2001 3:42 pm
Query not showing data when data Imported into Vendor Contracts We use an SQR to import data into our Vendor Contracts. Everything works fine except when we...
9863
janet_weiss@...
Aug 1, 2001 3:47 pm
Raghu, Take a look at Resolution R-LWIEDE-HX4WT under eBenefits for HRMS SP1. I haven't applied it to my environment yet, but it looks like it addresses your...
9864
Powell, John
john.powell@...
Aug 1, 2001 4:19 pm
You must narrow it down to what row is being processed when the error occurs. Add some a display statement to your code in front of the insert that is failing...
9865
hoxrider@...
Aug 1, 2001 4:32 pm
Since the REH Event Class was not correct when the JOB record change triggered the event, you need to do several things to correct the problem. 1. Make sure...
9866
Ray, Dorla
DKR@...
Aug 1, 2001 4:40 pm
First I would check the dates of your event rules to be sure they are effective prior to the rehire row effective date. Assuming this is ok I would then get...
9867
Heather Kepner
hkepner@...
Aug 1, 2001 6:40 pm
To get around this I make the field an expression and aggregate the expression. Then it will allow you to use it as criteria. Heather Kepner Programmer/Analyst...
9868
Robert Richley
rrichley@...
Aug 1, 2001 6:40 pm
Hi all, In version eight there is no red X. When our users use bread crumbs to go back in the menu and navigate to a page in the same component as the previous...
9869
john_garbaciak@...
Aug 1, 2001 6:42 pm
Has anyone balanced Proj_Resource to GL? Any information would be greatly appreciated....
9870
Bill Beckner
bbeckner@...
Aug 1, 2001 6:47 pm
In the Query tool, click on Criteria | Having - you'll see a new tab display labeled "Having Criteria". This is where you would add query criteria for any...
9871
Elder, Corey
celder@...
Aug 1, 2001 7:32 pm
You have to put that criteria in the HAVING criteria. It will look as follows: SELECT MAX(A.BALANCE_PERIOD) FROM PS_CHECK_YTD A WHERE A.EMPLID = '0000001' AND...
9872
Rhonda Hudgins
rhudgins@...
Aug 1, 2001 7:55 pm
I am in the middle of running another test of a move to production from 7.51 to 8 sp 1. I am in the step mvhc75im.dms, the previous script was mvprdimp.dms...
9873
Hardesty, James E
jh151011@...
Aug 1, 2001 9:27 pm
what userid and password are you using? has anyone been in your upgrade database setting up security? mvprdimp.dms copies security from your upgrade database...
9874
Tika Ramdan
tikaramdan@...
Aug 1, 2001 10:09 pm
Good Morning PeopleSoft Fans & SQR Wizards: I am trying to understand the logic contained in the SQR GLS7002 for General Ledger Activity. Specifically, the...
9875
Rector, Ruth Ann
rab1@...
Aug 1, 2001 10:10 pm
As others have suggested I had to add it to "having criteria" in order to add criteria on an aggregate field. In addition to that I had to add another field...
9876
jeasow
jeasow@...
Aug 1, 2001 10:30 pm
Yogesh, You are getting the error because of a duplicate row being inserted in the table. Maybe the data in the table is different in test and production....
9877
kewen huang
pskewen@...
Aug 2, 2001 1:10 am
Thanks. It works. I put the MAX(BALANCE_PERIOD) in a expression and add it to the select fields. PS Query Tools is not smart enough to pick it up as an...
9878
Raja Nandam
rajanandam@...
Aug 2, 2001 1:11 am
It is because mvprdimp.dms will have SYMBOLIC id and Access Id of source database.. You need to change the accessid and password and symbolic id to Production...
9879
Powell, Frank
fpowell@...
Aug 2, 2001 1:12 am
To all: Thanks for all of the helpful hints. After several attempts, I ended up deleting the bad records in the bas_partic tables and reran event maintenance....
9880
Christine Sessler
cms41@...
Aug 2, 2001 1:12 am
Yuji - I have found the "Essential Guide to PeopleSoft Development and Customization" (DeLia, Landres, Rivera, Sankaran) a very valuable resource for...
9881
arthur_anderson_2000@...
Aug 2, 2001 1:22 pm
We had the same problem with n-vision, this time running on batch. If the problem is the length of the file as you mentioned before, how about can we fix the...
9882
Billie Jean LePla
psuserbj@...
Aug 2, 2001 1:22 pm
Where can we find a copy of the "PeopleSoft ... __________________________________________________ Do You Yahoo!? Make international calls for as low as...
