How to disable auto-numering feature in Peoplesoft

In the Installation table fill the the last assigned value with 9's.

Eg:- Last Employee ID Assigned field on the Last ID Assigned tab should be filled with only 9's.


One user can see the rows in the job data while the other user cannot see in Job Data search page.

(Applicable for most version of PeopleSoft HRMS 8 and for all version HRMS 8.3 and higher)

For these symptoms:

1. A user cannot view data that they have been granted access to on the Department Security Tree.

2. A user can view data they have not been granted access to on the Department Security Tree.

3. User is receiving "No Matching Entries Found" when using a search record

4. The PS_SCRTY_TBL_DEPT becomes empty

Here are the troubleshooting steps :

1. Have you run the app engine process HR_FASTVIEW (via Setup HRMS > Security > Department Security > Update Dept Security)?

2. Is the Update Row Level Security checkbox enabled when running the HR_FASTVIEW process (via Setup HRMS > Security > Department Security > Update Dept Security)?

3. Is the As Of Date designated on HR_FASTVIEW the same date as your current Department Security Tree?

4. Are the effective dates of your departments less than or equal to the effective date of your current Department Security Tree?

5. Does the SETID and TREE_EFFDT of your Department Security Tree appear via the following SQL after running HR_FASTVIEW -> SELECT * FROM PS_R_PER505 and is TREE_EFFDT equal to the effective of your tree via Tree Manager?

6. Is your Department Security Tree named "DEPT_SECURITY"?

7. If you've added a new department via the Department Table, have you also added it to the DEPT_SECURITY tree?

8. Do your users have the appropriate Row Security permission list assigned to their user profile (via PeopleTools > Security > User Profiles > User Profiles > General Tab > Row Security field)?

9. Does the Row Security permission list assigned to your user contain the appropriate setids and associated departments (the setid/departments per each department security tree that the user should have access to), and do the departments have Read/Write access (via Setup HRMS > Security > Department Security > Setup Security Access)?

10. If updating Fast Security, are all three checkboxes enabled via the Update Dept Security run control page (Re-Fresh Type 1, 2 and 3)?

11. Are there any departments via Setup HRMS > Security > Department Security > Setup Security Access (PS_SCRTY_TBL_DEPT) that do not exist on your department security tree (these need to be in sync)?

12. For an employee that isn't retrieved via Job Data (for example), sql PS_JOB for the employee (SELECT EMPLID, SETID_DEPT FROM PS_JOB WHERE EMPLID = 'xxx'). Does the employee's setid value in SETID_DEPT on PS_JOB equal the SETID of the department security tree(s) entered on the user's row security permission list (HRMS > Security > Department Security > Setup Security Access)?


Paygroup default on the Job Data component

A pay group consists of a group of employees who are paid together with the same pay characteristics ( pay period, same pay date, frequency, and so on). Pay group is used by payroll and payroll interface.

Although this information may seem specific to payroll processing - with either People Soft Payroll or your own system - you also need it for PeopleSoft Human Resources because it enables you to set up job records and Benefit program. serveral of the fields on the job data component contain default values that you specify on this table.

1)Employee Type Defualt
2)Default Benefit Program
3)Holiday Schedule.


Refreshing Employee Compensation

Refresh Employee compensation

Workforce Administration, Collective processes, Refresh compensation, Refresh Employee Compensation.

Refresh Employee Compensation Process.

This process recalculates compensation based on the current values in the system and automatically populates the correct compensation amount by inserting a new job row (unless there is no change to an employee's compensation). The process replaces manual changes with the new default values.

The refresh employee compensation process executes the same steps as the default pay components button on the compensation page, but you can update several records at once.

1) Inserts a new job row when you click the add new effective Date options with the effective date you entered in the as of date field.
2) Updates the job that is effective as of date you selected in the As of Date field.
3) Updates any future rows (rows are considered to be future if they come into effect after the As of Date ) When you select the update future rows check box.


Comparison between Peoplesoft and Fusion

Oracle Application Development Framework (Oracle ADF).

Oracle ADF is an end-to-end application development framework that allows you to develop enterprise solutions that search, display, create, modify, and validate data using web, wireless, desktop, or web services interfaces. Just like PeopleSoft applications are built on PeopleTools Framework, Fusion Applications are built on Oracle ADF. Oracle ADF builds on Java Platform, Enterprise Edition (Java EE) standards and open-source technologies to simplify and accelerate implementing service-oriented applications. Whereas PeopleTools is a black box type of development environment, Oracle ADF is more of a white box. This brings with it many new opportunities but also requires more investment from developers in learning the basic aspects of the underlying technology.
JDeveloper (jdeveloper.exe)
Just like Application Designer was the Integrated Development Environment (IDE) for building PeopleTools applications, JDeveloper is an IDE for building web applications. JDeveloper covers the full development lifecycle from design to deployment, with drag-and-drop data binding, visual UI design, and team development features built-in. JDeveloper can be used to build ADF Applications but is also an IDE for other technologies such as HTML, JSF, Java, and Swing.
Oracle Application Server
PeopleSoft Application Server (psadmin.exe) and Web Server (startpia) are the runtime environment required to deploy and run your PeopleTools applications. The runtime environment required to deploy and run your ADF web applications is Oracle Application Server or an alternative J2EE Web Application Server with ADF Runtime Installed. JDeveloper also comes with an embedded integrated server for testing and debugging your applications. Hence, you don’t need to deploy your application to the main application server to test it like you do with PeopleTools.
Meta Data XML Files
Unlike PeopleTools metadata which is stored in the database in various PeopleTools tables (psrecdefn, psfielddefn, pspaneldefn etc.), ADF metadata is captured and stored as XML. For instance, when you create a new page called CreateOrder, a CreateOrder.jspx file is created in your project. As you drag and drop components onto your page in the visual editor, XML tags for these components and their attributes are added to the XML file. In contrast to PeopleTools where the only way to alter PeopleTools metadata is through the Application Designer, a developer can directly edit the source of the XML file in addition to using the visual editor.
ADF Business Components
Business Components represent the logical data model for your application. The Entity Object and its attributes map to the database tables and columns, just like the record definition. Entity Objects have declarative validation and business logic. The View Object is used to create different views of the various entities, like the PeopleTools Record Definition of type View, but doesn’t require an actual view to be created in the database, which significantly reduces the number of views in the database. View Objects allow developers to create logical business objects like Person, Order etc. Attributes that don’t represent columns in the database, i.e. calculated fields, can easily be added to view objects. This removes the need for derived records. Business logic can be added to the Business Component objects at the various layers just like record and field PeopleCode.
In PeopleTools, PeopleCode is the language that is used for business logic when declarative or definitional development isn’t possible. In ADF, the language used for business logic is Java. JSF Page, JSF Page Fragment This is the canvas for your User Interface. Developers drag and drop components such as tables, forms etc. onto their JSF page to create the user interface for users. They can drop HTML, JSF, or most likely, ADF Faces components onto their page.
ADF Faces Components
ADF Faces is a set of over 100 components for developers to use to create their pages. ADF Faces UI components include advanced tables with column sorting and row selection capability, tree components for displaying data hierarchically, color and date pickers, and a host of other PeopleTools to Fusion Quick Reference Guides Page 5 components such as menus, command buttons, shuttle choosers, and progress meters. ADF Faces components provide very interactive web 2.0 features such as drag and drop and partial page rendering. These ADF Faces components bind to the business object layer just as panelfields are bound to underlying recfields.
ADF Task Flow
The ADF Taskflow defines your transaction boundaries like your component definition. You define the pages that are a part of your transaction and the navigational flow between your pages and across your transaction.
Component Buffer
At runtime, the component buffer is the representation of your data structures and business logic for your transaction. It maintains the current row, state, and saving of the data to the database etc.
Application Module
The Application Module is the equivalent of the Component Buffer but is defined with your ADF Business Components. This allows for separation between your data/business logic and your user interface. You can test and run your application module in JDeveloper without having a User Interface.
Application Designer Build Project ADF Offline Database Designer
In PeopleSoft, you create record definitions and build your tables in Application Designer, based on the record definition. JDeveloper and ADF provide a number of sophisticated tools to design, diagram and maintain your database schema. This technology is called the ADF Offline Database Designer.


Upcoming Advanced features in Peoplesoft.

1) Peoplesoft Reporting
Connects 2 or more PS/Queries.

n level nesting,Schedulable.
Parent-Child relationships
Underlying structure for XML Publisher subreport support & XML Output.

2) PeopleSoft Query Access Services
Standard Web Services to run and create PS/Queries Planned for PT 8.50

PeopleSoft and Business Intelligence Publisher Web Services Integration Planned Using QAS.
Report would be scheduled and executed on the BIP Server retrieving PS/Query as data source via QAS.
3) Crystal Reports Now with Platform & Performance Options.

4) Collaboration In Action

Connected to PeopleSoft transactions
• Pre-integration of collaborative services.
• All communication and artifacts together.
• Enable the free-flowing, ad-hoc nature of Web 2.0.
• Web 2.0 integrated into the Enterprise
• Availability and reliability.
• Permits management, security.
• Heterogeneous technology must be integrated.
• Out of the box integration, lower TCO.


What’s in a PT8.50 upgrade?


Report Development in Peoplesoft

How to choosse a particular reporting tool for developing the reports in Peoplesoft ?

What are the advantages / Disadvantages of
different Reporting Tools.

This picture gives information about which Reporting tool to be used based on the type of the report.


Application Messaging

How to inactivate Applicaiton Messaging ?
When large amount of data is converted or load in to the peoplesoft system it is very important to turn off the Applicaiton Message to improve the performance.
Main Menu > PeopleTools > Integration Broker > Integration Setup > Service
are the Applicaiton messages in the HCM 9.0. This service publishes a message every time a JPM profile Updated.