I am planning the security scheme for the ERP implantacion. So, i need a list for all menus of the Financial Group. I´m built it, but if someone of your have...
2344
MARIA DEL MAR BARRON ...
mbarron@...
Jun 1, 2000 9:47 pm
Hi! I am just beggining with People Soft implementation. I have PTools 7.57 installed. To update to PTools 7.58, i received a CD Rom only. Some people told me...
2345
Todd Kurlowski
tkurlowski@...
Jun 1, 2000 9:47 pm
I would like to open a data file on another server (NT) via a SQR that runs on UNIX. When running the SQR on NT or the via DOS SQRW I am able to use...
2346
Elliot Mak
elliot_mak@...
Jun 2, 2000 2:54 pm
Hi all, I am currently setting up the HRMS751 environment. I am on the operator security right now, and I have noticed that I need to run HROPRSEC.SQR after I...
2347
Mike Conner
mike.conner@...
Jun 2, 2000 3:13 pm
I think it is a application engine database agent and not an SQR in 7.51 located under GO Define Business rules Define General options Process Update Operator...
2348
Barb Van Horn
barb.vanhorn@...
Jun 2, 2000 8:13 pm
Go - Define Business Rules - Define General Options - Process - Update HR Operator Preferences ... From: Elliot Mak [mailto:elliot_mak@...] Sent:...
2349
Mike Fulce
m.fulce@...
Jun 2, 2000 8:13 pm
No, unix doesn't do windows networking. You will have to run an nfsd program on the NT server and mount the NT file system on the unix server to be able to...
2350
Elliot Mak
elliot_mak@...
Jun 2, 2000 8:13 pm
My apology. I am the HROPRSEC application Engine. When I run the Update Operator Preference, nothing happens. It didn't not sync the table. Can someone...
2351
Pamela Lantzy
plantzy@...
Jun 2, 2000 8:13 pm
I think you need to mount the unix drives on the NT machine or vice versa. I think there is software but I dont know the name of it. ... From: Todd Kurlowski...
2352
skschelske@...
Jun 2, 2000 8:13 pm
You can run the delivered SQR program XRFMENU by navigating to: Go, PeopleTools, Process Scheduler, Process, Multiple Process Sample Click the Run button (the...
2353
Norm Schwartzman
norm_schwartzman@...
Jun 2, 2000 8:13 pm
Elliot Hroprsec is an application engine process. You can find it by going to Go --> Define Business Rules --> Define General options --> Process --> Update HR...
2354
m b
mbrayton@...
Jun 4, 2000 1:03 am
maria, if you followed the instructions from peoplesoft (i hope you had the instructions) it should be fine. we upgraded and have had no problems. there is...
2355
Kathy Mason
kmason@...
Jun 4, 2000 1:04 am
Elliot, One problem that we had was that there was one oprid that was used to set-up the default operator preference and we did not have that oprid set-up. I...
2356
Deepak Seth
seth_deepak@...
Jun 5, 2000 3:23 pm
I am trying to determine the project summary level in Project Trees with no success. Is there a definitive way to determine (under a specific SetID (I.E. ...
2357
Deepak Seth
seth_deepak@...
Jun 5, 2000 3:25 pm
I receive the error "Error 6001" when using a the custom report layout listed below: declare-report Summary-Report printer-type=HP layout=Trans-Layout ...
2359
Peter Clark
pgclark@...
Jun 5, 2000 6:49 pm
The most common reason for this type of error is that you forgot the -keep in your command line (SQR flags) which you need to do since your report will...
2360
mahonj@...
Jun 6, 2000 1:31 am
Hi, Does SQR support UNION clauses? There's no mention of it in the Landres book. If it can be done, can someone post a small example? Thanks. Jack Mahon ...
2361
Richard Johnson
RGJohnson@...
Jun 6, 2000 1:31 am
... there is a ... Grayed out. ... Maksim: I haven't actually had the occasion to implement menu peoplecode, but did some research on it. It appears that you...
2362
David Allen
dave.allen@...
Jun 6, 2000 1:31 am
Hello all Currently, experiencing the following two-way matching problem: Enter PO and dispatch - matching rules point to two-way and new setid setup Enter a...
2363
kibbles@...
Jun 6, 2000 1:17 pm
Jack, I used a union once before. Here is a copy of the syntax that I used. A couple of interesting points are (a) I couldn't get the order by to work with...
2364
Barb Van Horn
barb.vanhorn@...
Jun 6, 2000 2:49 pm
I have created a query (rather large with 2 joins). The SQL statement runs in SQL+ (Oracle 8 on NT) but when I run it in query it does not. I get the ...
2365
Heather Simpkins
heather.simpkins@...
Jun 6, 2000 2:49 pm
Yes it does support UNION - the below is an example, but not a working example - I can't remember the table and field names. Note: * The commas after the...
2366
Alan Otani
ATOI@...
Jun 6, 2000 2:49 pm
Jack: I've succcessfully used this format in the past - Begin-Select On-Error=SQL-Error-Processing '0' &DrvrTransSource A.FIELD1 &DrvrField1 A.FIELD2...
2367
c.george@...
Jun 6, 2000 2:49 pm
Jack, Use of Union sample:- begin-select on-error=error_proc column 1 column 2 column n from table A where xyz union column 1 column 2 column n from table B ...
2368
lthoma4@...
Jun 6, 2000 2:51 pm
SELECT DISTINCT A.field1, A.filed2, A.filed3 from table A union all SELECT DISTINCT ' ',B.filed1,B.filed2 FROM table B The important part is in both unions the...
2369
Pamela Lantzy
plantzy@...
Jun 6, 2000 2:51 pm
Heres your example its just as if you were going to do a UNION statement in SQL begin-SELECT on-error=sql-error A.RECNAME, A.FIELDNAME, A.DEFRECNAME, ...
2370
Powell, John
JPowell@...
Jun 6, 2000 2:51 pm
Another item regarding UNION that you can see in Stuart's example, but is still worth pointing out: (c) All processing commands go in front of the first FROM...
2371
Mike Fulce
m.fulce@...
Jun 6, 2000 8:12 pm
Query adds a couple more joins and a distinct for row-level security on HR tables. So, the sql you execute in SQL+ is not the same sql you execute via query....
2372
Kimberly decker
bmwdeckerusa@...
Jun 6, 2000 8:13 pm
I'm working with a Public Sector that is using Budget Checking for their PO's. I have a question for anyone who maybe using this. On the PO Inquiry panel...
2373
skschelske@...
Jun 6, 2000 8:13 pm
If it is an option, you could run the Query in 2-tier mode. ... From: Barb Van Horn [mailto:barb.vanhorn@...] Sent: Tuesday, June 06, 2000 10:45 AM ...
