Skip to main content.

Job Scheduling < Basics < Adapters

peopletools-l

Messages for peopletools-l

peopletools-l

Enabling a button
I'm a newbie to PeopleSoft, self-training, and trying to work out the follo

3 July 2009

RE: Rowset Datasource to generate PDF output
No, File Layout isn't needed for rowset or query data sources.

3 July 2009

Faculty Center error -You are not authorized to update your own data
When our Faculty use Self Service>Faculty Centre everything works fine exce

3 July 2009

RE:Is there any way we can run PSqueries through a unix script.
well... you can always call from the unix script a java class method wrappi

3 July 2009

Component Interface / App Engine working in debug but not in process scheduler
A component interface has been created from VCHR_QUICK_PNL component in Fin

3 July 2009

RE: Is there any way we can run PSqueries through a unix script.
It is not recommended, but it is possible to run PS Queries via UNIX Script

3 July 2009

RE: Inbound File Loader Utility
Denise - If it is a simple requirement I would recommend using file layout

3 July 2009

RE: EXEC() command not working
Hi pramod I tried it and its working. You try out with below parameter E

3 July 2009

RE: Rowset Datasource to generate PDF output
Hi James, I ask question #4 because it's part of the diagram I got from Or

3 July 2009

RE: Need help accessing a field on another page within the same component
It doesn't matter that the field is in a different page, all component data

3 July 2009

RE: Rowset Datasource to generate PDF output
(some) answers to your questions: 1. Rowsets can be anything in your compo

3 July 2009

RE: Rowset Datasource to generate PDF output
I don't see many delivered code that uses method SetRuntimeDataRowset. Not

2 July 2009

RE: Rowset Datasource to generate PDF output
Build your rowset to include both the Level 0 and Level 1 records. If you'r

2 July 2009

RE: Peoplecode - How to hide shared radio button properties
Could you use a %EDITTABLEn for the Prompt Table for the record-field and u

2 July 2009

RE: PeopleCode Trace Options for Message Subscriptions
Thanks Richard. I asked the DBA to turn on the trace and got what i needed.

2 July 2009

RE: Rowset Datasource to generate PDF output
Could you please elaborate on this -- You simiply pass the Rowset to the ap

2 July 2009

RE: How do I call a UNIX cron job through an sqr
You would use the syntax for the "CALL SYSTEM" SQR command using the comman

2 July 2009

RE: Perl VS Application Engine
Given the magnitude of performance difference you are experiencing, I would

2 July 2009

RE: Users Locked in PSOPRDEFN but still able to log in...!!
Try updating the version information. When you make a change "on-line" via

2 July 2009

How do I call a UNIX cron job through an sqr
Does anyone know the command to call a UNIX cron job inside an sqr?

2 July 2009

RE: Need help accessing a field on another page within the same component
Hi.. Access the required page field from Component Buffer instance by using

2 July 2009

Re: VPN connection
If you are connecting through a VPN to a terminal server sometimes the rig

2 July 2009

RE: VPN connection
Do you have PT installed locally on the PC? We were never able to run 3-tie

2 July 2009

RE: problem in building the record and font size of peoplecode is zero
I am having the same problem now. Initially it was all working fine. Now, I

2 July 2009

RE: Users Locked in PSOPRDEFN but still able to log in...!!
I do not think it is customized. We did install LDAP to create a single si

2 July 2009

RE: VPN connection
We use App Designer thru a CISCO VPN all the time with absolutely no proble

2 July 2009

VPN connection
Do you know of any issues between App designer and the CISCO VPN? We have n

2 July 2009

RE: Users Locked in PSOPRDEFN but still able to log in...!!
Did you turn on or customize singon people code Have your public user pro

2 July 2009

Users Locked in PSOPRDEFN but still able to log in...!!
I issued the following SQL UPDATE SYSADM.PSOPRDEFN SET LASTUPDOPRID = 'HRSY

2 July 2009

Vertical scrollBar for Grid in Peoplesoft
Hi, How to get a Vertical ScrollBar for a grid in Peoplesoft whether we hav

2 July 2009

RE: EXEC() command not working
Are you running from prcs server or 2 tier. Try on 2 tier also, (From app

2 July 2009

Re: EXEC() command not working
Hi Imran, i tried following code but still im getting 2 as a return code. i

2 July 2009

RE: EXEC() command not working
Instead of give concate path to EXEC function, Use variable to concate f

2 July 2009

EXEC() command not working
i m trying to execute EXEC() command from my AE program but i am getting 2

2 July 2009

RE: How to use replace function on LONG dataype?
Thanx for your posting .I did it another way. 1)Create table with clob

2 July 2009

Re: How to use replace function on LONG dataype?
Hi, I saw a lots of people providing solutions to this issue.Probably most

2 July 2009

How to pass a date value in the prompt table.
Hi, I have an account setup same as GL account set up which is effective da

2 July 2009

Has anyone customized CHECK1 or Check2 Crystal Reports for Duetche or Union Bank of CA
Hi, did anyone customize the Check1 or Check2 Crystal Reports to match the

2 July 2009

Setting up a custom SQR Report in pt8.49 -- accessing run control talbles, $prcs_oprid, etc
I have successfully called an SQR Report from PeopleCode -- a simple, custo

1 July 2009

RE: Want to make Notify button Invisible
UPDATE PSROLEDEFN SET ALLOWNOTIFY='N' WHERE ALLOWNOTIFY<>'N'; change defaul

1 July 2009

RE: Perl VS Application Engine
If the Perl program is working fine, why take the time to recreate it in an

1 July 2009

Perl VS Application Engine
Hi All I have a Perl script in Account receivable which uploads customer

1 July 2009

AutoSys PeopleSoft Adapter - using PSJob Set
Has anyone executed a PSJob Set from AutoSys for PeopleSoft. I know that a

1 July 2009

RE: Peoplesoft Performance Monitor setup
I would do a thorough study of the amount of data that will be collected. I

1 July 2009

RE: How to use Substitute function for line feed and carriage return
The function you want is char() not chr().

1 July 2009

RE: PSNT process scheduler unexpected boot
...tried to send this once before... We did not have that exact problem...

1 July 2009

RE: Hide navigation in the search verity results
That's a good question. Have you checked the box on the content reference t

1 July 2009

RE: PSNT process scheduler unexpected boot
I'm not sure about that one, but could it be someone setup a startup scrip

1 July 2009

RE: PSNT process scheduler unexpected boot
I get an email every time I login via the terminal server to my PSNT server

1 July 2009

RE: Is there any way we can run PSqueries through a unix script.
I don't think there is a way to run it via a unix script. You could try jus

1 July 2009

RE: Peoplesoft Performance Monitor setup
Peoplebooks covers the installation and setup of the performance monitor qu

1 July 2009

RE: ViewContentUrl Followed by Transfer function do not work in tools 8.49
I'm not positive but I seem to recall that ViewContentURL is a deferred exe

1 July 2009

Need help accessing a field on another page within the same component
I am trying to write a peoplecode program that will allow the user to place

1 July 2009

Peoplesoft Performance Monitor setup
I want to setup perf monitor on a new Solaris server using Oracle database.

1 July 2009

RE: PT 8.49, change to portal greeting
I've covered it briefly here: http://peoplesofttipster.com/2007/06/13/using

1 July 2009

PT 8.49, change to portal greeting
We modified the following in PT 8.48 &Greeting = &Portal.Homepage.Greeting;

1 July 2009

Inbound File Loader Utility
I've read the instructions from peoplebooks, which suggest you have to choo

1 July 2009

RE: peoplesoft backup
As you are probably aware, the problem you have to work around is the big-

1 July 2009

RE: peoplesoft backup
Moreover, if you're using ASM, I think the only option is rman or export (d

1 July 2009

RE: peoplesoft backup
Rman is recommended; if you don't want rman, you can shut the database and

1 July 2009

RE: UPK Installation not getting finished!
No, oracle and sql server are supported (we used oracle 11). I think usage

1 July 2009

RE: UPK Installation not getting finished!
I thought that I read that you need SQL server database for UPK. The SQ

1 July 2009

RE: Peoplecode - How to hide shared radio button properties
Sorry I need to claify I do need to show translate value of "M" in some cas

1 July 2009

Re: Candidate Gateway - Applicant Search Issue
Did you run the build applicant index?  It's under recruiting>administratio

1 July 2009

RE: Candidate Gateway - Applicant Search Issue
Did you run the Build Job Index, a Verity Search Engine process?

1 July 2009

RE: Integration Broker help PT 8.48 & PT8.49
What are you trying to develop for IB? The Peoplebooks are decent at explai

1 July 2009

RE: peoplesoft backup
I suggest you use RMAN. It's delivered with Oracle Database and it can rest

1 July 2009

RE: Peoplecode - How to hide shared radio button properties
Toolbox peopletools-l. . . Deactivate the translate value, if you can live

1 July 2009

Candidate Gateway - Applicant Search Issue
Hi all, I'm kind of new to this peoplesoft world.... Currently I have issue

1 July 2009

RE: Importing data from XML file in App.engine
thanks guys

1 July 2009

Peoplecode - How to hide shared radio button properties
Hi Gurus, Please let me know how to hide (using Hide()) a shared radio butt

1 July 2009

RE: PeopleCode Trace Options for Message Subscriptions
I can help a little bit. Tracing of IB requires that tracing be turned on

1 July 2009

RE: Integration Broker help PT 8.48 & PT8.49
The peoplebooks are horrible for 8.48 (we are on 8.48.19). IB was rewritte

1 July 2009

RE: what to include in project for process definition so mutual exclusive portionof process definition would move?
You should have everything needed. Check the Update flags to confirm that

1 July 2009

RE: Dynamice Role in Approval Workflow
Several thoughts spring to mind depending on how adventurous you are: 1) Us

1 July 2009

Accessing component properties in PeopleCode
Hello. I have a situation where I need to limit most users to read-only ac

1 July 2009

RE: How to enable the vertical scroll for a grid.
Hi, I have a similar issue , Can u share the solutin of this. Thanks Muthu

1 July 2009

RE: Error getting date value from field object
Curt Did you give legacy FetchValue a shot? Thanks Sid

1 July 2009

UPK Installation not getting finished!
Hi there, I have the UPK installed on my workstation and everything seems

1 July 2009

Re: Field Long Name error on a Page
hi there... just a question... what's the language you develop with and wha

1 July 2009

Field Long Name error on a Page
Hi, As per my project requirements. I need to change the Field Long Name. S

1 July 2009

How to use Substitute function for line feed and carriage return
i am using ASCII value for line feed and carreige return in following cod

1 July 2009

Dynamice Role in Approval Workflow
Peoplesoft Version 9.0 Module - MSS ( Promote Employee ) I am currently wo

1 July 2009

RE: CRM 8.4 data model
I have CRM 8.4 CDM data model as a file, please provide me your email addre

1 July 2009

RE: peoplesoft backup
Please suggest me which backup i can take except RMAN, so that i can restor

1 July 2009

RE: How to use replace function on LONG dataype?
Thanx for your posting but it still giving the same error. Regards....Cha

1 July 2009

what to include in project for process definition so mutual exclusive portionof process definition would move?
Hi, I updated a process definition with mutual exclusive process and insert

1 July 2009

Re: CRM 8.4 data model
Toolbox peopletools-lHi Andy, Would you let me know the link to the Peoples

30 June 2009

Online check error
Hi,   I got the following error while calculating the check from Online che

30 June 2009

RE: PSNT process scheduler unexpected boot
anyone please...............

30 June 2009

XML to XLS automated conversion
Hi, We have sqr that writes huge xml file.XLS file seems to be smaller and

30 June 2009

Level 0 Freeze
How to freeze the level 0 information on the page when you scroll up and do

30 June 2009

RE: Error getting date value from field object
I found a solution - use the %SelectAll(), as per below: &RecTGT = CreateRe

30 June 2009

RE: Error getting date value from field object
After much detailed investigation, here's the deal: Using the interative Pe

30 June 2009

RE: How to use replace function on LONG dataype?
Actually there is very little you can do with a LONG in SQL. See this link

30 June 2009

RE: How to use replace function on LONG dataype?
you can do this (assuming its oracle) select c.po_id, replace(to_char(c.com

30 June 2009

RE: Error getting date value from field object
It would seem as though the date isn't in PS format. Are you selecting the

30 June 2009

RE: peoplesoft backup
So how do you perform your backups now? If you aren't using RMAN for Oracle

30 June 2009

RE: Rowset Datasource to generate PDF output
The XML Publisher has a couple of options for a Data Source. Rowset is one

30 June 2009

RE: How to use replace function on LONG dataype?
Good morning, I find it is easier to put the value into a string variable,

30 June 2009

How to use replace function on LONG dataype?
how to use replace function on LONG dataype?? select c.business_unit, c.po

30 June 2009

RE: Pass the effdt value from first page to the second page
Your assumption is correct but the same time you need to write the code at

30 June 2009

RE: Pass the effdt value from first page to the second page
Take the value of effdate in component variable .then assign value to 2nd p

30 June 2009

RE: Integration Broker help PT 8.48 & PT8.49
Toolbox peopletools-lHave a look at the Appendix (Using the Delivered Liste

30 June 2009

RE: peoplesoft backup
No , please suggest me how restore in windows platform

30 June 2009

Pass the effdt value from first page to the second page
I want to write the code in ROWINIT event to pass the EFFDT value from one

30 June 2009

RE: Autosave using jquery and ajax in eperf
Hi, I've been trying to implement this solution and have got the Autosave w

30 June 2009

Integration Broker help PT 8.48 & PT8.49
hi, can anyone pls. refer me to docs pertaining to integration broker d

30 June 2009

Application Server ODBC Fail
Hi All, I'm installing peoplesoft 8.49 HMS 9.0 on windows XP environment. T

30 June 2009

Rowset Datasource to generate PDF output
I have a requirement to generate PDF output based on information displayed

30 June 2009

RE: Creating SQL View
Phil, Even same Doubt I have. Actually we are not bother in putting the Ord

30 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
This is how I understood your issue - You have PS portal. From portal you a

29 June 2009

Paycyle Fin2025 running slow.
Hi All, The fin2025 sqr is behaving very wierdly off late it is take 11 hou

29 June 2009

RE: SQR Issue: Out of Memory
Hi Can you please let me know what was the modification that was done. Tha

29 June 2009

RE: Error getting date value from field object
Curtis, I may be wrong, but I think it may not be a peopletools issue. The

29 June 2009

PeopleCode Trace Options for Message Subscriptions
Hi, I want to check the values assigning to variables in a Message (IB). Ca

29 June 2009

RE: Error getting date value from field object
Thanks Todd. I did that, and the data value is exactly what I expected - i

29 June 2009

RE: Error getting date value from field object
Sometimes date values do strange things across DB Links. Can you wrap your

29 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
It looks like if you use a dynamic external URL, that will target the paren

29 June 2009

RE:Error getting date value from field object
:-) well... as you said... "It would be slick if we could just use a record

29 June 2009

RE: Error getting date value from field object
Thanks Gabe. After examining your code, and Andrew's, I see what you are r

29 June 2009

RE:Error getting date value from field object
if you take a closer look, it expands and is single-quoted.. %DateIn(' expa

29 June 2009

RE: Crystal Reports 9 Unable to connect: incorrect log on parameters. %6 %7 %8 %9
I ran across this searching for a solution for the same issue. I thought I

29 June 2009

RE: Error getting date value from field object
This: %DateIn(&ThisField.Value) give me an "Unknown System Defined Variable

29 June 2009

RE:Error getting date value from field object
well... I've got a typo error myself... it's not &sWhileL0, it's just &sWhi

29 June 2009

RE: Error getting date value from field object
Sorry, it's a single value (copy and paste plus big-thumb error...). It's a

29 June 2009

Re: Error getting date value from field object
mate... you could try something like this....   Function WhereFieldWrapper(

29 June 2009

RE: Error getting date value from field object
Aside from having ".Value" there twice it looks ok. Are you getting a SQL e

29 June 2009

Error getting date value from field object
I an writing a function that constructs a where-clause based on a record ob

29 June 2009

RE: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Hi Neeraj, it would be great - if you can help me out on this one. Regards,

29 June 2009

RE: Creating SQL View
Why bother putting an order by clause in your view? You can do this when yo

29 June 2009

RE: how to set order for key fields?
If you identify a field as a key field, it is either ascending or descendin

29 June 2009

RE: SSL and Integration Broker
Not sure what web server you are running, I am using weblogic. Make sure yo

29 June 2009

RE: Value Propositions for Tools 8.50 & Portal 9.1
Check this link, let me know if you need the doc https://metalink3.oracle.

29 June 2009

Re: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Thanks Kd , This is working in our production , Let me see , If I have any

29 June 2009

RE: SSL and Integration Broker
Yes. Both client and root certificate are loaded in pskey, and in peopletoo

29 June 2009

RE: Problem loading a page in Application Designer
How about trying to connect to the database in two-tier app designer instea

29 June 2009

RE: PS Application Designer
Not that I'm aware of. I guess you could try to setup the whole system on a

29 June 2009

RE: Value Propositions for Tools 8.50 & Portal 9.1
I think they are only available via Metalink3 right now. Unless someone cop

29 June 2009

RE: database sql
Sounds like you need to read the installation guides. Did you read those fo

29 June 2009

RE: SSL and Integration Broker
Did you load the proper certificates in the pskey as well as in Peopletools

29 June 2009

RE: peoplesoft backup
Do you use RMAN to perform the backup from Oracle?

29 June 2009

RE: Generating Multiple Reports in SQR
Many thanks for all the responses on this. I too had a requirement to gener

29 June 2009

SSL and Integration Broker
Dear Mr. Bardillo, on the post http://peoplesoft.ittoolbox.com/groups/techn

29 June 2009

Problem loading a page in Application Designer
On attempt to open a rather heavy Service Order page in the Application Des

29 June 2009

RE: Time and Labour
Toolbox peopletools-lThe Transfer function might be of interest for you. Ha

29 June 2009

RE: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Hi neeraj, our tools version = 8.49.19. The financials version = 8.90 We

29 June 2009

RE: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Hi, we use Asynchronuos One Way Service Operation.

29 June 2009

RE: how to set order for key fields?
I forgot to mention the two fields are key fields.There are other fields al

29 June 2009

how to set order for key fields?
Hi all, In my record there are two fields.default order format is Ascendin

29 June 2009

writing data to a flat file in csv format form database
How to write data to a flat file in csv format form database that already w

29 June 2009

peoplesoft backup
Hi all, I want to know 1.How to take BACKUP of oracle-peoplesoft database

29 June 2009

RE: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Hi , Can you tell what kind of service Operation you are using like ASynch

29 June 2009

Re: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
What is your vesrion , we are using it this functionality for EDX . Rega

28 June 2009

Re: Creating SQL View
Hi, When you are using an order by clause in a view there is a small restri

28 June 2009

RE: UPK
Hi Larry, I, too, tried to download your Powerpoint Guide but was unsuccess

27 June 2009

Time and Labour
In the Payable Time component,i need to bypass the search page(TL_MNG_APRV_

27 June 2009

ORA-01722 :Invalid Number
Hi , I am getting an SQL Error " ORA-01722 :Invalid Number " while fill

26 June 2009

RE: Importing data from XML file in App.engine
Do not include explicit "commit"s in the code. This is handled by the compo

26 June 2009

work record with scroll/grid
Greetings - I have an inquiry page that consists of a single work record

26 June 2009

Performance problem with PC Budget Detail page with 50 or more Activities (Budget Items)
We have implemented Project Costing (release 8.9) integrated with Commitmen

26 June 2009

RE: Laod Balancing
*1966 has it for load balancing the web server. You should use a load balan

26 June 2009

RE: Problem with 'you have unsaved data on this page...' message after adding javascript
Hi Mike, I've viewed the source and the function isChanged is there. I hav

26 June 2009

RE: Importing data from XML file in App.engine
Here we go.......use the following code...it uses file layout it should wor

26 June 2009

Re: Problem with 'you have unsaved data on this page...' message after adding javascript
On Fri, Jun 26, 2009 at 04:26:56AM -0400, neil.grady via peopletools-l wrot

26 June 2009

database sql
hi, i just new to peoplesoft tools, do anyone understood how to setting app

26 June 2009

RE: Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
You should be able to adapt the functions so that you can use the file clas

26 June 2009

RE: Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
Thanks for your post about PC2XML but for that need to create iScript i

26 June 2009

RE: Laod Balancing
Are you asking how to load balanced multiple weblogic web servers or how to

26 June 2009

RE: Problem with the Process Scheduler Server
Check Tuxedo Log. There you wil find the exact error. Also check APPSRV.LOG

26 June 2009

Problem with the Process Scheduler Server
Hi folks, I can not start the Process Scheduler Server correctly. I always

26 June 2009

RE: Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
There could be many reasons but generally Integration Broker is not able to

26 June 2009

RE: Importing data from XML file in App.engine
Here we go............. &xmlFile = GetFile("\relativepath

26 June 2009

RE: jQuery and Peoplesoft
Thanks very much for your advice. I decided to just get the functionality w

26 June 2009

Problem with 'you have unsaved data on this page...' message after adding javascript
Hi all, I've added some autosave functionality to the ePerformance page EP_

26 June 2009

Re: Creating SQL View
use tablename.col_name or aliasname.col_name On Fri, Jun 26, 2009 at 11:23

26 June 2009

RE: Laod Balancing
Hi Jason, Thanks for your response...., I have done this but i want to know

26 June 2009

Creating SQL View
hi While creating sql view ,contais two record with same kay field then sq

26 June 2009

Integration Broker tools 8.49 PURCHASE_ORDER_DISPATCH. Subscription contract stays NEW
Hi All, currently we're investigating the possibility to dispatch PO's thro

26 June 2009

PSNT process scheduler unexpected boot
Hi gurus, I got a weird one here. We received email alert "The Process Sche

26 June 2009

Data Integrity Error..!!
We are facing a weird situation When ever we are doing any Promotion Change

26 June 2009

Value Propositions for Tools 8.50 & Portal 9.1
I can't access the Release Value Propositions for Tools 8.50 or Portal 9.1

26 June 2009

Sybase help on Meta-SQL Update
I am converting some app-engine Oracle SQL to Sybase. This is an example o

25 June 2009

Re: SFTP from SQR in Peoplesoft
On Thu, Jun 25, 2009 at 02:39:17PM -0400, Rod Wright via peopletools-l wrot

25 June 2009

RE: How do I find version for Peopletools and Application?
You could always ask the PeopleSoft Administrator of the system, or did the

25 June 2009

RE: SFTP from SQR in Peoplesoft
Sorry if I'm jumping in late here. We are running on a strictly Windows pla

25 June 2009

RE: SFTP from SQR in Peoplesoft
Last I checked, sFTP is not supported with PeopleSoft. There is a workaroun

25 June 2009

RE: Laod Balancing
Just continue the string psserver=app1:9000,app2:9050,app3:9100,app4:9150 p

25 June 2009

RE: Peoplesoft Cobol SQL error...GLPPPOST
Hi Terri, Yes- this is Resolution: Copy the Cobol programs from the server

25 June 2009

RE: Problem when installing PeopleTools in Unix
I do the following on an install. 1) Create the PS Home directory ensuring

25 June 2009

RE: Peoplesoft Cobol SQL error...GLPPPOST
Hi Ken, This is such great information. We've received that license agreeme

25 June 2009

PS Application Designer
Could any one advice, is there any facility to practice on PS Develpments t

25 June 2009

RE: Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
When you create a CSV file, you are really creating a TEXT file with fields

25 June 2009

RE: Peoplesoft Cobol SQL error...GLPPPOST
Navigate to PeopleTools>Process Scheduler>System Process Requests and run t

25 June 2009

RE: Importing data from XML file in App.engine
You can auto generate the peoplecode with app designer. First, create an XM

25 June 2009

RE: Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
I am creating comma separated excel file. Regards....Chandrashekhar

25 June 2009

RE: Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
I don't think there is a sheet 2 for a csv file. Only excel (xls) files hav

25 June 2009

Write data to Excel (csv ) file on sheet 1 as well as on sheet 2 .
i want to write data to exel (csv ) file on sheet 1 as well as on sheet 2

25 June 2009

RE: Need to Change the PeopleSoft Defaullt Error Message on the Sign in Page
We did some analysis and found out the error message is coming from peoples

25 June 2009

RE: How to cancel a Finalized Payroll in PeopleSoft
UPDATE PS_GP_CAL_RUN SET RUN_FINALIZED_IND = 'N', RUN_FINALIZED_TS = NULL,

25 June 2009

Re: How to cancel a Finalized Payroll in PeopleSoft
HI Srinivas, Apologies, I didnt' pick up it was a finalized run...... Acco

25 June 2009

RE: How to cancel a Finalized Payroll in PeopleSoft
Hi Shiju, Thanks for your reply. But my Question here is when we finalize t

25 June 2009

RE: How to cancel a Finalized Payroll in PeopleSoft
Thanks for your reply Shiju, but when we finalize a payroll run and go bac

25 June 2009

RE: Peoplesoft Cobol SQL error...GLPPPOST
Check ODBS exisist, and 'people' user have login access on DB Imran Barol

25 June 2009

Re: How to cancel a Finalized Payroll in PeopleSoft
To cancel an entire run, select teh Cancel check box on the Payroll/Absence

25 June 2009

How to cancel a Finalized Payroll in PeopleSoft
I want to cancel a Finalized Payroll run in poeplesoft, Can some one advice

25 June 2009

Peoplesoft Cobol SQL error...GLPPPOST
i have recently compiled cobol programs and saved all the *.gnt and *.exe f

25 June 2009

RE: Rerunning Fullsync EIPs
Hey John, I never did get that working. The particular message I was work

25 June 2009

RE: Can I define a field as boolean?
Alternatively, you can create the field as one having Translate Table Edit,

25 June 2009

RE: Integration Broker Performance help?
Thanks to the replies and suggestions. Come to find out, I was on the righ

25 June 2009

RE: Integration Broker Performance help?
One option comes to my mind is to do partitioning Second is to use dedicate

25 June 2009

RE: Can I define a field as boolean?
Toolbox peopletools-lNo! You can only use the Y/N translate values.

25 June 2009

Can I define a field as boolean?
  I know that you can create a yes/no field but I'm wondering if you can cr

25 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
That sort of works. I can transfer back to the pagelet that I was original

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
So why would Transfer not work again exactly? David Wildschuetz National

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
No, unfortunately it has to be in the same window.

24 June 2009

WIndows Shell Script error trapping
I have a Windows shell script that I call from Process Scheduler to pgp enc

24 June 2009

RE: wrapping a SQLEXEC or CreateSQL statement
Thanks to all for your input --- GetSQL works great !!! From: David via peo

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
Are you looking for it to stay in the same browser screen, or pop up a new

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
Like in an HTML area? Sure, I can do that, but I need to call this after e

24 June 2009

Re: Transferring to a URL via PeopleCode (through Portal)
On Wed, Jun 24, 2009 at 01:26:29PM -0400, beckkl via peopletools-l wrote: >

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
It isn't the URL generation that is the problem, it's the actual transfer t

24 June 2009

RE: wrapping a SQLEXEC or CreateSQL statement
You can create SQL object and then pass the variables. I used this in AE pc

24 June 2009

RE: wrapping a SQLEXEC or CreateSQL statement
Look at the GetSQL command in PeopleCode Peoplebooks. David Wildschuetz

24 June 2009

Importing data from XML file in App.engine
Anybody tried of importing data from a XML file to a psrecord in app.engine

24 June 2009

Re: wrapping a SQLEXEC or CreateSQL statement
On Wed, Jun 24, 2009 at 09:54:23AM -0700, heflerp via peopletools-l wrote:

24 June 2009

RE: wrapping a SQLEXEC or CreateSQL statement
I'm calling the sql from within pcode --- can I call a sql object from with

24 June 2009

Re: Transferring to a URL via PeopleCode (through Portal)
On Wed, Jun 24, 2009 at 11:53:13AM -0400, beckkl via peopletools-l wrote: >

24 June 2009

RE: wrapping a SQLEXEC or CreateSQL statement
How about creating a SQL object, or is the SQL logic dynamic in nature? D

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
I'm not sure that would work, since I'm transferring to a specific tab/home

24 June 2009

RE: Transferring to a URL via PeopleCode (through Portal)
Have you looked at the Transfer function instead of going via URL? David

24 June 2009

Re: wrapping a SQLEXEC or CreateSQL statement
On Wed, Jun 24, 2009 at 08:25:04AM -0700, heflerp via peopletools-l wrote:

24 June 2009

wrapping a SQLEXEC or CreateSQL statement
Does anyone know if it's possible to wrap a a SQLEXEC or pcode CreateSQL st

24 June 2009

Transferring to a URL via PeopleCode (through Portal)
I have an odd situation. I need forward the user to a url via peoplecode.

24 June 2009

Re: Integration Broker (Send an XML file to a External System)
This process is very simple now.And Since the response is via a Email, the

24 June 2009

RE: Integration Broker (Send an XML file to a External System)
Awesome, thanks for your precious words. I just received an email from the

24 June 2009

RE: Integration Broker (Send an XML file to a External System)
Actually I got a response from the third party saying that they have receiv

24 June 2009

RE: Rerunning Fullsync EIPs
Luca, I saw that you have recently posted on the challenges of executing a

24 June 2009

Integration Broker Performance help?
I am running a PERSON_BASIC_FULLSYNC between HR and CRM. It is running ver

24 June 2009

Re: Integration Broker (Send an XML file to a External System)
Sridhar,I have no experience in working on this precise issue. But If you w

24 June 2009

How to receive a csv file from an external system and store the file in whole on the server?
I would like to be able to receive a csv file from an external system, and

24 June 2009

Laod Balancing
Hi All, May i know How to configure load balancing in peoplesoft. we have

24 June 2009

Re: Integration Broker (Send an XML file to a External System)
Use peoplecode xmldoc class to built the xml and send in a sync message wh

23 June 2009

RE: Integration Broker (Send an XML file to a External System)
Appreciate your response. Here is the requirement detail: Integrating with

23 June 2009

RE: Integration Broker (Send an XML file to a External System)
Hi Sridher, Short question. Would like to know the business requirement. A

23 June 2009

Integration Broker (Send an XML file to a External System)
Hi All, I was successful in publishing a message in an XML format. But I am

23 June 2009

Re: Only the = operator in Search record
Thanks for help , but I had another doubt , what if we want to change the

23 June 2009

RE: Datamover command modifier "SET EXTRACT" - anyone use this?
Here's are some examples of the various options: SET INPUT C:\TEMP\upd77285

23 June 2009

RE: Cannot set log on data mover
I have learned that Data Mover does not like spaces in folder/file names

23 June 2009

RE: Syntax to see if a field value is changed
I would approach using either the IsChanged property or the FieldChanged fu

23 June 2009

CRM 8.4 data model
Do anyone have a link to the Peoplesoft CRM 8.4 data model (CDM), I can eas

23 June 2009

RE: Problem with MsgGetExplainText
Thanks Andy the solution works ,there is small error in the code the second

23 June 2009

Problem when installing PeopleTools in Unix
When i am installing PeopleTools 8.49 console mode in Unix server, after gi

23 June 2009

RE: Only the = operator in Search record
Is this issue is resolved or not? Thanks and regards Nidhi Luharuka __

23 June 2009

RE: How do I find version for Peopletools and Application?
Another way to get the Peopletools version is to run psreleaseinfo.exe whic

22 June 2009

Problem with long field print
hi all, please, i need help with sqr print command i have a description

22 June 2009

RE: How do I find version for Peopletools and Application?
Launch App Designer and go to Help>About Application Designer. It depends o

22 June 2009

PeopleSoft to ADP Payroll interface
Does anyone have info or resources to build an interface from PeopleSoft HR

22 June 2009

RE: How do I find version for Peopletools and Application?
go into Application Designer for the environment that you want to know abou

22 June 2009

Re: How do I find version for Peopletools and Application?
do CtrlJ on a page and that will give you the information you need. --- On

22 June 2009

How do I find version for Peopletools and Application?
I'm Oracle DBA just assigned to maintain Peoplesoft implementation. Seems

22 June 2009

RE: how do you do a union in sqr
I found the answer. I added commas in between the columns on the select fo

22 June 2009

how do you do a union in sqr
sqr union

22 June 2009

Re: Portal Discplay
Is your graph in the database? ujwaldyasani via peopletools-l wrote: > > >

22 June 2009

RE: people code and URL's
No problemo, I understand :-)

22 June 2009

RE: people code and URL's
Thank you very much Andrew - That worked! I had no idea as we are all new

22 June 2009

RE: XMLP Rupees to Word Convertor
Hi Vinay, Doing this conversion at template level seems to be difficult.

22 June 2009

Access peoplesoft level1 field from javascript
How to access a peoplesoft level1 field from a javascript

22 June 2009

RE: 64-bit and 32-bit servers
Yes you can run 64 Bit db server with 32 bit app/web/prcs server We are r

22 June 2009

RE: Portal Discplay
Thanks Mike, i manage to implement the functionality using WSRP. but i am n

22 June 2009

RE: Only the = operator in Search record
The field on the search page where you want = operator in search record fie

22 June 2009

XMLP Rupees to Word Convertor
I want to convert Indian Rupees into words in XMLP level.i want to write co

22 June 2009

RE: 64-bit and 32-bit servers
Hi Kent Thanks for your reply. Regards Michele From: Kent Nickels via peopl

21 June 2009

RE: Integration of SharePoint and PeopleSoft
What would this be used for?

20 June 2009

RE: 64-bit and 32-bit servers
You can mix and match. The only connection to app server is TCP/IP. There

20 June 2009

64-bit and 32-bit servers
Hi Would I be able to have a database server on 64-bit OS and 64-bit databa

20 June 2009

RE: Portal Discplay
Hi Mike, in Consumption Instance when i Click on "Load Gateway Connector" i

20 June 2009

RE: Portal Discplay
Thanks Mike, i am new to Enterprise Portal. i have specified the pagelet as

20 June 2009

RE: (SQR 4013) Missing operator in expression.
I am fairly new at SQR but it looks to me that your subquery is not in the

20 June 2009

RE: PeopleSoft and Internet Explorer v 7
The only problems we have experienced in IE7 is with tabbed browsing. Peopl

19 June 2009

RE: people code and URL's
Take a look at the PeopleCode function ViewContentURL.

19 June 2009

RE: PeopleSoft and Internet Explorer v 7
We ran into the same problem on IE7. The pagelet navigation no longer worke

19 June 2009

people code and URL's
anyone know how to open a new window in people code when doing a link to a

19 June 2009

Re: Only the = operator in Search record
Hi Rakeesh Even I tried to search this . It seems that we don't have this

19 June 2009

PeopleSoft and Internet Explorer v 7
We are experiencing problems with PeopleSoftv 8.9 since we have upgraded to

19 June 2009

Re: Portal Discplay
Depending on your tool set version 8.48 and above allows you to create a pa

19 June 2009

Re: jQuery and Peoplesoft
On Fri, Jun 19, 2009 at 11:26:02AM -0400, neil.grady via peopletools-l wro

19 June 2009

RE: Portal Discplay
Hi Mike, Thanks for your reply, I request you to please expand the word "WS

19 June 2009

jQuery and Peoplesoft
HI, I'm new to using javascript with Peoplesoft. I have however seen variou

19 June 2009

Re: Portal Discplay
wsrp ujwaldyasani via peopletools-l wrote: > > > Hi, > I want to create a

19 June 2009

RE: Page Field Properties Record
Thanks Arvind...It worked...

19 June 2009

RE: Push OK button in subpage via CI?
I want to run a nVision report but whitout allowing our users acces to repo

19 June 2009

RE: How do you unzip a file from an app engine program
Yes, I've logged on as the Process Scheduler User in the server and execute

19 June 2009

RE: How do you unzip a file from an app engine program
Does the Process scheduler "user account" have acess to the /opt/psuploads/

19 June 2009

RE: Push OK button in subpage via CI?
Why run via CI, could you not just use the Process Request class (this is a

19 June 2009

Push OK button in subpage via CI?
How do I push the OK button of a subpage via a CI? I want to run a report v

19 June 2009

RE: Portal Discplay
Thanks Ashish, as you have mentioned "You can always create a pagelet in Po

19 June 2009

RE: PeopleSoftServiceListeningConnector: GeneralFrameworkException
Prior to trying to open the wsdl in a browser open the GETWSDL "service ope

19 June 2009

RE: How do you unzip a file from an app engine program
I think you need to put the shell script in the PS_HOME somewhere. e.g.

19 June 2009

RE: Portal Discplay
Not really sure you can do that...... You can always create a pagelet in Po

19 June 2009

Portal Discplay
Hi, I want to create a pagelet in PeopleSoft HR instance and i want to disp

19 June 2009

RE: Query Results to File
I think we need to use prompt function for runtime prompt value. This what

19 June 2009

Delivered portal customization
When someone login to portal i want to give one popup message which tel the

19 June 2009

RE: Query Results to File
Try the below code, Local Record &aQryPromptRec; Local ApiObject &aRunQry;

19 June 2009

RE: How do you unzip a file from an app engine program
changed &exitCode = Exec("sh -c /opt/psuploads/MYDIR/unzip.sh", %Exec_Asyn

19 June 2009

PeopleSoftServiceListeningConnector: GeneralFrameworkException
Hi, I'm working on Peoplesoft FSCM release 9.0 , tools 8.49. I have configu

19 June 2009

SFTP from SQR in Peoplesoft
I have to do SFTP from SQR to remote server using peoplesoft. Anybody did t

19 June 2009

RE: Checking whether a department is in security tree
SELECT * FROM PSTREENODe WHERE SETID = :1 [SETID] AND TREE_NAME = 'DEPT_SE

18 June 2009

RE: Component Interface - limit number of rows return
Which part of the CI are you talking about (the FIND() method ?, rowset pop

18 June 2009

RE: Issues Issue with distributed processing in an SQR
I reported this problem where I was experiencing a problem with commit in a

18 June 2009

RE: Query Results to File
How about writing an A/E to access the query class, saving the output into

18 June 2009

RE: My Reports pagelet roll out
Hi Neil, Have you tried changing the option for the My Reports pagelet to "

18 June 2009

Component Interface - limit number of rows return
How can I limit only 10 rows to return when a CI is called?

18 June 2009

RE: Query Results to File
If you are on a windows platform and you have some flexibility you can writ

18 June 2009

RE: Application Engine - BI Publisher only generating data for first element in xml file
Just to follow up on this problem: This was my first application engine pro

18 June 2009

RE: (SQR 4013) Missing operator in expression.
I think you have not closed the table FROM (SELECT A.OP_LOC, D.BUSINESS_UN

18 June 2009

My Reports pagelet roll out
Hi, I am looking to make the 'My reports' pagelet available to a large grou

18 June 2009

How to exit out from app engine successfully with warning
I have some conditions in my app engine peoplecode which are if true then t

18 June 2009

RE: (SQR 4013) Missing operator in expression.
I modified the code as if $BASE_FLAG = 'Y'

18 June 2009

Query Results to File
We have several queries which we need to turn into files on our ftp server.

18 June 2009

RE: RE:Tuning PY_PULL_COST
Another way to do this rather than dropping the index is to perform an inse

18 June 2009

RE: POSITION_DATA - Custom fields on Component
no problem, happy to (try and) help :)

18 June 2009

RE: Tuning PY_PULL_COST
I got this tuned for an Oracle environment, if you are still interested aft

18 June 2009

RE: Page Field Properties Record
Hi, You can find it in PSPNLFIELD where pnlname = '' Regards, Ar

18 June 2009

What happens when you make a control account a non-control account?
We want to know if there are any downstream affects to making a control acc

18 June 2009

RE: POSITION_DATA - Custom fields on Component
Andrew, Thank you for all your help. I ended up putting a custom group b

18 June 2009

Need to Change the PeopleSoft Defaullt Error Message on the Sign in Page
When you disable a language in the PeopleSoft and you try to login to Peopl

18 June 2009

Page Field Properties Record
Does PeopleSoft Store the Page Field Properties in any particular record. I

18 June 2009

RE: PSJob of delivered Crystal and custom SQR
Sorry for the late reply -- ITToolbox stopped sending me e-mails, and I for

18 June 2009

RE: Call system command in SQR
I don't know if this will be helpful or not, but environmental variables fo

18 June 2009

How do you unzip a file from an app engine program
I am going to process several txt files through an app engine program. The

18 June 2009

RE: Peoplesoft dynamic view
You don't really need the WITH. From looking at your sql you are basically

18 June 2009

Checking whether a department is in security tree
Hi all, we sometimes have issues with departments being not in security tre

18 June 2009

RE: Sendmail(), problem in 'From'
Yes, I did that and it worked fine. Thanks for responding. Amit

18 June 2009

Re: Sendmail(), problem in 'From'
Toolbox peopletools-lDid you try the Sender vs the From? B ----- Original

17 June 2009

RE: Peoplesoft dynamic view
The SQL you are trying to use as a dynamic view may be too complicated. I'v

17 June 2009

RE: Audit Logs
I guess it depends on what your SQLExec() is doing. If it is just doing a o

17 June 2009

Peoplesoft dynamic view
Hello, Please help me with this view. I have created a dynamic view base

17 June 2009

RE: modules of Peoplesoft version 9.0
You can check this page to see what PeopleSoft Enterprise Applications are

17 June 2009

RE: Audit Logs
This is an inherit issue with SQLExec and other means of "non component pro

17 June 2009

RE: modules of Peoplesoft version 9.0
Nedd more info... In what product suite? (And then keep in mind every mo

17 June 2009

Audit Logs
I've set up an audit log to record all activity on a record. This audit lo

17 June 2009

Sendmail(), problem in 'From'
Friends I am trying to use sendmail function to send emails in an app. engi

17 June 2009

RE: scheduling PS query
could you please share your alternate way of doing this?

17 June 2009

RE: pcode to send an email when sql condition is met
Create step with 2 action Do when Peoplecode In do when paste following

17 June 2009

Re: pcode to send an email when sql condition is met
Use Do When followed by PeopelCode event.. On Tue, Jun 16, 2009 at 4:41 AM,

17 June 2009

RE: pcode to send an email when sql condition is met
We do that a lot from within some custom apps. We tend to use email distri

17 June 2009

modules of Peoplesoft version 9.0
Can someone give me the list of modules that are delivered within the Peopl

17 June 2009

RE: Consolidate into 1 row - Oracle
Hey Don Thanks very much, that worked a treat! Andrew

17 June 2009

RE: Peoplecode error : Invalid row number 1 for class Rowset method GetRow
Hey just try to make following modification. Function Set_Image_ToolTip

17 June 2009

RE: Peoplecode error : Invalid row number 1 for class Rowset method GetRow
Try using this.. Function Set_Image_ToolTip(&FIELDNAME); If &RESUME_I

17 June 2009

RE: POSITION_DATA - Custom fields on Component
Does your new field (which has been added to the CI) have the prefix "PROP_

17 June 2009

Peoplecode error : Invalid row number 1 for class Rowset method GetRow
I am writing this peice of code in a function, which is causing an error "

17 June 2009

RE: Want a logic of how journal id is getting generated in General Ledger Module.
Amit, One more doubt, In journal upload file we can also provide the journ

17 June 2009

RE: Want a logic of how journal id is getting generated in General Ledger Module.
Thanx amit , I was also finding the same. Regards....Chandrashekhar Fro

17 June 2009

RE: Want a logic of how journal id is getting generated in General Ledger Module.
Thanks a lot for your help. Thanks and regards Nidhi Luharuka People Soft

17 June 2009

RE: Want a logic of how journal id is getting generated in General Ledger Module.
Hi, To create new Journal we use JOURNAL_ENTRY1 page. On this page we have

17 June 2009

Want a logic of how journal id is getting generated in General Ledger Module.
eam, Please let me the know the logic of journal id generation process in g

17 June 2009

RE: scheduling PS query
Thanx for your post. But we have got another way to get around this. Rega

17 June 2009

RE: Customizing Verity Search Engine
Hi, As Shahzad said, if you are using multiple App Servers & your Batch ser

17 June 2009

RE: Customizing Verity Search Engine
I am trying to seutp Verity Search Engine to work with multiple application

16 June 2009

Re: Consolidate into 1 row - Oracle
Hi Andrew, Try something like this: select a.tree_node , a.tree_node_num ,

16 June 2009

Consolidate into 1 row - Oracle
Hi there, I am looking at this requirement which is to provide for each emp

16 June 2009

RE: Job stuck in QUEUED Status
We've run into this issue a handful of times as well... recurring job is st

16 June 2009

RE: Job stuck in QUEUED Status
First, check the process monitor to see what process scheduler you have it

16 June 2009

RE: Does anyone know whether or not PeopleSoft is certified for use with Microsoft Windows 7?
Windows 7 isn't due out until October. I'd be surprised if it was on the s

16 June 2009

Job stuck in QUEUED Status
How do I get a Process that is stuck in QUEUED status to run? Thanks, Jac

16 June 2009

Does anyone know whether or not PeopleSoft is certified for use with Microsoft Windows 7?
Does anyone know whether or not PeopleSoft is certified for use with Micros

16 June 2009

format of psoft user_account OPRID
we have SA, HR, and the FS suite of peoplesoft applications running ------

16 June 2009

RE: SavePostChange versus FieldChange
Hi Bob, First thing I would not recommend doing any kind of save in the Fie

16 June 2009

RE: AP - Voucher entry CI
Were you successful with the VCHR_Quick_pnl? I am having trouble with the

16 June 2009

RPTBOOK in PSJob gets Not Posted status
Following our upgrade from PeopleTools 8.45.19 to PeopleTools 8.49.16, PSJo

16 June 2009

RE: scheduling PS query
Have a look at the solution posted on Grey Sparling's site: http://blog.gre

16 June 2009

SavePostChange versus FieldChange
If I have a button at level 1 in a page, which is supposed to perform vario

16 June 2009

RE: POSITION_DATA - Custom fields on Component
Here is adding to the craziness... If I test the CI in App Designer, a

16 June 2009

RE: POSITION_DATA - Custom fields on Component
That logic is on POSITION_DATA.STEP.SPo. Anyway, it might be new to v9 or a

16 June 2009

RE: POSITION_DATA - Custom fields on Component
Where is that logic? When changing the custom fields, the CI is not being

16 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Yes even I was thinking the same. Thanks and regards Nidhi Luharuka Peopl

16 June 2009

RE: POSITION_DATA - Custom fields on Component
We're on v9 HCM and I can see it is using the CI but there is a check befor

16 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Hi Nidhi, Are you running this from an Application Engine? You can try a co

16 June 2009

RE: pcode to send an email when sql condition is met
there is a delivered AE called PT_AMM_WF. It works using standard role base

16 June 2009

Call system command in SQR
How call system command is used in SQR. Actually I have written one SQR wh

16 June 2009

RE: SQC and SQR Difference
as they're compiled which is quick I doubt you'd lose any performance. Mayb

16 June 2009

Call system command in SQR
Call system command in SQR

16 June 2009

RE: Crystal report customize group name
there are a few method to do this. one of this is using formula. create a

16 June 2009

RE: scheduling PS query
We done this but using this only link is getting send in mail. Regards...

16 June 2009

Re: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Andy,     Try to do the below settings. And one more thing, in PSAPPSRV set

16 June 2009

RE: pcode to send an email when sql condition is met
Hi, AE is good way to automate this request OR you can also use the SQR too

16 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Andrew, The problem I was assigning the value of %EDITTABLE at page activ

16 June 2009

RE: pcode to send an email when sql condition is met
Pete, you've described the exact way (the A/E route) that I would code it a

16 June 2009

How to setup Verity Search using multiple application servers.
I am trying to setup Verity Search using multiple applicaiton servers. I ha

16 June 2009

RE: SQC and SQR Difference
If we keep sqrs in one folder and sqc's in another folder will the perfoman

16 June 2009

pcode to send an email when sql condition is met
we are currently running the sql below (manually) on a daily basis to ident

15 June 2009

RE: POSITION_DATA - Custom fields on Component
It is using the delivered CI. I have had to update the delivered CI with t

15 June 2009

RE: POSITION_DATA - Custom fields on Component
I think from memory it wouldn't update a job record that had the override p

15 June 2009

RE: POSITION_DATA - Custom fields on Component
We are on HRMS 8.9 PT 8.48. ________________________________ From: Ken

15 June 2009

POSITION_DATA - Custom fields on Component
I have added a custom page to the POSITION_DATA component. I have added cu

15 June 2009

RE: Correspondence Mgmt:Use RBC_REQUEST_API to submit auto print letters from PC
I forgot to add I am using CRM 9.0 PT 8.49.08. I would appreciate any help

15 June 2009

Re: Integration Gateway - HttpTargetConnector:ExternalApplicationException. Http status code HttpStatusCode returned: 500
Go to the gateway and open errorLog.html and see what the error says. allti

15 June 2009

Integration Gateway - HttpTargetConnector:ExternalApplicationException. Http status code HttpStatusCode returned: 500
I generated the SOAP request message using peoplecode and validated it. It

15 June 2009

RE: Accessing tree using PeopleSoft Query
Thank you so much, Don. It's just what I need! From: Don Barclay via pe

15 June 2009

Re: scheduling PS query
Good morning,       If you were to add the Query to a nVision Tabular Layou

15 June 2009

Re: Accessing tree using PeopleSoft Query
Sure. Just query the table PSTREENODE. You'll need to specify the tree (

15 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Hi Suman, "Can you check the Minimum and Maximum Instances of PSAPPSRV proc

15 June 2009

Market Rates and automating loading the rates
(We're on release 9.0, Tools 8.49, but tools version not really important f

15 June 2009

RE: Integrity Error on Search page
Hi Ken I'm getting the same "Deserialization integrity failure: "error mess

15 June 2009

RE: Issues Issue with distributed processing in an SQR
So are you using the "do Commit-Transaction" and have the #include 'tranctr

15 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Hi Suman, "Can you check the Minimum and Maximum Instances of PSAPPSRV proc

15 June 2009

Accessing tree using PeopleSoft Query
Hello, I can't seem to figure out how to do this. We're in HCM 8.9, Peopl

15 June 2009

RE: Exec function issue while using 'lp' unix command
hi, I have used the EXEC command to copy one file to another folder. The sy

15 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
So what was the problem??

15 June 2009

RE: scheduling PS query
Yes, we're on Tools 8.49, release 9.0. Just setup the Distribution and be

15 June 2009

RE: RE:Issues Issue with distributed processing in an SQR
We had the commit being processed in a begin-sql statement. When we got t

15 June 2009

RE: Project Compare
Very good solution! I've created a user called PSPT - PeopleSoft PeopleTool

15 June 2009

RE: Issues Issue with distributed processing in an SQR
Well... are you actually calling the 'commit' procedure in your mainline c

15 June 2009

RE: (SQR 4013) Missing operator in expression.
Don is right, &AAI does not belong in the first variable. Also, the in-line

15 June 2009

Correspondence Mgmt:Use RBC_REQUEST_API to submit auto print letters from PC
I am trying to use the RBC_REQUEST_API to have letters generated once the u

15 June 2009

Re: (SQR 4013) Missing operator in expression.
For starters, replace the four quotes with a double quote. And I cannot t

15 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Thanks Andrew. The query is resolved. Thanks and regards Nidhi Luharuka

15 June 2009

scheduling PS query
scheduling PS query we have distributed scheduled query result ,user are ge

15 June 2009

RE: My Reports PAgelet
Thanks Mark, That seems to have worked to a certain extent however once I s

15 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
What I mean by "if it is set" is that you must be setting the record name f

15 June 2009

(SQR 4013) Missing operator in expression.
I am working on modifying an existing SQR report. I am using dynamic variab

15 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Andrew, That correct I have two edit box on my page one is for operating un

15 June 2009

RE: CI - create a mirror table and store the health_benefit records that matches by a criteria
Thank you! for your reply Sid, this is true in terms of functionality. Plea

15 June 2009

Re: GetNextStateRecord and SamCreateSecondary ---- Fail to obtain Second DB connection
we are in 8.49 tools and peoplesoft recommends not to use getnextnumberwith

14 June 2009

RE: CI - create a mirror table and store the health_benefit records that matches by a criteria
It depends what the purpose of second table is, if the second table is used

14 June 2009

RE: GetNextStateRecord and SamCreateSecondary ---- Fail to obtain Second DB connection
GetNextNumberWithGapsCommit is a function which opens a second DB connectio

14 June 2009

GetNextStateRecord and SamCreateSecondary ---- Fail to obtain Second DB connection
2009-06-14-14.10.10.281871 SearchArchive [1141] Exception logged: RC=3. 20

14 June 2009

Issues Issue with distributed processing in an SQR
We have a SQR which processes on our production server and updates a databa

13 June 2009

CI - create a mirror table and store the health_benefit records that matches by a criteria
1. I need to create a mirror table and store the health_benefit records tha

12 June 2009

RE: Userid issues - User's test id gets carried over to production browser
Interesting, I would like to know the report id or a reference number to th

12 June 2009

Re: Userid issues - User's test id gets carried over to production browser
This is a known issue. There is a fix on peoplesoft CC Manu via peopletools

12 June 2009

RE: Is there a PeopleSoft table that records a date/time stamp when a query is run using PS/Query?
You can get this info from 4-tier. Go to PeopleTools>Utilities>Query Admin

12 June 2009

RE: Userid issues - User's test id gets carried over to production browser
Normally you have single signon set up by setting the trusted nodes. By def

12 June 2009

Userid issues - User's test id gets carried over to production browser
Greetings all... We are on PS HCM 8.9 Tools 8.47x. Here is a pecular situat

12 June 2009

RE: PS Centralized Administration
Are you running all your tiers on windows?

12 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
You need to be able to look at the database and see what is going on there,

12 June 2009

CI - health enrollment
1. I wanted to test writing a CI say I have a table with emplid's and using

12 June 2009

Candidate Gateway Advanced Search
Has anyone had success adding the subpage HRS_APP_SCHJB_R_SP (Advanced Sear

12 June 2009

RE: PeopleSoft Roles
Not sure exactly what you are looking for. If you want to know what access

12 June 2009

RE: Is there a PeopleSoft table that records a date/time stamp when a query is run using PS/Query?
If you turn on the audit option for the query then you can access that info

12 June 2009

Is there a PeopleSoft table that records a date/time stamp when a query is run using PS/Query?
Is there a PeopleSoft table that records a date/time stamp when a query is

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
So you have two edit boxes? One is for Operating Unit and one is for Develo

12 June 2009

RE: I have to use a grid when the option is selected as 'List'?
If you place a group box around a grid, and associate the group box to the

12 June 2009

RE: I have to use a grid when the option is selected as 'List'?
Can you please share some more details about requirements

12 June 2009

I have to use a grid when the option is selected as 'List'?
I am trying to modify a page. It has to display an edit box when the option

12 June 2009

RE: Exec function issue while using 'lp' unix command
Hi John, I too faced the same issue while printing a file to printer on Uni

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Sorry not working. Thanks and regards Nidhi Luharuka People Soft Finance

12 June 2009

RE: Cobol Error : 114 Attempt to access item beyond bounds of memory (Signal 10)
Hi, 1.Take a replica of pscbl.mak. Let us say, pstest.mak 2.Add the flag -N

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Select type as prompt table with no edit for sub location field. Hope this

12 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
I saw some stuff on customer connect about PSPAL and it might be connected

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
No I cant do that. I wanted prompt for the sublocation too. Thanks and re

12 June 2009

RE: SQR Process Error
You must be using the PeopleSoft log in access to run this SQR. While your

12 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Looking at the Server Status in PSADMIN show this: ------------------------

12 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Here is the psappsrv.cfg, if anyone can see anything inside that which coul

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Try using selecting no edit radio button for sub location only. Regards.

12 June 2009

Re: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Can you check the Minimum and Maximum Instances of PSAPPSRV process in psap

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Hi, I m already doing this. System edit is getting fired when I m inserting

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
In table edit group box u have tree field type , prompt table , set contro

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Thanks Chandrashekharw for replying. I using %editable in Record field edit

12 June 2009

RE: How to display the correct error in CI if fields prompt are interrelated
Use prompt table edit option in record field edit properties of location an

12 June 2009

How to display the correct error in CI if fields prompt are interrelated
Hi, In the page i have two feilds Operating unit(Location id) and Developme

12 June 2009

RE: how to generate barcode in peoplesoft
thanks Imran

11 June 2009

RE: how to generate barcode in peoplesoft
thanks Vasavi. We are working on this.

11 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
I have this fixed. Our portal demo was working fine on that tab so I migrat

11 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
Thanks Andrew, the sql trace or peoplecode trace did not help much. Here is

11 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
I'd just check the last thing that happens in the log. Something must be ha

11 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
Hi Andrew, It always happen when I click on the Dynamic Members tab. It doe

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Andy, There are no magic bullets, and there are a lot of things to check in

11 June 2009

Custom Journal upload Excel to CI
Hi All We need to customize peoplesoft delivered JV forum and we want to

11 June 2009

RE: Time out issue with the Dynamic Members tabs in Role in Portal 9.0
I assume this didn't always happen? Can you set PeopleCode tracing on befor

11 June 2009

RE: SET VERSION_DAM 8.4
Thanks for posting this - I think the key here is copying the first TWO lin

11 June 2009

Re: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
There is no need to do anything with the log files on a 10g database. Can y

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Andy, We are on a SQL Server 2005 platform and I see that you are on an Ora

11 June 2009

Time out issue with the Dynamic Members tabs in Role in Portal 9.0
Hi all, I am having a weird problem. When I go to PeopleTools > Security >

11 June 2009

Re: Data Mover Script - with specific select
yes take the first select export is the first select. EXPORT PS_JOB WHERE

11 June 2009

Data Mover Script - with specific select
I am trying to create a script that will get specific data from ps_job_jr w

11 June 2009

Made changes to activity in workflow but it is not trigerring, bounced app server and calso cleared app server cache
I added a new step and made changes to the existing step but the changes ar

11 June 2009

PS Role Descriptions
Can anyone supply a description for the PS role names UPG_APPNLS, Process I

11 June 2009

PeopleSoft Roles
Anyone have informaiton with regards to a descriptoin for the role names UG

11 June 2009

Re: Peoplesoft HRMS 9 Installation
Yes but you will have to create the db manually if you download the instal

11 June 2009

RE: Peoplesoft HRMS 9 Installation
Then Can I install SQL Server 2005 and will Peoplesoft 8.48 will support t

11 June 2009

Hoe to make use of BAPI_PO_CREATE1
Dear All, There is an Object to me that i need to pick the data from

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Hi Ken, What's the log name of the log you're referring to as the 'database

11 June 2009

Re: Peoplesoft HRMS 9 Installation
SQL 2000 doesn't run on XP Ranjeet Shinde via peopletools-l wrote: > > > S

11 June 2009

RE: Peoplesoft HRMS 9 Installation
SQL Server 2000. From: mbyrne via peopletools-l [mailto:peopletools-l@Gro

11 June 2009

RE: Need an efficient query to get all Emplids IDs under a manager..
I understand that you want an SQL query. Here is an example using the posit

11 June 2009

Re: Peoplesoft HRMS 9 Installation
What version of your db Ranjeet Shinde via peopletools-l wrote: > > > > Hi

11 June 2009

Data Integrity Error
Hello, Our production users are sometimes receiving a Data Integrity Erro

11 June 2009

RE: Date time stamp for table updates
Hi, There is property of row ischanged(). Use it. Thanks and regards Nidh

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
We have around 250 users also and one thing that has slowed our PeopleSoft

11 June 2009

Date time stamp for table updates
We have a table that gets updated periodicaly. We added a column to the tab

11 June 2009

RE: Need an efficient query to get all Emplids IDs under a manager..
Hi Nisayle, Thanks for your reply... Could please give any pseudo code to w

11 June 2009

RE: Need an efficient query to get all Emplids IDs under a manager..
Hi Srinivas, I suppose that your hierarchy is based on position number onl

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
CRM 8.4, Tools 8.40.09 on Oracle 10g. There are approx 250 users a peak ti

11 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
CRM 8.4, Tools 8.40.09 on Oracle 10g.

11 June 2009

Need an efficient query to get all Emplids IDs under a manager..
I need ideas on solving a peculiar and interesting issue. . The requiremen

11 June 2009

Re: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Andy,    First off all , can you let me know approx. how many users use the

11 June 2009

RE: Peoplesoft HRMS 9 Installation
Hi, Operating System is windows XP. ? Thanks & Regards ... Ranjeet Shin

11 June 2009

Syntax to see if a field value is changed
Hi, I have requirement. please suggest the right syntax to use. On save pr

11 June 2009

RE: how to silently print PDF using peoplecode
I would simply write a generic dos batch program to pickup the files and pr

11 June 2009

RE: VM Ware Architecture
I'm not sure if you were looking for PeopleSoft specific answer, but I have

11 June 2009

RE: PSJob of delivered Crystal and custom SQR
Check the server you specified on the SQR, Crystal and the Job. A combinati

11 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
You can simply use redirectURL function. Example : %Response.RedirectURL(&U

11 June 2009

Re: Cannot set log on data mover
Or you could go the simple route and just put in a full network path to you

10 June 2009

RE: No SQL statement in SQR error log.
In the case of the process you are running, FIN2001.SQR, the error on line

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
Just for kicks, try giving yourself access to the permission list PTPT1000

10 June 2009

RE: PSJob of delivered Crystal and custom SQR
Yes, I mean that the SQR and the Crystal run by themselves via Process Sche

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
Yes, I granted full access to my custom WEBLIB, and now have full access to

10 June 2009

RE: run server reports from page are running at future date
Crystal reports are generally built using the output of a query. The query

10 June 2009

RE: AE reuse parameter causing different / incorrect results ?
We figured out what it was. We put "reuse" on a statement that was using a

10 June 2009

RE: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
This might not be the issue for you, but we have had this type of "random"

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
I've been told you also need to add full access to the following WEBLIBS in

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
And just to verify, you edited the WEBLIB in the permission list and grante

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
Sorry, yes I added the WEBLIB to a permission list that I have access. I h

10 June 2009

Re: Cannot set log on data mover
You are probably running dm from a network. How to bypass is to launch con

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
When you say 'I have granted access to the WEBLIB I developed', do you mean

10 June 2009

Cannot set log on data mover
Hi, I need help on setting a log on datamover. It seems that my data mover

10 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
I have been looking for a way to do a pop-up with some control on the pop-u

10 June 2009

Re: User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
What version of the PS and what version and vendor of the database Andy via

10 June 2009

Re: Peoplesoft HRMS 9 Installation
What is the operating system and what is the database version? Ranjeet Shin

10 June 2009

User complain Peoplesoft is running very slowly What steps to go through to diagnose reason for slowness.
Hi, If a user/group of users informs you the Peoplesoft is running slow or

10 June 2009

RE: Dynamic Path in AWE
Interesting. I made the approach of using a Static path and defined seven

10 June 2009

Peoplesoft HRMS 9 Installation
Dear All, I am trying to install Peoplesoft HRMS 9 Installation on my PC. I

10 June 2009

RE: VM Ware Architecture
In our environment we used VMWare all (production and test) of the web and

10 June 2009

Re: VM Ware Architecture
I did a bench mark on VM/Linux and VM and MS2003. running 64 bit for the da

10 June 2009

RE: How do I get an SQR to run on the client.
To add to what's been said, you might also need the DB connection stuff on

10 June 2009

RE: VM Ware Architecture
We experimented with Oracle database (9.2) on VM Ware for PeopleSoft and pe

10 June 2009

VM Ware Architecture
The majority of my clients and DBA friends who use Virtual Machine utilize

10 June 2009

How to work on Pagelets?
How to work on pagelets in Peoplesoft? I need a novice tutorial site or mat

10 June 2009

RE: How do I get an SQR to run on the client.
The "Client" location is a hold-over from old versions of PeopleTools (7.x

10 June 2009

RE: Is windows vista compatible with peoplesoft v9.0
Good morning: I run Vista on my laptop and have had no issues interacting

10 June 2009

RE: Is windows vista compatible with peoplesoft v9.0
Yes I believe its workable...I know some of my colleagues using VISTA as th

10 June 2009

RE: AE reuse parameter causing different / incorrect results ?
Not the same issue but I once had problems using the BulkInsert property of

10 June 2009

RE: How do I get an SQR to run on the client.
what version of PeopleTools are you running? I don't think from PT 8 onward

10 June 2009

RE: Is windows vista compatible with peoplesoft v9.0
on my massively underspec'd laptop I am running PT 8.49.21 and HRMS V9 with

10 June 2009

Re: Data Mover Fails on PSXLATITEM
Hi, Can you insert "SET UPDATE_DUPS;" statement in your datamover scripts a

10 June 2009

Data Mover Fails on PSXLATITEM
hi. while creating a demo or system DB with data mover. Both of them failed

10 June 2009

AE reuse parameter causing different / incorrect results ?
Has anyone ever seen the setting of the "reuse" parameter on AE SQL stateme

10 June 2009

How do I get an SQR to run on the client.
I have created an SQR that creates a PDF file that contains payroll data sp

9 June 2009

Is windows vista compatible with peoplesoft v9.0
is windows vista compatible with peoplesoft v9.0

9 June 2009

RE: Talent Acquisition - HRS APP PROFILE and HRS APPLICANT gets out of sync.
Prakash, How did you connect the App Profile to the Resume? Can you send m

9 June 2009

RE: Dynamic Path in AWE
Toolbox peopletools-lWould you be able to post your customization to the ap

9 June 2009

how to silently print PDF using peoplecode
Hello gurus, I need to print PDF check file . The file currently resides in

9 June 2009

RE: Exec function issue while using 'lp' unix command
We had a similar problem on NT and it was because PS was always prepending

9 June 2009

RE: Errors were encountered while this transaction was trying to save to the database.
If I'm remembering correctly, you should be able to access the administrati

9 June 2009

Re: AWE (HCM9.0) multiple approvers in single step
How we can use pooled worklist please explain? On Tue, Jun 9, 2009 at 1:19

9 June 2009

RE: PSJob of delivered Crystal and custom SQR
Just to be certain, you mean that the SQR and the Crystal run by themselves

9 June 2009

RE: No SQL statement in SQR error log.
The log does show the line number, which in this case is 56. Sometimes it

9 June 2009

RE: Dynamic Path in AWE
I have an approval process for job openings that has 1 stage, 1 path and 3

9 June 2009

Exec function issue while using 'lp' unix command
Hello, I am trying execute EXEC command to use 'lp' unix command to print a

9 June 2009

How Process scheduler figures out Server name for CreateProcessRequest
Hi , We have the function bellow that prints crystal report. For some users

9 June 2009

RE: How to make an Icon invisible using peoplecode?
Is the icon an image on a pushbutton? If so, hide the pushbutton.

9 June 2009

RE: How to make an Icon invisible using peoplecode?
1. Place the icon in a Group Box, setting the Group Box's properties

9 June 2009

RE: How to make an Icon invisible using peoplecode?
Insert an HTML object at the bottom of the page with javascript code to hid

9 June 2009

RE: PeopleSoft Distribution Node has invalid value for operating system
hi. it is supported on 32 bit for APP and Batch. for DB 64... i had a look

9 June 2009

InfoSync Client Issue
Hi All, We are implementing InfoSync client (version 5.5) onto PS8.49/CRM9.

9 June 2009

Re: My Reports PAgelet
Try this menu/click path PeopleTools > Portal > Structure and Content > Po

9 June 2009

My Reports PAgelet
Hi All, I have myself up with access to the My Reports pagelet and can see

9 June 2009

RE: PeopleSoft Distribution Node has invalid value for operating system
The table PS_CDM_DIST_NODE is populated once you set up a distribution node

9 June 2009

Errors were encountered while this transaction was trying to save to the database.
Hello, I am trying to perform termination trasaction through MSS, I gettin

9 June 2009

RE: AWE (HCM9.0) multiple approvers in single step
USE POOLED WORKLISTLIST .. Regards....Chandrashekhar From: peoplesoft

9 June 2009

RE: PeopleSoft Distribution Node has invalid value for operating system
thanks for the reply. I really appreciate it... I went into the DB to have

9 June 2009

How to make an Icon (not a Field) invisible using peoplecode?
Hi...I have a requirement in which I have to make a particular icon disappe

9 June 2009

How to make an Icon invisible using peoplecode?
Hi...I have an requirement in which i have to make particular 'Icon' (Not f

9 June 2009

RE: No SQL statement in SQR error log.
There are many ways to find out what line the error is. Use the -s flag, wh

9 June 2009

No SQL statement in SQR error log.
Hi, I'm having a problem with an SQR error log. I can easily see the error

8 June 2009

RE: AWE (HCM9.0) multiple approvers in single step
Your question needs some more clarity. When will be considered as Transacti

8 June 2009

RE: Problem with java OutOfMemory
could you please send me the document also. we are also seeing same error.

8 June 2009

RE: AWE (HCM9.0) multiple approvers in single step
By design, once any approver in the chain denies the transaction, the trans

8 June 2009

RE: PeopleSoft Distribution Node has invalid value for operating system
Report Node's Operating-System is based on the CDM_DIST_NODE record/table

8 June 2009

AWE (HCM9.0) multiple approvers in single step
Hi All am having workflow of 4 level in which last step contains multiple a

8 June 2009

RE: DYNROLE Issue
We were able to finally get a good GSC response on this issue (after closin

8 June 2009

RE: Dynamic Path in AWE
If your requirement is that All approvers must approve but if One denies (o

8 June 2009

RE: PSJob of delivered Crystal and custom SQR
1) Yes, the SQR reports fine by itself. [And the Crystal runs ok on its ow

8 June 2009

RE: Duplicate Batch processes running at the same time
Hi Meng, I think this calls for a better planning of the batch window. We h

8 June 2009

RE: Menu Pagelet help
This did help, I was able to remove the button I was referring to. Thanks!

8 June 2009

RE: Duplicate Batch processes running at the same time
Just a guess but try clearing the process scheduler cache. We've had quirk

8 June 2009

RE: DYNROLE Issue
We were having all kinds of problems with DYNROLE_PUBL after implementing d

8 June 2009

RE: PSJob of delivered Crystal and custom SQR
Two thoughts: 1) If possible, try running the SQR by itself. Maybe the PS

8 June 2009

RE: Duplicate Batch processes running at the same time
Hi , Since there are multiple batch processes running during night times, i

8 June 2009

RE: SQL Error while choosing value from Dynamic view
plz send SQL error...

8 June 2009

RE: Dynamic Path in AWE
Francis Try this; 1.) Create an Approver User List 2.) x number of Approver

7 June 2009

Re: Dynamic Path in AWE
Though it 4 approvers are created in single shot, AWE routes to oe person o

7 June 2009

PeopleSoft Distribution Node has invalid value for operating system
Hi. I setup Ptools 8.49 and HRMS on suse linux 10.(Demo Database, DB2) I a

7 June 2009

Dynamic Path in AWE
We are trying for a dynamic path in AWE ( Approval Workflow Engine) in FSCM

7 June 2009

Question about tunning Weblogic 9.1 on PT 8.49
I have a specific question about Weblogic 9.1 and the way that it is instal

6 June 2009

Duplicate Batch processes running at the same time
Hi all, In our production, multiple nightly run batch processes are schedul

6 June 2009

RE: DYNROLE Issue
I have seen issues where dynamic roles were working and then they stopped.

6 June 2009

RE: application desiger record attributes output
You could also export your project to a file and then parse the XML that is

5 June 2009

RE: Generating Multiple Reports in SQR
First, let me say that I haven't kept up with this trail. However, you can

5 June 2009

RE: Text formatting before send email - Online Peoplecode.
You can include the html tags in the body of your text for all the formatti

5 June 2009

RE: application desiger record attributes output
The closest you'll get is by querying or creating a view against psxxx tabl

5 June 2009

RE: Looking for Delivered Web Services
Take a look at this...might help http://www.wsdll.com/?gclid=CKzPqZab6ZoCFR

5 June 2009

RE: Generating Multiple Reports in SQR
Is your SQR coded to generate multiple reports. I mean you can generate mu

5 June 2009

PSJob of delivered Crystal and custom SQR
I've never had to combine 2 reports before, so... What is needed for putti

5 June 2009

RE: Generating Multiple Reports in SQR
"I tried giving on parametes list "-MR n" in the override options page... I

5 June 2009

RE: How do Derived Tables get built and populated?
Further to Phil's comments, I seem to recall reading in PeopleBooks that th

5 June 2009

Problem With WorkFlow - Version 8.0 Financials (Argentine Localized)
Good Morning, We have a Problem. We have Workflow in AM (Asset Management)

5 June 2009

RE: SQL Error while choosing value from Dynamic view
You don't mention what the error is. My guess is that the system is valida

5 June 2009

RE: How do Derived Tables get built and populated?
Now now, Denise. Those of us that maintain the payroll and ben admin COBOL

5 June 2009

RE: SQL working in QL developer by not thru SQR
I agree that a likely culpris it $lastpayenddt. Where is that coming from?

5 June 2009

RE: How do Derived Tables get built and populated?
yuri wrote: "Think of it as the WORKING-STORAGE section (anyone still remem

5 June 2009

RE: nVision hangs in Excel 2000
Application version doesnot support excel 2000. You have to use the latest

5 June 2009

nVision hangs in Excel 2000
Client recently upgraded from 8.47 to 8.49 tools, During testing we noticec

5 June 2009

RE: blanking out oprid on signin page
This setting can configure through web profile Imran Barolia __________

5 June 2009

Recover access id password
Hii All, I jus forgot my peoplesoft database access id password

5 June 2009

SQL Error while choosing value from Dynamic view
Iam using a dynamic view to act as a prompt . The prompt needs to display

5 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
I need popup window without address bar and menu and also i should able to

4 June 2009

Text formatting before send email - Online Peoplecode.
Hello, I have created a custom page to send emails usind sendmail() functio

4 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
You really don't need to use javascript, unless you want a popup window wit

4 June 2009

RE: Grid column header sort doesn't update rowset buffer sort order
no one knows? or is it not just possible?

4 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
I'm not sure I understand completely.... Are you just wanting to pop-up a

4 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
Thank you so much. I am succesfully able to dipay popup.What url i need to

4 June 2009

RE: blanking out oprid on signin page
Set "Days to Auto Fill User ID" to zero on the Web Profile Security Page. I

4 June 2009

blanking out oprid on signin page
has anyone done this? you know, after log out or timeout, when you return

4 June 2009

RE: SQL working in SQL developer tool but not in SQR
also, you'll want to make sure that your date variable is in the same forma

4 June 2009

application desiger record attributes output
does anyone know how a file be created from application designer that would

4 June 2009

RE: Query item count is bad - error in migration
Thanks Roy! This helped reduce the manual work of removing queries one by o

4 June 2009

RE: Candidate Gateway - Duplication check
I would have a look at the App Engine HRS_DUPE_PRC to start. The process li

4 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
Oops.....the first line of the HTML object should be

4 June 2009

RE: Candidate Gateway - Duplication check
Hi John, Could you please provide me some more details and purpose of that

4 June 2009

RE: How to get a pop up when we click a a hyper link on a page?
One way is to use the GenerateScriptRelativeURL. The following two lines,

4 June 2009

RE: Candidate Gateway - Duplication check
Hi All, Thanks for your thoughts. We are now trying to restrict at the time

4 June 2009

RE: Windows 64-bit
We are using SQL 2005 (64-bit). Our production system is the Enterprise v

4 June 2009

RE: How do Derived Tables get built and populated?
Here are a few differences between global variables and fields on Derived/W

4 June 2009

RE: AWE 9.0 Notifications
Hi All To all who are facing this issue just wanted to update you guys that

4 June 2009

IB , PubSUb Problem
We are using IB for third party interaction. When I tried the navigation In

4 June 2009

RE: Menu Pagelet help
Hi Janet, you can change the setting for minimize and refresh button in co

4 June 2009

RE: SQL working in QL developer by not thru SQR
AND U2.PAY_END_DT < $lastpayenddt hey here does $lastpayenddt has any value

4 June 2009

RE: how to generate barcode in peoplesoft
hey you can use print-bar-code function in SQR

4 June 2009

RE: how to generate barcode in peoplesoft
You can use barcode font and implement in report like Crystal report, if th

4 June 2009

how to generate barcode in peoplesoft
Hi We are trying to generate a barcode to print on a document using PeopleS

3 June 2009

How to get a pop up when we click a a hyper link on a page?
Hello All, When I click a hyper link on a page system should bring me a sm

3 June 2009

Re: GVT Fields visible without Fed Install
Tom, I don't think there are any settings that will disable the look up box

3 June 2009

Re: GVT Fields visible without Fed Install
I understand that I could create a custom fix. I was wondering if these fie

3 June 2009

RE: App Engine unique constraint error
Thanks for the reply. That is what I did. Looked for last commit in the tra

3 June 2009

RE: How do Derived Tables get built and populated?
Good question. The only response I can give you is that they've been around

3 June 2009

RE: How do Derived Tables get built and populated?
Yes, a derived record can have any data type allowed by PeopleSoft rather t

3 June 2009

RE: How do Derived Tables get built and populated?
You are correct; a derived record can have any combination of PeopleSoft fi

3 June 2009

Re: How do Derived Tables get built and populated?
You could try a "Find Definition References - Record Field" by opening the

3 June 2009

RE: How do Derived Tables get built and populated?
Ken, Check for Component Record and Component Record Field Peoplecode, a

3 June 2009

RE: How do Derived Tables get built and populated?
  Yes, I remember the Working Storage section.  In this case, I feel compel

3 June 2009

RE: How do Derived Tables get built and populated?
So, if a derived record is simply a "composite" place to put data, the data

3 June 2009

RE:How do Derived Tables get built and populated?
I was aware that a derived record is not in the database but I assumed, a

3 June 2009

Re: GVT Fields visible without Fed Install
Tom, The two fields on that subrecord are listed as list box items (and al

3 June 2009

RE: Candidate Gateway - Duplication check
The problem with National ID validation is that it typically isn't required

3 June 2009

RE: SQL working in SQL developer tool but not in SQR
Before your Begin-Select, place show statements to show the contents of the

3 June 2009

GVT Fields visible without Fed Install
We have a custom record with a prompt on JOBCODE_TBL. When using he prompt

3 June 2009

RE: How do Derived Tables get built and populated?
As Ken says, it's memory.   Think of it as the WORKING-STORAGE section (any

3 June 2009

RE: SQL working in QL developer by not thru SQR
Two things: 1 Are the non SQL lines indented so that they do not

3 June 2009

Re: SQL working in SQL developer tool but not in SQR
Are you using begin-select in your SQR?   You're showing "select" below for

3 June 2009

RE: How do Derived Tables get built and populated?
Derived/work tables are not built; App Designer does not even give you the

3 June 2009

RE: SQL working in SQL developer tool but not in SQR
Make sure your selected column names are in the first position on the line.

3 June 2009

RE: Candidate Gateway - Duplication check
I could be wrong but I doubt that this can be done. When somebody comes in

3 June 2009

RE: Candidate Gateway - Duplication check
We also had the same issue. The only way you can check is to make them ent

3 June 2009

RE: Candidate Gateway - Duplication check
There is no easy answer here. PS delivers a duplicate applicant checking AE

3 June 2009

RE: Blackberry Email Response and Approval Routing
Siva, Do you have any supporting documentation for this? I am looking at ro

3 June 2009

SQL working in QL developer by not thru SQR
Hi Friends, The following SQL gets the input of the current pay end date an

3 June 2009

Change Search Box Condition with PeopleCode
Is there a way to change the search condition from the default comparison?

3 June 2009

RE: User Profiles!
I think this is something you can do using different web profiles. May be y

3 June 2009

RE: How do Derived Tables get built and populated?
Hey Ken, Think of a derived table as an array, not to be confused with a

3 June 2009

RE: How do Derived Tables get built and populated?
A derived or work record is not stored in the database, so you do not build

3 June 2009

SQL working in SQL developer tool but not in SQR
Hi Friends, The below SQL fetches the max pay end date less than the curren

3 June 2009

PeopleSoft Single Sign between HR and Finance is not working
am setting up single sign on between PeopleSoft HRMS and Financials applic

3 June 2009

Re: peopletool-I Search Record at menu and Comp level
No you cannot override the search record thru PeopleCode.. but yes there ar

3 June 2009

Re: peopletool-I Search Record at menu and Comp level
The first event triggers is searchinit which is on search record. I don't t

3 June 2009

RE: Line break in hover text
Sorry for my late reply...but thanks to everyone who posted. I was able to

3 June 2009

RE: peopletool-I Search Record at menu and Comp level
I have the same doubt.. can we override the search record for a component t

3 June 2009

How do Derived Tables get built and populated?
  This is probably pretty basic but I'm looking at a derived record used on

2 June 2009

RE: Cross Reference tables in PeopleSoft
Talk to the people who own the PeopleSoft system, see how they would like t

2 June 2009

RE: CI Job data
Are you doing a &apiItem = &CI.JobColl.Insertitem(1) ?

2 June 2009

CR/LF stripped off DESCR field
Greetings -   Can anyone tell me what seems to be stripping off carriage re

2 June 2009

Menu Pagelet help
I have a requirement to remove the minimize and refresh buttons from the me

2 June 2009

RE: Message name not specified on the incoming request message.
I got the same error message between HRMS 8.9/PT 8.47 and FSCM 8.9/PT 8.49

2 June 2009

Re: Windows 64-bit
Could you expand on your message a bit? What database platform are you us

2 June 2009

CI Job data
We are using the delivered CI in PS 9.0 to insert into Job Data. The load

2 June 2009

RE: Windows 64-bit
We are on tools 8.49 with Weblogic 9.2. We were unsuccessful in installing

2 June 2009

Candidate Gateway - Duplication check
Hi Friends, We are implementing Candidate Gateway and we already have TAM f

2 June 2009

RE: Windows 64-bit
Thanks Mike From: mbyrne via peopletools-l [mailto:peopletools-l@Groups.ITt

2 June 2009

RE: Cross Reference tables in PeopleSoft
Thanks for the response, We basically want to be able to update the quantit

2 June 2009

RE: User Profiles!
We thought they could not be manipulated ________________________________ F

2 June 2009

Re: User Profiles!
Be careful with HTTP headers. They can be spoofed. Mike On Tue, Jun 02, 20

2 June 2009

RE: User Profiles!
Hi , You can differentiate the user by the incoming request using the HTTP

2 June 2009

RE: Cross Reference tables in PeopleSoft
So what is your specific problem ? Do you want to remap the data into Peop

1 June 2009

RE: Graying out a button on a Level 2 Data Grid
Are you definately sure that the scroll with a primary record called RECORD

1 June 2009

Re: Graying out a button on a Level 2 Data Grid
Gray function doesnt work on component buffer field. Use &KeyGridColumn.ena

1 June 2009

RE: Accessing Component Interface Using JAVA
Did you ever find a resolution to this? I am having the same error. Also

1 June 2009

Grid column header sort doesn't update rowset buffer sort order
If a user clicks on the column header to sort a grid, how can I process the

1 June 2009

Graying out a button on a Level 2 Data Grid
I have written Page.Activate Peoplecode to gray out a button that is part o

1 June 2009

User Profiles!
I have to change the user profile after the LDAP authentication depending o

1 June 2009

RE: How record PS_RTE_CNTL_RUSER is populated ?
It's populated via the user profile under PeopleTools>Security. On the rol

1 June 2009

How record PS_RTE_CNTL_RUSER is populated ?
Hi, I would like to know how the record PS_RTE_CNTL_RUSER table is populate

1 June 2009

RE: Cross Reference tables in PeopleSoft
Hi Thanks for the reply we have to cross reference inventory database table

1 June 2009

run server reports from page are running at future date
hi all, I am having a problem running the reports from the page. As pe

1 June 2009

RE: Cross Reference tables in PeopleSoft
Hundreds of them. What types of data sets were you thinking of cross refer

31 May 2009

RE: Error encountered using Find link in Grid
I haven't actually read the entire algorithm for the find function, but it

31 May 2009

RE: Out of Memory Error in SQR
I don't know if this will help in your situation, but something that has he

31 May 2009

Re: using https get to pull a file
but the client is not allowing ftps to be used...and they will give input f

31 May 2009

RE: App Engine unique constraint error
The likely reason that you are getting no rows when you run the select manu

29 May 2009

SQR Kanji Postscript
I am trying to print kanji from an sqr. I am having trouble finding a kanj

29 May 2009

Re: Turn off defualt profile!
Hi I suppose you are talking about web profile. In that case This is availa

29 May 2009

Turn off defualt profile!
Does anyone know how to turn off the default profile , in this case I need

29 May 2009

Out of Memory Error in SQR
Hi , I am trying to dispatch more than 4000 PO's using popo005.sqr. But

29 May 2009

RE: Error encountered using Find link in Grid
There are no large/weird field types used on the grid - longs, image raw bi

29 May 2009

Re: Error encountered using Find link in Grid
There are no large/weird filed types - longs, images, raw binaries, etc. H

29 May 2009

RE: Passing a Date to Sybase Query in SQR
Latest Update The top version runs in about 5-10 seconds works but the bott

29 May 2009

Re: Windows 64-bit
Nothing tricky about it. It is a standard install. Michele Murry via people

29 May 2009

RE: Accessing CrossReference tables in PeopleSoft From third party(.net) application
Hi Mike, Thanks for quick reply. Please send me the Project what u have d

29 May 2009

Cross Reference tables in PeopleSoft
Hi , Is there any concept of "cross reference tables" concept in PeopleSo

29 May 2009

Re: Accessing CrossReference tables in PeopleSoft From third party(.net) application
You should create a component and publish it as a wsrp wrapper then consum

29 May 2009

Windows 64-bit
Hi Next week I am changing from a 32-bit server to a 64-bit server on Windo

29 May 2009

RE: Accessing CrossReference tables in PeopleSoft From third party(.net) application
In the world of PeopleSoft, we have Integration Broker and Component Interf

29 May 2009

RE: Accessing CrossReference tables in PeopleSoft From third party(.net) application
Cross reference tables or interface tables are tables in peoplesoft which

29 May 2009

RE: Accessing CrossReference tables in PeopleSoft From third party(.net) application
You're going to have to explain what you mean by cross reference tables. If

29 May 2009

Accessing CrossReference tables in PeopleSoft From third party(.net) application
Hi Is there any concept of "cross reference tables" in peoplesoft ? If yes

29 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
I was able to get it to work by removing all the variables within the logic

29 May 2009

RE: Update peoplesoft inventory tables by an external application
Hi, thanks for the reply 1. will Peoplesoft Component interface(CI) itself

29 May 2009

RE: RE:Update peoplesoft inventory tables by an external application
You can provide your functionality using Component Interface (CI) and expos

29 May 2009

RE: Update peoplesoft inventory tables by an external application
Hi Thanks for the reply can u please give detail explanation on how to use

29 May 2009

RE: Update peoplesoft inventory tables by an external application
Hi Thanks for the reply can we please give detail explanation on how to

29 May 2009

RE: Update peoplesoft inventory tables by an external application
You can use Web Services [http://userimages.toolbox.com/user/b_1543202.jpg]

29 May 2009

Update peoplesoft inventory tables by an external application
we are working on a .net application that would require to update the inven

29 May 2009

RE: Error encountered using Find link in Grid
Is the grid huge (ie it contains a DESCRLONG that is populated with large d

28 May 2009

RE: PeopleTools 8.49 Integration Broker
Thank you. That did the trick.

28 May 2009

Re: PeopleTools 8.49 Integration Broker
You have to apply security to see the xml as well as the message handler mb

28 May 2009

PeopleTools 8.49 Integration Broker
I created a custom rowset based inbound message. I created the Service, Se

28 May 2009

Invalid userid error when signing on
hi, we are on 8.49.11 tools. i have strange issue. user goes to peoplesoft

28 May 2009

RE: Passing a Date to Sybase Query in SQR
I have also tried this but it makes the database ignore its indexes and run

28 May 2009

RE: Error encountered using Find link in Grid
This happens on a custom grid/page. I can not replicate this on ther grids

28 May 2009

RE: Passing a Date to Sybase Query in SQR
One more thing. if i pass the commented out dates to the query it runs fine

28 May 2009

Passing a Date to Sybase Query in SQR
Hey All, I am having a problem passing a dynamically generated date to a

28 May 2009

RE: Deleting a Recurrence in PeopleSoft 8.45
I was able to delete the records from the first table. I found the second

28 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
Just looking at your code. You have: import PSXP_RPTDEFNMANAGER:*; Local PS

28 May 2009

RE: Deleting a Recurrence in PeopleSoft 8.45
There are two tables. 1. sysadm.PS_PRCSRECUR 2. sysadm.PS_PRCSRECUREXEMPT

28 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
Yeah, the IB is turned on and yes, I do get a success returned in the monit

28 May 2009

Deleting a Recurrence in PeopleSoft 8.45
I have a few test recurrences that I would like to delete. There doesn't se

28 May 2009

RE: Loading 3rd Party XSD's to PeopleSoft to create XML file layout
Also you can use PutAttachment for Placing your XML file using FTP =======

28 May 2009

RE: Loading 3rd Party XSD's to PeopleSoft to create XML file layout
For schema validation you can use Messages. You can upload schema for a no

28 May 2009

RE: Loading 3rd Party XSD's to PeopleSoft to create XML file layout
Hi Matt, You must be using and sqr or other tool and generate an interface

28 May 2009

RE: reading a soft copy form and storing the data in PSoft
Pete, If you get any good information about how to create and pull data fr

28 May 2009

Re: Loading 3rd Party XSD's to PeopleSoft to create XML file layout
I have done this recently , but in that case You just ask the format (tags)

28 May 2009

Loading 3rd Party XSD's to PeopleSoft to create XML file layout
Is there a way to load 3rd party XSD's into PeopleSoft to create the XML fi

28 May 2009

RE: Database rights on sqlserver
Indead we want to limit rights where possible and preserve sysadmin for the

28 May 2009

RE: Dynamic Drop Down Lists
hi all. I know this thread may be dead til nw but i think it may be useful

28 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
Do you have the IB turned on? and are the PSRF service operations are going

27 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
Initially, I did have bursting on. It was bursting on the SSN. When this wa

27 May 2009

RE: App Engine creates XML (pdf) but cannot access it in Report Manager (not a hyperlink)
I think it's security related.....are you using the bursting option? If so

27 May 2009

RE: Concurrent Login
That's a very good point, as long as your OPR ID = EMPL ID. But many compan

27 May 2009

RE: Concurrent Login
If you make the OPRID = EMPLID, then you have everything you need. We have

27 May 2009

RE: Concurrent Login
Keep in mind that if you delete an Opr Id from PSOPRDEFN then what good doe

27 May 2009

RE: Concurrent Login
I agree, we purge old operator ids, but we exclude all of the tables that a

27 May 2009

RE: Concurrent Login
As a sidebar, you can delete OPRIDs from PSOPRDEFN if you do it through the

27 May 2009

RE: Concurrent Login
I don't know if there's a PeopleSoft-delivered way of doing this. A possib

27 May 2009

Application Engine - BI Publisher only generating data for first element in xml file
I'm running into a problem when trying to use an App Engine to generate a r

27 May 2009

RE: Concurrent Login
I never suggest deleting Opr IDs. You lose audit history when you do this.

27 May 2009

RE: Error encountered using Find link in Grid
If this can be replicated in your demo env't, then best thing to do is repo

27 May 2009

RE: Database rights on sqlserver
All, Your ACCESSID definitely does not need sysadmin rights in the database

27 May 2009

Re: Concurrent Login
yes we can,  first be clear that, you want to delete a profile of a user

27 May 2009

PS Centralized Administration
I'm looking into what options I have (custom solution or 3rd party) to cent

27 May 2009

reading a soft copy form and storing the data in PSoft
we're in the process of creating various soft copy security forms to suppor

27 May 2009

RE: Migration of XMLP objects
The objects migrated, but is it expected that the Data Source and Report De

27 May 2009

SCH_SHIFT
Hi, Is there anyone tried the CI SCH_SHIFT which is used for input shifts?

27 May 2009

Checklist Management - Person
I add a new value then complete he necessary fields on Checklist Management

27 May 2009

RE: View Log/Trace link is enabled in Process monitor Details link and the distribution status is "Posted" in Process Monitor but the reports are not saved at psreports
because you didn't define the URI Resource : SchedulerTransfer/hrcs9

27 May 2009

Re: Migration of XMLP objects
I dont know abt STAT tool.. But through application Designer itself you can

26 May 2009

RE: weird IB error
Hi, Did you find the solution for your weird IB error? We got something sim

26 May 2009

cmdtux_cat:764 error cannot attach to bb and libtux_cat: 334
Attempting to start process scheduler, BBL starts then 1st process hangs (r

26 May 2009

Re: Authentication domain in Weblogic
That will be fine michaelnerren@winn-dixie.com via peopletools-l wrote: >

26 May 2009

RE: Authentication domain in Weblogic
The only SSO will be to the report repository and I found that if I specify

26 May 2009

Re: Authentication domain in Weblogic
You should be fine if you are not using single signon to any other PS apps.

26 May 2009

Authentication domain in Weblogic
From what I understand, you can define the authentication domain in 2 place

26 May 2009

Migration of XMLP objects
We are testing XMLP, we can create the objects in our development environme

26 May 2009

FMLA hours special accumulator
We are planning to use the FMLA module. We want to use the Pay hrs and use

26 May 2009

Re: Database rights on sqlserver
Be sure and let us know the results of your testing. Ed Judge TriTech Solu

26 May 2009

RE: Pushing info from HCM to Active Directory
We actually wrote a custom app engine process that updates our Active Direc

26 May 2009

RE: Database rights on sqlserver
Just to be sure I just contacted our external developers. I was sure they

26 May 2009

Error encountered using Find link in Grid
Grid has 54 total rows, but displays 15 at a time. On occasion, when click

26 May 2009

RE: GetMessageText: No default message
You mention that the messages are visible in PeopleSoft - PeopleTools - Com

26 May 2009

RE: Need help to send email with attachment(.csv .pdf) through sqr in UNIX server
Hmm..the command looks to be a mess to me, but I am not sure what flavor o

26 May 2009

RE: Database rights on sqlserver
Technically I don't think it would be a problem say changing the accessid f

26 May 2009

RE: Pushing info from HCM to Active Directory
On the PeopleSoft side it'd be pretty easy. All you'd need is an interface

26 May 2009

Re: Database rights on sqlserver
First, I'm not a DBA so I don't quite know all the details, but I ran int

26 May 2009

RE: Database rights on sqlserver
Dear Ed, Thanks for your fast answer. I'm aware of the account people for

26 May 2009

Re: Database rights on sqlserver
Toolbox peopletools-l They're .sql scripts. -----Original Message----- Fro

26 May 2009

Re: PeopleTools 8.42 - view compare reports in excel
Thanks for your help. It worked as desired. Sincerely appreciate your respo

26 May 2009

Re: Database rights on sqlserver
May have a correction on the last post. I think the grant and connect scr

26 May 2009

Re: Database rights on sqlserver
Not sure where you are looking, but running PeopleSoft on a SQL Server da

26 May 2009

Database rights on sqlserver
Hi, We are running Peoplesoft on SQL Server. I'm asked to trace database l

26 May 2009

Concurrent Login
Can we stop concurrent users from logging in the peoplesoft application. I

26 May 2009

RE: ExcelToCI
Hi Durga Prasad, I am getting the same error. Can you please let me

25 May 2009

Need help to send email with attachment(.csv .pdf) through sqr in UNIX server
Hi All, I need to send an email with attachment(.csv) through sqr in UNIX s

25 May 2009

RE: PeopleSoft Mobile Agent Error
Hi, after trying and trying, I have seen how to configure it and it worked.

25 May 2009

Pushing info from HCM to Active Directory
Hi, We currently are integrated with active directory to use network passwo

25 May 2009

GetMessageText: No default message
Good afternoon, A few days ago I asked a question about transfering Message

25 May 2009

Translate values
I have modified the translate values for a field with effective date as 01/

25 May 2009

RE: Peoplesoft Integration Broker 9.0
What are you trying to integarte. You say that you are looking at integra

25 May 2009

Pagelet Security
Hi Experts, Using PT 8.49, CRM9.0. I've created a custom HTML pagelet with

24 May 2009

RE: Data Partitioning for FSCM
i suppose you are partitioning the tables owing to the huge amounts of data

23 May 2009

How to add a background image on a page?
Hi, Does anyone here know how can I make a background image appear on a

23 May 2009

ExecuteEdit() error in app package...
Hi All - I am subscribing an XML message through App Package PC.The code us

23 May 2009

RE: Query item count is bad - error in migration
Thanks for the idea...so what does it mean when they come out in that sysau

22 May 2009

Data Partitioning for FSCM
We are looking to perform data partitions to our FSCM data. Does anyone ha

22 May 2009

RE: How to get Print Button at level 1?
You need to add a 'print' field to your level1 record and copy your existin

22 May 2009

RE: Query item count is bad - error in migration
Run the sysaudit and it will show you all the queries that are invalid. You

22 May 2009

Data partitioning for PeopleSoft FSCM
We are looking to perform a database partition of our FSCM data, most notab

22 May 2009

RE: PeopleSoft and crystal
Thanks! for the reply, I figured out that my issue was on the process defin

22 May 2009

RE: Custom Field on Position not creating a new job row
On the save prechange of that record (Subrecord) field add the peoplecode v

22 May 2009

RE:Only the = operator in Search record
You don't have to configure.. peoplesoft will provide those values for you

22 May 2009

Re: Peoplesoft Integration Broker 9.0
Yes I had gone through Peoplebooks...though the matter was very descriptive

22 May 2009

RE: Query item count is bad - error in migration
hmmm...looks like what I entered was cut... Anyway, the error message is: "

22 May 2009

Dynamic views
Hi, I am using PeopleTools 8 (OLD). I am trying to assign SQL to a dynamic

22 May 2009

RE: Peoplesoft Integration Broker 9.0
Did you review Peoplebooks?

22 May 2009

Query item count is bad - error in migration
We are migrating a lot of queries in a project and gets this error for a lo

22 May 2009

Re: using https get to pull a file
You should use the ftps connetor lavanya_r via peopletools-l wrote: > > >

22 May 2009

RE: Install 2 Peopletool version on same Citrix Server
I know that you can simply run pscfg -import:n:\config\hr840.cfg from the

22 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Happy Friday everyone, I got the SQR to run correctly, wahoooo!! Turns out

22 May 2009

using https get to pull a file
Is it possible to use HTTPS GET/POST method in IB to get a CSV file?

22 May 2009

RE: Only the = operator in Search record
How can we configuration the operator (=,in etc) on search page. In financi

22 May 2009

How to call field change event using JavaScript in HTML
Dear All, I tried calling Record.Field PeopleCode event using JavaScript in

22 May 2009

RE: The site booted with internal default settings, beacuse of: bea.jolt.ServiceException: Invalid Session
Well, I know that this thread has been dead for more than 4 years but I'm c

21 May 2009

RE: PeopleTools 8.42 - view compare reports in excel
"File > Save Report As". Tab delimited is better because there can be comma

21 May 2009

RE: Custom Field on Position not creating a new job row
When we need to add custom fields to a delivered record, we use subrecords

21 May 2009

RE: Custom Field on Position not creating a new job row
??? Sofia Dobkin Lockheed Martin Enterprise Business Services. Phone:

21 May 2009

Custom Field on Position not creating a new job row
I added a custom field (COST_CENTER) to a custom subrecord on POSITION_DATA

21 May 2009

RE: App Engine unique constraint error
Thanks Mutyala, Those are the few things that I did as debugging process.

21 May 2009

RE: Grid Subtotals
Thank you all for your help. The problem is fixed. My main problem was on

21 May 2009

RE: PeopleTools 8.42 - view compare reports in excel
In Oracle Support under Doc ID 647772.1 just do File > Save Report As and y

21 May 2009

Install 2 Peopletool version on same Citrix Server
Running 2 PT versions on the same CITRIX server has changed starting people

21 May 2009

RE: Integration of SharePoint and PeopleSoft
As Bishwanath works for Hexaware, I am assuming that he is telling us that

21 May 2009

Peoplesoft Integration Broker 9.0
Can anyone tell me in detail the steps to configure IB between Financials a

21 May 2009

the issue of multiple user IDs
Hi All Our current environment is an HRMS PeopleSoft Application and we int

21 May 2009

Clarification in PSXP_XMLGEN
how this application package gets the long translate value for the respecti

21 May 2009

RE: how to remove from worklist
Hi chandrashekharw , This query is hardcoded for particular transctionID bu

21 May 2009

RE: How to remove from worklist when accessing the main navigation
It's a delivered function.I found in Peoplebooks this one: Use the MarkWLIt

21 May 2009

How to get Print Button at level 1?
In my page there's a Print button button which's at level 0 .I want this bu

21 May 2009

RE: How to remove from worklist when accessing the main navigation
Why you r using MarkWLItemWorked()" function. From: vinay1234 via peop

21 May 2009

RE: how to remove from worklist
Update psworklist table. This sql might helpful for you.. UPDATE PSWORKLI

21 May 2009

How to remove from worklist when accessing the main navigation
A supervisior can enter his page through 2 navigation ie thr worklist & thr

21 May 2009

RE: messagebox
In the popup window You can never get two buttons.If you want two buttons t

21 May 2009

how to remove from worklist
use can go to the page via two ways.ie through the main navigation & anothe

21 May 2009

RE: Appserver Status
Thanks for u r response.. Again I am adding my post. Hi all, I am using PT

21 May 2009

RE: App Engine unique constraint error
Not sure if this reply is too late! But I think "Row(s) affected: 0" messag

21 May 2009

RE:Approval Work Engine - Promotion
AWE routes to everyone in the Admin role when it does not find Approver. Yo

21 May 2009

RE: Peoplecode Transfer function problem
HR_TRN_SUMM_EMP is on the VIEW bar ( BarName . View ) From: neil.grady vi

20 May 2009

RE: Grid Subtotals
If you create a scroll (maybe just using a view of that record) above it th

20 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
did you include the stdapi.sqc (I think) and call the procedure StdApi-Init

20 May 2009

RE: PeopleSoft Security from the internet
Why are you using the REN (Realtime Event Notification) Server? I don't thi

20 May 2009

RE: Auto-creating user_accounts in psoft
Pete, PS delivers a process that uses mass change to auto create user accou

20 May 2009

RE: Customizing Query App Engine
No problems, happy to help. It is always nice to know why something didn't

20 May 2009

RE: Grid Subtotals
If the data is display only, you can create your own subtotals within the g

20 May 2009

RE: Customizing Query App Engine
Andrew, Thanks so much! I used your tip of adding the MessageBox and was a

20 May 2009

RE: PeopleSoft Tree
Hi Srini, Looks like you resolved this issue. Can I plz get the complete de

20 May 2009

RE: App Engine unique constraint error
Thanks for your Reply Rao. Well, that is THE problem is that the SQL finds

20 May 2009

PeopleTools 8.42 - view compare reports in excel
Let me know procedure if anyone has created excel reports of Compare report

20 May 2009

Re: The service operation PERSON_BASIC_SYNC stays stuck in the queue with status
Hi Nisayle, Please check the below points   1) Go to the Publication contr

20 May 2009

RE: Appserv issue
Thanks for u responce.... the issue has been solved . 1. the write permiss

20 May 2009

RE: Application Engine doesn't work
Hi Veronica, The AE has does have an option to commit at the section level

20 May 2009

PeopleSoft Security from the internet
We are rolling out PeopleSoft's Candidate Gateway product as an outward fac

20 May 2009

Component Interface
Hi, im having some troubles testing a component interface. Im' trying to up

20 May 2009

RE: Help! FMLA Setup
Hi, We want to implement and use the FMLA Administration. I came up with th

20 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Jason, Something to keep in mind with the substitution variables, SQR doe

20 May 2009

Application Engine doesn't work
Hi, I'm having problems with an application engine. It was working ok, but

20 May 2009

RE: Embedding Hyperlink in Warning/Error Messages
I would like to do the same thng. Did you ever find a solution?

20 May 2009

RE: What are Tools 8.44 to 8.50 upgrade benefits?
Any time now. There is a proposed path ini the maint schedule for Sept.

20 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Have you put show statements to see what the values of $Prcs_OprID $Prcs

20 May 2009

RE: Crystal Report Error:
Just in the center. Thamxs! -----Original Message----- We have had a proble

20 May 2009

Peoplecode Transfer function problem
Hi, I'm having problems getting the Transfer command to work on a particuul

20 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Hello and thanks everyone for all your replies and suggestions, I really ap

20 May 2009

RE: PeopleSoft and crystal
First off, does the crystal run okay when you run it manually? I'm assumin

20 May 2009

RE: What are Tools 8.44 to 8.50 upgrade benefits?
When will Tools 8.50 be GA? Westfield Group: Sharing Knowledge. Building T

20 May 2009

How To Activate Hidden Page Return Link
Hello all, I'm new to FSCM 9.0 and I need to activate the return Home Link

20 May 2009

Grid Subtotals
Has anyone created a grid with subtotals? I want to break on a change of s

20 May 2009

PeopleSoft and crystal
I am trying to a crystal report via Peoplesoft thru processscheduler.. and

20 May 2009

RE: Appserv issue
Have you actually successfully run/executed the psconfig.sh? So if you ech

20 May 2009

RE: What are Tools 8.44 to 8.50 upgrade benefits?
There are a whole bunch of middle ware components that have been added to t

20 May 2009

RE: Nobody able to login into peoplesoft.....
This is happening to me as well. Just upgraded to 8.49.19 and DYNROLE gets

20 May 2009

RE: Missing entries in Message Catalog
Thank You very much, that explains this problem. Romuald.

20 May 2009

RE: Missing entries in Message Catalog
Hi Romuald, When copying a project to a flat file, messages are NOT include

20 May 2009

RE: Missing entries in Message Catalog
The act of comparing doesn't check messages and the check box may not be ap

20 May 2009

RE:Using the Message Catalog for Hyperlink or Push Button Labels
Thank you! I will give that a try. --- On Wed, 5/20/09, blrvenkat via peopl

20 May 2009

RE: Customizing Query App Engine
Your code seems quite straightforward and it's really just the "if" conditi

20 May 2009

RE: Missing entries in Message Catalog
I have defined Message Catalog Entries in my Application Designer Project,

20 May 2009

RE: Approval Work Engine - Promotion
I can set that on the Process Definition to approve o n submit but the issu

20 May 2009

Customizing Query App Engine
We have customized the PSQUERY app engine such that when certain queries ar

20 May 2009

RE: PutAttachment PeopleSofft HCM
Hello all of you ! Ifigured it out last Sunday evening: /*Add the attachmen

20 May 2009

RE: The service operation PERSON_BASIC_SYNC stays stuck in the queue with status
It sounds very painful. The publish/subscriber process was not started. Now

20 May 2009

RE: The service operation PERSON_BASIC_SYNC stays stuck in the queue with status
Hi , Check whether message version is same on both publisher as well as su

20 May 2009

The service operation PERSON_BASIC_SYNC stays stuck in the queue with status
Hi all, We have a very big problem here and we have absolutely no clue why

20 May 2009

RE: Appserv issue
Dear All, Thanks for your response,, I am getting this error....during Load

20 May 2009

RE: Using the Message Catalog for Hyperlink or Push Button Labels
Janet, I'm not sure if I understood your requirement correctly. I'm not cl

20 May 2009

Re: How to generate single XML output file from multiple records
Its upto you, create a XML based upon your requirement and dnt base the fil

20 May 2009

How to generate single XML output file from multiple records
Is it possible or is there any alternate way for generating single XML outp

20 May 2009

RE: What are Tools 8.44 to 8.50 upgrade benefits?
Roger, Only a couple of days back Oracle made a entry in their PeopleTools

20 May 2009

RE: WebLogic 8.1 Administrator Password reset
In the peoplesoft world this is how we do . Administrator password was ch

20 May 2009

What are Tools 8.44 to 8.50 upgrade benefits?
We are thinking of upgrading from Tools 8.44 to 8.50. Just Tools, not Apps

20 May 2009

Re: Approval Work Engine - Promotion
Hi, Your custom code might not work, esp if you try to use it as old workfl

19 May 2009

RE: Getting 'Your PeopleSoft connection has expired' right after log in screen of PIA
I have the same problem, anybody knows why?

19 May 2009

RE: Appserv issue
What is in the TUXEDO log? And like Mike said, did you source the psconfi

19 May 2009

RE: How to use Subquery in select using Ps query?
Write the subquery as a view and then you can call it in your query

19 May 2009

RE: Appserver Status
I think your post got cut off. Can you repost your output. -Mike

19 May 2009

RE: Comp Plan Enrollment Table In PeopleSoft
What version of PS HR?

19 May 2009

RE: IB Issue
What kind of problems are you seeing? Any info in the logs? -Mike

19 May 2009

RE: Appserv issue
Are you running psadmin as the user you did the install with? Did you sourc

19 May 2009

Approval Work Engine - Promotion
Hi, We have upgraded to 9.0 and Promotion Transcation is now setup for Appr

19 May 2009

Crystal Reports for PS
I am getting an error with the PSToWords function in Crystal 9. I have cop

19 May 2009

PSToWords function in Crystal for PS
I have copied the 3 PSICU* dll docs to the same directory as the crw32.exe.

19 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
How do you know that it is not populating the variables? Have you used SHO

19 May 2009

PSmessages collection not being populated when the cache is cleaned up
Hi there! I'm facing an cache issue. In an Application Engine Peoplecode, I

19 May 2009

RE:Using the Message Catalog for Hyperlink or Push Button Labels
Thanks Rao--that worked. But what I'm really trying to do is to display Mou

19 May 2009

Appserv issue
Dear All, I am getting the following error. we have PT 8.49,bea Tuxedo 9.

19 May 2009

RE: WebLogic 8.1 Administrator Password reset
Jim, Im facing same problem but I am not able to follow step 5. setEnv scri

19 May 2009

WebLogic 8.1 Administrator Password reset
How can we reset administrator password in command line without using conso

19 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
In addition to the declaring the select-parameters have you called it withi

19 May 2009

RE: Using the Message Catalog for Hyperlink or Push Button Labels
Yes. Use MsgGetExplainText method and the label property of the field to se

19 May 2009

RE: How to use Subquery in select using Ps query? [NC]
Hi , I change the sql definition as follows SELECT, > ,b.invoice_id

19 May 2009

Re: How to use Subquery in select using Ps query? [NC]
Hi, For "if it work then it will be greate just a few question. (%SQL(T2.

19 May 2009

RE: Blackberry Email Response and Approval Routing
Finally I was able to implement this, all you need POP3 /IMAP eamil account

18 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Just put some SHOW statements in there to see what (if anything) is being s

18 May 2009

Using the Message Catalog for Hyperlink or Push Button Labels
When using the Message Catalog for a Hyperlink or Push Button label, is it

18 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Hi there... I didn't see anything that jumps out at me, but here are a coup

18 May 2009

RE: Unable to run nVision reports thru web to network folder
yes, UNC pathing worked! Thanks.

18 May 2009

RE: RunCTL user parameters not being passed to SQR SQl
Shouldn't WHERE RUN.OPRID = $Prcs_OprID be WHERE RUNCTL.OPRID = $Prcs_OprID

18 May 2009

RunCTL user parameters not being passed to SQR SQl
In Peoplesoft, I have an SQR that uses a PS runctl record to capture user i

18 May 2009

RE: Insert SQL object with GetSQL
Thank you Gabe, I apologize for the lack of an error message. The message

18 May 2009

RE: Insert SQL object with GetSQL
Thank you, yes I found that the issue was completely related to the date fo

18 May 2009

Insert SQL object with GetSQL
I am having issues with getting an insert to work using a SQL object and Ge

18 May 2009

RE: PutAttachment PeopleSofft HCM
This is a code snippet from our system: &nbr_retcode = PutAttachment(URL.HR

18 May 2009

RE: Decryption of Credit Card numbers
I actually figured it out. Called an app package to decrypt. Worked well th

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
I've seen number of solutions and of themj (and other things being equal),

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
suppose my sql object is like below SELECT b.business_unit ,b.voucher_id

18 May 2009

RE: Unable to run nVision reports thru web to network folder
We use PeopleTools 8.49 with Financials 8.8 SP1. For our nVision reports,

18 May 2009

Re: How to use Subquery in select using Ps query? [NC]
* Thanks Francis Xavier* ... its really a nice tip.. On Mon, May 18, 2009 a

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
if it work then it will be greate just a few question. (%SQL(T2.FIELD3,TABL

18 May 2009

Re: How to use Subquery in select using Ps query? [NC]
Hi, Consider the Query you require to be of this form . SELECT T1.FIELD1,T1

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
Thanx reddy really .........

18 May 2009

Re: How to use Subquery in select using Ps query? [NC]
select expression tab Select Expression type : character or based on u r re

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
how to call it in expression...what will be syntax ?? thanx in advance...

18 May 2009

Re: How to use Subquery in select using Ps query? [NC]
suppose if u created a pl/sql function with name *get_name(emplid)*. To use

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
can please elabrote more on this with example. we use pl/sql here.

18 May 2009

Re: How to use Subquery in select using Ps query? [NC]
There is a workaround for this if u know pl/sql.. write a pl/sql function a

18 May 2009

Re: How to use Subquery in select using Ps query?
There is a workaround for this if u know pl/sql.. write a pl/sql function a

18 May 2009

RE: How to use Subquery in select using Ps query? [NC]
thanx Ritika but we want subquery in select clause not in where clause.

18 May 2009

RE: How to use Subquery in select using Ps query?
thanx slnnaravindh , for your responce i also think this is not possible i

18 May 2009

PutAttachment PeopleSofft HCM
Hi everyone, I have build 3 webservices from Component interfaces: 1. all o

17 May 2009

Re: Insert SQL object with GetSQL
since we lack of error messages to help us narrow down the root of the prob

16 May 2009

Accounting for Expense for Currencies other than GL BU base currency
We have a requirement for accounting for Currencies other than GL BU base c

16 May 2009

Re: Insert SQL object with GetSQL
It appears that you are trying to pass %OperatorId to A.OPRID_LAST_ACTION

16 May 2009

Re: Insert SQL object with GetSQL
You'll need to wrap :4 (bind variable #4) with %DateIn. 2009/5/16 Ryan via

15 May 2009

Unable to run nVision reports thru web to network folder
(on Tools 8.49, release 9.0) Users can run nVision reports in 2-tier just

15 May 2009

RE: How to add in singel quotes for multiple lines in an update stmt?
For single quotes, put three in a row. For a comma, put it between two sing

15 May 2009

How to add in singel quotes for multiple lines in an update stmt?
I want a simple way to add in both single quotes and the comma into an upda

15 May 2009

RE: How to use Subquery in select using Ps query? [NC]
Sorry....use that expression as field in your main select.... Thanks & Reg

15 May 2009

RE: How to use Subquery in select using Ps query? [NC]
Create Expression and in that expresseion you can write ur subquery... Then

15 May 2009

RE: Insert SQL object with GetSQL
Please give the error message also.. From: peopletools-l@Groups.ITtoolb

15 May 2009

Peoplesoft 8.8 vs SYBASE ASE 15 compatibility/support
I've been asked to find out if we should upgrade from SYBASE 12 to 15. I've

15 May 2009

RE: SQR Let syntax question
Toolbox peopletools-lDo a search in the SQR for $SQL-Statement -----Or

15 May 2009

RE: How to delete PeopleSoft private queries
This may be a stupid question, but why can't you remove them in Query Admin

15 May 2009

Insert SQL object with GetSQL
I am having issues with getting an insert to work using a SQL object and Ge

15 May 2009

RE: How to determine, through PeopleCode, if a particular field is present on the page?
If %Page = Page.PAGE_A Then ..... End-If

15 May 2009

RE: Problem with Scheduling JobSets
perkins, We use JobSets, but not with specific times as you describe. As y

15 May 2009

RE:How to use Subquery in select using Ps query? [NC]
Hi slnnaravindh/Chandra Thez an option in Query Manager...go to criteria..

15 May 2009

RE: How to use Subquery in select using Ps query?
Hi Chandra, As far as know, this is not possible in PS Query. Please correc

15 May 2009

RE:How to determine, through PeopleCode, if a particular field is present on the page?
welll you can always try and catch a getfield method from a page... right?

15 May 2009

Re: Need help to print a compare rpt created in PT 8 - 8.19
Hi Colleen,   I've got an old tools 8.22 stand alone install on a vm in my

15 May 2009

Re: How can I mask the Worklist URL?
I have tried sending a reply 4 times now but no luck. Not sure what iswrong

15 May 2009

RE: Need help to print a compare rpt created in PT 8 - 8.19
Colleen, Even we are on 8.46 and 8.48. After seeing your post I tried some

15 May 2009

RE: How to determine, through PeopleCode, if a particular field is present on the page?
Just as an aside, I don't have an editable environment at the moment. If y

15 May 2009

RE: How to determine, through PeopleCode, if a particular field is present on the page?
As Howler_Fish and Curtis have pointed out you may be better off moving you

15 May 2009

Need help to print a compare rpt created in PT 8 - 8.19
I have the output of an old compare report for a project I developed, and n

14 May 2009

RE: SQR Let syntax question
The variable $SQL-Statement is used by a common error handler, in conjuncti

14 May 2009

RE: How to determine, through PeopleCode, if a particular field is present on the page?
In a general sense, you usually don't really care if the field is on a page

14 May 2009

SQR Let syntax question
  I'm working my way through a huge SQR that is used to move data from CRM

14 May 2009

RE: Wrong error display for invalid user or password
This issue has been addressed in incident 574094000 and was initially fixed

14 May 2009

RE:Peoplecode example of connected check boxes
Hi Teri...    please don't get me wrong on this... but... have you got any

14 May 2009

RE: Peoplecode example of connected check boxes
Dunno what app you are on, but the main GP runcontrol page has a set of sev

14 May 2009

RE: How to determine, through PeopleCode, if a particular field is present on the page?
You can either hardcode something like EVALUATE %PAGE WHEN PAGE.PAGEA <-- F

14 May 2009

How to determine, through PeopleCode, if a particular field is present on the page?
I am using a sub-record, which is where the people code is located. Then,

14 May 2009

RE: Wrong error display for invalid user or password
Hey Rao, Are you an IT genius?? You seem to know everything! :) Tracy

14 May 2009

RE: Peoplecode example of connected check boxes
You know what, I really appreciate the help that was suggested in the previ

14 May 2009

RE: Auto-creating user_accounts in psoft
Refer the Metalink3: Doc ID 653928.1 1. Build a group of people for whom y

14 May 2009

RE: Peoplecode example of connected check boxes
Thank you for the ideas!! I will give this a try and let you know my outco

14 May 2009

RE:Peoplecode example of connected check boxes
well mate, it looks like you need to have a sort of states machine... or in

14 May 2009

RE: Peoplecode example of connected check boxes
Thanks for the info...I will try what you have suggested.

14 May 2009

RE: Peoplecode example of connected check boxes
Teri, I think I have done this before by setting the second che

14 May 2009

RE: Wrong error display for invalid user or password
Mike, This usually happens if the PTWEBSERVER account is locked or if the

14 May 2009

RE: Peoplecode example of connected check boxes
The problem is... is that the user needs to see two check boxes. The firs

14 May 2009

RE: Problem with a grid on a run control page
Found the problem. I was missing PeopleCode on oprid fieldDefault. All is w

14 May 2009

Re: Decryption of Credit Card numbers
Documentation of encryption/Decryption. Give a shot. http://helpnet.vccs.ed

14 May 2009

RE: Peoplecode example of connected check boxes
Don't do a check box do a radio button if there is only two options for the

14 May 2009

Wrong error display for invalid user or password
I just started to get this issue out of the blue. When a user trys to log i

14 May 2009

RE: How to delete PeopleSoft private queries
If you are on PeopleTools 8.4x you can delete the Private Query through the

14 May 2009

Re: How to delete PeopleSoft private queries
You can convert Private query to Public Query (Via SQR is achievable) and d

14 May 2009

RE: WEBLOGIC: java.lang.OutOfMemoryError: Failed to fork OS thread
We are experiencing the same issue with out installation of Financials 9.0

14 May 2009

Peoplecode example of connected check boxes
I need an example of how to have peoplesoft check boxes dependent on each o

14 May 2009

RE: Help about URL in a mail
So did you take your url from the portal and send it or did you send the on

14 May 2009

RE: Insert Blob Field
If you are having applications like Toad for accessing database, u can crea

13 May 2009

Query App Engine Process
No suggestions or ideas as to why this is not working? We have customised t

13 May 2009

Comp Plan Enrollment Table In PeopleSoft
Anyone know how to create a query to pull active comp plan enrollment in PS

13 May 2009