Peoplesoft Important Interview Questions and Answers

8/10/2009 No Comment

Important Questions and Answers on Peoplesoft.

1. What is a workflow processor?
Workflow processor is a suite of online agents that run and control the workflow in your business processes. Once you define your business processes, you set up agents to do the work for you. Workflow processor consists of:

Word lists, which are ordered lists of the work a person (or group of people) have to do.
Application agents, which detect when a business rule has been triggered as users enter data into a People soft application. They evaluate who should action the new work instance (the role) and routes it to them (the routing)
The message agent, which processes messages sent to People soft external systems, such as electronic mail systems, interactive voice response systems, kiosks, other workflow systems, even the internet. It provides an application-programming interface (API) that enables third-party systems to integrate with People soft applications.

Database agents, which monitor the People soft database to identify items that need to enter workflow, such as overdue requisitions, scheduled performance reviews; departments that are over budget-any item you want to be alerted about. Workflow Administrator gives you the ability to access, monitor, analyze, and control workflow in your organization, which activities take the longest, which work lists are overloaded, and you can redesign work when an employee is out sick

2. What is a Tree?
It is a People soft object that defines the grouping and hierarchical relationship between the values of database fields. It also specifies how the system groups together the values of the fields for the purpose of reporting and security access.
Note: A particular tree is imported through out People soft system. Only one tree should be active throughout People soft system at a time.

3. What is a Tree Node (Unit)?
It represents the group of detailed values that report to it.

4. What is a Tree level?It provides the short way to refer all nodes that share a single parent.

5. What is a node?
It is an individual branch of main level.

6. What is a Parent?A node, which has other nodes reporting to it.

7. What is a child?
Lower level than its parent is called a child.

8. What is a sibling?
A node, which is placed at the same level, is called sibling.

9. What is meant by category in Tree manager?High-level grouping under which you can organize your tree structure and tree definition.

10. Explain the various options to define a Tree?
There are 2 options to define a Tree..
1.Detailed Tree: used to gather information about the various parts of the tree.
2.Summary Tree: collection of detailed tree nodes.

11. What are the advantages of Tree Manager?The following are the advantages of a Tree Manager..
1. By building a tree you can make rules centralized and can be used throughout the system.
2. Tree makes it easier to select the values you want to include in a report, ledger or security profile.
3. The main advantage in a tree is that it summarizes the rules visually and you can easily see as to now the values relate to each other.

12. What is an application reviewer?
It is a tool, which is window, based and designed as an aid in debugging People code programs. It allows us to investigate processing errors and to set a break point in between programs.
Note: People code works in data on the stacks. (Stacks store the internal machine execution numbers)

13. What are the important Cross-reference Reports in People soft?There are three important Cross-reference reports in People soft..
1. XRF PCFL (Cross reference people code to field)
2. XRF FLPC (Cross reference field to People code)
3. XRF PNPC (Cross reference panel to People code)

14. What is a Query Tool?
Query tool is a powerful tool for defining database queries in an easy-to-use graphical environment. You can extract the precise data you want using visual representation of People soft database.

15. Enlist the uses of Query tool?The following are the uses of Query tool..
1. It is used to simplify SQR statements
2. It can be used to generate one-time adhoc queries or queries used repeatedly.
3. It provides security for queries.
4. Query tool can be used to generate Pnvision and Crystal reports.

16. Explain briefly the types of queries?
There are 3 types of Queries
Search for records. Many of the search dialog boxes in People soft applications enable you to open Query and create a query based on the search record definition. This option enables you to search for records based on sophisticated search criteria. This type of query is called a search query.

Determine who to forward information to. You can write queries that People soft Work flow uses to determine who to send e-mails, forms, or work list entries to.
This type of query is called a role query>

User defined queries (adhoc query) is used to generate reports in the user defined format.

17. Explain briefly about the Database tab and Query tab?When you click the database tab, you see a list of available record definitions (or record components). You can view these records as either a tree of access groups or as an alphabetical tree of records to which you operator ID has access.
When you click the Query tab, you see all the components used in the current query (such as record components, field components, prompts, expressions, and so on.

18. What is an Access Group in a Query tool?
Access groups provide a way for you to logically organize the record components to control security access within Query. It is not a physical representation of your database. The record components shown are those that the operator has been granted access to.

19. Explain briefly about Crystal Reports?With Crystal Reports Pro from Seagate software, you can generate attractive reports. Crystal reports builds directly on queries you create in People soft Query. Crystal reports pro for windows is a report formatter that helps you to generate clear and easy to read printed reports containing data from your People soft applications. You can generate standard reports we have already created and saved in Crystal, or create your own custom reports.
Generating formatted output in Crystal involves two steps. First you create and save queries in People soft Query then you create report definitions in Crystal to format the fields (columns) used in the queries. Once you have created and saved the report definitions, you can print reports that are easy to read and understand. You can generate reports in a variety of different formats, including ASCII files, Microsoft Word documents and spread sheets.
Related Posts


No comments :

 

Aired | The content is copyrighted and may not be reproduced on other websites. | Copyright © 2009-2016 | All Rights Reserved 2016

Contact Us | About Us | Privacy Policy and Disclaimer