peopletools-l
Messages for 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
Ordonnancement
Sites (frenchs)
PeopleSoft Planet blog
Licence
Search
Global search
Ads