- World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions
Our Services
Get 9,000 Interview Questions & Answers in an eBook.

Get it now !!
Send your Resume to 6000 Companies
PeopleCode Interview Questions & Answers - Learning Mode

PeopleCode Interview Questions & Answers - Learning Mode

PeopleCode is an object-oriented, proprietary language used to express business logic for PeopleSoft applications. In its fundamentals, PeopleCode syntax resembles other programming languages. PeopleCode is the structured programming language built into PeopleTools that extends the functionality of the PeopleTools environment. All PeopleCode programs are associated with a parent definition.

Try PeopleCode Interview Questions & Answers - Exam Mode

1 2 3 4 Next

Sort By : Latest First | Oldest First | By Rating

PeopleCode Interview Questions & Answers - Learning Mode
Try PeopleCode Interview Questions & Answers - Exam Mode
Question: What is the diff b/w component level peoplecode and record level peoplecode?

Question: How to send email to the all employeee from the peoplesoft application when a certain event is true?
2. What is the event used to trigger?

Answer: Create a workflow. In the workflow, use a query with active employess and their email ids as inputs. On the successfull occurence of the event, trigger this workflow using TriggerBusinessEvent. Source:
Question: What is the difference between SQl Object and SQl Exec?

Answer: 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 retrive only one row and u can update multiple rows of data. It directly interacts with the database.
Question: SMTP sendMail failed error during testing of HRMS upgrade to 8.9 (8.46.09 tools). On all of our triggerbusinessevents trying to send an email, we receive the above error. Any help would be appreciated.

Answer: Solution 1:Ask your DBA to UP SMTP server.

Solution 2:make sure that you have filled all the feilds in the page or attach specified files if any.

These are the only reasons of above error.
Question: Tell me about component Buffer?

Answer: 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 Source:
Question: What is a Rowset Object in PeopleCode?

Answer: A Rowset Object, instantiated from a Rowset class, is a collection of rows associated with buffer data. A component scroll is a rowset. You can also have a level zero rowset. The following two lines of code are equivalent:-
Want to get field value into people code which is at level 2. GetLevel0 ()(1).GetRowset(Scroll.level 1recordname).GetRow(CurrentRowNumber()).record.fieldname
The default method for the Rowset class is GetRo Source:
Question: Difference between WinMessage and MsgGet functions in PeopleCode?

Answer: a)The MsgGet function retrieves a message from the PeopleCode Message Catalog, substitutes in the values of the parameters into the text message and is stored in database, where as WinMessage doesn?t store in database.
b) MsgGet function message number is mandatory parameter, but there is no such parameter in WinMessage. Source:
Question: What is the advantage and disadvantage of sqlexe in peoplecode?

Answer: 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 Source:
Question: What are the Component Level PeopleCode Events?

Answer: PostBuild Event

PreBuild Event

SavePostChange Event

SavePreChange Event

Workflow Event Source:
Question: How can I comment out a piece of the peoplecode in my program

Answer: REM can be used to comment a single line, but it will be processed by the comp. processor;

Single and multiple line commenting:

/* PeopleCode stmts

------ ------ ------ ----


Nested Comments:


/* PC Stmts ...... ..... ..... */

/* ...... Some info on code ...... */

/* More comments */

Question: Difference between SQLExec and CreateSql?

Answer: SQLExec can only select a single row of data. If your SQL statement retrieves more than one row of data SQLExec sends only the first row to its output variables. Any subsequent rows are discarded.

If you need to SELECT multiple rows of data use the CreateSQL or GetSQL functions and the Fetch SQL class method. Source:
Question: When should WinMessage be used in PeopleCode?

Answer: The WinMessage built-in function, in PeopleCode, is used to display an information message to the operator without performing normal error and warning processing. It also can be very helpful when used for debugging. Source:
Question: Variable types available in PeopleCode?

Answer: 1) User defined variable prefixed with ?&? 2) System defined variable prefixed with ?%?. Source:
Question: Difference between Gray and UnGray functions in PeopleCode?

Answer: Use the Gray function user to make field unavailable for entry a page. Preventing the user from making changes to the field. Gray make a field display-only, while hide makes it invisible.
Syntax: Gray (fieldname)
Use the Ungray function to make a gray (non-editable) page field editable .If the field was grayed with call to the Gray function. If the page field is made display-only in page the field properties dialog, then Ungray has no effect.
Syntax: UnGray (fieldname) Source:
Question: When is it useful to select the Export to File option in Find in PeopleCode?

Answer: An Export Report produces an unformatted copy of all of the source code where the character string was found. This can be very helpful in an upgrade. Source:
Question: Difference between AddDropDownItem and ClearDropDownItem functions in PeopleCode?

Answer: a) AddDropDownItem: The AddDropDownItem method adds an item to the dropdown list in the control for the field. The first time this method is called, it overrides the prompt table or translate table used to populate the list. Those items no longer appear in the list. Only the items added using this method display. Subsequent calls to this method add additional items to the dropdown list. The items added with the first call to the method also display. If there is an existing value and the dropdown Source:
Question: Expalin about FieldFormula in PeopleCode?

Answer: The FieldFormula event is not currently used. Because FieldFormula PeopleCode initiates in many different contexts and triggers PeopleCode on every field on every row in the component buffer, it can seriously degrade application performance. Use RowInit and FieldChange events rather than FieldFormula.
If a field value is changed, whether through PeopleCode or by a user, the IsChanged property for the row is usually set to True. However, if a value is set in FieldDefault or FieldFormula, the r Source:
Question: Difference between MetaSQL and normal SQL in PeopleCode?

Answer: SQL Statements are Platform Dependent, where as MetaSQL statements are Platform Independent.
MetaSQL: - %Bind, %Execute Edits, %Select, %SelectInit, %Sql, %Table, %Truncate Table.
SQL: The SQL statements are used to fetch/retrieve, update, insert, delete data from the database. In PeopleSoft we use the SQL statements using SQLExec or CreateSQL. Different SQL statements are: Select, Insert, Update, Create and Delete.
MetaSQL: Different RDBMS have different date and time formats. Though t Source:
Question: How is a message added to the Message Catalog in PeopleCode?

Answer: To add a new message to the Message Catalog, the correct message set should first be retrieved. A new message can be added to the set by performing a row insert (F7). The new message number will automatically be assigned. Source:
Question: Where PeopleCode get stored??
Option: 1. Application Server
Option: 2. Database Server
Option: 3. Client Machine.
Option: 4. File Server.
Option: 5. Batch Server.

Answer: 2. Database server

1 2 3 4 Next

India News Network
Latest 20 Questions
Payment of time- barred debt is: (a) Valid (b) Void (c) Illegal (d) Voidable
Consideration is defined in the Indian Contract Act,1872 in: (a) Section 2(f) (b) Section 2(e) (c) Section 2(g) (d) Section 2(d)
Which of the following is not an exception to the rule, "No consideration, No contract": (a) Natural love and affection (b) Compensation for involuntary services (c) Completed gift (d) Agency
Consideration must move at the desire of: (a) The promisor (b) The promisee (c) The promisor or any other party (d) Both the promisor and the promisee
An offer which is open for acceptance over a period of time is: (a) Cross Offer (b) Counter Offer (c) Standing Offer (d) Implied Offer
Specific offer can be communicated to__________ (a) All the parties of contract (b) General public in universe (c) Specific person (d) None of the above
_________ amounts to rejection of the original offer. (a) Cross offer (b) Special offer (c) Standing offer (d) Counter offer
A advertises to sell his old car by advertising in a newspaper. This offer is caleed: (a) General Offer (b) Special Offer (c) Continuing Offer (d) None of the above
In case a counter offer is made, the original offer stands: (a) Rejected (b) Accepted automatically (c) Accepted subject to certain modifications and variations (d) None of the above
In case of unenforceable contract having some technical defect, parties (a) Can sue upon it (b) Cannot sue upon it (c) Should consider it to be illegal (d) None of the above
If entire specified goods is perished before entering into contract of sale, the contract is (a) Valid (b) Void (c) Voidable (d) Cancelled
______________ contracts are also caled contracts with executed consideration. (a) Unilateral (b) Completed (c) Bilateral (d) Executory
A offers B to supply books @ Rs 100 each but B accepts the same with condition of 10% discount. This is a case of (a) Counter Offer (b) Cross Offer (c) Specific Offer (d) General Offer
_____________ is a game of chance. (a) Conditional Contract (b) Contingent Contract (c) Wagering Contract (d) Quasi Contract
There is no binding contract in case of _______ as one's offer cannot be constructed as acceptance (a) Cross Offer (b) Standing Offer (c) Counter Offer (d) Special Offer
An offer is made with an intention to have negotiation from other party. This type of offer is: (a) Invitation to offer (b) Valid offer (c) Voidable (d) None of the above
When an offer is made to the world at large, it is ____________ offer. (a) Counter (b) Special (c) General (d) None of the above
Implied contract even if not in writing or express words is perfectly _______________ if all the conditions are satisfied:- (a) Void (b) Voidable (c) Valid (d) Illegal
A specific offer can be accepted by ___________. (a) Any person (b) Any friend to offeror (c) The person to whom it is made (d) Any friend of offeree
An agreement toput a fire on a person's car is a ______: (a) Legal (b) Voidable (c) Valid (d) Illegal
Cache = 0.032227 Seconds