PeopleSoft Guys - Tricks » 2006

August 2006
S	M	T	W	T	F	S
		Oct »
	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	31

Posting a 1099 File to Web

By suresh malneedi

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.

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

For more info go through the People Books.

Posted in System Administration | No Comments

Change Assistant: not showing up the environment name and system

By suresh malneedi

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.

Posted in System Administration | No Comments

Unable to connect to RenServer

By suresh malneedi

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 ?.

Posted in System Administration | No Comments

Changing Access ID and Access Password

By suresh malneedi

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 = 0This 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.

Posted in System Administration | No Comments

REN server with DNS alias issue

By suresh malneedi

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

Posted in System Administration | No Comments

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

By suresh malneedi

(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)

Posted in CRM, SQR | No Comments

PeopleSoft FAQs

By suresh malneedi

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.

Posted in CRM, Miscellaneous | No Comments

Inserting Objects in to Project Automatically

By suresh malneedi

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.

Posted in CRM, PeopleTools | No Comments

Crystal Reports Print Engine error

By suresh malneedi

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.

Posted in CRM, Crystal Reports | No Comments