1. Explain 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

2. What is Customer Connection?

Log into (currently) PeopleSoft website with your login and password - https://www.peoplesoft.com/corp/en/login.jsp

3. Tell me Which of the following became obsolete with PS Ver8?

Operator Class

4. The field property is changed from Prompt with no edit to Prompt with edit wht is the effect. No more data edit possible?

explain your self

5. Explain Difference between chartfield and chart of accounts?

explain your self

6. Tell me How did you apply your patces and bundles?

use the PeopleSoft delivered Upgrade Assistant or Change Assistant for PT8.45 and above.

7. Suppose You need not create separate DB for every user in PPSFT 8.4 onwards. This is possible because of?

Access ID

8. Explain Use of process profile?

(scenario based on process profile / process group)Server o/p path override , process he can access

9. Tell me File format for SQR?

a) PDF
d) txt

10. Tell me What is component interface, where did you use?

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.

Download Interview PDF

11. Explain What are the think-time functions?

The functions which will suspend processing either until the user has taken some action. for example clicking a button in a message box

12. Tell me Can a business Process be used as a Navigator Home page?

true

13. Explain Where is Unicode used?

1) IBM DB2/UDB
2) Oracle
3) SQL Server

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?

WinMessage

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?

A role name

16. Do you know A System Manager must approve all the transactions what is this?

a) Business Event
b) A Rule
c) A Role
d) Activity

17. What are the parameters that you will give for crystal reports?

parameter is something that is prompted to enter by the user.Parameter fields support the following datatypes.
Boolean, currency, date, datatime, number, string, time

18. How to define the names of the application servers being used to access PeopleSoft?

a) In Configuration Manager, under the Application Servers tab.

19. What are the Outputs of SQR?

explain your self about the Outputs of SQR

20. When do we view Business process map?

a) Change in mapping of data

21. what are the major differences between peoplesoft versions HRMS8.8 and HRMS8.9? Explain with one example?

explain your self

22. 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)

23. 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

24. 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.

25. 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.

Download Interview PDF

26. PeopleSoft reserves ALL WinHelp context numbers (in Utilities, PeopleTools Options) up to which number?

10,000,000

27. Explain What is the result of the search with the following criteria in PS Books?

SQL Table OR Field

28. 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.

29. 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

30. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?

No its PSAUDIT

31. 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.

32. What is commitment control?

explain your self

33. What is the Process flow in Billing, AR, AM. GL, AP, PO etc?

explain your self

34. What are different peoplecode events?

fiels edit,fi
eldchange,
field default,
field formula
rowinit
,rowdelete
,rowinsert
,rowselect
,prebuild
,postbuild,
saveedit,
saveprechange
,savepostchange
,worlflow

35. What are the Different types of matching in AP(2,3,4 amd receipt only matching)? Explain them?

Explain your self

36. 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.

37. How to stop sqr, while running using a command in sqr(stop)?

explain your self

38. Peoplecode attached with Push Button can be associated with which of the following events?

Field Change event

39. Which Table contains Login User Id & Password in Peoplesoft Database?

It Is PSOPRDEFN. The password however is encripted.

40. To launch an Application Engine program from another App Engine program, which one of the following is correct?

CallSection Action

Download Interview PDF

41. Trace 255 command line option produces the trace file with the name?

PID.AET

42. People Soft allows multiple long fields per State Record?

False

43. 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

44. Do you know TriggerBusinessEvent is used for triggering the workflow and its written on workflow event. TriggerBusinessEvent has the syntax?

riggerBusinessEvent(BusProcess,BusActivity,BusEvent);

45. Do you know What are the triggers in a component?

Prebuild, Postbuild, save prechange, save postchange and workflow

46. Do you know Which of the following record is not found in database?

Derived work record

47. Do you know PSWORKLIST record is used for workflow routing. It should contains minimum of?

6 keys in Ascending orders

48. Tell me In which one of the following views would you see the fields, criteria, and other details associated with the current query?

Query view 9.

49. Tell me what is record, row peoplecode?

explain your self record, row peoplecode

50. Explain Differences between State and temp records?

We can use multiple instances of temp records where as in state record we can use only one instance of state record.

51. Can you explain DoSave( ) can be called from one of the following events?

FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange

dosave() can not be called from Save Prechange.

52. Explain Config. Command for JOLT?

psserver in configuration properties

53. 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.

54. what is PSCAMA(Peoplesoft Application messaging attribute)?

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 <PSCAMA> 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.

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?

PSRECORDNAME

Download Interview PDF

56. What is scroll select, etc?

explain your self scroll select, etc

57. Where do peopletools data is cached?

app server

58. Suppose A Simple Query involving Professor, Asst Professor and to find if both can be available before and at a mentioned date?

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

59. PeopleCode variables (global, component, local, and parameter), method, and property names can now be up to _______ characters long?

1000

60. Explain Tuning can be done on which servers?

a) Database Server
b) App Server
c) Batch Server
e) Web Server

61. What is paycycle and paycycle manager?

explain your sefl paycycle and paycycle manager

62. Explain File formats for File Layout?

The file formats can be .csv and fixed length also

63. What are the techniques for data transfer?

Data mover,importmanager,filelayout,sqr,application engine, component interface

64. The Trace tab in Configuration Manager only traces Windows client (two-tier) interactions?

True

65. What is One-to-Many?

Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table.

66. Tell me In which PeopleCode event does ALL data validation take place?

FieldEdit

SaveEdit

67. Explain Difference between sql statements and metasql statements?

meta sql is platform independent while sql is not.
meta sql enhances reusability.

68. Explain Why temp records are needed?

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.

69. Explain The application server dynamically scales server processes according to the volume of transaction requests? which is known as?

Spawning

70. What are the main differences between PeopleSoft Financail 8.4 And 8.8/8.9 version?

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

Download Interview PDF

71. How to delete a file using sqr?

use the command in the sqr:
delete($filename)

72. Explain How to test an application engine program in 8.8?

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.

73. What is a bundle?

Bundle is the group of patches and fixes, peoplesoft had delivered during specific time period

74. How did you apply your patces and bundles?

Through app designer manually (rarely) or through the change assistant, upgrade assistant tool.

75. What are the topics covered in People Books?

Bad options

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?

PS_RECORDNAME

77. Explain Load look up in sqr, where did you use?

load look up is a temporary storage where we can store data from multiple tables.we use it in setup section.

78. Explain In the URL identify Portal and Component name?

explain it your self

79. Explain Different ways to run AE, SQR?

Command, process scheduler

80. What are the new features in security in 8.0?

Learn about the new features in security in 8.0

81. What is left join, right join?

Learn about the all joins

82. The DB User mentioned in Connect ID should have permission to which Three PeopleSoft Tables?

PSACCESPRFLPSSTATUS PSOPRDEFN

83. Tell me Interlink data type can be declared as?

Local

84. Explain Process Profile contains?

a) Sequence of processes
b) Sequence of jobs
c) batch processes

85. Explain SQL Queries on PS_STAFF table?

3 Questions on this table with different queries and results

Download Interview PDF

86. What is app messaging, where did we use?

It is used to transfer data to the third party systems.

87. When Auto-join check box is checked what does it mean?

Common key fields

88. Tell me Call Section Action it is possible to leave the Program ID with blank Value in certain cases?

True

89. Leave went into LOP(scenarios based fit gap) Requirement phase is?

explain your self

90. Tell me What category of commands can be executed in data mover?

Sql , data mover commands

91. Suppose An employee is transferred where should he refer in this aspect?

Business Process

92. Explain SQL injection?

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.

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?

Projects provide the ability to migrate all objects at once or each object type individually.

94. Explain Why state records are needed?

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.

95. Explain Which of the following are object definitions?

a) Mobile Page
b) File Layout
c) App Engine

96. What is File formats for File Layout?

a) xml
b) csv
c) fixed length

97. How to views two Program of AE Program?

Definition, Program flow

98. Explain Where do we find the doc /// in customer connection---frequently updated. thing like patches?

log into Peoplesoft customer connect and navigate to Patches and fixes. To see future updates in plan - Click on Support -> Roadmaps and Schedules.

99. Where do you set People code trace?

In configuration manager trace tab.

100. Suppose If you change the long name of translate field what object to be altered?

Page def

Download Interview PDF

101. What is Connect id?

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.