1.What is an Application Engine?
Application Engine is a PeopleTools Object used to carry out background SQL processing. It contains a set of SQL statements, PeopleCode, and program control Actions like Looping (DoSelect, DoWhile, and DoUntil) and Conditional logic (DoWhen). Application Engine comprises two distinct components—a designer where you define your batch program and the runtime environment where you run and monitor your program.
2.What is the use of Application Engine?
Application Engine is useful to develop ,test and run Batch or Online Programs that performs background SQL processing.
3.What are the advantages of Application Engine?
AE is a PeopleTools Object so it can be easily upgraded between the databases.
• Supports Restart facility.
• Supports Meta SQLs which makes the code platform
• independent.
• Supports Parallel Processing.
• Supports GUI.
• Supports Effective Dating.
• Reuse Business Logic.
• Encapsulation.
• Portable to Operating System.
4.What are the elements of Application Engine?
An Application Engine program comprises of a set of processes to carry out a given task. It is made up of these key elements:
• Sections
• Steps
• Actions
• State records
5.What are the Types of Application Engines?
• Standard: Used by standard entry-point programs.
• Upgrade Only: Used by PeopleSoft upgrade utilities only.
• Import Only: Used by PeopleSoft import utilities only
• Daemon Only: Use for daemon-type programs.
• Transform Only: Support for XSLT programs.
6.What is Daemon Processing?
A special type of program used as a daemon process and is intended for recurrent jobs. For example: A Daemon process which runs based on an input file. It waits till the input file loads in particular server then starts executing automatically.
7.What are the other Tools which can also supports background SQL Processing?
COBOL, SQR, Mass Change.
8.Which PeopleTools table stores the Application Engine information?
PSAEAPPLDEFN
8.Does Application Engine Generate SQLs like Query Manager?
No, Application Engine does not generate SQL or PeopleCode. It executes the SQL and PeopleCode that you include in an Application Engine Action.
9.Is compilation required for Application Engines?
Compilation is not required for AE Programs.
10.What are the Platforms that AE can support?
DB2, DB2/Unix, Informix, Microsoft, Oracle and Sybase.
11.What is the limitation to the Application Engine program name?
12 characters.
12.What is the use of Transform Only AE Type?
These types of programs enable different systems to communicate with one another by transforming messages into appropriate formats.
13.How many Tabs available in AE Properties?
• General
• State Record
• Temporary Table
• Advanced
14.How to tune the Application Engine Performance?
• Use Temporary Tables.
• Avoid Row by Row Processing.
• Use Set Processing.
• Use Bulk Insert.
• Reuse.
• Split the logic into smaller piece rather coding everything in one place.
• By using Traces.
• Avoid using SQLs in PeopleCode Action rather use in Do Actions.
15.What are the properties available in Advance Tab?
• Disable Restart
• Application Library
• Batch Only
• Message Set
• Program Type.
Tryst with PeopleSoft 