CoolInterview.com - 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
COOLINTERVIEW.COM PEOPLESOFT INTERVIEW QUESTIONS PEOPLECODE INTERVIEW QUESTIONS 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?

Answer:
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.
Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
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.


CoolInterview.com
Question: Explain about the WorkFlow Event in PeopleCode?

Answer: WorkFlow PeopleCode executes immediately after SavePreChange and before database update that precedes SavePostChange. The main purpose of the workflow event is to segregate PeopleCode related to workflow from the rest of applications PeopleCode. Only PeopleCode related workflow (Such as triggerbusinessevent) should be in workflow programs. Your program should be deal with workflow only after my SavePreChange process completed. Source: CoolInterview.com
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: CoolInterview.com
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
Source: CoolInterview.com
Question: What are the Component Level PeopleCode Events?

Answer: PostBuild Event

PreBuild Event

SavePostChange Event

SavePreChange Event

Workflow Event Source: CoolInterview.com
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: CoolInterview.com
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: CoolInterview.com
Question: Tell me few peoplecode functions you worked with?

Answer: Component Buffer consists of rows of buffer fields that hold data for the reocrds associated with the page including primary scrolls, derived work records etc. Source: CoolInterview.com
Question: What is Component Processor in case of PeopleCode?

Answer: Component Processor is a runtime engine that controls processing of an application from the time user request the component from the menu till the database is updated and processing of component is completed. Source: CoolInterview.com
Question: Where can you write the peoplecode?

Answer: u can write people code in 7 objects

1. record field level

2.component field level

3.page

4.menu

5.application engine

6.component interface

7.messages
Source: CoolInterview.com
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: CoolInterview.com
Question: How are Dates converted within SQLExec Statements in PeopleCode?

Answer: Dates in PeopleCode, are converted within SQLExec built-in function by using the system variables %DateIn and %DateOut. Source: CoolInterview.com
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: CoolInterview.com
Question: How is a message retrieved from the Message Catalog in PeopleCode?

Answer: To retrieve a message from the Message catalog in PeopleCode, the MsgGet built in function is used. The required parameters of the function are message set, number and a default message. Source: CoolInterview.com
Question: What are the drawbacks of using a SQLExec built in function in PeopleCode?

Answer: Since the SQL statement is contained within quotes, it is a black box to PeopleSoft. Means the programmer is responsible for the syntax, efficiency and maintenance of the SQL. Also, if a SQLSelect is being performed within the function, only one row of data can be returned. Source: CoolInterview.com
Question: Define PeopleCode?

Answer: PeopleCode is an object oriented proprietary (case-insensitive) language used to express business logic for PeopleSoft applications. Source: CoolInterview.com

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.03125 Seconds