Important question in peoplesoft

PEOPLE TOOLS:

1. What is the difference between Key and alternate search Key?

2. Which effective dated rows can be retrieved in update/display mode, update/display all and correction mode?

3. What types of audits are supported by people soft? In case of record level audit what is the structure of table?

4.    What are Table Edits?

5. What conditions are required to establish parent child relationship between two records? What are the advantages with that?

6. Can you place Sub page into Grid? If yes How?

7. Can you hide a primary page in a component? Reason?

8. What is an Expert Entry?

9. What is Auto Update?

10. What is Record Group? Which records can be included into a record group?

11. How can you improve the security and usability of a Prompt table edit.?

12. What are the different ways to setup row level security?

13. How does peoplesoft use views? Which are online functions?

14. Why do peoplesoft often use views as search records?

15. How can a component have more than one search record? Give a situation.

16. What is PIA and what are its components?

SECURITY

1. Before accessing a people soft application what levels of security must be passed through.

2. What is the use of primary permission list in user profile?

3. How to authorize the user to run a process or report?

4. How to give access to the records that are to be used in a query?

5. What are the rules used by the system to determine whether a user is authorized to update an object?

6. What are the different ways we can set up the portal security to access component in portal?

PEOPLE-CODE:

1.    Differentiate Field edit and Save edit?

2.    What are think time functions?

3.    In which events error & warning are used most extensively.

4.    Is there any way by which you can find out whether the user is in Add mode or Update mode?

5.     In which situation are we going to write peoplecode at component level?

6.    What is the purpose of the SQLEXEC function? What are its benefits and draw backs?

7.    How is the searchinit event most often used by people soft application?

8.    What are the options for using SQL in people code?

9.    What is the difference between component buffer and data buffer?

10. What databuffer classes are available in people code?

11. When we select a component what events will be fired?

12. What are different variables in people code and their Scope?

13. What is default processing?

14. What is difference between field default and Row init?

15. What is difference between saveprechange and savepostchange? Which function directly interacts with the database?

16. What is Getlevel0()? What is the use of %subrec and %selectall functions?

17. What is an array in people code? What is maximum dimension of an array? Which function inserts values into an array? What is “pop”?

18. What is difference between Getrowset and Createrowset in people code?

19. Can you save the component programmatically?

20. What is deffered processing and its advantages?

21. Write the syntax to access third level record field using object oriented peoplecode?

22. Write the syntax to hide third row of a second level record?

APPLICATION ENGINE

1. If AE program is aborted and is to be restarted from beginning, what will you do?

2. What is the use of temporary tables?

3. What are the section properties in AE?

4. What is the main purpose of the Access property in the Section?         

5. Which actions are mutually exclusive and why they are mutually exclusive?

6. If an error occurs in the step how will you handle the AE program?

7. What is the specialty of Bulk Insert in AE?    

8. What is the difference between Do while and Do until?     

9. What record types are used  to  create the state record?

10. How the state record can be shared between the AE programs?

11. What is the difference between exit(0) and exit(1)  functions used in AE?

12. How the temporary tables are allocated to the AE program in online &Batch mode?           

13. How do you interact with the state record?

14. What is the difference between the %SELECT and %SELECTINIT?

15. How many types of AE programs are there?

16. What is set processing?

17. What is the difference between callsection action and the CallAppEngine function

     

18. Explain about the dynamic property in the callsection action.

19. How will you read data from CSV or EXCEL file and upload it into the database using AE?

COMPONENT INTERFACE

1. What is Component Interface?

2. What are the different methods available in component interface?

3. How can you create new method to the component interface?

4. What does a session object do?

5. What environments are supported by the component interface API?

WORKFLOW

1. How do you fire the workflow?  What is the mandatory built-in function used in workflow peoplecode?

2. Is it possible to send a URL link through email?       

3. What are the advantages by using approval rule set?

4. How to set row level security in Workflow?    

5. What advantages do you have using role queries in roles?

6. When will you choose pooled list in worklist attributes?

SQR

1. What are the sections and paragraphs available?

2.    Is it possible to increase the array size once defined?

3.    What is Load-lookup? Give the Syntax for Load-Lookup?

4. Can you Call a SQR from another SQR? How?

5. Briefly explain Most commonly used SQC’s in SQR programs?

6. What are the commands used in filehandling of sqr?

7. What are On-break parameters?

8. How can you Debug SQR programs?

9. What is the difference between sqr and sqc?

10. What are different types of variables in sqr?

11. Is there any read-only variable in sqr?

12. How to pass Inputs for sqr program while running from windows?

13. How to pass Inputs to the SQR while running through the Process Scheduler?

14. What is the purpose of Stdapi.sqc

15. What is the SQT file? What are the advantages of SQT files?

16.  What is the SQC used to read data from translate table?

17. Which section is mandatory in an SQR program?

18. How will you display an image in SQR?

19. What is use of SETENV.SQC?

20. How will you perform ERROR handling in SQR?

21. How many ways of performance tuning are there in  SQR?

22. Can you call procedure in oracle from Sqr? How? 

 

23. Can you connect more than one database using one Sqr? How? 

 

24. What are the differences between Load lookup and Array

25. What are the steps required to run the SQR from peoplesoft environment?

26. How to pass command line flags to a sqr report running through process scheduler?

SHARE

peoplesoft

• 
• 
• 
• 
•