1) Where peoplecode get
stored?
A) In Database Server(PSPCMPROG
table)
2) Suppose if there is same component X in two different menus,
menu1 and menu2 and if u want to assign a different search record for each
menu, then which people code function do u use and where do u write the code?
A ) Instead of using PeopleCode, Directly
we can assign the search record at the menu level which will override the
search Record specified at the component level.
3)
What is Component Processor?
A) The Component Processor is the PeopleTools
runtime engine that controls processing of an application from the time that a
user requests a component from an application menu until the database is
updated and processing of the component is complete.
4) Explain How to send
email to the all employeee from the peoplesoft application when a certain event
is true? What is the event used to trigger?
A) Create a workflow. In the workflow, use a query with active
employees and their email ids as inputs. On the successful occurrence of the
event, trigger this workflow using TriggerBusinessEvent.
5) Explain about component Buffer?
A) Component
Buffer is the area in memory that stores data for the currently active
component.
6) Explain the advantage and
disadvantage of sqlexe in peoplecode?
A) By using
SQLExec function we can do the manipulation to the database. we can write
insert, update, delete sql commands. But drawback while selecting the data
using sqlexec, it will return only one at a time another drawback, if the name
of the records changed, then you have to make the changes in the code as the
query will in the quotes inside sqlexec
7) Tell
me Where can we write the peoplecode?
A)
1.Record field
level
2.Page people
code
3.Component
level people code
4.Component
record people code
5.Component
record field people code
6.menu item
people code
7.Application
engine people code
8.Component
interface people code
9.Messaging
people code
10.Application
package people code
8) Tell
me Is there any function exist in peoplecode which stops the processing of
whole component?
A) i think, it is
"Error" Function. Use the Error function in FieldEdit or SaveEdit
PeopleCode to stop whole processing and display an error message. It is
distinct from Warning, which displays a warning message, but does not stop
processing. Error is also used in RowDelete and RowSelect PeopleCode events.
9) Tell me What is the difference
between SQl Object and SQl Exec?
A) SQL Object is a
peopletool definition which can be created using app designer as well as using
peoplecode command CREATESQL( ) , it is mainly used for reuseablility of the
sql statements. so whenever this statement is required no need to hard code,
just create an sql object of the same and use where ever it is required.
sqlexec is a peoplesoft delivered function used
to retrieve only one row and u can update multiple rows of data. It directly
interacts with the database.
10) Tell me What is the diff between
component level peoplecode and record level peoplecode?
A) Record
Level peoplecode:
The peoplecode written on the Record level
Peoplecode will affect all the Components in which that particular record is
used.
Component Level
Peoplecode:
The
component level Peoplecode works only for that particular component and if any
record in the component is referenced by component level peoplecode then it
would not effect any other component where same record is used as it was doing
in above case.
Sequence: first Record level peoplecode will
fire and then Component level peoplecode.
11) Can you explain about component
Buffer?
A)
When you open any page in a component, the system retrieves all of the
data records for the entire component and stores them in one set of record
buffers, organized by scroll level and then by page level. This component
buffer consists of rows of buffer fields that hold data for the various records
that are associated with page controls, including the primary records; related
display records, derived work records, and translate table records.
PeopleCode frequently must refer to data in the
Component Buffer, that is, the area in memory that stores data for the
currently active component.
There are two methods of specifying a piece of
data in the Component Buffer from within PeopleCode:
-------- Contextual references, which refer to
data relative to the location of the currently executing PeopleCode program.
-------- References using scroll path syntax,
which provide a complete, or absolute, path through the Component Buffer to the
referenced component.
The component buffer contain current active
component data it is temporary memory area .
12) what is the sequence
of events fired when a page is saved.
A) SaveEdit,
SavePreChange,
Workflow,
SavePostChange
13) How to store
output of sql query in a variable using peoplecode?
A) using
SQLExec() function
SQLExec(“select EMPLID, NAME from
PS_PERSONAL_DATA”, &emplid,&name);
14)what is an
array in people code?
A) An Array is a
collection of data storage locations, each of which holds the same type of
data.
The maximum depth of a peoplecode array is
15 dimensions. Push and UnShift are the functions of the array used to add the elements into the
array one from the end of the array and one from the beginning. Pop is a function of array used
to select and delete an element from the
end of the array.