Component Interface Interview Questions

1. What is Component Interface meant for?

It enables synchronous access to a PeopleSoft component from another application (third party application like Java,C++,COM etc) including all business rules and data.

2.What are the main elements in the Component Interface ?

Main elements of Component Interface:

ü  Component Interface name

ü  Keys

ü  Properties and collections

ü  Methods

3.What are the standard properties when a Component Interface is created?

Standard properties of CI are:

ü  Interactive mode

ü  GetHistoryItem

ü  EditHistoryItem

4. Can we map more than one component at a time from the CI ?

No, A Component Interface can be mapped to only one component, but one component can be mapped to multiple CI’s.

5. Explain what  are the various steps that describes the PeopleCode logic while implementing a Component Interface?

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 .

6.What is method? What are the different types of method?

A method is an object that performs a very specific function on a CI  at runtime.

                Types Methods are Standard methods and User-defined methods

Standard methods: - Automatically generated upon the creation of a new component Interface in Application

7. Which KEYS are mapped as find keys for a Component Interface?

                Search key and alternate search key.

8. How do you login in correction mode in the Component Interface?

Get History Items and Edit History items property to should be set to true.
9. If you are PS developer then in what scenarios Component Interface will have advantages over component?

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 PeopleSoft database information programmatically.

PeopleSoft Component Interfaces expose a PeopleSoft component (a set of pages grouped for a business purpose) for synchronous access from another application (PeopleCode, Java, C/C++, or Component Object Model [COM]).

10. What happens when a Component Interface is created on component that has add Action enabled?

Create method and create keys are created. The create method will not be present if the Add mode for the Component is not enabled.

11. Can we create get and find keys manually ?

No, These keys are created based on the search record definition for the underlying component.

Application engine Interview Questions

1. What is  application engine ?

                Application Engine programs are PeopleSoft's batch processing technology. They are developed in application designer and consist of blocks of PeopleCode and SQL. Application engine programs can also use application classes, Component Interfaces, XML publisher reports, and call SQRs and COBOLs through PeopleCode.

2. What is application library?

                Application library is a program that contains collection of callable sections.  We can’t define application library with standalone program.

3. What are the Different types of Application Engine?
                Standard: Standard entry-point program.
                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 Transform programs.
4.What is the difference between the %select and %selectinit meta SQL functions?

                %select        : If any values have not selected then previous values will be there

                %selectinit   : If any value have not selected then previous value reinitiate to null.

 5.What are the different types of  temporary tables in application engine program?

                Dedicated - They have lock management. (continue)

                Undedicated- There is no lock management on these tables. (Abort)

6. what are the different types of variables in the Application Engine people code?
Local variable – These are available for the duration of the program in which they are declared.
Global / Component – These variables are available while the Application Engine program is running. They are saved at commits and checkpoints, So they can be used for restarts. Component variables are same as Global incase of the AE.
7. What are the Different ways pass data between the steps?
                State records – One row can be passed and can have many state records.
                Component/Global People code variables
                Temporary records – Multiple rows of data can be passed.
8. What is Prerequisite for the State record?
                i)Should be either Derived work record Or SQL Table.
                ii)Name of the record must end in AET

                iii)PROCESS_INSTANCE must be a key.
                iv)Any data types except character or numeric must not be required fields.
Note: - No People code fires on an Application Engine state record.
No Validation of translate values or Prompt tables are done.
9.What is the difference b/w %select, %bind?

                %Select—used for inserting

                %Bind----- used for retrieving.

10.How do you execute Application Engine through Push Button?
                a.CreateProcessRequest () , Schedule ()
                b.CallAppEngine.

11. What is the syntax for CallAppEngine?
CallAppEngine (applid [, state record]);
12. What are the 3 trace parameters you can pass to your psae.exe?
                - TRACE , - TOOLSTRACESQL , - TOOLSTRACEPC 
13. Which Trace option is the best place to start for general performance information?
- TRACE 384 – mostly used trace value.
14. What is the difference between a Trace value and Trace parameters?
A Trace parameter determines which type of trace is turned on.
A Trace parameter determines what type of data is recorded in your trace files (s).
15. What are the 3 common ways to pass a trace parameter and value to your program psae.exe?
Configuration manager, Process Definition, Command prompt.
16.What is the difference between the exit(0),exit(1) when we are using this function in AE?

Exit(1) causes immediate termination of  a PeopleCode program. We use this parameter to rollback database changes.

Exit(0) causes immediate termination of a PeopleCode program but it doesn’t make rollback in the database.

17. What is Set Processing? 
Set Processing uses SQL to process groups or sets of rows at one time rather than processing each row individually. With set processing, you only select those rows that meet the filtering criteria and then run the rule once again all the affected rows. (With row by row processing you following a repetitive loop that selects a row, determines if it meets a given criteria, if so, apply rule x to row Update row, commit.)

18. Advantages of Set Processing?
Improved Performance, Minimized SQL Overhead, Easy Maintenance, Leveraging the RDBMS

19. Why call section and SQL are mutually exclusive?

Both CallSection and SQL are used to perform DML operations, To avoid Locking we will use either SQL or CallSection.

20. What is the use of temporary records and state record in application engine ?

Temporary Tables: Used to store the immediate values during the processing of the AE.
Help in batch processing by creating multiple instances and there by facilitating parallel processing.
State Records: Used to pass on values between sections/steps/programs.

21.How can you integrate workflow with A.E?

A.E programs triggers business events indirectly, by passing their queries to CI. If the component has associated with workflow, A business process is  trigger when the CI saves the  page.

22.What are the PeopleCode events used for CallAppEngine function.

SavePreChange ,SavePostChange, WorkFlow , FieldChange.

23.What is the Order of Action Events?

Do When ,Do while , Do select  ,People Code  , SQL/Call Section, Log-Message, Do Until.

24.What are the prerequisites for Temporary Record ?

Process instance as  a key and  name should end with _TAO

25. What are different types Do Select ?

                Select/Fetch

                Reselect

                Restartable

Application Designer Interview Questions

1. What are Popup Menu types available?
                1.Transfer
                2.PeopleCode
                3.Separator

2. What views are available in Application Designer project workspace?
                Development and Upgrade

3. If you change the long name of translate field what object to be altered?
                Page definition

4 .Can you place Sub page into Grid? If yes How?
                yes, we can insert subpage using insert subpage. After insert subpage into main page, drag the subpage into the grid. When we save the page we are successfully able to save the page showing that we can insert a subpage into a grid.

5.Limitations of translate table?

ü  Field type should be character

ü  Minimum filed length should be 1 to 4 characters

ü  Field value should be small and static 

6. What is SET CONTROL TABLE?

Set control table default value is Business unit. It contains record groups and its default value is SetID. So it is used to access data from different Business unit.

7. Define auditing in PS? Types of auditing and explain each?

There is two types of audits available PS. Record level audit and record field level Audit.

8. Which PS object can’t be blocked by developers as a part of change control locking system?

Process Definition

9. Define Scroll? How many types of scrolls are there?

A Scroll is used to enter multiple rows and retrieve multiple row data. 

1. Nested scrolls – For each repeating data and for each entry with other set of repeating set of data is called a nested scroll. Maximum 3 nested levels are allowed. The nested scrolls share same high level keys.

2. Independent Scrolls: At each scroll level a maximum of 15 screens can be included.

10. What is mutually exclusive build execute option with the alter build option?

                Execute SQL now

11. How to view report from application designer?

                fileàreport from fileàview report

12. What is registering a component?

                We will add the component to menu and give permissions and security.

13. How to run AE program from Application Designer?

                open AEàeditàRun Program

14. Difference between search record and add search record?

                No diff b/n both the records, but add search record should be used in add mode.

15. Define component buffer and data buffer?

Component buffer consists of active component data, but data buffer contains multiple component data and other PeopleSoft applications data also.

16. What is the use of owner id in any PS object general properties?

                It is useful to restrict the PS object to the certain module.

17. What is the use of default page control in record field properties?

Specify the default appearance of a field as it appears on the page that Corresponds with the record field that you are creating.

18. How to set 3tier execution location of a component?

Component properties--àuse-à3tier execution location

19. When registering a component to menu, menu bar name is not mandatory (true/false)?

                False 

20. What is default grid occur level?

                one

21. How do you bring advanced search page before normal search page?

                Component propertiesàinternetàdefault search/look up typeàbasic or advanced.

22. What are the numbers of sub pages and secondary pages that can be created in one level?

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.

23. How to combine two projects?

                fileàmerge projectsàInsert project nameàinsert

24. Define update ids in project properties?

                These are useful, when change project option is activated.

25. The default processing mode of the component?

                Deferred Mode

26. Define Record?

                A record definition is definition of what your underlying SQL database tables will look like, and how they will process data.

27. Record types that are not going to store in to Database/types that can't be build?

                Derived/work record, dynamic view and Sub record.

28. “Approval rule set” is not PeopleSoft object? (true/false)

                False

29. How to disable the appearance of prompt button on a page?

                Page field propertiesàrecordàdisplay optionsàshow prompt button (UN check)

30.  What happened when select “build script file” option?

                Table is not going to create into database but it’s just creating Script file.

PeopleSoft Internet Architecture