Save edit validates data and gives messages or warnings.when no error/warnings exist then saveprechange fires. it helps by doing one last check before the save process. save post change updates/inserts data into the records that have not been... Read More

Q : &OPRID = %OperatorId; Where would the above PeopleCode event be found on a Run Control Record? a.     SearchInit b.     RowDelete c.     RowSelect d. ... Read More

1. Query trees 2. Combination trees Read More

a) user can enter values from prompt table b) user can enter values from prompt table and default value will be populated Read More

There are few differences between Translate tables and prompt tables1. Translate tables have a max length of 4 char for each element. However, prompt table elements have no such limitation.2. There can be only 30 entries in a translate table. Where... Read More

Q : Which one of the following is NOT a component of the Process Scheduler? a.      Process scheduler server shutdown Process monitor Process scheduler server agent d.     ... Read More

PIA-.PeopleTools->Integration Broker->Node DefinitionApplication Designer->Message ->Properties Read More

Q : Which one of the following PeopleCode events should NOT contain the WinMessage function? SearchInit b.      SavePreChange  FieldChange SaveEdit RowInit Ans :  B Read More

a) Temp Table b) SQL Table c) Query Table d) Dynamic(Guess: Temp Table, check People books App Engine) Read More

Q : Which one of the following programming languages does PeopleCode most closely resemble? a.      COBOL Fortran C d.      C++ Pascal Ans :  d Read More

FieldEdit Read More

PRINT-BAR-CODE Read More

Unlimited Read More

Q : Let us take a Temp Table TMP_TAO. In People Tools options the following instance settings are done Temp Table Instances (Total) : 5 Temp Table Instances (Online): 4 In AE1 App Engine Program the... Read More

Get keys, Create keys, and Find keys are created automatically. The Create method is created along with the other Standard methods for the CI. Read More

PeopleSoft Knowledge base SYSAUDIT finds for Orphaned Records Read More

AE is built on PeopleSoft proprietary language called People Code, where as SQR is a third party tool. Read More

Q : As a member of the development team, you are asked to create a new record definition to be used in an existing PeopleSoft application. Referring to the above information, in which one of the following workspaces would you create a... Read More

The tools available are Application designer and Integration Broker Setup on the Portal. In peopleSoft, 8.48 messages and Queues can be created from the Setup itself. Read More

PSDAEMON Read More

Business Process Read More

Q : PeopleSoft has its own naming convention for system and non... Read More

Rowclass is a single row of data that consists of 1 to n records of data. Rowset object is a data structure used to describe hierarchal data. It consists of a collection of rows. Read More

User can type only prompt table values and the default values are populated from the database. Read More

Q : You have a situation where a field value changes, and you don't know how it changed. There are two ways to find all references to a field. Referring to the above information, which of the following two tools will help you find... Read More

6 keys in Ascending orders Read More

a) Temp Table b) SQL Table c) Query Table d) Dynamic(Guess: Temp Table, check People books ? App Engine) Read More

TriggerBusinessEvent(BusProcess,BusActivity,BusEvent); Read More

Spawning   Read More

Security Administrator 20 Read More

Demo Read More

Q : Which one of the following PeopleCode events can run in both two-tier and three-tier       environments on either the client or application server? a.      SavePostChange ... Read More

... Read More

7 Read More

Q : You have a situation where a field value changes, and you don't know how it changed. There are two ways to find all references to a field. Referring to the above information, which of the following two tools will help you... Read More

ERP is generally referred to a class of business software that addresses a business firm in totality, rather than one or two functions.For example, there are accounting software, inventory software, etc. that addresses a specific function of a... Read More

Starts a Process Scheduler Read More

Local Which of the following ApiObject data type objects cannot be declared as Global? Java Object Read More

Specifies the output path Read More

1. MS IIS 2. Apache Read More

A component exposes your pages to peoplesoft only.Moreover it helps us to define common properties for a set of related pages. A component interface is a set of application programming interfaces (APIs) that you can use to access and modify... Read More

Application Messaging is used by PeopleSoft applications to communicate withone another. This is true not just for 8.1x and 8.4 applications, but also between an 8.1x and an 8.4application . For example, the HRMS 8.3 applications, which are based on... Read More

One of the core values of the PeopleTools development group is investment protection. The time, money and resources that you may have already invested in licensing another web server, training developers and administrators, building and deploying... Read More

If you want the prompt table to vary depending on the context of the field, indicate a field in the derived or work record (DERIVED) that contains the name of the prompt table at runtime. In this field enter %FieldName. The % is required, and... Read More

No. The PeopleSoft Mobile Agent architecture, which is used to supportdisconnected mobile applications, is only available in PeopleTools 8.4. ThePeopleSoft Mobile Agent is dependent upon certain core technologies that werespecifically developed for... Read More

Database superuser Read More

Released Read More

Section ,Step and Action Read More

PSAPPSRV.tracesql Read More

FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange Read More

... Read More

... Read More

SETID Read More

Scrollselect (1, targetname, recordfiledname) Read More

PSRECORDNAME Read More

Q : Assume that you just finished customization work that involved the creation of many new objects. You can move these objects from your development database (source) to a testing database (target) to conduct more elaborate testing. Referring to the... Read More

Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4 for several reasons: v JServ is no longer an active product and is in maintenance mode and there are no longer any new... Read More

Update Statistics Read More

1.Establish a user session 2.Get the Component Interface 3.pulate the Create Keys 4.eate an Instance of the CI 5.pulate the required fields 6. Save the CI Read More

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. Read More

Section ,Step and Action Read More

PSRECORDNAME Read More

a) Process Definitions Read More

TriggerBusinessEvent(BusProcess,BusActivity,BusEvent); Read More

CallSection Action Read More

PID.AET Read More

A & B Read More

JavaObject Read More

Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s) Read More

Keys, Properties & Collections, Methods and Name Read More

... Read More

Q : You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing... Read More

Q : Which security administrator profile provides the necessary IDs and passwords for the behind-the-scenes database logon that occurs when an operator signs on to PeopleSoft? a.     Class b.... Read More

Q : In the above workspace, which one of the following folders would you choose to display the results of a search through PeopleCode? Find in PeopleCode folder Validate folder Results folder Find Object References folder ... Read More

b) Recreate a Tabled) Recreate a View Read More

a) Graphical Representation of Business process and Relations b) Flowchart of tables and Fields Read More

delete($filename) Read More

DB Server Read More

Yes Read More

BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer to use their own HTTP web server and WebLogic?s or WebSphere?s Java servlet engine. PeopleSoft uses this plug-in capability tosupport IIS. We have no reason to... Read More

1. Development2. Upgrade Read More

Process Scheduler, Use, Process Definitions Read More

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. Read More

One can test Application in two ways: 1. Running Application engine from 2-Tier 2. Running Application engine from 4-Tier. 1. Running Application Engine from 2-Tier: Open Application Designer, Then open desired Application engine. Then on top... Read More

... Read More

Q : Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs). You need to... Read More

Q : Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time,... Read More

Access ID Read More

The statement being executed is line 233 of the PeopleCode program. Read More

Query view 9 Read More

psadmin -c shutdown! -d ps800dmo Read More

Field Edit, Field Change Read More

TIMESTAMP Read More

FieldChangeSearchSave and SavePreChange Read More

1. Shuts down the domain using the tmshutdown -k TERM -c command.2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes After logging into customer connection, you wish to search for fixes/patches. What are... Read More

True Read More

True Read More

PSRELEASE Read More

When a SQL is run, there is a lock on the table by the database until that section is completed. If during that time there runs some other process which will use the same table locked by our section using call section, this process will fail. Read More

PRCSTYPEDEFN.GBL Read More

WorkList Record Read More

GRANT_USER Read More

Derived work record Read More

Question : You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more elaborate testing... Read More

using call system command Read More

1. The application server first attempts to connect to database using the user id and password as part of the database connection string. 2. User must be defined on either the operating... Read More

Configuration Properties Read More

Q : PeopleSoft uses which one of the following tables to automate the process of creating large volumes of users on tables? PSOPRCLASS PSOPRLOAD PSOPRDEFN_INTFC d.      PSOPRDEFN ... Read More

Dynamic View is similar to SQL View but we cannot build the dynamic view. When we do not want store the database then us dynamic view. Read More

A section is a set of ordered steps that is executed as part of a program. You can call sections (and other programs) from steps within other sections. Read More

1) Server Status 2) Client Status 3) Queue Status Read More

No. The PeopleSoft Mobile Agent architecture, which is used to support disconnected mobile applications, is only available in PeopleTools 8.4. The PeopleSoft Mobile Agent is dependent upon certain core technologies that were specifically developed... Read More

Worklist Read More

1. Component 2. PeopleCode 3. Separator Read More

Bootstrap mode is actually logging into the App designer in 3-tier mode i.e. Logon to the App server. Data mover scripts are run on 3-tier mode. Read More

Field Edit Validate particular field only, but Save Edit validates all the fields in that component. Read More

Record peoplecode is triggered whenever you deal with the record. EX when u right a piece of code on Record Field change that code is fired whenever the Field is changed in any page. There is nothing called Row PeopleCode. Read More

SQL statements are Database specific whereas meta-SQL statements are Db independent. Read More

Trigger Business Event (BusProcess, BusActivity, BusEvent); Read More

PSACCESPRFLPSSTATUS PSOPRDEFN Read More

GetHistoryItems Read More

Yes, databases can co-exist on the same physical machine. In most cases, the databases themselves can exist within the same RDBMS; however, it is important to verify that the database version required by PeopleTools 8.4 is the same as for the current... Read More

Windows (Correct) Read More

Study all hyperlinks in the first page of people books. Read More

Psadmin –p start –d Read More

PeopleTools Tables Read More

Demo Read More

Create Trigger Read More

Application Updates and Fixes Read More

Study all hyperlinks in the first page of people books. Read More

There are several scenarios that may exist when customers use the PeopleSoftEnterprise Portal with a mixture of 8.1x and 8.4 applications. Specificinformation on the use of the PeopleSoftEnterprise Portal in a blendedenvironment will be available in... Read More

The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft’s Java Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architecture is supported only on the BEA WebLogic and... Read More

One of the core values of the PeopleTools development group is investment protection. The time, money and resources that you may have already invested in licensing another web server, training developers and administrators, building and deploying... Read More

The Component Processor is the PeopleTools runtime engine that controls processing of an application from the time that a user requests a component from an application menu until the database is updated and processing of the component is complete. Read More

Start with /*, end with */ Read More

Using Application packages is a very good way of coding your business logic and display logic. This way you can modularize your code very well and you can bring in the Object Oriented way of programming which will be very easy to develop and... Read More

PeopleCode may be placed on Record Field,Page,Componet,Menu Item,Component Interface,Meassage and Message Channel and Application Engine Read More

The Advanced Single Server Edition (AEs) of WebSphere provides the same core J2EE and Web Services programming model as the Advanced Edition (AE) with simplified administration. In the AE version WebSphere uses DB2 or other standard database to... Read More

Prompt table with edit means we can enter the value directly in edit box if the same value exists in prompt table and prompt table with no edit means we have to click on prompt button icon to enter the values Read More

Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine. They are not used as middleware with the PeopleSoft Application Server. Tuxedo is always used with PIA, regardless of the HTTP server or Java servlet engine. Read More

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 thedatabase version required by PeopleTools 8.4 is thesame as for the current... Read More

1. shuts down the domain using the tmshutdown -k TERM -c command.2. A forced shutdown is a non-quiescent shutdown that immediately terminates all the processes Read More

1. Report ID2. Date / time3. Release Read More

1. MS IIS2. Apache Read More

Action,Section,Step,Event Read More

SavePostChange Read More

1. The application server first attempts to connect to database using the user id and password as part of the database connection string.2. User must be defined on either the operating system or the database and within the PeopleSoft. Read More

log into Peoplesoft customer connect and navigate to Patches and fixes. To see future updates in plan - Click on Support -> Roadmaps and Schedules. Read More

Save post change Read More

Depth First Algorithm Read More

If yes, then Compare/Report is used to compare different projects. In sense, when there is a typical upgrade or for just the reason to compare the same projects in two databases we use this feature. When logged in as two-tier mode click on tolls >... Read More

Changes would occur globally; meaning the field is changed everywhere else in the database. Read More

Question : The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233What does the Source=233 parameter in the above LOG file entry identify? Answers: The... Read More

event definition Read More

False Read More

Local Read More

1000 Read More

a) Partner Alliance b) Partner Connection c) People Soft Connect d) Portal connect e) PSU (check) Read More

The inventory demand table structure was changed. In 8.4 there are 3 demand tables: demand_inf_inv, demand_inv, ship_inf_inv. In 8.8/8.9 there is only 1 demand table: in_demand Read More

In SaveEdit event,first all fields are checked for business rules and validations are carried out on all fields. If any of the values of fields doesn’t satisfy any of the business rule,warning or error message get generated depending on the... Read More

a) Graphical Representation of Business process and Relationsb) Flowchart of tables and Fields Read More

Question : What is search Record? Q2. How to create SQC? Q3. How to connect other application in component interface? Answers: Search record is a record that has at least one search key. Sqc is nothing but sqr... Read More

Unlimited Read More

1. Report ID 2. Date / time 3. Release Read More

1. Client Workstation in two tier mode (Yes) 2. App Server (Yes) 3. Batch Server (Yes) 4. Data Mover (Yes) Read More

XML   Read More

True Read More

Save post change Read More

PID.AET Read More

People Tools Read More

JavaObject Read More

event definition   Read More

b) Apply all Service packs Read More

Application Server Read More

app server Read More

a) SQL table b) SQL View Read More

a) Business Event b) A Rule c) A Role d) Activity Read More

3 Questions on this table with different queries and results Read More

1000 Read More

Q : Which is correct SQR Comment Syntax? a.     ! b.     /* */ c.     <* *> d.     Remark e.     None of the above ... Read More

Q : You just finished customization work that involved the creation of many new objects. You must now migrate these objects from your development database (source) to a testing database (target) to conduct more... Read More

Q  :  Which one of the following PeopleCode debugging tools automatically converts values of            any data type other than object into... Read More

Q : The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233 What does the Source=233 parameter in the above LOG file entry... Read More

Q : Which one of the following is the primary purpose of the application designer's SQL Alter function? a.  To update the database table to be in sync with the PeopleTools... Read More

Q : What is PeopleSoft's recommended way to access panel groups and the business logic associated with them outside of PeopleSoft online panels? a.      Component Interface Application engine ... Read More

Q : You created a new menu with three new data entry panels. The panels were created by another member of the development team. You must now add these panels to the new menu so users can key data into the system. Referring to the above... Read More

Q : The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqr .What do the above SQR flags signify to the SQR Report Writer upon execution? Specifies the path to the ALLMAXES... Read More

Q : Which of the tools below would you use to view the business process map display? Tree manager Security administrator Utilities Application designer Navigator Ans :  d Read More

Q : Which one of the following is NOT a component of the various tree types in the PeopleSoft tree manager? a.      Root Setid/Effective date Record definition Tree structure Category Ans :... Read More

Q :  Which one of the following tasks CANNOT be performed using PeopleSoft's Process Scheduler? Schedule a process to run monthly, daily, hourly, and even by the minute. Schedule recurring processes. c. ... Read More

Q : 1) REM This is an example of commenting PeopleCode;2) /* ----- Logic for Compensation Change ----- */ 3) /*Recalculate compensation for next row. Next row is based on*/ 4) prior value of EFFDT 5) calc_next_compchg(... Read More

1. Standard 2. Pop-Up Read More

We need to install Connectivity Software on Appserver and scheduler server if they are not on the Database server Read More

To store application data for life of the application Engine process Read More

In Sql view manually write the SQL statement, Query view use the PS QUERY tool. Read More

To do this, after you have created your Departments Navigate to TreeManger->Tree Manager and select Appropriate Security Tree (In General in People soft this will be DEPT_SECURITY).Attach your newly created Department in the tree in the required... Read More

Activity type is the nature of "action committed or happened" and nature depends on the environment. The all value paid or bear is located in small center is called Cost Center.GAP Analysis is finding out the "Deficiency or gap" between ideal system... Read More

When a SQL is run, there is a lock on the table by the database until that section is completed. If during that time there runs some other process, which will use the same table locked by our section using call section, this process will fail. Read More

Plan the Upgrade : 1) Prepare Copy of Production Database 2) Install New Release 3) Upgrade People Tools 4) Run and Review Compare Reports 5) Apply Application Changes 6) Complete Production Copy 7) Test the Upgrade 8) Move into... Read More

Component Buffer: Component Buffer contains all the Data of active componentData Buffer: Data Buffer contains Data other then the Data in the Component Buffer. Data Buffer classes are available in people code, Rowset, Row, Record, Field, Array,... Read More

Development and Upgrade Views Read More

ACTQRY.RPT Read More

Derived work record Subrecord Dynamic view These record changes do not affect the DB Read More

1. Development View 2. Upgrade View Read More

GetExisting option is equivalent to opening a record in Update/Display Mode only Read More

A component interface can be mapped to multiple PeopleSoft components Read More

Yes. WebSphere or WebLogic are used as the HTTP server and servlet engine. They are not used as middleware with the PeopleSoft Application Server. Tuxedo is always used with PIA, regardless of the HTTP server or Java servlet engine. Read More

Yes, both PeopleTools 8.4 and PeopleTools 8.1x application servers can run on a single machine. It is important to ensure that there are no port clashes between the installations. Read More

The PeopleSoft Internet Architecture uses a web application server and an HTTP server. PeopleTools 8.12 and above include both BEA WebLogic and Apache with Jserv. With PeopleTools 8.4, both BEA WebLogic and IBMWebSphere are bundled. Apache with Jserv... Read More

Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to do web server load balancing. In such scenarios, if an instance is down, requests are automatically routed to another instance. For more information on high availability and... Read More

All popular http servers (reverse proxies) are supported. Please refer to the platforms database on Customer Connection for specific information on current certified platforms. Read More

WorkList Record Read More

Tuxedo Read More

Server, Client and Queue Status Read More

Save Post Change Read More

PSDAEMON Read More

DB Access Id Read More

(Scenario based on process profile / process group) Server o/p path override, process he can access. Read More

1) IBM DB2/UDB 2) Oracle 3) SQL Server Read More

Drived Work Record definitions not stored in the database and not require for build. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then go for customizations through Consultants Read More

Orphaned Objects Read More

Profile Read More

SavePostChange Read More

List Box item Read More

Using UNION Read More

State Records are used in AE to pass values from action and section to the other. It also allows you to restart the App engine. For this, the State record has to be a SQL table. A state record either can be an SQL table or derived Work record.... Read More

When you want to validate data upfront before loading them into db, better plan to use appeng or ci, when you are thinking of huge data to be loaded SQR would be a better option Read More

2-tier, 4-tier, process scheduler Read More

Starting Web Server Read More

SQL Table OR Field Read More

Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s) From the following statements, which one is NOT true about Pub Broker? Psserver in configuration properties Read More

PSCAMA Read More

PSAPPSRV.CFG Read More

Process Scheduler, Use, Process Definitions Read More

PID.AET Read More

Process monitor Read More

PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties Read More

People Tools Read More

Page def Read More

Once you exit PeopleSoft and log back in. Read More

Message agent queries Read More

Integration Broker Read More

1. Establish a user session 2. Get the Component Interface 3. Populate the Create Keys 4. Create an Instance of the CI 5. Populate the required fields 6. Save the CI Read More

There are several scenarios that, may exist when customers use the PeopleSoft Enterprise Portal with a mixture of 8.1x and 8.4 applications. Specific information on the use of the PeopleSoft Enterprise Portal in a blended environment will be... Read More

The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft’s Java Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architecture is supported only on the BEA WebLogic and... Read More

The Advanced Single Server Edition (AEs) of WebSphere provides the same core J2EE and Web Services programming model as the Advanced Edition (AE) with simplified administration. In the AE version, WebSphere uses DB2 or other standard database to keep... Read More

One of the core values of the PeopleTools development group is investment protection. The time, money, and resources that you may have already invested in- 1) Licensing another web server 2) Training developers and administrators 3) Building... Read More

No. The web server that was delivered on the Tuxedo CD has absolutely nothing to do with WebLogic. WebLogic is a web application server that is designed for large-scale production websites. The HTTP server on the Tuxedo CD was only there to provide a... Read More

No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere for early adopters program, created and managed by IBM. Further information about this program... Read More

No. Both products are certified with PIA as of version 8.4 and work equally well. By offering both BEA WebLogic and IBM WebSphere, we give our customers more choices and flexibility to run PeopleSoft in their preferred environment. Read More

BEA and IBM provide plug-ins for many of the leading web servers. This allows the customer to use their own HTTP web server and Web Logic’s or Web Sphere’s Java servlet engine. PeopleSoft uses this plug-in capability to support IIS. We... Read More

WorkList Record Read More

Use App Designer -> Copy DB Read More

Some options are-1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes) Read More

Section, Step and Action Read More

PSAPPSRV.tracesql Read More

Only selection of existing data is possible Read More

GRANT_USER Read More

FieldEdit, SaveEdit, and RowDelete Read More

ENCRYPT_PASSWORD Read More

Database superuser Read More

Configuration.properties Read More

Commit Read More

Apply all outstanding patches, prior to upgrade Read More

Action, Section, Step, Event Read More

1. The application server first attempts to connect to database using the user id and password. 2. User must be defined on either the operating system or the database and within the PeopleSoft. Read More

1. Go 2. Step Over 3. View Variable Value Read More

1. File Layout 2. CI 3. app. Messaging Read More

1. Development 2. Upgrade Read More

DB Server Read More

XML Read More

WinMessage Read More

Webserver configuration.properties file Read More

True Read More

Some options:1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes) Read More

GetExisting option is equivalent to opening a record in Update/ Display Mode only Read More

Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI Read More

GetHistoryItems Read More

GetExisting option is equivalent to opening a record in Update/ Display Mode only Read More

Get keys, Create keys and Find keys gets created automaticallyThe Create method is created alongwith the other Standard methods for the CI Read More

A OR b Read More

A component interface can be mapped to multiple PeopleSoft components Read More

Yes, both PeopleTools 8.4 and PeopleTools 8.1x application servers can run ona single machine. It is important to ensure that there are no port clashes between the installations. Read More

The PeopleSoft Internet Architecture uses a web application server and anHTTP server. People Tools 8.12 and above include both BEA WebLogic andApache with Jserv. With PeopleTools 8.4, both BEA WebLogic and IBMWebSphere are bundled. Apache with... Read More

The Advanced Single Server Edition (AEs) of WebSphere provides the same core J2EE and Web Services programming model as the Advanced Edition (AE) with simplified administration. In the AE version WebSphere uses DB2 or other standard database to keep... Read More

No. The web server that was delivered on the Tuxedo CD has absolutely nothing to do with WebLogic. WebLogic is a web application server that is designed for large-scale production websites. The HTTP server on the Tuxedo CD was only there to... Read More

No. The PeopleSoft Mobile Agent architecture, which is used to support disconnected mobile applications, is only available in PeopleTools 8.4. The PeopleSoft Mobile Agent is dependent upon certain core technologies that were specifically developed... Read More

No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere for early adopters program, created and managed by IBM. Further information about this program... Read More

No. Both products are certified with PIA as of version 8.4 and work equally well. By offering both BEA WebLogic and IBM WebSphere, we give our customers more choices and flexibility to run PeopleSoft in their preferred environment. Read More

Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to do web server load balancing. In such scenarios, if an instance is down, requests are automatically routed to another instance. For more information on high availability and... Read More

Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4 for several reasons: v JServ is no longer an active product and is in maintenance mode and there are no longer any new... Read More

All popular http servers (reverse proxies) are supported. Please refer to the platforms database on Customer Connection for specific information on current certified platforms Read More

Worklist Read More

TIMESTAMP Read More

Windows (Correct) Read More

Specifies the output path Read More

A OR b Read More

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. Read More

i think, it is "Error" Function. Use the Error function in FieldEdit or SaveEdit PeopleCode to stop whole processing and display an error message. It is distinct from Warning, which displays a warning message, but does not stop processing. Error is... Read More

Using Application packages is a very good way of coding your business logic and display logic. This way you can modularize your code very well and you can bring in the Object Oriented way of programming which will be very easy to develop and... Read More

Record Level peoplecode: The peoplecode written on the Recoed level Peoplecode will affect all the Components in which that particular record is used, and if we want to execute the record peoplecode for particular Component then we would need to add... Read More

Instead of using PeopleCode,Directly we can assign the search record at the menu level which will override the search Record specified at the component level. Read More

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... Read More

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 Read More

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. Answers: 2. Database server Read More

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... Read More

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. Read More

REM can be used to comment a single line, but it will be processed by the comp. processor; Single and multiple line commenting: /* PeopleCode stmts ------ ------ ------ ---- */ Nested Comments: <* /* PC Stmts ...... ..... ... Read More

Component Buffer consists of rows of buffer fields that hold data for the records associated with the page including primary scrolls, derived work records etc. Read More

1. Include all the roles in a project by clicking on Insert -> Definitions into Project -> select Roles and add them into the project. Migrate the project to anotherdatabase. 2. Create a datamover script to migrate roles from PSROLEDEFN... Read More

Yes, both PeopleTools 8.4 and PeopleTools 8.1x application servers can run ona single machine. It is important to ensure that there are no port clashes between the installations. Read More

No. Both products are certified with PIA as of version 8.4 and work equally well. By offering both BEA WebLogic and IBM WebSphere, we give our customers more choices and flexibility to run PeopleSoft in their preferred environment. Read More

No. IBM WebSphere is certified on PeopleTools 8.4 only. Customer wishing to use IBM WebSphere with PeopleTools 8.1x may take advantage of an IBM WebSphere for early adopters program, created and managed by IBM. Further information about this program... Read More

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. Read More

There can be any number of sub-pages but only one secondary page in a level. Read More

The PIA Java servlets in PeopleTools 8.4 are coded to JavaSoft’s Java Servlet API 2.0 and are fully compatible with Servlet API 2.2. It should be noted that the PeopleSoft Internet Architectureis supported only on the BEA WebLogic and IBM... Read More

Apache JServ was a servlet engine that was supported in PeopleTools 8.1x. This support has been removed from PeopleTools 8.4 for several reasons: v JServ is no longer an active product and is in maintenance mode and there are no longer any new... Read More

Customers can set up clusters of BEA WebLogic or IBM WebSphere servers to do web server load balancing. In such scenarios, if an instance is down, requests are automatically routed to another instance. For more information on high availability and... Read More

No. The web server that was delivered on the Tuxedo CD has absolutely nothing to do with WebLogic. WebLogic is a web application server that is designed for large-scale production websites. The HTTP server on the Tuxedo CD was only there to provide... Read More

All popular http servers (reverse proxies) are supported. Please refer to the platforms database on Customer Connection for specific information on current certified platforms. You may find this at http://www.peoplesoft.com/corp/en/iou/platforms... Read More

Application Messaging is used by PeopleSoft applications to communicate withone another. This is true not just for 8.1x and 8.4 applications, but also betweenan 8.1x and an 8.4 application. For example, the HRMS 8.3 applications, whichare based on... Read More

The PeopleSoft Internet Architecture uses a web application server and anHTTP server. PeopleTools 8.12 and above include both BEA WebLogic andApache with Jserv. With PeopleTools 8.4, both BEA WebLogic and IBMWebSphere are bundled. Apache with Jserv... Read More

yes both weblogic and websphere has ability to plugin to most of the webserver like iplanet,apache,IIS,tomcat. Read More

Specifies the output path Read More

Some options:1. Customize PS application (Yes)2. Buy third party software (Yes)3. Call PS Development Center for Enhancement (Yes) Read More

Commit Read More

PeopleSoft Knowledge base Read More

User Profile Read More

ENCRYPT_PASSWORD Read More

SavePostChange Read More

FieldChangeSearchSave and SavePreChange Read More

1. batch server2. App server3. two tier client Read More

Study all hyperlinks in the first page of people books. Read More

PeopleTools Tables Read More

Orphaned Records Read More

Create Trigger Read More

Development and Upgrade Read More

Configuration.properties Read More

1. Release2. Updated date time3. Report Id Read More

Application Updates and Fixes Read More

ACTQRY.RPT Read More

Query view Read More

Add the field, SETID, as a key field to each table you want to share, and then define the set control field. PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number? Read More

Derived/Work Record Read More

1. Query trees 2. Combination trees Read More

UNION Read More

1. File Layout2. CI3. app. Messaging Read More

1. Appl. Messaging2. Component Interface3. File Layout Read More

DB Server Read More

Use App Designer -> Copy DB Read More

1. Client Workstation in two tier mode (Yes)2. App Server (Yes)3. Batch Server (Yes)4. Data Mover (Yes) Read More

Update Statistics Read More

Oracle, DB2, Other Options: SQL Server, Informix, Sybase Read More

FieldEdit, SaveEdit and RowDelete Read More

ENCRYPT_PASSWORD Read More

Tuxedo Read More

Psadmin ?p start ?d Read More

It Is PSOPRDEFN. The password however is encripted. Read More

psadmin -c shutdown! -d ps800dmo Read More

Spawning Read More

Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table. Read More

Lets say all the data resides in a table PS_TABLE_A. Lets say AS_OF_DATE is held by a variable as_of_date. Here goes the query:- Select PROFESSOR, ASST_PROFFESSOR FROM PS_TABLE_A WHERE EFFDT< as_of_date OR EFFDT= as_of_date Read More

Configuration Properties Read More

app server Read More

Access ID Read More

A component interface is a PeopleSoft PeopleTools definition that is created to access a Component buffer without actually accessing the Component physically from the PIA. Read More

A Connect ID is a valid user ID that, when used during login, takes the place of PeopleSoft User IDs for the logon process. Using Connect ID means you don?t have to create a new database user for every PeopleSoft user you add to the system. Connect... Read More

webserver configuration.properties file Read More

app server Read More

oracle9i is developed by the oracle corporation. sql server 2000 is developed by the Microsoft Read More

Log into (currently) PeopleSoft website with your login and password - https://www.peoplesoft.com/ corp/en/login. jsp Read More

(scenario based on process profile / process group)Server o/p path override , process he can access Read More

Component Read More

use the PeopleSoft delivered Upgrade Assistant or Change Assistant for PT8.45 and above. Read More

portal registry is a tree-like structure in which content references are organized, classified, and registered. It is stored in a set of tables within a PeopleSoft database made specifically for hosting portal registries. Portal registries contain... Read More

Process monitor Read More

Where are the work items presentWorkilist Read More

fiels edit,fi eldchange, field default, field formula rowinit ,rowdelete ,rowinsert ,rowselect ,prebuild ,postbuild, saveedit, saveprechange ,savepostchange ,worlflow Read More

Common key fields Read More

We have to enable the service from the psadmin.PSDBGSRV is the service which should be set to yes to start the debugging of peoplecodeGo to configure the domain in psadmin and follow the instructions Read More

Advance search Read More

Application Server Read More

3 Questions on this table with different queries and results Read More

SQL Table OR Field Read More

Operator Class Read More

1 19. Read More

parameter is something that is prompted to enter by the user.Parameter fields support the following datatypes. Boolean, currency,date,datatime,number,string,time Read More

a) In Configuration Manager, under the Application Servers tab. Read More

Data mover is used to move data of a record of database to another record in another database and the records should be identical in all respects like the number of fields, keys and fields Read More

10,000,000 Read More

appdesigner -> worklist definition Read More

true Read More

Question : Let us take a Temp Table TMP_TAO. In People Tools options the following instance settings are done Temp Table Instances (Total) : 5 Temp Table Instances (Online): 4 In AE1 App Engine Program the instance count to TMP_TAO is 3 In... Read More

True Read More

True Read More

7 Read More

Standard & Secondary Read More

True Read More

True Read More

PSCAMA Read More

Integration Broker Read More

PS_HOME/appserv in the Application Server Read More

Starts a Process Scheduler Read More

PSACCESPRFLPSSTATUS PSOPRDEFN Read More

a) Sequence of processes b) Sequence of jobs c) batch processes Read More

People Tools Read More

a) PDF d) txt Read More

a) Mobile Page b) File Layout c) App Engine Read More

b) Recreate a Table d) Recreate a View Read More

a) user can enter values from prompt table b) user can enter values from prompt table and default value will be populated Read More

The functions which will suspend processing either until the user has taken some action. for example clicking a button in a message box Read More

Prebuild,Postbuild,save prechange,save postchange and workflow Read More

The file formats can be .csv and fixed length also Read More

1. XLS is the correct answer Read More

SQR:command line(sqrw. exe),process scheduler & peoplecode AE:commandline(psae.exe),process scheduler,peoplecode-callappengine(aename,st-rec) Read More

While running the SQR via command line, you may also generate the output in .PDF format by including the parameter -PRINTER:PD Read More

lets say all the data resides in a table PS_TABLE_A. Lets say AS_OF_DATE is held by a variable as_of_date. Here goes the query:- Select PROFESSOR, ASST_PROFFESSOR FROM PS_TABLE_A WHERE EFFDT< as_of_date OR EFFDT= as_of_date Read More

b) Apply all Service packs Read More

psserver in configuration properties Read More

a) Change in mapping of data Read More

Load Lookup is essentailly an array which acts in the form of a table. Load Lookup is used to reduce the complexity of joins - it populates the values of a certain field depending on the ke field specified from a certain table. Then the users can... Read More

If data needs to be validated well before updating records and to make parent child records synchronous with respect to data, use AE/CI. When there is huge data to be manipulated, better use SQRs (run on server if possible). Read More

Yes. It is similar to use function, procedure and packages in SQR. The only difference is - Use begin- Sql Begin procedure(param1,param2) End End-Sql Read More

Using create report you can create multiple reports in one single SQR report Read More

Inner join : An inner join (sometimes called a "simple join") is a join of two or more tables that returns only those rows that satisfy the join condition. Outer Joins : An outer join extends the result of a simple join. An outer join returns all... Read More

Setenv.sqc,setup02.sqc,prcsapi.sqc,prcsdef.sqc,curdttim.sqc,datetime.sqc are some of the SQC’s that should be present. Read More

Update Statistics Read More

Psadmin –p start –d Read More

... Read More

PeopleTools Tables Read More

FieldEdit, SaveEdit and RowDelete   Read More

Demo   Read More

... Read More

Configuration.properties Read More

Commit Read More

Application Updates and Fixes Read More

Action,Section,Step,Event Read More

1. File Layout 2. CI 3. app. Messaging   Read More

Yes Read More

web server configuration.properties file Read More

True   Read More

Q :The following is an entry from the application reviewer LOG File: start Field=PERSONAL_DATA.EMPLID-RowInit Temps=1 Stack=4 Source=233What does the Source=233 parameter in the above LOG file entry identify? A : The statement... Read More

Table 1 relates to 0,1 or many records in Table2, Table 2 relates to Table1 as one and only one table. Read More

Starts a Process Scheduler Read More

Pub Broker is invoked after Pub Contractor Handler evaluates routing rules and writes contract(s) Read More

PIA-.PeopleTools-> Integration Broker->Node DefinitionApplication Designer->Message ->Properties Read More

Page def Read More

Integration Broker   Read More

FieldEdit, FieldChange, MenuItemSelected MenuItemSelected, Save Prechange & SavePostChange Read More

Every 5 Mins Read More

Derived work record Read More

Depth First Algorithm Read More

Component Read More

Common key fields   Read More

appdesigner -> worklist definition Read More

Advance search Read More

a)xml b)csv c) fixed length Read More

a) PDF d) txt Read More

a) Mobile Page b) File Layout c) App Engine Read More

a) Graphical Representation of Business process and Relationsb) Flowchart of tables and Fields Read More

a) Database Server b) App Server c) Batch Server e) Web Server Read More

a) Change in mapping of data Read More

6 keys in Ascending orders Read More

(scenario based on process profile / process group)Server o/p path override , process he can access   Read More

Q : Which of the following links are found in PeopleBook ... Read More

Q : Department Manager should approve the each Business activity before it goes to next step. How would u implement this in Work Flow? Rule Role Users None of the above All of the above Ans : ... Read More

Q : Criteria in PS Query refers which of the following in SQL a.     Where b.     Select c.     Insert d.     Commit e.   ... Read More

Q : Where report would be processed? a.     Process Scheduler b.     Application Server c.     Client d.     Workstation e.   ... Read More

Q : Which of the following would be stored in to the database? (Choose 3) a.     SQL Table b.     SQL View c.     Dynamic View d.    ... Read More

Q : Which of the following are the ways to execute AE Program? (choose 4) a.     Application Designer Run Button b.     Process Scheduler c.     People Code d.... Read More

Q : U downloaded some patches. What are all the things that might come with those patches? a.     SQR b.     People Code c.     Upgrade template d.  ... Read More

Q : Entity Relationship diagram means? a.     Business process map b.     Work flow process c.     A flow chart that indicates each entity and its relationship d.... Read More

Q : Where u would give the parameter values for Process to run? a.     Run control table b.     State record c.     Some other options d.    ... Read More

Q : Which is of the following are valid Variable scopes. a.      component , Record ,Global b.      Component, Local, Field c.      Local, Global,... Read More

Q : PeopleSoft has its own naming convention for system and non-system (application) tables. In the list below, RECORDNAME refers to the name of any table or record. Referring to the above information, which one of the... Read More

Q : Which one of the following tree types is NOT supported in the PeopleSoft tree manager? a.  Node-Oriented trees b.  Query trees c.  Detail trees d.        ... Read More

Q : You are asked to perform some security-related tasks. You determine the quickest method to do this is... Read More

Q : UPDATE PSLOCK SET SECURITY_OPTION = ''; what function does the above SQL statement perform? a.     Disables the PSLOCK security option for ALL users. b.     Enables the... Read More

Q : The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqr what do the above SQR flags signify to the SQR Report Writer upon execution? a.     Directs... Read More

Q : What application server service initiates a COBOL program to run a transaction? a.          Jolt Internet relay b.          Remote... Read More

Q : Which one of the following is NOT a standard enforced by Data Mover? a.     With the exception of double-dash (--) comment statements, statements may span multiple lines. b.     With... Read More

Q : Which one of the following files are NOT stored in the process scheduler logging directory? a.     Application server logs b.     COBOL trace logs c.     Process... Read More

Q : Which process requests will run through the process scheduler server? a.     All processes submitted on the server b.     All SQR and COBOL processes ONLY c.    ... Read More

Q : The major types of Trees that can be created using the Tree Manager? a.  Position, Succession, Department, Access Group b.     Detail Trees, Summary Trees, Node Oriented Trees, Query Access Trees ... Read More

Q : You created a new menu with three new data entry panels. The panels were created by another member of the development team. You must now add these panels to the new menu so users can key data into the system. Referring to the... Read More

Q : Which of the following shortcuts would you install on a developer's workstation to       allowquickaccess to the PeopleSoft applications while also allowing them to change    ... Read More

Q : Before performing an upgrade, it is a good idea to validate the consistency of the database in which the upgrade will occur. This helps ensure a "clean" starting point for the upgrade process. Referring to the above information,... Read More

Q : Which one of the following is NOT a task performed by Data Mover? Transfer application data between PeopleSoft databases. Rename record and field names within PS Database. Re encrypt passwords globally for a single... Read More

Q : 2. print " " 3  BLANKLINE = 1 4. .B 5  display " "      Which of above SQR statements allows you to print a blank line within a document when creating a letter within SQR? 1 2 3 4 5 ... Read More

Q : How do you set up table-sharing in PeopleTools applications? a.      Add the field, SETID, as a key field to each table you want to share, and then define the set control field. Add the... Read More

Q : PeopleSoft reserves ALL Message Sets (in Utilities, Message Catalog) up to which number? 10,000 19,999 30,000 40,000 50,000 Ans : B Read More

Q : Why is the record description displayed above important when creating a new record? It is used for Upgrade processes. PS Query and Tree Manager use it to identify the record. It is a required description. Record... Read More

Q :  How are PeopleCode programs saved within the database? Saved as ASCII text, and stored in the field definition. Saved as binary, and stored in the field definition. ... Read More

Q : Which events occur when an error or warning is issued during a FieldDefault PeopleCode event? Displays the Error or Warning message, and continues processing. Causes a runtime error, and forces cancellation of the... Read More

Q : Which one of the following database management systems requires that you key the SERVER NAME in lower case in the configuration manager signon defaults? Microsoft SQL Server b.      Informix ... Read More

Q : Your application users are experiencing problems with one of the customizations your development team has recently worked on. The customization involved changes to a PeopleCode object within the database. You decide to use... Read More

Q : Your delivered PeopleSoft reports do not contain enough information in the headings. Your users want more detailed information in the headings. Referring to the above information, which one of the following utilities allows you to... Read More

Q : How would you track ongoing changes to PeopleTools objects within your database? Use change control administrator's Lock All Objects option. Use change control administrator's Use Change Control Locking... Read More

Q : A user requests a new field to be added to the data entry application used by the company. This new field will capture large amounts of text, up to 2000 characters long. As a developer, you must decide what type of field to use to... Read More

Q : PeopleSoft Query is split into which of the following two views? Query view and data view Record view and field view Component view and designer view Object view and field view Object view and results view Ans :... Read More

Q : The TUXEDO Connect String is designed for advanced configuration to support dynamic load balancing.  The following example illustrates a sample TUXEDO Connect String:           /... Read More

Q : Which one of the following situations requires the installation of database connectivity software on the client workstation in a three-tier environment? If you run application designer If you wish to run a process on the... Read More

Q : Which query type requires the use of aggregate functions on the columns being selected in the query? Reporting query PS/nVision matrix query Ad-hoc query Search query Search dialog box query Ans :  b Read More

Q : Which option best describes the term, upgrading, in PeopleSoft? Migrating PeopleSoft objects from one database to another. Installing new executables that increase the current software version to a higher version. ... Read More

Q : Which one of the following components is NOT part of the PeopleSoft three-tier architecture? Application server Batch server Web server Client workstation Database server Ans :  d Read More

Keys, Properties & Collections, Methods, and Name Read More

Oracle, DB2, Other Options: SQL Server, Informix, Sybase Read More

Report id date release Read More

CI’s can be used to upload data from legacy systems through excel to CI or create new data within PeopleSoft from another component. Read More

True Read More

Specifies the output path Read More

Spawning Read More

PSRELEASE Read More

Q : Suppose the CEO wants a list of the departments, whose MINIMUM salary is greater than $100,000? Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time, you decide to... Read More

Q : Your Onsite DBA has called you up and told you that one of the tables PS_ABC_TAO has grown very big in size. Based on the standard naming convention, you have determined that the record is a temporary record since it ends with _TAO you look into... Read More

Released Read More

PRCSTYPEDEFN.GBL Read More

1. Client Workstation in two-tier mode (Yes) 2. App Server (Yes) 3. Batch Server (Yes) 4. Data Mover (Yes) Read More

Q : Your company obtained the newest Application Release of PeopleSoft, and you need to prepare for the upgrade. Upon reading the new Release Notes, you notice that changes were made to two COBOL modules (batch programs). You need to decide how to... Read More

True Read More

True Read More

Keys, Properties & Collections, Methods and Name Read More

1.Establish a user session 2.Get the Component Interface 3.pulate the Create Keys 4.eate an Instance of the CI 5.pulate the required fields 6. Save the CI Read More

Component Buffer is the area in memory that stores data for the currently active component. Read More

There are several scenarios that may exist when customers use the PeopleSoftEnterprise Portal with a mixture of 8.1x and 8.4 applications. Specificinformation on the use of the PeopleSoft Enterprise Portal in a blendedenvironment will be available... Read More

Row class is the component object where it binds all the row’s in all level will be in the buffer row set is the set of rows that are in the level one from there for every rowset you can access the data in the level two Read More

Only selection of existing data is possible Read More

Question : The Security Administrator is not available. You are in a hurry to grant a user the ability to start an application server, and you decide to make the change in the actual application server configuration file, rather than using... Read More

Server, Client and Queue Status Read More

1. Go2. Step Over3. View Variable Value Read More

Apply all outstanding patches, prior to upgrade. Read More

user can type only prompt table values and the default values gets populated from the database. Read More

Field Change event Read More

a) Database Server b) App Server c) Batch Server e) Web Server Read More

Page def Read More

Bundle is the group of patches and fixes, peoplesoft had delivered during specific time period Read More

XML Read More

Data mover,importmanager,filelayout,sqr,application engine, component interface Read More

Question : Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO. Since writing an SQR will take too much time,... Read More

Question : PeopleSoft has its own naming convention for system and non-system ( application) tables. In the list below, RECORDNAME refers to the name of any table or record.Referring to the above information, which one of the following... Read More

A role name Read More

True Read More

Definition, Program flow Read More

Every 5 Mins Read More

a) Business Event b) A Rule c) A Role d) Activity Read More

DDD Audit is a SQR used to find the inconsistencies between the data structures defined in PeopleTools table against the underlying database. SYS Audit is an SQR used to compare the different people tools tables and find inconsistencies like... Read More

1) IBM DB2/UDB 2) Oracle 3) SQL Server Read More

Component and Query view Read More

Database superuser Read More

1. Development 2. Upgrade   Read More

True Read More

app server Read More

a) Partner Alliance b) Partner Connection c) People Soft Connect d) Portal connect e) PSU (check) Read More

Q : The field mapping button on worklist definition is used for for mapping the fields of worklist record that can be visible on worklist message. We can assign the following type of values to it? A : A role name Read More

Q : In which of the following code would be automatically generated when u drag the component? (multiple answers) File Layout Component Interface Application Engine None of the above All of the above Ans... Read More

Q : PeopleSoft reserves ALL Win Help context numbers (in Utilities, PeopleTools Options) up to which number? a.     10,000,000 b.     12,000,000 c.     14,000,000 ... Read More

Q : Suppose the CEO wants a list of the departments whose MINIMUM salary is greater than $100,000. Your manager asks you to determine the quickest method to deliver this data to the CEO.... Read More

Q :1.View      2. SQL Table 3.Derived / Work Record 4. Sub Record 5. Query View      Which of the above record definitions is NOT stored on the database and is therefore NOT required... Read More

Q : The Application Reviewer is not working correctly, and you are in a hurry to find the problem with a piece of PeopleCode that's been causing problems. You need a quick method to find all the fields being referenced by the... Read More

Q : As a last resort, query will write the default Crystal Report to which directory? CRWRPTPATH directory Root directory of the PeopleSoft application server Server %TEMP% directory Windows %TEMP% directory User's... Read More

Q : Select max(effdt)   from ps_car_alloc where emplid = &EMPLID    and effdt <= %currentdate    and end_dt is null;      What problem exists in the above... Read More

Q :  <Log Directory>ProcessName_ProcessInstance.log Which one of the following log files does the above log file naming syntax and path location identify? Process server message agent log Process server agent log ... Read More

Q : How would you run SQL Alter to alert you to discrepancies between your record definitions and underlying SQL tables, without actually performing changes to the object in the database? Run as a user with AUDIT permissions to the ... Read More

Q : If an object is removed from the database, it will NOT automatically be removed from the project(s) to which it was added. How do you determine if a project contains valid objects without checking every object manually? Open... Read More

Q : Which one of the following database management systems requires the use of the Connect ID and Connect Password in the configuration manager signon defaults section? a.      DB2 Microsoft SQL Server ... Read More

Q : Message definitions are created using which one of the following tools? EDI manager Application engine c.      Application designer PeopleTools utilities PeopleSoft query Ans : c Read More

JOB record Read More

Standard & Secondary Read More

Component and Query view Read More

a) Database Server b) App Server c) Batch Server d) Web Server Read More

1. FieldChange 2. FieldDefault 3. FieldEdit 4. FieldFormula 5. PrePopup 6. RowDelete 7. RowInit 8. RowInsert 9. RowSelect 10. SaveEdit 11. SavePostChg 12. SavePreChg 13. SearchInit 14. SearchSave 15.... Read More

1. Use Load-lookup and Arrays 2. Use SQT files. 3. Generate multiple reports. 4. Use correct sql joins. Read More

Save post change Read More

A OR b Read More

Application Messaging is used by PeopleSoft applications to communicate with one another. This is true not just for 8.1x and 8.4 applications, but also between an 8.1x and an 8.4 application. For example, the HRMS 8.3 applications, which are based on... Read More

Unlimited Read More

To connect a report first we have to know about run control page. So that we can add the required fields over there and then passing those oprid and runctlid through the stdapi.sqc we can run an an SQR by including this SQC. This can be runned... Read More

Server, Client and Queue Status Read More

Question : 1.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? Answers: Create a workflow. In the workflow, use a query with active... Read More

DB Server Read More

Yes Read More

False Read More

No answer available currently. Be the first one to reply to this question by submitting your answer from the form below. Read More

a) SQL table b) SQL View Read More

There are several scenarios that may... Read More

Where are the work items presentWorkilist Read More

Business Process Read More

a) Sequence of processes b) Sequence of jobs c) batch processes Read More

Q : Which is correct People Code comment Syntax (choose 2) a.     <* *> b.     /*  */ c.     Comments d.     None of the above ... Read More

Q : After going live with your new application, you realize that one of the values being used for computing Employee Leave Accruals is not correct. You've narrowed the problem down to a section of PeopleCode within the... Read More

Q : Application engines are comprised of one or more steps and are quite similar, in... Read More

Q : When naming system (non-application) tables in PeopleSoft, there is one exception of which you need to be aware. Referring to the above information, which one of the following records is the aforementioned exception for PeopleSoft... Read More

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,... Read More

Sql, data mover commands Read More

Sql , data mover commands Read More