More Questions

Here are some of the most frequently asked interview questions in PeopleSoft Technical side. This page contains only questions so that you can research more and find the answer and gain knowledge on the related areas.

For having question & answers check out the PeopleSoft IQ section.

1          How good are you in SQR?
2          How to write a simple report in SQR using 'setup'?
3          What are the various SQCs we are using in an SQR program?
4          How much time you will take to understand an SQR program?
5          How good you are in SQL?
6          What are the data you are capturing in Job hire page?
7          Have you worked in HRMS? Which functionality?
8          How do you solve data conflict problem?
9          How do you setup department security?
10        Where do you setup row level security?
11        In the search page for an employee duplicate rows are showing. What will be the problem?
12        What is meta SQL? Wher can it be used?
13        Event flow in people code? How you will debug peoplecode?
14        While running a process using process scheduler the process status remains as "queued" . What is the problem?
15        How to configure SMTP server?
16        Have to change the field length of a field. How you will go about it?
17        What will happen if we are reducing the field length? What precaution we have to take?
18        If we are changing the translate value for a field, what impact it will make in the system?
19        Have you worked in data mover?
20        How you will import the data from one table to another using data mover?
21        What is vacation process? How it works?
22        What are different action and action reason in job page?
23        What is FTP? Where we are using that?
24        Array in SQR. How to define an array and how to populate values?
25        What events get triggered in "SEARCH" mode? ADD mode?

1          what is your ratings in SQR,AE,Processes Scheduler,PIA,PeopleCode
2          what is structure of an Appplication Engine Program?
3          what is state record ?
4          can we pass the values from one program to another program using staterecord
5          what is set processing? Where it will be used ?
6          if we have to run an sqr report through processes scheduler wht we have to do ?
7          what are the procedures used to run a report through Processes Scheduler?
8          where we can view the status of the report?
9          have you used any multiple reports?
10        how to pass user request  from webserver to application server?
11        what is temperory table?
12        when we  insert a row what are events get fired ?
13        what is jolt ?
14        how to attach sqr report to processes scheduler?
15        what is load looku p?
16        can you tell me two meta sql's used in AE
17        while saving what are the events get fired
18        can we have more than one main section in a AE program
19        where to give the node defination in processes scheduler
20        what is PIA
21        how good you are in funtional
22        how to debug  in sqr
23        what is the difference between show and display?
24        what is the difference between print and show?

1          Tytes of Record
2          SetID  And Business_unit Concept
3          diff between field change and fieldedit
4          Ps Query Concept
5          what r the Key fields in Job table
6          what   is the use of EFFSEQ
7          How many levels  Available in page
8          Grid in which level we have to use
9          when the user enter a row of data what r the events will be fire
10        Application Engine structure
11        Allow Deferred Processing   Concept
12        Allow Deferred Processing  where we can define
13        satate record concept
14        How TO debug SQR PROGRAM
15        performance techinics in SQR
16        Effdate  Query
17        Prompt Table Concept
18        what is the  use of command line fasg -s
19        what is TRIGGER
20        What Is Cursor
21        how to run the sqr program in process Sehedular
22        what is purpose of Derived Work Record
23        What events get triggered in "SEARCH" mode? ADD mode?
24        Setup Tables in CORE HR
25        Arrays And Load lookup Concept
1          In Save Mode what r the events will be fire
2          what r the Available Actioins in Application engine a
3          Can I use one application engine state record to another application engine
4          What is the use of Command line flag -ZIV
5          What r the key fields in run control record what is the record name.
6          Think time function in which event we can use
7          What is use of Discard Row function
8          on-error concept in SQR
9          Load-lookup Arrays Concept indepthly
10        Structure of Application engine .
11        If application engine program Not having MAIN Section what we can call that Application engine program
12        Serch mode events
13        What are the Component Record and field and component level events
14        what r the events evalable in page level
15        Temparary table concept
16        if I create one tempary table I gave 4 instances for that table total how many instance will be created
17        what is use of %select and %bind Meta sql functions
18        how to run sqr through SQRW
19        What r the think time  functions where we can use
20        what is the use of STDAPI.SQC Ana What r the procedures include that SQC
21        What r the sectionS Available in SQR
22        What is the use of SETUP section
23        DML Statements in which section we can write
24        can we write different sql state ments in one procedure
1          something about myself
2          Something about the work i have done in my projects.
3          How to execute an Appengine program through peoplecode
4          what are different ways to execute Appengine?
5          what is the difference between  field edit and field change?
6          what is the difference between Rowinit and RowInsert?
7          what is Import & Replace_all commands in Data mover?
8          How to refer 2nd level row field  value?
9          In which scenario you have used CI
10        How  you created CI?
11        What kind of customization you have done & with one example?
12        what is difference between Active row count & Total row count
13        How to open component without search page?
14        what kind of security you have done?
15        what kind of work done with query ?
16        Have you develope queries in 2-tier or 3-tier mode
17        which option you select to write code in Record level or Component level
18        in which scenario you used Dynamic view and what kind of code written?
19        How execute an Appengine program from process scheduler
20        How you give the security to query?
1          Explain about the project you are currently working.
2          What is the difference between field edit and field change.
3          How you will override the search page ?.
4          How you will enter the data from flat file to people soft tables through SQR Program.
5          What is rowset and how you will access Perticular row in a scroll?.
6          Can we write the Trigger business event function in saveprechange ?.
7          What will happen if we Update the component records in Savepostchange event?.
8          What is the difference between save prechange and save postchange events.
9          Have you worked on the SQL class.
10        What is state record and tell me an example?.
11        How many state record instances we can create?.
12        When we will use the component level people code?.
13        What kind of code we will write on Page Activate event.
14        What kind of reports you worked on in SQR like Graphs, tabular reports etc?.
15        Overview of file layout.
1          Tell us about your experience
2          Please let us know the support calls you have resolved during your FAP support project
3          What is the process involved in changing an Employee to an Non-Employee in jobdata
4          Explain the steps in creating an SQR for uploading the JOBDATA component
5          What are the minimum Key fields required in uploading the data , please explain the appropriate validations  which you will consider for those fields.
6          How do you tune your JOBDATA SQR  is slow (explain the steps)
7          Explain the Begin-Select and Begin-SQL Paragraph with examples.
8          Have you used Load Lookup in your SQR's , if so what was the requirement and how did you use it
9          What is a Translate Table , what is the purpose of it.
10        Explain  a case study where we use SavePreChange and SavePostChange events

1) difference between interface and conversion
2) For data conversion which approach u will go and why
3) any cjhallenges u face
4) tell me abt ur current project details
5)tell me any app engine created from scratch.
6)execute edits
7) file layout edit error
8)state record - if u run 2 app engine parallely how many rows will be present in state record
9)temp table
10 tell me any function that u wrote in peoplecode
11) if u creat alt search keys then do we have to build
12)set processing and row by row processing
13) load look up
App. Designer

  

  1. What is efftdt? How to make a table as Effective Dated?
  2. How to by pass search page?
  3. What is the Difference Between Search and Advance Search?
  4. How to change Translate value dynamically?
  5. How will you fetch the value from a scroll if there is a particular field value?
  6. When a component buffer loaded what kind of fields that the entire row is not loaded into the buffer?
  7. Difference between Sql-view and Derived Record?
  8. Where the sub record stored?
  9. Where we use Dynamic View?
  10.  What are the Diff. between Prompt and Translate Table?
     13. Can I have more than one level of scroll in a same level?
  1. How will you find the current row of the employee?
  2. Describe development life-cycle of PeopleSoft application?
  3. Describe the purpose of Upgrade tab of Application Designer?
  4. What is System Table?
  5. What is Tools Table?
  6. What is Application Table?
  7. What is Translate Table? And where the translate values are stored?
  8. What is Prompt Table?
  9. If we have multiple rows with SAME Effective date, how do you identify the most recent row?
  10. Describe Field Display, Use Display, Edits Display and PeopleCode Display?
  11. Describe Record Types in PeopleSoft?
  12. What is Sub-Record?
  13. What is Sub-page?
  14. What is Secondary-page?
  15. What is the difference between Query View, SQL View & Dynamic View?
  16. What is mean by Temporary Table & its purpose?
  17. Can we use Non-Standard SQL table in PeopleSoft? Have you used it?
  18. What is the benefit of creating table with Index?
  19. What is the purpose of Compare & Reports?
  20. Where to view Change Control History?
  21. How to migrate project from one instance to another instance?
  22. What is the purpose of creating Project in Application Designer?
  23. What is mean by Search Record?
  24. Where will you setup Search Key, Alternative Search Key, List box Item?
  25. What is Audit? Where will you define?
  26. What is the benefit of using Alter-Table?
  27. Can we make the field as related display field with out having display control field?
  28. What is mean by Scroll?
  29. What is the difference of using Grid & Scroll?
  30.  How many Scroll Levels we can have and how many records we can use with each level?
  31. At what Level will you define Search Record?
  32. What is deferred processing? Where will you define?

Component Interface

  1. How do you interact PeopleSoft Application from Non-PeopleSoft Application?
  2. What is Component Buffer? Where the Component Buffer is created?
  3. Keys, methods, properties and collections?
  4. What is the hierarchical structure of the data buffer?
  5. Can you test your Component Interface in the Application Designer?
  6. Which property is used to determine whether the Component Interface runs in Update/Display or Correction mode?

Workflow
  1. Define the components of Workflow?
  2. What function will you use for triggering the workflow?
Process Scheduler

  1. What is Run control ID?
  2. How to create a Run control Table what are all the fields required?
  3. Where can you restrict the output destination options for reports using?

Application

  1. What is the difference between Add, Update/Display, Update/Display All, and Correction Mode?
  2. What is Business-Unit?
  3. What is Setid?
  4. What is mean by Row level security?
Application Engine

  1. What are the layers into which an AE is structured?
  2. What is state record?
  3. Why we use restart and reuse logics?
  4. What are the AE Actions brief us?
  5. What is the purpose of using the Meta-Sql?
  6. Compare App. Engine and SQR and Differentiate?
  7. What is Set Processing? What are the Advantages?
  8. How do we activate the Debug Facility? What steps would be appropriate?(We have to set the Debug check box ON, in the process scheduler folder tab in the Configuration Manager)
  9. If you want remove restart logic what are all the places you need to remove?
  10. Types of variables used in AE?
  11. What are the Application Engine Components?
  12. In how many modes we can Execute AE program?
  13. What are the advantages of using Application Engine? Have you written one? What for?
  14. What are the parts of Application Engine?
  15. What are the different ways in which an Application Engine program can be run?
  16. What is the Function for Calling Application Engine Program?
  17. What is the benefit of using Re-start logic?
  18. Why do we use the File Layout?
  19. What is File path Absolute& Relative in File Layout?
  20. What is State Record?
  21. What is Temporary Table?
  22. What is META SQL? %Bind? %Select?

SQR

1. Why and when to use SQR?
  1. List type of procedures?
  2.  What is the significance of SQC’s?
  3.   What are the common uses SQC’s?
  4. How to write multiple reports in a single SQR?
  5. Why we use Break-logic?
  6. I want access data from CSV source, where we need to declare in the report?
  7. (We need to write Declare-Connection in the Begin-Execute command , prior to the
  8. Begin-Select command)
  9. What are the Debugging commands used in SQR?
  10. What are the sections of SQR Report?
  11. What is the default section in SQR?
  12. What is SQC? Have you written one?
  13. What are the minimum SQC’s you need to execute your SQR?
  14. Difference between SQR Report & SQR Process?
  15. What is the purpose of Setup Section?
  16. How will you debug your SQR? Explain?
  17. What is Implicit & Explicit Printing?
  18. Difference between Show & Display?
  19. What is the purpose of On-Break Logic?
  20. What is Look-up and Load-Lookup?
  21. How will you print Bar-codes in SQR Report?
  22. What is mean by Array? Where will you define in program? Have you used it?
  23. How will you track the SQL Error messages in your program?
  24. How will you use Global variable, which is defined in local procedure?
  25. What is a difference between Ask & Input command?
  26. How do we Convert Number to String in SQR?
  27. How do you print a document/letter using SQR?

PeopleCode

1. If there is an error being encountered on RECORD.FIELD.FieldFormula? How do you pinpoint where the error is.

  1. Define Component processor event Sequencing?
  2. If you want to save the panel forcefully, what is the peoplecode we use?
  3. What utility functions we used to read the flat file?
  4. Can we run a batch file from a page, if so which function we use to run? 
  5. Explain real time scenario for a savepost built peoplecode event?
  6. What is the sequence of PeopleCode Event execution?
  7. What is Page PeopleCode Event & describe the purpose?
  8. What is Derived/Work record? Why is it used?
  9. Differentiate FieldEdit & FieldChange event?
  10. What is the purpose of using SaveEdit event?
  11. What is the purpose of using SavePreChange & SavePostChange Event?
  12. Which event can we write Error/Warnings?
  13. Name the events associated with - Record field, Component Record Field, Component Record, Component, Page, Menu?
  14. In which event do we write code to force an user to enter some values to the search key in a search page so that the full list need not be retrieved?
  15. How will you skip the Search Page using peoplecode function and which event will you write this?
  16. Have you done debugging PeopleCode?
  17. What is set processing?
  18. What is meant by Built in SQLExec functions? How to use input parameters, bind variables and output variables in them? Explain giving examples?
  19. What is the use of FieldFormula Event?
  20. What is the use of RowInit event?
  21. Can you create a new class in PeopleSoft?


Subscribe to: Posts (Atom)