PeopleSoftGuys.com Home
Navigate
viagra samplesviagra high blood pressureviagra super activeviagra jellyviagra costviagra theme songviagra make you last longerviagra 100 side effectsviagra original useviagra 100mg reviewviagra vasodilatorviagra alternativeviagra y alcoholviagra informationviagra usaviagra patent expirationviagra ukviagra like drugsviagra online prescriptionviagra jokes emailviagra erowidviagra los angelesviagra with alcoholviagra interactionsviagra nitratesviagra cost walgreensviagra headquartersviagra no prescriptionviagra levitra cialisviagra joint painviagra shelf lifeviagra ringviagra or cialisviagra paypalviagra voucherviagra japanviagra and cialis togetherviagra expirationviagra vs cialisviagra mgviagra erectionviagra useviagra kidneyviagra email virusviagra under tongueviagra priceviagra super forceviagra without edviagra virus emailviagra 3viagra before and afterviagra vs levitraviagra juicingviagra eye problemsviagra and womenviagra gumviagra use in womenviagra jetviagra horror storiesviagra questionsviagra directionsviagra jingleviagra and grapefruitviagra soft tabsviagra buyviagra vs genericviagra blogviagra generic dateviagra when to takeviagra videoviagra zurichviagra recreational useviagra headacheviagra zonder receptviagra 30 pills 100mg eachviagra and alcoholviagra how it worksviagra use in young menviagra triangleviagra za muskarceviagra ingredientsviagra effectsviagra substituteviagra blue visionviagra vsviagra generic nameviagra mexicoviagra next day deliveryviagra nitric oxideviagra triangle barsviagra kick inviagra womenviagra pillsviagra commercial songviagra kenyaviagra use directionsviagra drug interactionsviagra dosesviagra vs levitra vs cialisviagra side effectsviagra quick tabsviagra kidsviagra cialisviagra vs. birth controlviagra canadaviagra youtube channelviagra effects on womenviagra by mailviagra para mujeresviagra premature ejaculationviagra kaiser permanenteviagra kick in timeviagra empty stomachviagra in canadaviagra blindnessviagra virusviagra goldviagra off patentviagra 150 mgviagra 100viagra 100mg priceviagra you raise me upviagra side effects alcoholviagra with dapoxetineviagra adviagra in the waterviagra fallsviagra grapefruitviagra urban dicviagra professionalviagra buy onlineviagra young ageviagra historyviagra musicviagra makes a romantic relationshipviagra indicationsviagra from indiaviagra overdoseviagra best priceviagra newsviagra experiencesviagra maximum doseviagra las vegasviagra for womenviagra 10mgviagra rxviagra 3000mgviagra discount couponviagra patentviagra testimonialsviagra and zocorviagra walmartviagra overnightviagra 30 day free trialviagra young menviagra prescriptionviagra doesn't workviagra timeviagra 30 minutesviagra and ecstacyviagra 25mg side effectsviagra gelviagra za zeneviagra over the counter
August 31st, 2006

Posting a 1099 File to Web

Recently I came across one issue that the 1099 Process is generating a file with .001 getting posted to Report Repository, but it is not producing any link in View log / trace.

The link is not showing up in View Log trace, because the file type .001 is not defined in the Process Scheduler System settings. To fix the problem use the following steps.

  1. Go to  PeopleTools -> Process Scheduler -> System Settings
  2. Go to Distribution File Options
  3. Complete the File Type and other necessary information for .001 file.

For more info go through the People Books.

August 26th, 2006

Crystal Report Date format Issue

Process Scheduler changing the custom date format to default date format.Workaround:

Go to Process Schduler -> Processes ->
Open the your crystal process definition
Go to Overrude options tab and Append the following to the Parameter List.

-LX0

August 26th, 2006

Change Assistant: not showing up the environment name and system

Change Assistant not showing up the environment name and system typeWhile uploading the Environment to the peoplesoft gateway. The XML file is not including the environment name and system type.

Solution:

This happens when there is no environment name and system type not mentioned in PeopleTools options. Use the following navigation.

PeopleTools -> Utilities -> Administration -> Peopletools Options

you will then have to do a recrawl and upload to see the environment name.

August 26th, 2006

Unable to connect to RenServer

When One of our functional People running a report from the page they were getting the following error.Unable to connect to RenServer

Solution:

I verified the Ping Test and Buffer Test by going to RenServer cluster, everything was working Normal. Then I changed the machine name to Lower Case and I was able to run the report successfully.
Strange isn’t it ?.

August 26th, 2006

Changing Access ID and Access Password


If you need to change the both Access Id and Access Password follow the following steps.
UPDATE PSSTATUS SET OWNERID = ‘ACCESSID’
UPDATE PSACCESSPRFL SET ACCESSID = ‘NEW_ACCESS_ID’, SYMBOLICID = ‘SYMBOLIC_ID’, ACCESSPSWD = ‘NEW_ACCESS_PASSWORD’, ENCRYPTED = 0
This AccessID should have dbo access when it created on database server.

Note: No need to encrypt this, when you open the application designer first time, it will automatically encrypt and update the PSACCESSPRFL table.

If you need to change the access password, change the password for that user at the database level and open Application Designer then go to Miscellaneous Definitions - > Access Profiles.

August 26th, 2006

REN server with DNS alias issue

I was getting REN server communication failed eror when I try to ping from REN Server cluster page, After changing the URL from machine name to a DNS alias.Workaround:

Go to PeopleTools -> REN Server Configuration -> REN Server Cluster
Replace your machine name in Cluster URL and Browser URL point to your DNS name.
Recycle Your Application Server

August 26th, 2006

(SQR 4045) Function or operator ‘dateadd’ requires date

(SQR 4045) Function or operator ‘dateadd’ requires date argument. The above error will show up if you use dateadd function in SQR and didn’t declare the variable as date. use the following example. declare-variable
date $sunday
end-declare

….
let $date1 = dateadd($sunday,’minute’,1)

August 26th, 2006

PeopleSoft FAQs

1. Where do you do the development in PeopleSoft ?.
A. Using Application Designer.
2. How do you trace in PeopleSoft ?.
A. When you go to 3-tier login screen you will see a link for Trace, there you will specify the trace settings.

3. How do you run an SQR in PeopleSoft ?.
A. You can run in 2 ways
i) On client side using SQRWIN.exe
ii) On Server using Process Scheduler (Process Scheduler is also called as Batch Server).

4. How do you run an online job or process in PeopleSoft ?.
A. You can run using a Run Control page, once you click the run button it will submit the job to Process Scheduler. to check the status of submitted job click on Process Monitor link.

5. How do you check the process status in peoplesoft ?.
A. go to PeopleTools -> Process Scheduler -> Process Monitor.

6. How do you design a query in PeopleSoft ?.
A. Can be designed in 2 ways

i) Open App Designer then PeopleTools - > Query
ii) Login into 3-tier then go to Reporting Tools -> Query -> Query Manager.

7. What do you need to do to see a table in query designer ?.
A. Table needs to be added to a Tree to see the table.

8. How do you convert Panels to Pages ?.
A. Add all the Panels to a project and login to 3-tier (web) and go to PeopleTools -> Utilities -> Administration -> Convert Panels to Pages.

9. What are Translate values ?.
A. Transalate values will be assigned to fields where you will have a common 3 character values for example Federal ID filed could have values like SSN , TIN .

10. What is a Prompt Table ?.
A. Prompt table is used to prompt the valid values for a specific filed on a page. Prompt table can be a view or a table.

11. What are the major section in an SQR ?.
A. The main section is Begin-Program and End-Program, Begin-Procedure and End-Procedure.

12. How do you write a SQL statement in an SQR ?.
A. for select BEGIN-SELECT and END-SELECT for other BEGIN-SQL and END-SQL.

13. How do you debug an SQR program ?.
A. By putting Display and Show statements in the program and then check the out put file or use debug statement.

14. What output extension does the SQR will have if you run it from a client ?.
A. It can be .spf or .lis based on the SQR flag set.

15. What kind of out put you can get when you run from web (3-tier) ?.
A. It can be PDF, HTML, e-mail , LIS etc..

16. What is report repository ?.
A. Once the process scheduler finishes processing it will post the out put files to Report repository.

17. What is Report Manager ?.
A. Report manager can be used to see the reports in the report repository.

18. How do you see the newly created Component in the 3-tier menu.
A. You need to register the component by using Application Designer.

August 26th, 2006

Inserting Objects in to Project Automatically

Objective:
Developer needs to include all his objects when they modified and saved into the project.
Method:
The following method shows you how to insert an object automatically into a project when you modified and saved or deleted.

1. Open Application Designer.
2. Click on Tools - > Options
3. Under Insert Definition into Project, select ‘When definition is modified ….’ Option.
4. Under Related Definitions options, select ‘Prompt user to pick ….’ Option.
5. Click OK.

August 26th, 2006

Crystal Reports Print Engine error

I got the following error, when I tried to run a barcode report to PDF ouput type.Crystal Reports Print Engine error text: Error in File d:\pt8.44tst\crw\eng\po003.rt:
Operation not yet t:
Operation not yet implemented. %6 %7 %8 %9 (65,30)
Message Set Number: 65
Message Number: 30
Message Reason: Crystal Reports Print Engine error text: Error in File d:\pt8.44tst\crw\eng\po003.rt:
Operation not yet t:
Operation not yet implemented. %6 %7 %8 %9 (65,30)


Resolution:
This was causing because crystal reports is not able to export the barcode fontware (wasp) we are using to a PDF. To workaround be either use a different barcode fontware which is compatinle with Acrobat or choose different output type, when you submit the process to Process Scheduler.