PeopleSoft HRMS
18. What prcsapi.sqc written
#INCLUDE 'PRCSAPI.SQC' ! UPDATE PROCESS REQUEST API 19. Can you override the setting in SQR
===============================
Application Designer
1. What is the difference between SQL view and Query view SQL View
It is SQL table created in the database which includes fields from one or more SQL tables that are reorganized into a different sequence. This provides an alternate view of information that is stored in tables Query View
Select to define the record definition as a view that is constructed using the PeopleSoft Query tool. Before you can create the view, PeopleSoft
Application Designer prompts you to save the definition.This has nothing to do with PS query.
It makes available to the user a template by which he can construct script simply by dragging the fields and by adding the necessary criteria.
.
2. What is dynamic view
It is a record definition that can be used like a view in pages and PeopleCode, but is not actually stored as a SQL view in the database.
Instead, the system uses the view text as a base for the SQL Select that is performed at runtime. Dynamic views can provide superior performance in some situations, such as search records and in PeopleCode Selects, because they are optimized more efficiently than normal SQL views
3. What is the difference between Search key and Alt search key Key Select to identify the field as the search criteria that uniquely
identifies each row. You cannot have duplicate values for primary keys.
PeopleSoft HRMS
35 Duplicate
Order Key Select to indicate that duplicate values can occur Alternate
Search Key Select to identify the field as a key that provides an alternate path into the table data. Duplicate values are allowed in an alternate search key field. If you define a field as an alternate search key in a search record, when you bring up a page, the system prompts you to enter a key or alternate search key values.
Descending
Key Select to identify the field as descending if you want rows of data to be retrieved in reverse alphanumeric order (for example, 3, 2, and 1)
Search Key Select to make the field available on the basic and advanced search or lookup pages. A search key is valid only for keys and should be used only in search and prompt records. If you select this check box, the system automatically selects List Box Item 4. What is the use of List box item in record field properties
Select if you want the field to appear in the list box preceding a page. If a field has values in the translate table and you designate it as a list box item, the list box automatically shows the translated value instead of the code.
5. What is the length of translate value – 4
6. What is the different type of Record definition
SQL Table , SQL View , Dynamic View , Derived/Work , SubRecord , Query View, Temporary Table
7. What is the difference between Prompt table and Translate Table Prompt table :
Promt table is physical table that can be attached to certain field. Then we can select value for that field from that physical table.
Translate table :
The Translate Table is a prompt table, which is similar to an all-purpose data dictionary, to store values for fields that don't need individual prompt tables of their own. As a general rule, store field values in the Translate Table if the field meets the following criteria:
· Field type is Character.
· Field length is 1 to 4 characters.
· Field values consist of a relatively small, static set of values that are not maintained by the user.
PeopleSoft HRMS
· No other fields relate to this field.
8. What is the derived record and what is the use of it
It provides a temporary workspace to use during online page processing.
A derived or work record is not stored in the database 9. What is the concept of parent-child record
If any record has Parent record then specify parent record at record property- use tab. The keys that you establish in a parent record definition determine which keys are required in child record definitions. The child must have the same keys as the parent, plus one or more keys that uniquely identify each row.
10. What is the use of Add Search Record in component properties
This is reqd if a different search record is reqd for add actions. For example, if you selected the auto-numbering option for employee IDs (EMPLID), don‘t include EMPLID in the search record. Likewise, you might want to create special security views for add actions that limit the rows that users can add, based on specific search criteria. The system default is the standard search record if you don‘t specify an add search record
11. What is the difference between Sub page and Secondary page
Subpages are a powerful means of factoring out commonly used page
functionality in your application. Rather than duplicating the same set of page fields on two or more pages, you can create a single subpage that contains those page fields and add it to any page. This makes it much easier to maintain the functionality these page fields represent. Subpages are even more effective when used with corresponding subrecords
While a secondary page is just another page to the user at runtime, they look and behave differently than the primary pages. For example: You can view a secondary page from its primary page only. A secondary page should have OK and Cancel buttons so that the user can dismiss the page (accepting or
canceling input) and return to the primary page. To offer the user alternative buttons to dismiss the page, disable the default OK and Cancel buttons in the Page Properties dialog box.
===============================
PeopleSoft HRMS
37 1. What is the use of state record
It is used to assign variables for Application Engine program. Also sections, steps, and actions pass values to subsequent program steps through state records.
One can have any number of state records associated with a particular
Application Engine program. However, only one record can be the default state record. You can specify both work (derived) and ―physical‖ (SQL table) records to be used as state records. The only difference is that derived state records cannot have their values saved to the database at commit time, and so the values would be lost during a restart. Therefore, PeopleSoft Application Engine erases the contents of derived state records at commit time if Restart is
enabled for the current process.A PeopleSoft Application Engine state record must have a process instance defined as the first field and the only key field and the state record name must end with _AET.
2. What is the use of Temporary record
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.
3. What are the actions available in app engine in PS 8.8
SQL
Do (When, While, Select, Until)
PeopleCode
Call Section
Log Message
XSLT (enabled for Transform Only program types)
4. What is the structure of an application engine program Section , Step and Action
5. What is the difference between Do select and Do When DO When
When using a Do When action, consider the following:
The Do When action is a SELECT statement that allows subsequent
PeopleSoft HRMS
actions to be executed if any rows of data are returned.
This action is similar to a COBOL ―IF‖ statement. A Do When statement runs before any other actions in the step. If the Do When statement returns any rows, the next action is executed. If the Do When conditions are not met, the remaining actions within that step are not executed.
Your program executes a DO When action only once when the owning step executes.
The only property that you can specify for the Do When action is the ReUse Statement property, which applies to all SQL-based actions.
Do While
The Do While action is a SELECT statement that, if present, runs before subsequent actions of the step. If the Do While does not return any rows of data, the action terminates. The Do While is identical to the COBOL ―WHILE‖
function. In other words, the subsequent actions within the step are executed in a loop as long as at least one row is returned by the SELECT statement for the DO While action. In short, if the Do While does not return any rows, the step is complete.
The only property that you can specify for the Do While action is the ReUse Statement property, which applies to all SQL-based actions.
Do Select
The Do Select action is a SELECT statement that executes subsequent actions once for every row of data that the Do Select returns. For instance, a Do Select can execute a SQL statement for each row returned from the SELECT
statement. The subsequent actions within the step are executed in a loop based on the results of the SELECT statement. The type of the Do Select determines the specific looping rules.
6. Can you use Call App Engine in App engine Program Peoplecode
You can use the CallAppEngine function in a Peoplesoft Application Engine program, either directly (in a PeopleCode action) or indirectly (using a
Component Interface). This functionality must be used carefully, and you should only do this once you have a clear understanding of the following rules and restrictions.
Dedicated cursors are not supported inside a "nested application engine instance" (meaning an application engine program invoked using
CallAppEngine from within another application engine program). If a
PeopleSoft HRMS
39
As in any other type of PeopleCode event, no commits are performed within the called application engine program. This is an important consideration. If a batch application engine program called another program using CallAppEngine, and that child program updated many rows of data, the unit-of-work might become too large, resulting in contention with other processes. A batch application engine program should invoke such child programs using a Call Section action, not CallAppEngine.
Temp tables are not shared between a batch application engine program and child program invoked using CallAppEngine. Instead, the child
program is assigned an "online" temporary table instance, which is used for all temp tables in that program. In addition, if that child program invokes another program using CallAppEngine, that grandchild shares the online temp instance with the caller. In other words, only one online temp instance is allocated to a process at any one time, no matter how many nested CallAppEngine's there might be.
The lock on an online temp instance persists until the next commit. If the processing time of the called program is significant (greater than a few seconds), this would be unacceptable. As a general rule, application engine programs that make use of temp tables and have a significant processing time should be called from other application engine programs using a Call Section action, not CallAppEngine.
7. How do you Schedule the app Engine
8. what is the extension of state record.
_AET
9. Different types of Application engine
Types - Standard, Upgrade, DEAMON, Transform, Import Only.
===============================
Peoplecode
1. give the sequence in which the events are fired in application processor flow
Record.Field Edit ---> Component.Record.Field Edit --->
Record.Field Change ---> Component.Record.Field Change --->
PeopleSoft HRMS
2. What is the difference between Rowset and Standalone rowset Rowset : A rowset object is a data structure used to describe hierarchical data. It is made up of a collection of rows. A component scroll is a rowset. You can also have a level 0 rowset
A level 0 rowset from a component buffer only contains one row, that is, the keys that the user specifies to initiate that component
One can use simple getrowset function.
Standalone Rowset : Standalone Rowsets are like regular Rowsets except they aren't associated with a component or page. Use them when you need to work on data that isn't associated with a component or page buffer.
Standalone rowsets are not connected to the Page Processor, so there are no database updates when they are manipulated. Delete and insert activity on these types of rowsets aren't automatically applied at save time.
Use Createrowset to create standalone rowset
&MYRS = CreateRowset(RECORD.SOMEREC);
3. How many levels we can use on one page
Excluding level 0, there are 3 more levels (level 1, level 2, level3) that can be used on page .
4. What is component buffer
Whatever data is fetched from database while populating component will kept in temporary memory of application server i.e. called as
component buffer.
the area in memory that stores data temporarily for the currently active component.
The Component Buffer consists of rows of buffer fields that hold data for the various records associated with page controls, including primary scroll records, related display records, derived/work records, and translate table records. PeopleCode can reference buffer fields associated with page controls and other buffer fields from the primary scroll record and related display records.
PeopleSoft HRMS
41 Workflow PeopleCode executes immediately after SavePreChange and before the database update that precedes SavePostChange. The main purpose of the Workflow event is to segregate PeopleCode related to Workflow from the rest of the application‘s PeopleCode. Only PeopleCode related to Workflow (such as TriggerBusinessEvent) should be in Workflow programs. Your program should deal with Workflow only after any SavePreChange processing is complete.
6. While creating the workflow what are the three objects used •Rules:
Rules are the company‘s business practices which can be captured in software.
Rules determine what activities are required to process business data
•Roles
•Roles describe how people fit into the Workflow process. A role is a class of users who perform the same type of work such as managers etc.
•Roles direct the work to classes of people rather than to individuals. Identifying roles instead of individual users makes the workflow more flexible and easier to maintain.
•Roles remain stable even if individuals change jobs.
•Routings
•Routings connect the activities in the workflow. They are the system‘s means of moving information from one place to another, from one step to the next.
•The network of routings creates a business process from what used to be isolated activities. They get the right information to the right people at the right time, enabling users to work together to accomplish the company‘s goals.
Routings can take the form of an e-mail message or a worklist entry 7. What is the use of sub record
A subrecord enables you to add a group of fields that are commonly used in multiple record definitions
It is used as Reusable component
8. What is the difference between Save prechange and save postchange event
SAVEEDIT:
The SaveEdit event fires whenever the end-user attempts to save the component. You can use SaveEdit PeopleCode to validate the
consistency of data in component fields. Whenever a validation involves more than one component field, you should use SaveEdit PeopleCode. If a validation involves only one page field, you should use FieldEdit PeopleCode.
An Error statement in SaveEdit PeopleCode displays a message and redisplays the component without saving data. A Warning enables the end-user to click
PeopleSoft HRMS
OK and save the data, or click Cancel and return to the component without saving.
SAVEPRECHANGE :
The SavePreChange event fires after SaveEdit completes without errors. SavePreChange PeopleCode provides one final opportunity to manipulate data before the system updates the database.
SAVEPOSTCHANGE :
After the Component Processor updates the database, it fires the SavePostChange event. You can use SavePostChange PeopleCode to update tables not in your component using the SQLExec built-in function.
An Error or Warning in SavePostChange PeopleCode causes a runtime error, forcing the end-user to cancel the component without saving changes. Avoid Errors and Warnings in this event.
9. What is the difference between prebuild and postbuild event PREBUILD :
The PreBuild event fires before the rest of the component build events. This event is often used to hide or unhide pages. It’s also used to set component variables.
Note. If a PreBuild PeopleCode program issues an error or warning, the end-user is returned to the search page. If there is no search page, that is, the search record has no keys, a blank component page displays.
The PreBuild event is also used to validate data entered in the search dialog, after a prompt list is displayed. For example, after the end-user selects key values on the search, the PreBuild PeopleCode program fires, which catches the error condition and issues an error message. The end-user receives and acknowledges an error message. The component is cancelled (because of the error) and the end-user is returned to the Search dialog box. PreBuild
PeopleCode is only associated with components.
POSTBUILD:
The PostBuild event fires after all the other component build events have fired. This event is often used to hide or unhide pages. It‘s also used to set component variables.
PostBuild PeopleCode is only associated with components.
10. What is page activate event does
The page event set consists of a single event, the Activate event, which
PeopleSoft HRMS
43 11. Which event fire first Record field or Component record
Field
Record field
12. Name of the objects used in people code
The various objects used in peoplecode are SQL, Rowsets, Records, Messages, Arrays
13. How do you open the secondary page using the peoplecode Using DoModal Function. The syntax is specified below :
&RC= DoModal(Panel.PCS_PRJ_RES_PO_SBP, "Purchase Order Details", - 1, - 1);
where -1, -1 stands for center alignment.
14. What is the use of effective data
15. How many rows SQLEXEC return One.
16. What does the Setcursorpos do
SetCursorPos places the focus in a specific field anywhere in the current component.
17. Have u debug the Peoplecode?? Explain it
The PeopleCode Debugger is an integrated part of PeopleSoft Application Designer. The interface to the Debugger has a visual indicator of breakpoints, an arrow indicating the current line and the ability to step through code. You can inspect the value of a variable by ‗hovering‘ your cursor over it and reading the pop-up bubble help. The Debugger also provides variable inspection
windows for Globals, Locals, Function Parameters, and Component scoped variables. It also enables PeopleCode objects to be "expanded", so you can inspect their component parts.
Also the developer can save the trace file that is generated during execution provided the debugging parameters are set rightly.
18. What is the difference between Field change and Fieldedit event and which fire first
Field Edit:
PeopleSoft HRMS
FieldEdit PeopleCode is used to validate the contents of a field, supplementing the standard system edits. If the data does not pass the validation, the
PeopleCode program should display a message using the Error statement, which redisplays the page, displaying an error message and turning the field red