Prasad

• Jul 28th, 2017

State Record pass the values from section to section and step to step. it should be SQL table or derived work record. must started with _AET. process_instance is the high level key field. During batc...

RAJ ATMAKUR

• Oct 10th, 2014

BOTH THE TEMP TABLES AND STATE RECORDS CAN B USED TO PASS VALUES FROM ONE STEP 2 ANOTHER OR ONE ACTION 2 ANOTHER .. BUT THE DIFF IS, WITH STATE RECORD -WE CAN PASS A SINGLE ROW OF DATA ...

Answer Question  Select Best Answer

What is the pros and cons of using App Engine Interface and Integration Broker. When should we use App Engine Interface? And when should we use Integration Broker?

Difference between temporary table and sql view in peoplesoft

ravi

• Aug 31st, 2014

Temporary Table used to increase the performance of Application Engine(based on batch process or etc ..).
SqlView used to get the data from multiple tables and select statements is manually written

ravi.velchuri38

 Profile Answers by ravi.velchuri38 Questions by ravi.velchuri38

• Aug 13th, 2008

Temporary Table: Temporary tables are used for running PeopleSoft Application Engine batch processes. Temporary tables can store specific data to update without risking the main application table. S...

Answer Question  Select Best Answer

sai

• Sep 30th, 2013

Enable / Disable Restart Logic

indhrakannan

 Profile Answers by indhrakannan Questions by indhrakannan

• Sep 5th, 2008

1. Main is the required section in Application Engine. 2. There can be multiple steps in single application engine, but atleast one step should be part of AE. 3. Similarly you can have multiple acti...

Answer Question  Select Best Answer

As in when we open job page, we find advanced search page instead of normal search page. how to do that

Girish

• Sep 25th, 2011

There is a setting available in Component properties to make either the Normal Search Page or the Advanced search page to appear first.

Answer Question  Select Best Answer

Mayank

• Sep 6th, 2011

If we specify one field as a set control field then we will get data based on this when we are using prompt table. Based on this field only we can have valid prompt list at the time of prompt button ...

Bhawna

• Mar 16th, 2007

Set Control id is used when you want to share tables in Peopletool applications.This key identifies the sets of information in the table that are shared by multiple companies or business units under y...

Answer Question  Select Best Answer

Alagiri Ruban

• Aug 1st, 2011

IBM WebSphere and Oracle Weblogic

Answer Question  Select Best Answer

Rahul

• Jul 16th, 2011

Well .. Component variables can be used to carry data from one section to another. The scope of component variable remains throughout the program . They can be used in place of state record provided you do not want a restart facility and dynamic section calls.

Answer Question  Select Best Answer

How to use State Record to Update a table?

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 29th, 2009

Benefits of set control field: If we specify one field as a set control field then we will retrieve data based on this when we are using prompt table. Based on this field only we can have valid prompt list at the time of prompt button clicking.

gouthamireddy29

 Profile Answers by gouthamireddy29 Questions by gouthamireddy29

• Dec 19th, 2007

Select a set control field that overrides the set control field of the record definition specified in the prompt table. If you don't specify a name in this field, the default is the set control fi...

Answer Question  Select Best Answer

bandisdevi

 Profile Answers by bandisdevi Questions by bandisdevi

• Oct 25th, 2009

Sub page:  Mainly use for sub records. We can place sub records in to sub page. Secondary page: It is used to enter additional data, rarely entered data & unimportant fields. There can be any...

arunkumar061

 Profile Answers by arunkumar061 Questions by arunkumar061

• Apr 30th, 2008

Multiple number of subpages can be created in one scroll level but only one secondary page can created in one scroll level using push/hyperlink.

Answer Question  Select Best Answer

chini009

 Profile Answers by chini009 Questions by chini009

• Feb 3rd, 2009

Indexing tables on the database side helps in batch processing a great deal. Analysing tables helps. If there is custom code, make sure the SQL queries used are written well with the use of proper keys and joins are correct as well.

Answer Question  Select Best Answer

i want to store the output of a query say select EMPLID from Job;the output of this column should be stored in a variable. how it can be done?

psft1017

 Profile Answers by psft1017 Questions by psft1017

• Nov 12th, 2008

You can use SQLExec to do the same.SQLExec("SELECT EMPLID FROM JOB",&Emplid);The value of EMPLID gets stored in the variable &Emplid.

Answer Question  Select Best Answer

What is meant by application package?

girijat

 Profile Answers by girijat Questions by girijat

• Oct 23rd, 2008

Application Package is Used to create Application Classes, which could be used to either extend the functionality of existing PeopleTools classes (Rowset, Array, and so on) or to create your own classes.

ravi.velchuri38

 Profile Answers by ravi.velchuri38 Questions by ravi.velchuri38

• Aug 13th, 2008

App package:An application package is a container for application subpackages and application classes, which will  provide a hierarchical structure to your PeopleCode programs and help you extend...

Answer Question  Select Best Answer

hemsiri

 Profile Answers by hemsiri Questions by hemsiri

• Jul 15th, 2008

By using edittable

Answer Question  Select Best Answer

jeetendrap

 Profile Answers by jeetendrap Questions by jeetendrap

• May 28th, 2008

Peopletools: windows, Unix (Red Hat, SLES)Database: Oracle, SqlServer, DB2PIA: IE 5.0 or greater

Answer Question  Select Best Answer

nsivudu

 Profile Answers by nsivudu Questions by nsivudu

• Mar 28th, 2008

We can create multiple sub-pages and secondary pages.

natarajcheedella

 Profile Answers by natarajcheedella Questions by natarajcheedella

• Nov 8th, 2006

Any no of subpages can created and any no of secondary pages can created.There is no restrictions.

Answer Question  Select Best Answer

Is this possible.. If yes, Please explain

soumajit

 Profile Answers by soumajit Questions by soumajit

• Feb 23rd, 2008

It is not possible normaly.. but u can write a people code by which u can insert the field data into the records

Answer Question  Select Best Answer

rashijoshi

 Profile Answers by rashijoshi Questions by rashijoshi

• Sep 26th, 2007

Following steps need to be followed for migration:1. Login to database through App Designer as a source database. 2. Click on upgrade tab and open the project which contains roles which you want to mi...

Rashi

• Sep 26th, 2007

1. Login to database through App Designer as a source database. 2. Click on upgrade tab and open the project which contains roles which you want to migrate.3. Double click on Roles fold...

Answer Question  Select Best Answer

Yes, databases can co-exist on the same physical machine. In most cases, thedatabases themselves can exist within the same RDBMS, however, it isimportant to verify that the database version required by PeopleTools 8.4 is thesame as for the current PeopleTools 8.1x implementation.

Amit Agrawal

• Aug 24th, 2007

In a step if you r writing SQL then you need to commit it with in the same step but in the next action if u call another section or step it wont perform the desired actions.because the previous step step is not committed.

harish_mahanta

 Profile Answers by harish_mahanta Questions by harish_mahanta

• Nov 24th, 2006

Q. In Application Engine,why SQL & CallSection action are mutually Exclusive?

Answer Question  Select Best Answer