GeekInterview.com
Series: Subject: Topic:

PeopleCode Interview Questions

Showing Questions 1 - 20 of 31 Questions
First | Prev | | Next | Last Page
Sort by: 
 | 

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 peoplecode function do u use and where do u write the code?

Asked By: Interview Candidate | Asked On: Jul 29th, 2005

Answered by: anu_peoplesoft on: Oct 29th, 2012

In the record field properties where you want the the dynamic search record -- change it to Table Edit and in the prompt table write %derived.
then
in the component prebuild code
change the search record specific to the menu.

Answered by: Muruga Ganesh on: Aug 16th, 2012

You can use the menu override option to specify your search record for the respective menu.

Suppress search page

Asked By: danalaxmy | Asked On: Sep 23rd, 2010

What are the different ways to suppress the search page, when a component is opened?

Answered by: vamshi on: Jun 2nd, 2012

1). "nosearch_vw" is a view which is not having search keys,if wee pass this view as a search record........
2). "setsearchdialogbehaviour()" by using this function in searchinit event we can bypass the search page

Answered by: Mukundhan on: Feb 27th, 2012

Use record with no search keys

Table ps_empl_tbl has the following structureemplid as key field. Emplnamesalarytable ps_dept_tbl has deptid as key fielddeptnamemgridi need prompt for emplid in ps_empl_tbl as mgrid in ps_dept_tbl .How...

Asked By: funct | Asked On: Jan 31st, 2007

Answered by: Carrie on: Aug 25th, 2011

join the two tables:
select E.EMPLID
from PS_EMPL_TBL E
, PS_DEPT_TBL D
where D.MGRID = E.EMPLID

Answered by: vayrapetov on: Jan 6th, 2010

You need to link two tables where MGRID = EMPLID

What is the diffrence between SQLexec and createsql?

Asked By: Pranuthi | Asked On: Oct 15th, 2006

Answered by: gouse on: Aug 15th, 2011

with the help of SQLExec, we can fetch only one row of multiple same rows.
with the help of CreateSql, we can fetch all the rows.

Answered by: suresh33.a on: Oct 21st, 2008

The main Difference Between SqlExec and CreateSql is SqlExec directly interactive with
data base but Createsql not directly interactive with the data base

What is the difference between component level peoplecode and record level peoplecode?

Asked By: Interview Candidate | Asked On: Aug 19th, 2005

Answer posted by ramya on 2005-03-09 04:59:47: component and record level peoplecode are executed when the control is passed to the associated component and component containing the record respectively. Since a single record might be associated with several different components, it is posiible to trigger...

Answered by: bandisdevi on: Oct 12th, 2010

Record level people code Executes in any Component containing the record field.

Component level people code Will only execute for that particular Component.

Answered by: ggiri on: May 19th, 2010

Record level peoplecode will be fired in all the components to which it is attached. This code will be fired first.ComponentRecord level peoplecode will be fired only while processing through a partic...

People code - migration of SQL reports

Asked By: gouthamireddy29 | Asked On: Dec 19th, 2007

Can we migrate SQL reporting?If yes,how?

Answered by: SreejaSasidharan on: Jul 20th, 2010

I guess you are asking about the migration of SQL report from one env to another (like from development to UAT)Your DBA will be required to place the SQR report manually to the target env, however, su...

Sending email with workflow

Asked By: CHAKROUN | Asked On: Jun 5th, 2008

Hello!I'm beginner in peoplesoft.I'm looking for sending emails with workflow in peoplesoft 8.45thxchakroun

Answered by: SreejaSasidharan on: Jul 20th, 2010

If you want to send mails through Workflows, then you need to use the objects Business Process.Under a business process, you define an activity.Within an activity, you need to define steps, events and...

Answered by: SreejaSasidharan on: Jun 26th, 2008

hi there, You can send emails in PeopleSoft using function SendMail().There are arguments for the function SendMail(&n_MailFlags_l, &s_MailTo_l, &s_MailCC_l, &s_MailBCC_l, &s_MailS...

Where peoplecode get stored?Option: 1. Application serveroption: 2. Database serveroption: 3. Client machine.Option: 4. File server.Option: 5. Batch server.

Asked By: Raja Chakrabarti | Asked On: Dec 23rd, 2005

Answered by: expictian on: Jan 11th, 2010

Databse Server Select * from PSPCMPROG You will all below information 1 AA_OVRD_CRSDATA 2 STRM 12 RowInit 1 AA_OVRD_CRSDATA 2 UNITS_DIRECTED 12 RowInit 1 AA_OVRD_CRSDATA 2 UNITS_DIRECTED 12 RowInsert ...

Answered by: Sumon on: Apr 10th, 2007

Database Server

Where can u write the peoplecode?

Asked By: Interview Candidate | Asked On: Aug 19th, 2005

Answered by: kishore.kummr on: Oct 9th, 2009

Events are the only way that you can associate Peoplecode to an Object. Prior to PeopleTools 8 (i.e., before Object Oriented Peoplecode evolved), Peoplecode is associated only with the Records and Men...

Answered by: Rouletabille on: Oct 7th, 2008

You can write PeopleCode (PC) in the Application Designer IDE. The PC are stored :- on the events and are triggered by them- in librairies called funclibs in PeopleSoft and called manually by the deve...

What is the sequence of events fired when a page is saved.

Asked By: gnana | Asked On: Apr 25th, 2007

Answered by: kishore.kummr on: Oct 9th, 2009

For the discussions already made, I would add one more event when a page is saved, i.e. workflow. So, Now series will be
SaveEdit,
SavePreChange,
Workflow,
SavePostChange

Workflow: Only Peoplecode related to Workflow (e.g. Approval processes and Notification purposes) are written.

Answered by: Kavitha on: Oct 22nd, 2007

Firstly, its SaveEdit followed by SavePreChange and finally SavepostChange The SaveEdit event is initiated whenever a user attempts to save the component. You can use SaveEdit PeopleCode to vali...

Whats the advantage and disadvantage of SQLexe in peoplecode?

Asked By: ajith | Asked On: Oct 3rd, 2005

Adv: no need to write query just want to build dis: we cant view queries

Answered by: amitsk_00 on: Jul 9th, 2009

Also, SQLExec will open a new session on database, so if anything has been updated in Comp Buffer, will not be available in that session as COMMIT might not have happened. Also, if we have selected so...

Answered by: Narendar Reddy K. on: Apr 26th, 2007

If we need to retrieve more than one rows from the database, we can use SQL class instead of SqlExec...

Sequence of events fire when you click save button?

Asked By: ramesh | Asked On: Aug 7th, 2006

Answered by: amitsk_00 on: Jul 9th, 2009

To add to all this, if deferred processing is started, then if any pending FieldEdits/FieldChange are also executed before SaveEdit starts.

Answered by: bamaboy on: Apr 13th, 2009

1.SaveEdit Event2.Save Prechange3.Workflow4.SavePost changeSaveEdit is intiated when a component is saved.It is used to validate the consistency of the data in the component fields.It is used when&nbs...

Component buffer

Asked By: balanps | Asked On: Aug 6th, 2008

How do you bring the component buffer into app eng?

Answered by: piya.s.singh on: May 7th, 2009

You can assign a record which is used in component buffer to a state record of Application engine.

Is there any function exist in peoplecode which stops the processing of whole component?

Asked By: Fundoo | Asked On: Nov 30th, 2005

Answered by: vasireddyanil on: Apr 23rd, 2009

exit(1)

Answered by: suresh33.a on: Oct 22nd, 2008

We have the docancle() function, it cancle the current component when it Occurs

Peoplecode prebuild & postbuild

Asked By: madhu.ps16 | Asked On: Nov 30th, 2007

What is the difference between prebuild & postbuild events and saveprechange&savepostchange?

Answered by: rajesh.t on: Aug 4th, 2008

Record level Peoplecode perform for that perticuler record only.

Component level Peoplecode performs for all the records which are under that perticuler component.

Answered by: rajesh.t on: Aug 4th, 2008

1. The PreBuild event is initiated before the rest of the component build events. 2. This event is often used to hide or unhide pages. 3. It is also used to set component variables. 4. The PostBui...

Peoplecode prebuild and postbuild events

Asked By: Anilchaitu | Asked On: Jun 10th, 2008

What is the main difference between prebuild and postbuild events where as both are used to hide or unhide the pages, why two events are needed for the same purpose? Which event is better to write people code to hide or unhide the pages and why?

Answered by: Santoosuryan on: Jul 29th, 2008

PreBuild event is the foremost event which triggers at Component Level. If at all there is an error generated at prebuild then the component fails to load before the search itself. Where as PostBuild ...

Tell me few peoplecode functions u worked with?

Asked By: Interview Candidate | Asked On: May 17th, 2005

Answer posted by rv on 2005-05-17 18:32:24: 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.

Answered by: devipriya99 on: Jul 9th, 2008

People code supports these types of functions:

1.Build in

2.Internal

3.External people code

4.External non-people code

Answered by: kishwar on: Feb 16th, 2007

people Code functions are

setdefault

NOne

hide

unhide

insertimage

delimage

Getfield etc.. 

What is a query view and dynamic view ?

Asked By: homealone363 | Asked On: Oct 21st, 2007

Answered by: ksllavanya on: Jun 8th, 2008

Dynamic View:This is selected to define a record definition that can be used like a view in pages and PeopleCode,but is not actually stored as a SQL view in the database.Instead, the system uses the v...

While pressing save button how many times save pre change and save post change triggers and when does the commit occur?

Asked By: Mani | Asked On: Jul 11th, 2007

Answered by: rpreddy on: Mar 24th, 2008

save prechange exicutes for all active rows but savepost change exicutes only once....

Answered by: surender_engg on: Dec 11th, 2007

Hey i dont think, it will get executed for all the active rows. It will always gets executed once.

Peoplecode events used in appengine

Asked By: jayakrishna08 | Asked On: Mar 8th, 2008

What are the peoplecode events that can be used in application engine program?

Answered by: venkat_leader on: Mar 10th, 2008

we can use the on-execute event. sometimes we can use the saveprechange event also.

First | Prev | | Next | Last Page

 

 

Ads

Connect

twitter fb Linkedin GPlus RSS

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

Ads

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.