What is Enterprise Performance Management?

Sakthivelraj

• Feb 9th, 2012

PeopleSoft EPM offers multiple performance management solutions for various budgets and phases of the management cycle, helping managers formulate strategies for profitable growth, align strategies wi...

Answer Question  Select Best Answer

How do you generate two output files from one SQR?

Prem

• Feb 8th, 2012

1.We can generate Multiple Reports by using "use-report" concept in SQR, and also we need to give Overrride Option (-MRn, n= No of reports) in process defintion. 2.we can achieve the above same using "new-Report" concept

Code
 

Answer Question  Select Best Answer

How to delete/modify the Existing Run control ID created in Peoplesoft 9.0

Ganapathy

• Dec 20th, 2012

Go to respective searach record. In database you can see the run control id values. You can delete it or modifiy it. else need to go for the PSRECDEFN

Answer Question  Select Best Answer

You have moved a PeopleSoft instance from DB2 to Oracle and when trying to build tables and indices, you notice that the SQLs generated by the Application designer are wrong / unacceptable, What could be the possible issue ?

which is the best option

a) Issues with PSDDLMODEL
b) Definitely not any one of the above
c) Issues with Application Designer
d) Issues...

Reena

• Jan 18th, 2017

A) Issues with PSDDLMODEL

This table holds the Oracle DDL templates (i.e how the syntax of table , index etc should be in a particular DB )
There is a delivered DMS script (psddl.dms) that can be run to reset the structure of the objects

Answer Question  Select Best Answer

What is the use of Service Date? How is it different from the Hire date?

Shelley

• Aug 14th, 2016

Service date is your original and/or pensionable date of service. Hire date is for current/previous position data

Answer Question  Select Best Answer

vcramachandran1979

 Profile Answers by vcramachandran1979 Questions by vcramachandran1979

• Jan 18th, 2007

Possible by opening two session from a single application whether it is sql-plus or db2 or sql-server

R Krishna Prasadh

• Aug 20th, 2006

Yes, but you need to have two different connections in your application. This is also known an Con-current connections, where in more than one connection, accessing a Server for different Databases.

Answer Question  Select Best Answer

ashish_rawat06

 Profile Answers by ashish_rawat06 Questions by ashish_rawat06

• 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.

rahuls007

 Profile Answers by rahuls007 Questions by rahuls007

• 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?

Answer Question  Select Best Answer

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.

ashish_rawat06

 Profile Answers by ashish_rawat06 Questions by ashish_rawat06

• May 17th, 2011

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

rajendert123

 Profile Answers by rajendert123 Questions by rajendert123

• May 9th, 2008

SMTP Server is not configured for the environment.

Answer Question  Select Best Answer

cedt26

 Profile Answers by cedt26 Questions by cedt26

• Sep 6th, 2008

The Data Mover is one kind of the File Transfer System it uses the fastest data transfering  and the data must transfer reliably and must redable. The data mover is also called as the storage router because it stores the backup of the data in our computer system.

Kannan

• Oct 4th, 2005

Datamover used to take back up and buisness rule updation thru sql and security purpose.

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by jayakrishna08

• Feb 27th, 2008

The main difference between Show and Display commands is-with display command we can display only one variable (or) literal (or) column name at a time.But with show command we can display any number v...

harish_mahanta

 Profile Answers by harish_mahanta Questions by harish_mahanta

• Mar 3rd, 2007

Both show & display command use for Debuging purposes. In case of show command we can use variable literal & string.But incase of display command we can only use string & literal.

Answer Question  Select Best Answer

anandayn

 Profile Answers by anandayn Questions by anandayn

• 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.

Satish

• 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.

Answer Question  Select Best Answer

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Sep 15th, 2009

Move: To move the contents of one field to another field with optional editingLet: To assign the values to the variable

kamal

• 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

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by jayakrishna08

• Feb 27th, 2008

Its because the processer cant decide which action to do first.Both actions involves the transfer of control from one place to another place.

Madhusudan Reddy

• Nov 20th, 2007

If we use call section and SQL actions simultaneously then database deadlock will occur. That is why we cannot use at the same time

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by jayakrishna08

• Feb 27th, 2008

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

aryaninlove143

 Profile Answers by aryaninlove143 Questions by aryaninlove143

• Dec 14th, 2007

SQC is STRUCTURED QUERY COMMAND

Answer Question  Select Best Answer

jayakrishna08

 Profile Answers by jayakrishna08 Questions by jayakrishna08

• Feb 27th, 2008

No,we cannot call one SQR from other.

peoplesoft45

 Profile Answers by peoplesoft45 Questions by peoplesoft45

• Dec 14th, 2007

No we cannot call one sqr from an other sqr.instead u can call sqc's from sqr's

Answer Question  Select Best Answer

What is the difference between search record and addsearch record.

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• 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...

jayujain

 Profile Answers by jayujain Questions by jayujain

• 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), dont include EMPLID in the ...

Answer Question  Select Best Answer

What is the differences in Debugging and Tracing

anandayn

 Profile Answers by anandayn Questions by anandayn

• 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...

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• 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...

Answer Question  Select Best Answer

What are Explicit Print and Implicit Print

anandayn

 Profile Answers by anandayn Questions by anandayn

• 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...

sureshnelakurthi

 Profile Answers by sureshnelakurthi Questions by sureshnelakurthi

• 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...

Answer Question  Select Best Answer

How to upload image in Peoplesoft database and present same image in output window?

elma_ae1

 Profile Answers by elma_ae1 Questions by elma_ae1

• Oct 1st, 2008

In App Designer, create a new Image object.  It will prompt you to select what image from your computer you want to upload.  Save the image so it gets saved to the database.  From there, you can use it as an image on an HTML page or as a command button image.

yashwanth.chaitanya

 Profile Answers by yashwanth.chaitanya Questions by yashwanth.chaitanya

• Jul 10th, 2008

Using Image tool in the Application designer, We can upload images on the pages reuired.

Answer Question  Select Best Answer

What is the difference between Section Commit and Step Commit

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• 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.

Atoshi

 Profile Answers by Atoshi Questions by Atoshi

• 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.

Answer Question  Select Best Answer