GeekInterview.com
Series: Subject:

PeopleSoft FAQs

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

Generate pdf files in SQR

Asked By: Prakash3366 | Asked On: Apr 9th, 2009

How to generate pdf file in SQR thru coding?

Answered by: Dhasna on: Jul 12th, 2012

by using -printer:PD command

How do you read data from word document through SQR

Asked By: Vally | Asked On: Sep 25th, 2007

Answered by: ANITHA on: Oct 20th, 2011

file interface

Hi, iam learning peoplesoft by myself.I would like to know how do we differentiate financial and hrms peoplecode.Do we have seperate book for financials and hrms. Can anyone please forward me the interview...

Asked By: SHRAVYA | Asked On: Jun 16th, 2006

Answered by: prathima on: Aug 18th, 2011

for financials u can refer student guide.pdf where complete information for financials is present.

Answered by: nandu1210 on: Jun 15th, 2011

I would say you to prepare Asset management, Account Payable, General Ledger, Variance.

How many scroll levels can be set in a page?

Asked By: bhuvana | Asked On: Aug 16th, 2007

Answered by: Terrastar on: May 23rd, 2011

Level 0
Level 1
Level 2
Level 3

Total 4

Answered by: nataraj.cheedella on: Aug 20th, 2007

There are four Scroll levels in a standard page.i.e.,0,1,2,3

Auto-generate

Asked By: orkedII | Asked On: Jul 6th, 2008

How to create auto-generate for id? For example, the id for new transaction page automatic generated.

Answered by: Terrastar on: May 23rd, 2011

You can use 'NEXT' for auto generating the IDs. Otherwise you can write your own coding as follows.


SQLEXEC("get the max value from the table",&count)

&count=&count+1;

SQLEXEC("inserts the new count value to the database");

Commit option

Asked By: kumarps.115 | Asked On: Jul 29th, 2008

What is the difference between section commit and step commit

Answered by: bandisdevi on: Jul 20th, 2009

CoCommit: If we select commit from section after the completion of each step commit occur, else commit occur which respective step properties.

Answered by: Atoshi on: Feb 25th, 2009

Section commit applies to a section as a whole and step commit, in each step. We can override the section commit value in Step level. Suppose there is no commit action mentioned in a section, but you can override in teh step and mention to commit after that step execution.

Debugging tracing

Asked By: bandisdevi | Asked On: Apr 15th, 2008

What is the differences in debugging and tracing

Answered by: anandayn on: Dec 1st, 2010

Debugging is step-by-step/line by line and you can see the values in variables while they are getting changed/populated by enabling the debugger option in AE.Tracing: In the login page you can set &am...

Answered by: bandisdevi on: Oct 25th, 2009

AE debug: Go to configuration manager of (App Designer). Then navigate thru Profile > Edit > Process Scheduler > Application Engine, check the Debug option. Open the AE program needs to d...

Search record

Asked By: bandisdevi | Asked On: Apr 15th, 2008

What is the difference between search record and addsearch record.

Answered by: bandisdevi on: Oct 25th, 2009

Search record controls the amount of data that can be requested and downloaded from the database server as well as the structure of the search dialogue box. It is also responsible for populating l...

Answered by: jayujain on: Jan 12th, 2009

Specify this record if you want a different search record specifically for add actions. For example, if you selected the auto-numbering option for employee IDs (EMPLID), don’t include EMPLID in the ...

Why we cant use views as a state record?

Asked By: Debashis Maity | Asked On: Sep 17th, 2007

Answered by: ashish_rawat06 on: May 17th, 2011

state records are used to store values that can be passed between actions in AE programmes. whereas views are not actual physical table. they are unable to hold values. that's why we can't use views as a state record.

Answered by: rahuls007 on: Sep 30th, 2007

State Records are used for storing values that we would like to share between actions and steps in an AE program, so they have to be tables.
BTW: Why do you need to use a view as a state record?

Sending mails from peoplesoft

Asked By: madhu.ps16 | Asked On: Dec 20th, 2007

I have written peoplecode for sending emails. But I am getting the smtp send mail error. An error occurred during the smtp, could anyone please suggest this.

Answered by: ashish_rawat06 on: May 17th, 2011

check your parameters. i have also faced such problem just because of wrong and initialise parameters.

Answered by: rajendert123 on: May 9th, 2008

SMTP Server is not configured for the environment.

Can we call one SQR program in another SQR program? How? In all platforms

Asked By: riya | Asked On: Jan 18th, 2007

Answered by: umcee on: Jan 30th, 2007

We cannot call SQR program from another SQR program because each SQR has a main function. We cannot have two main functions.

What is the full form of sqc and sqt in peopesoft?

Asked By: Nupur Sinha | Asked On: Oct 4th, 2007

Answered by: jayakrishna08 on: Feb 27th, 2008

SQC-Structured Query Compiler (Library file)
SQT-Structured Query Translation (Compiled version of SQR)

Answered by: aryaninlove143 on: Dec 14th, 2007

SQC is STRUCTURED QUERY COMMAND

What are the differences between move and let commands in SQR???

Asked By: vamsi krishna | Asked On: Nov 20th, 2006

Answered by: anandayn on: Dec 1st, 2010

Move command is used for transferring a single value along with edit options.  Where in case of Let option you cant use the edit option, rather you can use expressions.  Hope this helps.

Answered by: Satish on: Nov 29th, 2006

Hi

Move command used to move the values from loaction to other and to assign a values to variable or a literal LET command will be used.

What happens if you don't specify a search record for a component?

Asked By: psnovicegirl | Asked On: Jun 6th, 2006

Answered by: kiranchitla on: Jul 5th, 2006

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.

This would solve it.

Answered by: Laxman on: Jun 9th, 2006

Component will not be saved without a search reacord

Print commands

Asked By: bandisdevi | Asked On: Apr 15th, 2008

What are explicit print and implicit print

Answered by: anandayn on: Dec 1st, 2010

In Explicit Print Command, you code the Print Command giving the coordinates where you want to print the data.  However, in the implicit Print Command you can print the value directly from the se...

Answered by: sureshnelakurthi on: Jul 12th, 2008

Here we have two types of print commands1) Implicit print:  (a) here no need to give the print statement.  (b) mainly useful for variables...2)explicit print:   (a)we must give the...

Line by line debugging

Asked By: bandisdevi | Asked On: Jul 16th, 2009

How to perform line by line debugging in application engine?

Answered by: anandayn on: Dec 1st, 2010

Line by line Debugging option is possible, by enabling the Debugger option in the Configuration Manager.  At the point from where you want to debug the code, set the break-point.  From there by pressing F7 you can do line by line debugging.

Peoplesoft ci

Asked By: Dunlap | Asked On: Jun 22nd, 2008

Give an example to configure ci in peoplesoft

Answered by: bandisdevi on: Feb 24th, 2010

A component interface is a people tool to enable a PeopleSoft comonent for synchronous access from another application (PeopleCode, Java, C/C++ or XML) There are 5 different methods available in component interface. They are Save, Cancel, Find, Create, Get.

Levels in on-break in SQR

Asked By: anil bingumalla | Asked On: Jan 25th, 2008

Why levels are used in on-break logic.How does they work.Which lebel gets highest priority EIther level 1 or level 99.

Answered by: bandisdevi on: Oct 25th, 2009

On-break: On-break can only be used on string and column variables. We cannot use on-break with sqr numeric variables. To perform this, we must first move its value to a string variable & then set on-...

Answered by: sureshnelakurthi on: Aug 22nd, 2008

On-break is the important Command in SQR used to Control the redundancy of data..here SQR have different options for on-break...
1)After
2)before
3)never
4)always
5)change
6)change/top page

Above options are used with Group Headings and Footings

What are the differences between move and let commands in SQR??

Asked By: krisvamsi2005 | Asked On: Nov 20th, 2006

Answered by: bandisdevi on: Sep 15th, 2009

Move: To move the contents of one field to another field with optional editing

Let: To assign the values to the variable

Answered by: kamal on: Feb 12th, 2007

the basic difference between move and let areMOVEthe move command can use the edit option and can easily have the masking move date1 date2 edit yyyy-mm-dd LETLet command is only used to assign values to the variablesLet var1=var2 or 5

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.