| Subject | Date Asked |
|
| Role Query | 12/9/2008 |
Q: Can you tell me how role 'Query User' is used, there's no permission list attached so I'm not sure ...
A: One example would be if the "Use Query to Route Workflow" checkbox was checked on the Workflow tab ...
|
| Role Query | 12/7/2008 |
Q: Can you tell me how role 'Query User' is used, there's no permission list attached so I'm not sure ...
A: I don't have access to view this role on my current system, but roles can be used for workflow and ...
|
| Dont where to begin from with XML Publisher | 11/20/2008 |
Q: I am interested in learning XML Publisher but i really dont know where to begin. Can you please give ...
A: Best place to begin would be the XML Publisher PeopleBooks - this would give you information on the ...
|
| File Transfer | 10/13/2008 |
Q: ..I need to transfer one file from one UNIX box to another UNIX box through people code( or I may ...
A: The Exec command isn't interactive, so you can't use it for commands which return some text or value ...
|
| Component Record Field | 10/12/2008 |
Q: What is component record , component record field ? If we want to write a code on component record ...
A: Open the component definition in App Designer and go to the second tab that lists the component ...
|
| File Transfer | 9/25/2008 |
Q: ...This is to follow up with my earlier question about File Transfer from one UNIX Server/Machine to ...
A: In Unix, you can "mount" a drive, which is, at it's simplest, similar to mapping a drive in Windows. ...
|
| Peoplesoft | 9/24/2008 |
Q: I am trying to run an existing sqr but not getting the pdf,can i know in what possible cases we dont ...
A: Some SQRs will not produce output (a PDF file) if there's no data, so ensure that data does indeed ...
|
| ps QUERY | 9/17/2008 |
Q: I have an audit query which looked at changes to a voucher over a stamped date/time. It was working ...
A: Check the Use tab of the Record Properties for the VOUCHER record in App Designer. You should have ...
|
| Crystal repot migration | 9/4/2008 |
Q: Crystal template was migrated from one environment(crystal folder) to another twice - second time I ...
A: Try adding some version text, e.g v2, in the header or footer of the report. Ensure that the "Save ...
|
| Security | 9/2/2008 |
Q: "You are not authorized for this page. ...
A: Your User ID must be granted permission to access the page. This is usually done by a Security ...
|
| Excel in Application engine | 8/12/2008 |
Q: I would like to create an excel output from an Application engine process. I've browsed the ...
A: You can use GetFile and the WriteLine function to write comma-separated values to a XLS file. You ...
|
| Query Help | 8/11/2008 |
Q: I'm trying to write a query that will give me the number of CRs that are in one of these 3 statuses: ...
A: Try removing the "AND A2.CR_STATUS = A1.CR_STATUS" line, so the query will look like: SELECT A1.* ...
|
| Application Engine | 8/7/2008 |
Q: I just wanted to know why we can't have CALL and SQL Action in a Single step.I have gone through ...
A: PeopleSoft doesn't really explain why both actions cannot co-exist in a step. My personal thoughts ...
|
| Scroll Select | 8/6/2008 |
Q: ..I have one field at level 0 from work record. On the RowInit Event I have populated my Level 1 ...
A: Check whether the SaveEdit event is being fired on fields in your Level 1 scroll - either through a ...
|
| People Code | 8/1/2008 |
Q: I have a SROLL on level 1. I want to dynamically populate it with data and the data is the result of ...
A: Very easy to do. Use the following template as a guide: /* Declares rowset */ Local Rowset &RS; /* ...
|
| Creating Dyanmic View | 7/11/2008 |
Q: I need your help in creating dynamic view for this SQL Query "SELECT PROJECTNAME FROM PSPROJECTITEM ...
A: A few things to try: 1. Use WinMessage to display the SQL string before you assign it to SQLText so ...
|
| Peoplesoft Security v9.0 | 7/2/2008 |
Q: My question is what is the difference between setting up security in v8.9 and v9.0? Is there a red ...
A: 9 to 9.0. Security is actually considered part of PeopleTools, so the Security changes would depend ...
|
| PS FInancials: Pay Cycle scheduling | 6/19/2008 |
Q: We have a requirement where we need to schedule the PayCycle processing. The requirement is that the ...
A: In that case, you may need to customize the AE. I'm not too familiar with the Payroll apps, but one ...
|
| PS FInancials: Pay Cycle scheduling | 6/17/2008 |
Q: We have a requirement where we need to schedule the PayCycle processing. The requirement is that the ...
A: You can create a separate job which runs the selection process only, and you can attach this new job ...
|
| Regarding PeopleSoft | 6/5/2008 |
Q: I am new to PeopleSoft.how to learn PeopleSoft.There's no resources available
A: There are several resources you can use. 1. Read through PeopleBooks for the modules you're ...
|
| multiples-reports | 5/29/2008 |
Q: I need to generate multiples-reports from a SQR, but the report's number is variable, I'm using ...
A: Open the process definition for the SQR and append the following to the parameter line: -MR n ...
|
| SQR report | 5/28/2008 |
Q: I created a run control page,process to run an sqr report. can you please tell me the process how to ...
A: You'll need to create a Process Definition. This ties the run control to the process, and also ...
|
| File layout Property Change: | 5/26/2008 |
Q: ! This is a follow up of your prior reply for File layout Property Change. In PT 8.49 "Space" in ...
A: First, ensure that a space value does indeed exist in the file, as in ' ' Then go to the Preview ...
|
| RE: SQR Help | 5/20/2008 |
Q: I just have another question relating to that. Would you say that way is more efficient or would ...
A: The Substr() function can return the character at a specific position in a string. The following ...
|
| RE: SQR Help | 5/19/2008 |
Q: I just have another question relating to that. Would you say that way is more efficient or would ...
A: There's no "for" loop in SQR - you have to use WHILE instead. The WHILE loop would look like: let ...
|
| SQR Help | 5/15/2008 |
Q: I am having this problem where when I look at my report, the bottom of the page will have all the ...
A: You might be able to use the WRAP option in the PRINT command. Look it up in the SQR Reference ...
|
| App Eng: "Traffic Light Signal" Button Disabled | 5/14/2008 |
Q: Greetings!! I have installed peoplesoft in my system Tools 8.48 and product 9.00. When I log into ...
A: A few things to check: 1. You must be logged on in 2-tier for the traffic light to be enabled. 2. ...
|
| File layout Property Change | 5/12/2008 |
Q: Working in PS 9.0/PT 8.49 and the below 2 changes were noticed for File Layout objects. 1)Number ...
A: Open the File Layout in App Designer and click on the Preview tab. Choose the Segment name and for ...
|
| Message Log in AE | 5/2/2008 |
Q: I have an AE which consists of a couple update statements (on transaction tables). I need to log the ...
A: In that case, you might want to include an action before your SQL update/insert step that returns a ...
|
| Message Log in AE | 4/30/2008 |
Q: I have an AE which consists of a couple update statements (on transaction tables). I need to log the ...
A: You can use either of the following to log a message to the message log for your App Engine: 1. Use ...
|
| component interface import | 4/22/2008 |
Q: iam working with the component interface with filelayouts to import the data from a text file. the ...
A: Test the CI using the Test CI option in the Tools menu. Once it works there, then ensure that you ...
|
| error | 4/15/2008 |
Q: when i save the page at portal a error is poping up as "Data being added conflicts with existing ...
A: Try doing a PeopleCode trace on the save button. This would tell you what data is causing the issue. ...
|
| Excell Object | 3/28/2008 |
Q: I try to Open an excell Object from Peoplesoft with the following code Local object &WORKAPP; ...
A: Looks like you misspelt "Application" in the first line. Try: &WORKAPP = CreateObject("COM", ...
|
| Seagate Crystal Report for PeopleSoft | 3/27/2008 |
Q: When I attempt to open the application (crw32.exe) I receive and error "Invalid multi-user file". I ...
A: If you copy the working directory from another installation, it won't work because there are several ...
|
| Tool to move all the setups(not transactions) from one PeopleSoft Instance to other Instance | 3/24/2008 |
Q: I am asked to create a tool, which we will run at the day end, to move all the setups and ...
A: Data Mover would be the easiest solution. Just add the tables and criteria. You can then setup ...
|
| Error in PS JOB | 3/18/2008 |
Q: I have an existing report and I need to automate it, the report is run via process type - Job, there ...
A: since there are several. You can schedule the existing job without cloning it. Try creating the ...
|
| Installing Peoplesoft 9.0 on a Labtop | 3/1/2008 |
Q: I am a peoplesoft functional expert and want to update my skills with the PeopleSoft 9.0 HRMS. I ...
A: You need some technical knowledge of databases, web and app servers to setup a PeopleSoft ...
|
| Replication between PS HRMS & Fin | 2/27/2008 |
Q: Could you please let me know what are different ways of replicating data between PS HR & Finance ...
A: Two of the most popular options available to you are: 1. Using Integration Broker messaging to ...
|
| Peoplesoft General Ledger differences between 8.9 and 9.0 | 2/25/2008 |
Q: I'm investigating the differences between features of Peoplesofts General Ledger 8.9 and 9.0. ...
A: Mike, Your best bet is to review the Release Notes on Customer Connection for version 9. This will ...
|
| not getting upload page in recruiting | 11/30/2007 |
Q: while trying to upload the resume the upload page is not appearing and it's going for page expire. I ...
A: Were any modifications made to the upload page and code? As delivered, the code should be uploading ...
|
| write to .CSV File through AE | 11/2/2007 |
Q: Regarding writing into the .CSV File it was not my homework actually I was trying a AE that could ...
A: Excel simply interprets a CSV file as an Excel file and displays the values in a column format. ...
|
| SQR Report | 10/18/2007 |
Q: I have a problem with my report repositery we all know we have report repositery on web sever but my ...
A: You can have your DBA code a FTP script to move the report file from the Report Repository to your ...
|
| Testing PeopleSoft | 9/27/2007 |
Q: I am new to Peoplesoft testing, and have been asked to test for the updates in Taxes, and also 401K ...
A: Test cases and test plans are usually confidential client deliverables, so it would be difficult to ...
|
| Instantiating object of a class in DLL | 9/23/2007 |
Q: Can u plz help me in Instantiating object of a class in DLL? DLL is from dot net application. I used ...
A: I've instantiated Java objects using the CreateJavaObject method. I'm not too sure if this works ...
|
| Journal lines of one journal are posted to other | 8/23/2007 |
Q: we have a a JE wherein the Journal lines of one journal are posted to other Journal? Could you ...
A: Not sure why this would happen. Journal IDs tie the header and line information together. This could ...
|
| file creation and loading data | 8/9/2007 |
Q: my requirement is i want a file at the end of data which contains all the transactions made on that ...
A: Look up the GetFile peoplecode function. In App Engine, you can use the following to open a file, ...
|
| Generating Reports Using Application Engine | 6/22/2007 |
Q: I have written an AE program which picks the data and writes it into the CSV file. Since the CSV ...
A: It is possible to write a PDF file from App Engine, but it involves the use of third party ...
|
| Application Engine | 6/19/2007 |
Q: Few days back i asked you how to do reports (out put in excel) using Application Engine ...
A: Try: local Object &WORKAPP; &WORKAPP = CreateObject("COM", "Excel.Application"); &WORKBOOKS = ...
|
| Hi,all | 6/14/2007 |
Q: May i know exact difference between Component level PeopleCode and Record Level PeopleCode
A: There is no difference between the actual PeopleCode that you can use at the component, record field ...
|
| Reporting Using Application Engine | 6/11/2007 |
Q: I need your help to clarify the following doubts: 1)how to do reports (out put in excel) using ...
A: In it's simplest form, you can create CSV output in Application Engine - these files are readable by ...
|
| Query Expressions | 6/8/2007 |
Q: I have a query that results in a list of customers who need to be assigned to service reps based on ...
A: You'll need to create an expression, and then add the expression as a field/column to your query. ...
|
| SETIDs | 6/5/2007 |
Q: Our company has had Peoplesoft for several years now - when it was installed, we didn't understand ...
A: Your concerns are valid. Setids and Business Units are control data which you'd setup before the ...
|
| Control Records | 6/3/2007 |
Q: I am just starting with PeopleSoft programming and I was wondering what is Control Record used for ...
A: Control records enable you to share control table information (like job codes, locations, department ...
|
| application engine | 5/31/2007 |
Q: how send a e-mail using application engine and how to write a code for send an e-mail after it gets ...
A: Look up the "sendmail" function in your PeopleCode Reference PeopleBooks. You can use this function ...
|
| ps table | 5/29/2007 |
Q: I have installed PeopleSoft 8.48 and HRMS 8.9.I am navigating through Set Up HRMS, Product Related, ...
A: The record name will be displayed under the heading Record (on the Order tab of the page ...
|
| ps table | 5/28/2007 |
Q: I have installed PeopleSoft 8.48 and HRMS 8.9.I am navigating through Set Up HRMS, Product Related, ...
A: I don't have access to a HR system right now, but try this: navigate to the page in question, press ...
|
| Regarding Application Engine | 5/22/2007 |
Q: What is the use of Application Engine
A: PeopleSoft Application Engine is a PeopleTool designed to help you develop, test, and run background ...
|
| Report writing in Peoplesoft | 5/14/2007 |
Q: At the moment I am searching the internet for some manauls on the reporting possiblities in PS 8. ...
A: The "tools" version is different from the "product" version. So HRMS 8.8 or 8.9 might be running on ...
|
| SQR dynimical sql syntax | 5/10/2007 |
Q: I meet a syntax problem , as below : let $t_sales_group_cust = '#t_sales_group_cust' after ...
A: To use a dynamic text string in your SQR for selecting from a table, use the following: $where = ' ...
|
| RE :which technology is best | 5/4/2007 |
Q: okay thanx very right .i wanted to know that which tool is best for SQR (which can give you the ...
A: In terms of PeopleSoft development, I've found that a simple text editor and the basic Brio SQR ...
|
| which technology is best | 5/3/2007 |
Q: I am currently working in SQR (BRIO) .i wanted to know that which technology is best SQR or crystal ...
A: It all depends on what type of reports you want to create. If you're using an existing PS Query and ...
|
| sqr | 3/19/2007 |
Q: hai Ash, could u tell me that where actually the SQR in loaded for execution as it is a 3rd party ...
A: The SQRW executable, which actually executes your SQR programs, exist at PSHOME/bin/SQR/DBX/BINW ...
|
| sqr | 3/18/2007 |
Q: hai Ash, could u tell me that where actually the SQR in loaded for execution as it is a 3rd party ...
A: Have a look at the following article: ...
|
| secondary page | 2/15/2007 |
Q: i want to go from secondary page to main page by using peoplecode which function will support to do ...
A: The secondary page comes with OK and CANCEL buttons that can be used to return to the parent page. ...
|
| Application Engine | 1/27/2007 |
Q: We have a job which is scheduled to run daily. We have added an app eng in that job. But that job is ...
A: Open the Job Definition and ensure that the Run Always on Warning and Run Always on Error is set ...
|
| small question | 1/8/2007 |
Q: why call section and sql are mutually exclusive in Application engine actions.
A: PeopleSoft doesn't provide any explanation for the fact that these two steps are mutually exclusive ...
|
| Multiple reports in SQR | 1/4/2007 |
Q: Could you please tell me how can i get the details of a record through SQR. means suppose i am ...
A: You'll need to query the following tables: PSRECDEFN - record definitions PSRECFIELD - fields that ...
|
| SQR error while connecting to link server | 12/19/2006 |
Q: I am getting error while importing data from HR to Fin through SQR. I guess system here is using a ...
A: You'll need to check your DBA on this one. A couple of things for him to look at: - Ensure that ...
|
| Multiple reports in SQR | 12/11/2006 |
Q: Ashram, we are doing data archival but while doing multiple table in a time we are not able to do ...
A: The history or archive table has a _H appended to the end of the table name. So for PS_JOB, the ...
|
| PSOPRDEFN emplid | 12/9/2006 |
Q: My question is regarding how emplids are created in Peoplesoft. Our security admin had recently ...
A: Employee IDs are created and used within HRMS, but not Financials. To answer your questions: > I am ...
|
| Multiple reports in SQR | 12/5/2006 |
Q: !!!!!!!! Ashram - we are looking to implement data archival and we are looking for diffrerent ...
A: Data archival in PeopleSoft is pretty straighforward, so I would recommend it over any 3rd party ...
|
| multiple report in SQR | 11/29/2006 |
Q: in the message log the maximum length is 256???? Thanks AbhishekHi I am trying to generate ...
A: What I meant was that the maximum file length in Windows is 256 characters. That being said, try ...
|
| let and move commands | 11/22/2006 |
Q: what are the differences between let and move commands in SQR?
A: Let assigns the value of an expression to a variable. The expression can be a function, group of ...
|
| PeopleCode md5 hash value generation for a file | 11/19/2006 |
Q: Is there a PeopleCode function that can generate a md5 hash value for a file? Please send me an ...
A: There's no delivered PeopleCode function to generate a MD5 hash. You should be able to write a batch ...
|
| PeopleSoft Technical | 11/14/2006 |
Q: Thnks for the reply but Ya it is that once you click on a component link, the menu collapses to look ...
A: That's definitely strange behaviour. Have you or anyone else modified any portal menu code? Also, ...
|
| PeopleSoft Technical | 11/9/2006 |
Q: I have a query. When I am selecting a page from the navigation in the left, once I am on the page, ...
A: Are you saying that the navigation disappears and you don't see the portal menu? Or is it that once ...
|
| Asset Retirment Status Code = C | 10/27/2006 |
Q: One of the fields in the PS retirment table is labled retire status and contains a code of C. What ...
A: If you have access to Application Designer, open the field definition, click on the Properties ...
|
| master file setup import layout | 10/13/2006 |
Q: Hey Ashram have read your posts around, and have to tell you that u are the Guru in PS.... I needed ...
A: SQR provides a UNSTRING function which can help you split a line read from a file into a set of ...
|
| Duplicate Reqs are appearing in Worklist | 10/12/2006 |
Q: We have one user who is seeing duplicate requisitions to approve in her worklist. We are using 8.4 ...
A: Multiple worklist entries can appear on an approver’s worklist where the person entering the ...
|
| peoplecode | 10/11/2006 |
Q: i want to know answer for a very basic question in peoplecode. what is the difference between the ...
A: Have a look at the following article from PeopleSoftCity: ...
|
| Applcation Designer | 10/4/2006 |
Q: I know the page name which I can open in Application Designer.Now, I want to open that page in ...
A: It depends on what Tools version you're using. One way would be to do a "Find Def Reference" and ...
|
| Application Engine | 9/29/2006 |
Q: What is the difference between Do Select and Do while and Do until?
A: Here's a basic outline of the AE actions you're asking about: Do While The Do While action is a ...
|
| ROLEXLATOPR table | 9/28/2006 |
Q: How does this table get populated? There is an employee id field on the table that I need to ...
A: ROLEXLATOPR is the role user table. It's populated through the workflow page called Roleuser ...
|
| Finance : AR | 9/27/2006 |
Q: What is the difference between bill and invoice? How they are related?
A: A bill is a document requesting payment for goods previously supplied. This presentation of a bill ...
|
| Application Engine | 9/24/2006 |
Q: I am facing problem in Peoplecode this time.Actually we are upgrading Peoplesoft from 8.3 to 8.9 ...
A: Hey there, Try it in DEMO to be certain that you're supposed to be transfered to the Job component ...
|
| Application Engine | 9/22/2006 |
Q: suppose my AE is calling 5 different child AE so will we be having different process instance for ...
A: App Engines usually call sections in other app engine programs - in these cases, they share the same ...
|
| Application Engine | 9/21/2006 |
Q: Thanks, AbhishekHi If i am using on one physical state record in my application engine and that ...
A: I'll try to answer your questions:If i am using on one physical state record in my application ...
|
| Application Engine | 9/19/2006 |
Q: If i am using on one physical state record in my application engine and that State record is having ...
A: A PeopleSoft Application Engine state record must have a process instance (PROCESS_INSTANCE) defined ...
|
| Application Engine | 9/16/2006 |
Q: this nikhil Please let me ,what are the various way to Restart in the application Engine.Can we ...
A: You can configure your App Engine process to enable restart by using the Program Properties dialog ...
|
| File layout!!! | 9/15/2006 |
Q: I used Import Manager before but this version 8.9 is no longer supported so I have to use the File ...
A: Correct, File Layouts replace Import Manager, and they're not too difficult to use! Have a look at ...
|
| Creation of Operators via database | 9/7/2006 |
Q: i had asked you a question sometime ago on creating PS Operators for PeopleSoft 7.5. Generally this ...
A: Good job! Would it be possible to run a PeopleCode/SQL trace on an Operator save? This would give ...
|
| peoplecode | 9/1/2006 |
Q: i want to ask you what are basic navigation and how to set an application in an enterprise on ...
A: When you are kicking off a report using the process scheduler, you can specify what output format ...
|
| PeopleSoft nVision Printing | 8/31/2006 |
Q: We have just upgraded to PeopleSoft 8.8 from 7.5. I am still having an issue with nVision. Reports ...
A: Unfortunately, the option for printing all instances does not exist in 8.x. You can either open and ...
|
| Asset Retirement | 8/31/2006 |
Q: No Disposal code selected for the Retirement. We do have Retirement accounting entry templates ...
A: Try creating templates for different combinations of Category/Transaction Type/Template Id for your ...
|
| DFD using Visible Analyst | 8/30/2006 |
Q: you are so nice and you could be a fantastic tutor in uni. My tutor is so bad who even hates talking ...
A: A class diagram might suffice for your situation - although it depends on what your assignment ...
|
| Asset Retirement | 8/28/2006 |
Q: When I tried to retire an Asset I the message "There is no accounting entry template for the ...
A: If you've selected a Disposal code for Retirement, you'll need to check the Retirement by Disposal ...
|
| DFD using Visible Analyst | 8/22/2006 |
Q: I have a really hard task from uni and have to ask you for help cauze I enjoyed learning from your ...
A: Although this isn't a PeopleSoft-related question, I do have experience with CASE tools so I'll try ...
|
| Peoplesoft - AP setup for Thailand VAT | 8/17/2006 |
Q: Actually i am looking at how to improve the efficiency of entering the VAT, as my users have to go ...
A: Since the location and vendor have VAT defaults setup, the line defaults would filter down from the ...
|
| Peoplesoft - AP setup for Thailand VAT | 8/16/2006 |
Q: To whom it may concern, My company is using peoplesoft 8.8 version now, however we have some ...
A: I'm not an AP expert, but I have worked with the module during development, and from what I ...
|
| PeopleSoft SQR to create Operator | 8/10/2006 |
Q: I was investigating creation of a Operator (P.S. 7.5) using MessageAgent. However, after talking to ...
A: SQR is licensed to PeopleSoft by Brio Technologies, and its main purpose within PeopleSoft is for ...
|
