Top PeopleSoft Jobs
PeopleSoft AWE (Approval Workflow Engine) - Part 1
Tuesday, October 30, 2012
- Business Process
- Activities
- Steps
- Roles and Rules.
- Requires development in Application Designer (creating Business Process, Activities, Steps and PeopleCode etc.)
- Not configurable online
PeopleSoft AWE (Approval Workflow Engine) - Part 1
Read more...PeopleSoft Document Resources
Tuesday, February 23, 2010
Helpful PeopleSoft Documents (PeopleTools/Technical Related) from Metalink:
Red Paper Topic | Description | Meta Link | ||
Online Performance Configuration Guidelines for | Practical | rp_e_opcg_845_846_847_848_849.pdf (440.33 KB) | ||
Online Performance | Learn how | Download Download Download Download | ||
LDAP Red Paper with Troubleshooting Tips for PeopleTools | LDAP Red Paper (1,820.02 KB) | |||
Red Paper on Securing Your PeopleSoft Application | How to secure PeopleSoft | Red Paper (1,382.04 KB) | ||
PeopleSoft PS/nVision Configuration & Troubleshooting | RP_nVision_guide (1,204.22 KB) | |||
Red Paper on Implementing Clustering and High | Clustering_and_High_Availability-_840.pdf (1,983.35 KB) | |||
Clustering and High Availability for Enterprise Tools | This | PeopleTools Clustering Red Paper (2,827.3 KB) | ||
Configuring a PeopleSoft Portal | This | configuring_ps_8_portal_v1.pdf (1,259.16 KB) | ||
Troubleshooting WebLogic 8.1 and 9.2 Issues |
| |||
Approval Workflow Engine (AWE) for HCM 9.0 | This | Approval Workflow Engine (AWE) for HCM 9.0 (672.01 KB) | ||
PeopleSoft Performance Monitor Red Paper | Performance | Performance_Monitor_RedPaper.pdf (3,326.46 KB) |
PeopleSoft Document Resources
Read more...Test E-mail workflow functionality
Monday, February 22, 2010
"the mail is not going to the mail user and i am not even getting any error messages. I checked my SMTP in my server its all working fine . I dont know what is the issue. I even tried using Sent Mail function till its not working as expected.... "
Answer:
To troubleshoot this issue, there might be different reasons. You need to have appropriate setup and test the setup to see if your SMTP settings are working in the first place.
Below are setups the required for enabling or using Workflow notifications/emails:
1. The first and foremost thing is to setup: SMTP server Application server/Process scheduler used for the development.
2. E-mail should be enabled and configured for the instance in which the workflow is developed. eMail id's should exist in PSOPRDEFN and PSEXLATOPR tables; Also, emails are triggered using Person Profile.. in some places.
3. The User Profiles for the Roles are already in Place with proper Worklist ID s and Permissions.
Configure the SMTP in your psappsrv.cfg as well as in psprcs.cfg:
Invoke the PSADMIN.exe in the PS_HOME/appserv directory and in the application server configuration, SMTP settings section specify the ip-address for the machine where SMTP server is installed.

Under the Setup WorkFlow Defaults:
1. They have a valid Worklist-id in PeopleSoft User profile.
2. E-mail and Worklist are enabled for the users


2. Enter the test mail subject message
3. Save the component
Once the component is saved, it should trigger e-mail to the test users Worklist id specified in the user profile.
- Locate an SMTP mail server that you specified in SMTP settings under your App or Prcs Server SMTP settings
- Prove the mail server is accessible by connecting via telnet or pinging it.
3) Make sure the email id specified is active and exists.
Test E-mail workflow functionality
Read more...PeopleSoft PeopleBooks
Thursday, February 11, 2010
Where can i find Documenation like PeopleBooks related to PeopleSoft?
Answer:
Check the below link that would give you links to PeopleBooks for PeopleSoft Application 9.0, 8.x versionsand PeopleTools 8.4x
PeopleSoft PeopleBooks
Read more...PeopleSoft Query Security
Answer:
All of these are utilized by PeopleSoft Query through user's security settings, row-level security, and primary permission list. Query Profiles are setup in Permission List (PTPT1000) , under Query Tab. Query Access Groups are attached to Permission List (HCSPQUERY), under Query Tab.
About Query Security Record:
• It Specifies the rows of data that user is permitted to retrieve.
• OPRCLASS
• ROWSECCLASS
For Example, If you want to add a Query Security to PS_JOB record, you need to check the record properties (the query security comes pre-delivered)
PeopleSoft Query Security
Read more...XML Publisher : Question
Hi
I am using peoplesoft HR9.In XMLP, when defining new record definition,the XML Output options are disabled on the output page. Please help Thanks
Answer:
PTPT2500 (XMLP Power User )
PTPT2600 (XMLP Report Developer )
Note that the delivered reports tend to use the PeopleSoft User role as the author ID. If you are configuring security stick to roles - rather than assigning security by individual users.
You can also change this through:Reporting Tools > XML Publisher > Setup > Report Category
Also, by default, when you load the Report Definition Page, the output page is enabled with all format output options for the template type you pick in the Definition Page. check this table to see if the data is loaded or not:
select * FROM PSXPTMPLOUTFMT
if the data is missing from PSXPTMPLOUTFMT, then you may have to get it from your Demo system.
XML Publisher : Question
Read more...Step by Step PeopleSoft Installation
Wednesday, February 10, 2010
Answer:
Step by Step PeopleSoft Installation
Step by Step PeopleSoft Installation
Read more...Slow performance since oracle 10g upgrade...
Question:

It is a 56 page PDF document related to performance on Oracle 10g using Enterprise PeopleSoft products. Some of the information covered include:- Generating Statistics
- Reviewing Dedicated Temporary Tables
2. Oracle 10g Migration:slow performance after upgrade to Oracle10g
Hope this helps...
Slow performance since oracle 10g upgrade...
Read more...PeopleSoft Compare Reports
While iam doing compare reports ,i have received the repost saying that SOURCE is -->ABSENT and TARGET is -->Present .What does it mean ,please help me on this.

There are several steps in the compare process:

from Target Database i.e. Copy of Prod, which is at 8.3 release level:

If an object definition is defined differently in the Demo database than in the Copy of Production, the compare process will check to see whether either object definition has changed since the comparison release. If the object’s LASTUPDDTTM value is greater than the RELEASEDTTM value for the comparison release level (stored in PSRELEASE), the object has changed. If the object’s LASTUPDDTTM value is equal to or less than RELEASEDTTM, the object has not changed (since the comparison release). Whether the compared object has changed or not, if it has ever been changed prior to the comparison release by someone other than Oracle (LASTUPDOPRID <> ‘PPLSOFT’), the object is identified as a customization.
Below are the status that you would get for Source and Target Databases based on Compare report:


For Example :
When you run the below SQL in Source Database, i.e. a new version Demo Database you get the results of the PS_JOB record:

When you run the below SQL in Target Database, i.e. a Copy of Production Database you get the results of the PS_JOB record:

For Source Status: Since the LASTUPDDTTM (7/12/2006 8:06:39 AM) of PS_JOB in Source DB is less than release table's RELEASEDTTM (11/29/2006 11:38:04 AM) , and sinceLASTUPDOPRID is PPLSOFT, the status for this object in Compare Report should come as "Unchanged"

Use the Report Options dialog box to designate the report options:

Use the Report Filter dialog box to designate which reports will be produced:

Filtering comparison reports doesn’t affect which objects get added to a project during a database comparison, only which objects are reported. Any object defined differently in the two databases will always be added to the project.
The default actions for each object that you compared are reported in the Action column. The compare sets the action column based on what you need to do to make the Copy of Production database consistent with the New Release Demo database. You should not change these actions. You can decide whether or not to accept each action by setting the Upgrade value. Action types include:
The upgrade action is either on (Yes) or off (No). The system assigns the upgrade action based on the target orientation:This table summarizes the various status, action, and upgrade action possibilities that can be applied to a single definition during the upgrade compare process:
PeopleSoft Compare Reports
Read more...Trace AE and COBOL processes
Question: Process Type defn COBOL NT/Win2000 ORACLE %%PRCSNAME%%%%DBTYPE%%/%%DBNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%//%%DBFLAG%% With both the AE and Cobol traces done like this once this is done, everytime the program runs it will be traced. Need to undo all of this setting the override back to None in both Definitions will turn it off. Trace AE and COBOL processes
How to trace AE and COBOL processes using the Process Definitions instead of setting on Process Scheduler / App Server Config files.
ANSWER:
For AE, Open the Process Definition under PeopleTools, Process Scheduler. Go to the override tab, and on the Parameter list line select Append from the dropdown, and in the edit box next to it, you can use the desried combination of traces, they all are;
Parameter List Append -TRACE 7 -TOOLSTRACEPC 3596 -TOOLSTRACESQL 31
Save the Definition and hence forth this program will be traced each time it is run, until this is removed. Using Both the -TOOLSTRACEPC and -TOOLSTRACESQL together should only be done when required, as the output from both go into the same file, making it very large and difficult to read. For normal program tracing using just the;
-TRACE 7 -TOOLSTRACEPC 3596
Give the Application Engine Trace, which traces the SQL in an AE program, and the PeopleSoft Trace, which is the pcode trace.
The above settings have equivelent settings in psprcs.cfg, they are;
TraceAE= -TRACE output goes into Application Engine Trace (.AET) TracePC= -TOOLSTRACEPC output goes into the PeopleTools trace file (.trc) TraceSQL= -TOOLSTRACESQL output ALSO goes into the PeopleTools trace file (.trc)
Again, depending on what the program is doing, most commnoly we'd use the -TRACE and -TOOLSTRACEPC together.
The only time I use the -TOOLSTRACESQL is when we're looking for a problem with the psae program itself.
For COBOL the idea is similar, we won't be appending to the parameter list instead we'll be overriding it. So first step is to open the appropriate Process Type Definition, example;
Copy the whole parameter list line into you mouse clipboard;
Then open the Process Definition for the particular COBOL Process, go to the Override Tab, and on the Parameter list line, select Override from the drop down. Then in the Parameter Edit box, paste the whole parameter list from the Process Defn we just got;
%%PRCSNAME%% %%DBTYPE%%/%%DBNAME%%/%%OPRID%%/%%OPRPSWD%%/%%RUNCNTLID%%/%%INSTANCE%%//%%DBFLAG%%
Notice at the end of the line after the %%INSTANCE%% and before the %%DBFLAGS%% there are 2 // We need to insert the desired bit map number inbetween the slashes.
![]()



















