100 Updated PeopleSoft General Interview Questions
Q – 1 Explain Data Mover questions…..where did you use etc?
Ans- Data mover is used to move data of a record of database to another record in another database and the records should be identical in all respects like the number of fields, keys and fields
Q – 2 What is Customer Connection?
Ans- Log into (currently) PeopleSoft website with your login and password – https://www.peoplesoft.com/corp/en/login.jsp
Q – 3 Tell me Which of the following became obsolete with PS Ver8?
Ans- Operator Class
Q – 4 The field property is changed from Prompt with no edit to Prompt with edit wht is the effect. No more data edit possible?
Ans- explain your self
Q – 5 Explain Difference between chartfield and chart of accounts?
Ans- explain your self
Q – 6 Tell me How did you apply your patces and bundles?
Ans- use the PeopleSoft delivered Upgrade Assistant or Change Assistant for PT8.45 and above.
Q – 7 Suppose You need not create separate DB for every user in PPSFT 8.4 onwards. This is possible because of?
Ans- Access ID
Q – 8 Explain Use of process profile?
Ans- (scenario based on process profile / process group)Server o/p path override , process he can access
Q – 9 Tell me File format for SQR?
Ans- a) PDF
d) txt
Q – 10 Tell me What is component interface, where did you use?
Ans- A component interface is a PeopleSoft PeopleTools definition that is created to access a Component buffer without actually accessing the Component physically from the PIA.
Q – 11 Explain What are the think-time functions?
Ans- The functions which will suspend processing either until the user has taken some action. for example clicking a button in a message box
Q – 12 Tell me Can a business Process be used as a Navigator Home page?
Ans- true
Q – 13 Explain Where is Unicode used?
Ans-
1) IBM DB2/UDB
2) Oracle
3) SQL Server
Q – 14 Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
Ans- WinMessage
Q – 15 The field mapping button on worklist definition is used for for mapping the fields of worklist record that can be visible on worklist message. We can assign the following type of values to it?
Ans- A role name
Q – 16 Do you know A System Manager must approve all the transactions what is this?
Ans-
a) Business Event
b) A Rule
c) A Role
d) Activity
Q – 17 What are the parameters that you will give for crystal reports?
Ans- parameter is something that is prompted to enter by the user.Parameter fields support the following datatypes.
Boolean, currency, date, datatime, number, string, time
Q – 18 How to define the names of the application servers being used to access PeopleSoft?
Ans- a) In Configuration Manager, under the Application Servers tab.
Q – 19 What are the Outputs of SQR?
Ans- explain your self about the Outputs of SQR
Q – 20 When do we view Business process map?
Ans- a) Change in mapping of data
Q – 21 what are the major differences between peoplesoft versions HRMS8.8 and HRMS8.9? Explain with one example?
Ans- explain your self
Q – 22 Different ways to run AE, SQR.(Command, process scheduler)?
Ans- SQR:command line(sqrw.exe),process scheduler & peoplecode
AE:commandline(psae.exe),process scheduler,peoplecode-callappengine(aename,st-rec)
Q – 23 Explain Which one of the following PeopleSoft Objects CANNOT be locked by developers as part of Change Control Locking as displayed above?
Ans- a) Process Definitions
Q – 24 What are the various ways to run sqr?
Ans- 1.sqrw
2.From the front end through process schedular.
>>Register the sqr to any component and run the sqr.
Q – 25 Explain Difference between SavePreChanges and SavePostChanges w.r.t SAVEEDIT?
Ans- Save edit validates data and gives messages or warnings.when no error/warnings exist then saveprechange fires. it helps by doing one last check before the save process. save post change updates/inserts data into the records that have not been brought into to component buffer. it is recomended not to give error or warning messages in prechange and postchange events.
Q – 26 PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?
Ans- 10,000,000
Q – 27 Explain What is the result of the search with the following criteria in PS Books?
Ans- SQL Table OR Field
Q – 28 How to debug AE?
Ans- To run a program in debug mode:
Set the debug option.
You can set the debug option in the following locations:
Start PeopleSoft Configuration Manager and select the Process Scheduler tab.
In the Application Engine group, enable debug by selecting the Debug check box. This is the method that applies to all methods of invocation.
If you used the command line option to invoke your Application Engine program, then you can include the −DEBUG Y parameter in the command line you submit to PSAE.EXE.
Q – 29 Can you explain the difference between SaveEdit and FieldEdit?
Ans- Field edit can be used to locally check the syntactial errrors made by end user( mostly). It can be used for conplex checking operations too but rarely.
Save edit is used to check the logical existance or invalid datta inputs.It can be used for conplex checking operations.
Example if a broker becomes ineffective after a perticualr date, and if some calculations are done after that date, logic can be written in save edits to stop further processing and help the user identify another broker whose effictive date is valid for the date specified.
Field Edit peoplecode is fired when you try to change the value of a field on the page and Save Edit peoplecode is fired when you try to save the page. Both validates data but Field Edit peoplecode is used to validate the data for only that particular field which is changed and Save Edit peoplecode is used to validate all the data changes made to the fields on the page
Q – 30 PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
Ans- No its PSAUDIT
Q – 31 Explain What are different peoplecode events?
Ans- searchinit,
searchsave,
rowselect,
prebuild,
fielddefault,
fieldformula,
rowinit,
postbuild,
activate,
rowinsert,
rowdelete,
saveedit,
saveprechange,
workflow,
savepostchange,
fieldedit,
prepopup,
fieldchange,
itemselected.
Q – 32 What is commitment control?
Ans- explain your self
Q – 33 What is the Process flow in Billing, AR, AM. GL, AP, PO etc?
Ans- explain your self
Q – 34 What are different peoplecode events?
Ans- fiels edit,fi
eldchange,
field default,
field formula
rowinit
,rowdelete
,rowinsert
,rowselect
,prebuild
,postbuild,
saveedit,
saveprechange
,savepostchange
,worlflow
Q – 35 What are the Different types of matching in AP(2,3,4 amd receipt only matching)? Explain them?
Ans- Explain your self
Q – 36 What happens if you dont specify a search record for a component?
Ans- Fist thing, if the search record is not specified then the editor will not alow us to save.
Secondly, if the rquirement itself demands to skip the search record then, the best thing is to use a dummy search record called – INSTALLATION.
Q – 37 How to stop sqr, while running using a command in sqr(stop)?
Ans- explain your self
Q – 38 Peoplecode attached with Push Button can be associated with which of the following events?
Ans- Field Change event
Q – 39 Which Table contains Login User Id & Password in Peoplesoft Database?
Ans- It Is PSOPRDEFN. The password however is encripted.
Q – 40 To launch an Application Engine program from another App Engine program, which one of the following is correct?
Ans- CallSection Action
Q – 41 Trace 255 command line option produces the trace file with the name?
Ans- PID.AET
Q – 42 People Soft allows multiple long fields per State Record?
Ans- False
Q – 43 Tell me Data Mover questions…..where did you use etc?
Ans- Data mover is used to move data of a record of database to another record in another database and the records should be identical in all respects like the number of fields, keys and fields
Q – 44 Do you know TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?
Ans- riggerBusinessEvent(BusProcess,BusActivity,BusEvent);
Q – 45 Do you know What are the triggers in a component?
Ans- Prebuild, Postbuild, save prechange, save postchange and workflow
Q – 46 Do you know Which of the following record is not found in database?
Ans- Derived work record
Q – 47 Do you know PSWORKLIST record is used for workflow routing. It should contains minimum of?
Ans- 6 keys in Ascending orders
Q – 48 Tell me In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Ans- Query view 9.
Q – 49 Tell me what is record, row peoplecode?
Ans- explain your self record, row peoplecode
Q – 50 Explain Differences between State and temp records?
Ans- We can use multiple instances of temp records where as in state record we can use only one instance of state record.
Q – 51 Can you explain DoSave( ) can be called from one of the following events?
Ans- FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange
dosave() can not be called from Save Prechange.
Q – 52 Explain Config. Command for JOLT?
Ans- psserver in configuration properties
Q – 53 Explain the difference between SaveEdit and FieldEdit?
Ans- Field edit can be used to locally check the syntactial errrors made by end user( mostly). It can be used for conplex checking operations too but rarely.
Save edit is used to check the logical existance or invalid datta inputs.It can be used for conplex checking operations.
Example if a broker becomes ineffective after a perticualr date, and if some calculations are done after that date, logic can be written in save edits to stop further processing and help the user identify another broker whose effictive date is valid for the date specified.
Q – 54 what is PSCAMA(Peoplesoft Application messaging attribute)?
Ans- PeopleTools adds the PSCAMA record to every level of the message structure during processing. It isnt accessible in the message definition, but you can reference it as part of the Message object in the sending and receiving PeopleCode, and you can see it in the Integration Broker Monitor. PeopleCode processes this record the same way as any other record.
PSCAMA contains fields that are common to all messages. The tag repeats for each row in each level of the transaction section of the message.
The sender can set PSCAMA fields to provide basic information about the message; for example, to indicate the message language or the type of transaction a row represents. When receiving a message, your PeopleCode should inspect the PSCAMA records for this information and respond accordingly.
Q – 55 Do you know PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for system tables?
Ans- PSRECORDNAME
Q – 56 What is scroll select, etc?
Ans- explain your self scroll select, etc
Q – 57 Where do peopletools data is cached?
Ans- app server
Q – 58 Suppose A Simple Query involving Professor, Asst Professor and to find if both can be available before and at a mentioned date?
Ans- Lets say all the data resides in a table PS_TABLE_A.
Lets say AS_OF_DATE is held by a variable as_of_date.
Here goes the query:-
Select PROFESSOR, ASST_PROFFESSOR FROM PS_TABLE_A WHERE EFFDT< as_of_date OR EFFDT= as_of_date
Q – 59 PeopleCode variables (global, component, local, and parameter), method, and property names can now be up to _______ characters long?
Ans- 1000
Q – 60 Explain Tuning can be done on which servers?
Ans- a) Database Server
b) App Server
c) Batch Server
e) Web Server
Q – 61 What is paycycle and paycycle manager?
Ans- explain your sefl paycycle and paycycle manager
Q – 62 Explain File formats for File Layout?
Ans- The file formats can be .csv and fixed length also
Q – 63 What are the techniques for data transfer?
Ans- Data mover,importmanager,filelayout,sqr,application engine, component interface
Q – 64 The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?
Ans- True
Q – 65 What is One-to-Many?
Ans- Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table.
Q – 66 Tell me In which PeopleCode event does ALL data validation take place?
Ans- FieldEdit
SaveEdit
Q – 67 Explain Difference between sql statements and metasql statements?
Ans- meta sql is platform independent while sql is not.
meta sql enhances reusability.
Q – 68 Explain Why temp records are needed?
Ans- We use temporary tables because on run time it creates many instances for parallel processing so that load on main table can be bring down if multilple users are using same main table at same time.
Q – 69 Explain The application server dynamically scales server processes according to the volume of transaction requests? which is known as?
Ans- Spawning
Q – 70 What are the main differences between PeopleSoft Financail 8.4 And 8.8/8.9 version?
Ans- The inventory demand table structure was changed. In 8.4 there are 3 demand tables: demand_inf_inv, demand_inv, ship_inf_inv. In 8.8/8.9 there is only 1 demand table: in_demand
Q – 71 How to delete a file using sqr?
Ans- use the command in the sqr:
delete($filename)
Q – 72 Explain How to test an application engine program in 8.8?
Ans- One can test Application in two ways:
1. Running Application engine from 2-Tier
2. Running Application engine from 4-Tier.
1. Running Application Engine from 2-Tier: Open Application Designer, Then open desired Application engine. Then on top middle tool bar you can see ‘Run Programm button’ click on to that button, give vales to parameter like Process Instance, Run Cntrl id etc and click. this will run application engine and genreate a trace file to you local system. After complition of Application engine you can see if you got desired results or not.
2. Running Application engine from 4-Tier: Open 4-Tier link, Go to peopleTools-> Process Schedular -> Process, Add you Application engine process here, in ‘Process Defination Options’ give ‘PRCSMULTI’ in COMPONENT and ‘TLSALL’ in Process Group and then Save the page.
After defining Application engine, Go to peopleTools-> Process Schedular -> System Process Request, then add a RUN CONTROL ID, After adding run control id, click on the RUN button on the page, this will lead you to page where all the process will be listed, Select you process name (Application engine Name) and clik on ok. This will run you Application eingine.
Q – 73 What is a bundle?
Ans- Bundle is the group of patches and fixes, peoplesoft had delivered during specific time period
Q – 74 How did you apply your patces and bundles?
Ans- Through app designer manually (rarely) or through the change assistant, upgrade assistant tool.
Q – 75 What are the topics covered in People Books?
Ans- Bad options
Q – 76 PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record.Referring to the above information, which one of the following identifies the naming convention PeopleSoft uses for non-system(application) tables?
Ans- PS_RECORDNAME
Q – 77 Explain Load look up in sqr, where did you use?
Ans- load look up is a temporary storage where we can store data from multiple tables.we use it in setup section.
Q – 78 Explain In the URL identify Portal and Component name?
Ans- explain it your self
Q – 79 Explain Different ways to run AE, SQR?
Ans- Command, process scheduler
Q – 80 What are the new features in security in 8.0?
Ans- Learn about the new features in security in 8.0
Q – 81 What is left join, right join?
Ans- Learn about the all joins
Q – 82 The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?
Ans- PSACCESPRFLPSSTATUS PSOPRDEFN
Q – 83 Tell me Interlink data type can be declared as?
Ans- Local
Q – 84 Explain Process Profile contains?
Ans-
a) Sequence of processes
b) Sequence of jobs
c) batch processes
Q – 85 Explain SQL Queries on PS_STAFF table?
Ans- 3 Questions on this table with different queries and results
Q – 86 What is app messaging, where did we use?
Ans- It is used to transfer data to the third party systems.
Q – 87 When Auto-join check box is checked what does it mean?
Ans- Common key fields
Q – 88 Tell me Call Section Action it is possible to leave the Program ID with blank Value in certain cases?
Ans- True
Q – 89 Leave went into LOP(scenarios based fit gap) Requirement phase is?
Ans- explain your self
Q – 90 Tell me What category of commands can be executed in data mover?
Ans- Sql , data mover commands
Q – 91 Suppose An employee is transferred where should he refer in this aspect?
Ans- Business Process
Q – 92 Explain SQL injection?
Ans- SQL injection is an attack in which malicious code is inserted into strings that are later passed to an instance of SQL Server for parsing and execution.
Q – 93 Suppose You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing.Referring to the above information, why would adding your objects to a Project
streamline the migration to a new database?
Ans- Projects provide the ability to migrate all objects at once or each object type individually.
Q – 94 Explain Why state records are needed?
Ans- A state record is a People Soft record that must be created and maintained by the Application Engine developer. This record defines the fields a program uses to pass values from one action to another.Think of the fields of the Application Engine state record as the working storage for your Application Engine program.
An Application Engine state record can be either a physical record or a work record, and any number of state records can be associated with a program. Physical state records must be keyed by process instance.
Q – 95 Explain Which of the following are object definitions?
Ans-
a) Mobile Page
b) File Layout
c) App Engine
Q – 96 What is File formats for File Layout?
Ans-
a) xml
b) csv
c) fixed length
Q – 97 How to views two Program of AE Program?
Ans- Definition, Program flow
Q – 98 Explain Where do we find the doc /// in customer connection—frequently updated. thing like patches?
Ans- log into Peoplesoft customer connect and navigate to Patches and fixes. To see future updates in plan – Click on Support -> Roadmaps and Schedules.
Q – 99 Where do you set People code trace?
Ans- In configuration manager trace tab.
Q – 100 Suppose If you change the long name of translate field what object to be altered?
Ans- Page def
Q – 101 What is Connect id?
Ans- A Connect ID is a valid user ID that, when used during login, takes the place of PeopleSoft User IDs for the logon process. Using Connect ID means you don?t have to create a new database user for every PeopleSoft user you add to the system.
Connect id performs initial connection to the databse when the user tries to signon.