61⟩ Which Table contains Login User Id & Password in Peoplesoft Database?
It Is PSOPRDEFN. The password however is encripted.
PeopleSoft General
Home Management PeopleSoft General
“PeopleSoft Common guideline for job interview preparation. Explore list of PeopleSoft General frequently asked questions(FAQs) asked in number of PeopleSoft Common interviews. Post your comments as your suggestions, questions and answers on any PeopleSoft General Interview Question or answer. Ask PeopleSoft General Question, your question will be answered by our fellow friends.”
102 PeopleSoft General Questions And Answers
62⟩ How to stop sqr, while running using a command in sqr(stop)?
explain your self
63⟩ Do you know TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?
riggerBusinessEvent(BusProcess,BusActivity,BusEvent);
64⟩ What happens if you dont specify a search record for a component?
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.
65⟩ What is commitment control?
explain your self
66⟩ What are the Different types of matching in AP(2,3,4 amd receipt only matching)? Explain them?
Explain your self
67⟩ PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
No its PSAUDIT
68⟩ Explain What is the result of the search with the following criteria in PS Books?
SQL Table OR Field
69⟩ PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?
10,000,000
70⟩ What are different peoplecode events?
fiels edit,fi
eldchange,
field default,
field formula
rowinit
,rowdelete
,rowinsert
,rowselect
,prebuild
,postbuild,
saveedit,
saveprechange
,savepostchange
,worlflow
71⟩ Peoplecode attached with Push Button can be associated with which of the following events?
Field Change event
72⟩ Explain What are different peoplecode events?
searchinit,
searchsave,
rowselect,
prebuild,
fielddefault,
fieldformula,
rowinit,
postbuild,
activate,
rowinsert,
rowdelete,
saveedit,
saveprechange,
workflow,
savepostchange,
fieldedit,
prepopup,
fieldchange,
itemselected.
73⟩ How to debug AE?
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.
74⟩ Can you explain the difference between SaveEdit and FieldEdit?
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
75⟩ Tell me Data Mover questions.....where did you use etc?
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
76⟩ What is the Process flow in Billing, AR, AM. GL, AP, PO etc?
explain your self
77⟩ Explain Which one of the following PeopleSoft Objects CANNOT be locked by developers as part of Change Control Locking as displayed above?
a) Process Definitions
78⟩ Different ways to run AE, SQR.(Command, process scheduler)?
SQR:command line(sqrw.exe),process scheduler & peoplecode
AE:commandline(psae.exe),process scheduler,peoplecode-callappengine(aename,st-rec)
79⟩ Explain Difference between SavePreChanges and SavePostChanges w.r.t SAVEEDIT?
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.
80⟩ What are the various ways to run sqr?
1.sqrw
2.From the front end through process schedular.
>>Register the sqr to any component and run the sqr.
