Inception : Copied from a Donald Duck comics !!!!

Lo !!!!
Dang hollywood dang....!!!

"Inception"... the trillian-aillion dollar blockbuster is inspired from the following Donal duck comic available in Public Domain..... [ Click here ]



Cool doods...

Oh yes... anyways "The Dark Knight" was inspired/ legally -inspired he ... he...
from Batman's comic "The Long Halloween"......

Chalo... koi na...

Install Internet Explorer on Fedora

Yaa,
just to get rid of those hyperlinks which behave as jpgs :(

Perform these commands as root:

yum -y install wine*
yum -y install cabextract
yum -y install wget*
yum -y install tar*

After successful install of the packages,
Exit from root

Perform the following steps as a normal user:

cd /tmp
wget http://www.tatanka.com.br/ies4linux/downloads/ies4linux-latest.tar.gz
tar -xvfz ies4linux-latest.tar.gz
cd ies4linux-*

./ies4linux # for GUI wizard , which he.. he.. may crash on Fedora

./ies4linux --no-flash --no-desktop-icon --no-menu-icon --no-gui # CLI more stable on Fedora

./ies4linux --no-flash --no-desktop-icon --no-menu-icon --no-gui --beta-install-ie7 # Same as above but with IE7 support (beta)

Peoplesoft HRMS

Core payroll tables are the tables that are required to implement the Payroll for North America application,
including organization tables, compensation and earnings tables, deduction tables, pay calendar tables,
garnishment tables, vendor tables, general ledger interface, tax tables, retroactive processing, and tip
allocation.

Employee pay data includes personal data, job data, benefits data, federal, state/provincial, and local tax
information, general and benefit deductions, additional pay, garnishments, savings bonds, and direct deposits.

The basic steps of payroll processing are: create paysheets, pay calculation, pay confirmation, and generate
checks and direct deposits. You can employ audit reports and data review pages to verify and correct the
results of each step before moving on. You can also review and adjust employee balances.

Enterprise One General Ledger to transfer the expenses and liabilities incurred from a pay run to the General Ledger application.

PeopleSoft Enterprise Payables to transmit tax data to the Payables application for
automatic payment to tax authorities.

integration with Payables to transmit employee and employer deductions such as garnishments and
benefit deductions to the Payables application for automatic payment to third parties.

The Load Paysheet Transactions process loads transactions from sources other than PeopleSoft
applications to paysheets for processing. Such transactions require a paysheet update source of Other Sources.

PeopleSoft Setup Manager enables you to generate a list of setup tasks.The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables

Payroll for North America also provides component interfaces to help you load data from your existing
system into Payroll for North America tables.

The components that have component interfaces:
`
PAY_RUN_TABLE - Setting Up Pay Calendars - Creating Pay Run IDs.
GENL_DEDUCTION_TBL - Defining General Deductions
GDED_COM_TABLE - Defining Deductions - Assigning General Deductions to a Company
TAX_LOCATION_TBL - Setting Up CompanyTax Tables for North America.
COMP_LOCAL_TAX_TBL - Setting Up CompanyTax Tables for North America.
SPCL_EARNS_TABLE - Establishing Special Accumulator Codes
TERM_ACTN_REASON - Setting Up the Payroll Process, Defining the Final Check Process
TERM_PGM_TABLE - Setting Up the
FLSA_CALENDAR - Creating Pay Calendars and FLSA Calendars.
TAX_TYPE_TABLE - Setting Up Tax Types for PeopleSoft Enterprise Payables Integration.
CO_UI_RPTCD_TABLE - Setting Up Payroll Tax Tables, (USA) Establishing UI Report Codes
TREATY_NR_ALIEN_TA - Understanding TaxTreaties.
US_SOC_TABLE - Establishing Standard Occupational Classifications.
CAN_WCB_CU_RATES - DefiningCanadian WCB AssessmentReporting,
RETROPAY_PGM_TBL - Setting Up RetroPay Processing
TIPS_ESTAB_TBL - Setting Up the Payroll System for Tip Allocation




Tax tables store tax information that the system requires to calculate and report taxes.

The pages for Federal/State Tax, Taxable Gross Definition, and Canadian Tax tables reference more
than one table.

These are the PeopleSoft-maintained tables for U.S. employers:
• Federal/State Tax and Local Tax tables,(STATE_TAX_TABLE). which contain rates and other constants
• State and Local Tax Reciprocity tables
• Taxable Gross Definition table, which identifies differences between states or localities and the federal
government in the definition of taxable wages.
PeopleSoft delivers sample taxable gross component IDs for Group Term Life (GTL), Section 125 (125),
domestic partner benefits (DPB), Health Savings Accounts (HSA), and Health Savings Account employer
contributions (HSR).
• SWT Marital Status table, which defines the valid tax marital status codes for each state.

U.S. employers must set up and maintain the following tables:
• Tax Location table, which contains the work locations for which you process payroll and taxes.
• Company State Tax and Company Local Tax tables, which store tax identification numbers,
unemployment and disability experience rates, and general ledger codes for the states and localities for
which your company collects and pays taxes.
• Tax Reporting Parameters table, which controls the execution of many of your quarterly and annual tax
reports and specifies data needed for magnetic media filing.


Pennsylvania Local Services Tax ?

On the Federal/State Tax Table - Additional Rates page, the Tax Class LS Tax represents the Local Services
Tax (LST) for Pennsylvania employees. The total LST paid by any individual in a calendar year is limited to
52 USD, regardless of the number of political subdivisions in which the individual works during the year.
Certain LST processing requirements relate to the combined LST rate for municipalities and school districts.
These entries have the letter "C" in position 8 of the Locality Code.For example, the locality code O430212C

It is deducted as a lump sum from the employee's first paycheck of the year in the taxing jurisdiction. If the LST is levied at a combined rate exceeding 10 USD annually, the tax is divided equally across the number of pay periods in the employee's pay frequency. When calculating prorated pay period deductions, employers are required to round down to the nearest cent.

The state-level Pennsylvania LST Memo tax record keeps track of how much Pennsylvania LST an employee
has paid for the year.

If you need to set up Local Tax Data records for multiple LS Tax jurisdictions for an employee in order to
clear Payroll Error 92 ("Local Tax Not Found: The local tax record for the locality cannot be found for this
employee."), then you can limit the employee to one active LST by setting all but one of the employee's Local
Tax Data records for LST to the Special Tax Status of "Do Not Maintain Taxable Gross and Do Not Withhold
Tax".

Anees Bazmee to remake Telegu hit "Ready" with Salman Khan [:)]

Story:

A light hearted movie, the story is about Chandrashekar who is more dearly known as Chandu (Ram) who is a clever guy with the right looks and has enough courage in him to take up any challenge. Chandu also has a kind heart and is the first one to come up with solutions for the problems of his friends and dear ones. In this process, he helps his cousin Lakshmi (Tamannah) elope with her NRI lover (Navdeep) right on her wedding day. This causes Chandu to face the wrath of his family which comprises of the head Raghupathi (Nasser), father Raghava (Tanikella), uncle Rajaram (Chandramohan) along with their wives and kids. He comes out of the house and his various attempts to get back goes in vain.

Meanwhile, in an effort to help his friend's love matter, Chandu goes along with his group of friends (Srinivas Reddy, Suman Shetty and others) and kidnaps Pooja (Genelia) right from the wedding venue. The group put their tongues in cheek when they realize that they went to the wrong venue and got the wrong bride. However, Pooja from her end is really happy since she is not interested in the wedding. Chandu falls for Pooja at the first sight and decides to win her heart at any cost. He takes her to wherever she wants to go and in this process chases happen, scenes happen and slowly romance also blossoms between the two but they don't express it to each other. In this escape situation, Chandu hatches a plan and makes Pooja land at his home and eventually he also gets inside with some story.

The romance gets stronger between both and this is realized even by the family members. Just when everything looks smooth, Pooja's uncle Peddi Naidu (Kota) locates her and takes her along with him. Meanwhile, his rival brother Chitti Naidu (Jayaprakash Reddy) is also looking for Pooja since both brothers want to get her married to their sons respectively. Chandu arrives in the scene using his intelligence again and through the channel of McDonald Murthy (Brahmanandam) who happens to be the auditor for both brothers he gains entry. With a cleverly staged plot, he manages to reunite both brothers and now he has to ensure he gets married to Pooja. How does he do that? Will the Naidu brothers discover his real identity? All this forms the rest of the story.

Extreme Peoplesoft !!

http://gasparotto.blogspot.com/

Peoplesoft - more

1. What is PIA and what are its components?
It is n-tier architecture. We have client, web server, application server and Database server. We have jolt and tuxedo. We have WSL, WSH, JSL, JSH, QUEUES and services.
In database server we have system tables, peopletools tables and application tables.

2. Differentiate Field edit and Save edit?
In Field edit for each field change, a transition to the application server to the database is taken place. In Save edit for all the fields, only one transition to the application server to the Database is taken place.

3. What are think time functions?
Think-time functions suspend processing either until the user has taken some action (such as clicking a button in a message box), or until an external process has run to completion.

4. In which events error & warning are used most extensively.
Field edit, Save edit, Search save, row delete, row insert.

5. Is there any way by which you can find out whether the user is in Add mode or Update mode?
%mode---returns A---for Add mode. Returns U –for Update mode

6. What is the purpose of the SQLEXEC function? What are its benefits and draw backs?
SQLEXEC is used to execute the sql statements (select, insert,update,delete).
We can get only one row at a time.

7. How is the searchinit event most often used by people soft application?
A) Searchinit fires before the search dialogue page is displayed to the end user.For this reason searchinit is often used to enhance roll level security by inserting and graying out certain values to the search dialogue page.

8. What are the options for using SQL in people code?
a) Sqlexec
b) Record class methods (selectbykey, delete, insert, update)
c) Using sql class, its properties and methods.

9. What is the difference between component buffer and data buffer?
Component buffer contains all the data of the active component.
Data buffer contains the data other than the data in the component buffer (Data of other records)

10. What databuffer classes are available in people code?
Rowset, Row, Record, Field, Array, File, Sql, chart, grid and so on.

11. When we select a component what events will be fired?
If default mode for component is search mode: only searchinit will fired .If default mode for component is new mode :field default, field formula, rowinit, searchinit.

12. What are different variables in people code and their Scope?
System variables and User defined variables.
Scope --- Global, Component, Local.

13. What is default processing?
In default processing, any blank fields in the component are set to their default value. You can specify the default value either in the Record Field Properties, or in FieldDefault PeopleCode

14. What is difference between field default and Row init?
Field default specifies only the default value for a field when we are in Add mode.
Row init fires only when a row of data coming from database to component buffer.

15. What is difference between saveprechange and savepostchange? Which function directly interacts with the database?
Saveprechange---last event that executes before updating the data from component buffer to the database.
Savepostchange –fires after the updation of data in the database.
SQLEXEC --- function directly interacts with the database.

16. What is Getlevel 0()? What is the use of %subrec and %selectall functions?
Getlevel0 ()---used the get the rowset of the level0.
%subrec--is used only in Dynamic View SQL where it expands to the columns of a subrecord:
%selectall--%SelectAll is shorthand for selecting all fields in the specified record, wrapping date/time fields with %DateOut, %TimeOut.

17. What is an array in people code? What is maximum dimension of an array? Which function inserts values into an array? What is “pop”?
An array is a collection of data storage locations, each of which holds the same type of data.
The maximum depth of a PeopleCode array is 15 dimensions.
Push and unshift are the functions of the array used to add the elements into the array one from the end of the array and one from the beginning.
Pop is a function of array used to select and delete an element from the end of the array.

18. What is difference between Getrowset and Createrowset in people code?
Getrowset –is used to get rowset for a record in the component buffer.
Createrowset—is used to create rowset for a record which in database, and is also called a Standalone rowset

19. Can you save the component programmatically?
Using Dosave and Dosavenow functions.

20. What is differed processing and its advantages?
Postpones some user actions to reduce the number of trips to the database so that increases the performance (in system edits, field edit, and field change).
Advantages:
1) Reduces the network traffic.
2) Increases the performance.
33. Write the syntax to access third level record field using object oriented peoplecode?
&fld=Getlevel0 ()(1).GetRowset(Record..GetRow(1),
GetRowset (Record.).GetRow(1),
GetRowset (Record.).GetRow(1),
GetRecord (Record.).GetFieild(Field.))

21. What are the built-functions used to control translate values dynamically?
Adddropdownitem ()
Deletedropdownitem ()

22. How to populate data into grid in online?
&Rs.Select or Scrollselect ().
SECURITY
Before accessing a people soft application what levels of security must be passed through.
a) Field level security
b) Row level security
c) Maintain security
d) Definition security
e) Portal security.

23.What is the use of primary permission list in user profile?
Primary permission list is used for mass change and definition security purposes.
How to authorize the user to run a process or report?
To authorize a user to run a process, the process group, which contains the process or report, should be added to the permission list of that user.

24.How to give access to the records that are to be used in a query?
To give access to the records that are to be used in query, we have create a new query security tree and add the records which we want to give the access and then assign a access group to the tree. After that we have to add that query tree and query access group to the permission list.

25.What are the rules used by the system to determine whether a user is authorized to update an object?
The user should have the permission to update the object. This is given by the Definition security. The group, which holds the object, should be added to the permission list of the user in update mode.
What are the different ways we can set up the portal security to access component in portal?
1) Structure & content
2) Menu import
3) Register component

Business Object

Why do you need to create multiple repositories?
Ans: If the organization is globally spread out and the users access the repository from different locations, then the physical distance can delay the response to
the query of the user. To avoid this organizations create multiple repositories across the world, and all the repositories are synchronized on regular basis.

What is the Business ObjectsMain.key?
Ans: • Business ObjectsMain.key contains the address of the repository security domain.
• All the users can communicate with other domains in the Repository.
• It is created at the same time as the Security domain.
• BoMain.key defines connection to a repository
• The physical location of the file can be created either in:
ShData folder : default shared folder on the network
LocData folder : for each user to have a local copy.

What is Scope Management?
Ans: Scope management (Tools?Options?Security Policy) is a SUPERVISOR option, which allows you to control the extent of the access that all supervisors are granted to users and user groups.
Standard Mode: This setting provides simple supervisor functionality (i.e., no restricted or extended powers). Supervisors will have access only to the users within their own groups.
Secured Mode (Default Setting): It prevents supervisors from delegating to other users the resources that do not belong to them.
Extended Mode: allows group supervisor’s access to users outside their own group(s) so that they can add or remove users to their own groups.

What are the rules for assigning privileges to users?
• A user is always assigned to at least one group; the first group is always the root group.
• A user can belong to one or more groups.
• Every user, or every user group, inherits the rights of its direct ascendants.
• Within a group, all users have the default privileges of the group.
• Within a group, a user may be entitled to special privileges in addition to those arising merely from his or her adherence to the group.
• The rights assigned to descendants have precedence over those assigned to ascendants.
• Every group is unique within the hierarchy.

What is the difference between removing and deleting a user?
Ans: When you remove a user from a group, the user is not removed from other groups to which he or she was assigned. If the user belongs to only one group, then you must delete the user. Deleting a user in SUPERVISOR will permanently delete the user from the database.

What is Script?
Ans: A script is a set of commands, written in VBA, that is used to automate tasks. Scripts are created and executed by end users from BUSINESSOBJECTS. End users can store scripts as files with an .spt extension, or can export them to the document domain of the repository. Scripts are automatically assigned to the root group.

What is a Channel?
Ans: A channel is a Web site that uses “push” technology, also known as Webcasting, to keep subscribers abreast of up-to-date information.

What is a Category?
Ans: A category is a keyword or phrase end-users can assign to documents when they send them to users, groups, or BROADCAST AGENT.

Ram Madhvani's Hippo...

Fight hunger, fight evil: Parle Agro Hippo's maiden TV campaign



Parle Agro’s snack product 'Hippo', which had a gradual roll-out across the country over the last few months, is now ready with its first mass media advertising campaign.

Till now, the brand's marketing strategy has been focused on distribution, retail visibility and consumer sampling.

Having completed a nationwide rollout, Hippo has come up with its first television commercial that takes a fresh look at the role snacks can play in society. Titled ‘Fight Hunger’, the TVC has been created and executed by Creativeland Asia and directed by Ram Madhvani of Equinox Films.

View TVC here



Sajan Raj Kurup, chief creative officer, Creativeland Asia says, "That an empty stomach is a devil’s workshop, is universally understood. The insight became a lot more relevant on probing deep into the Indian culture. Food is a fantastic way of calming people down. If you got grumpy or angry at home, you would often hear your mom say, ‘Go eat something’ to calm you down. The commercial is a beautiful marriage of this insight and wishful thinking deep inside all of us that wants to make this world a place free of all evils. It is manifested in a light-hearted satire on the society and the evil that exists within it."

Kurup says that the objective was to differentiate Hippo from the other snack players. "We succeeded in doing that with the name and packaging. It was imperative we carried it into its communication. So the challenge was not just in creating noise, it was also about creating a noise with a soul to it - something that would be relevant both for the brand and the society."

The TVC is seen through the hippo's (brand mascot) view as he goes to every scene of crime, war or conflict, offering each of the involved parties some Hippo chips. Everybody happily obliges and takes a bite, and this is shown to resolve all issues. As the series continues, the voiceover goes on to say that the root cause of all evil in the world is hunger. "So please, don’t be hungry," it appeals. The song ‘Pyaar baat te chalo’ (Keep spreading the love) which doubles up as the background music, plays a pivotal role in helping the TVC communicate its message.

Credits

Client: Parle Agro
Creative agency: Creativeland Asia
Chief creative officer: Sajan Raj Kurup
Executive creative director: Vikram Gaikwad
Creative director: Anu Joseph
Copywriters: Sajan Raj Kurup, Anu Joseph, Huzefa Kapadia
Client servicing: Jay Gala
Production house: Equinox Films
Director: Ram Madhvani
Post-production studio: Pixion
Media agency: OMD

Sourced :

http://www.campaignindia.in/news/2010/02/01/fight-hunger-fight-evil-parle-agro-hippo-s-maiden-tv-campaign

Peoplesoft and SQR kickboxing

1. The main attributes of a Component Interface (CI) are?
Keys, Properties & Collections, Methods and Name
2. Which one of the following are standard properties when a Component Interface (CI) is created?
GetHistoryItems

3. With reference to the Component Interface Tester which of the following is NOT TRUE?
GetExisting option is equivalent to opening a record in Update/Display Mode only

4. Which of the following are TRUE when a Component Interface (CI) is created on component that has Add action enabled?
Get keys, Create keys and Find keys gets created automatically. The Create method is created along with the other Standard methods for the CI

5. Which of the following is NOT TRUE in Component Interface (CI) Architecture?
A component interface can be mapped to multiple PeopleSoft components

7. The following are 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

8. Will Tuxedo continue to be used in a PeopleSoft/WebSphere or PeopleSoft/WebLogic environment?
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.

9. Can a PeopleTools 8.4 and a PeopleTools 8.1x database run on the same machine?
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 PeopleTools 8.1x implementation.

10. Can a PeopleTools 8.4 and a PeopleTools 8.1xapplication server run on the same machine?
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.

11. How does the PeopleSoft Enterprise Portal work with 8.1x and 8.4 applications?
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 available in a forthcoming white paper, which will be available on Customer Connection. In general, the recommendation is to use the PeopleSoft Enterprise Portal 8.4with 8.1x and 8.4 applications, rather than an older version.

12. For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
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 WebSphere servlet engines.

13. IBM How should Web Application Servers be used with PeopleTools 8.1x and PeopleTools 8.4?
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 IBM WebSphere are bundled. Apache with Jserv is no longer a supported web application server combination. Customers can choose which web application server to run during installation time. In a mixed PeopleTools 8.1x and 8.4 environment, each PeopleTools installation should have their own chain of web application server and application server, PeopleSoft Proprietary and Confidential Page 5and these can be on the same machine. For example, a PeopleTools 8.1xinstallation using Apache and Jserv could reside on the same machine as a PeopleTools 8.4 installation using IBM WebSphere. Care should be taken to ensure that unique port numbers are assigned to each server chain.

14. Why did PeopleSoft bundle IBM WebSphere Advanced Single Server Edition rather than Advanced Edition?
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 the configuration and runtime information to support very large farm of WebSphere servers. However, it is one more database to install, administer and maintain. The AEs version does not use the database and uses file based configuration in a way that is similar to BEA WebLogic. PeopleSoft and IBM WebSphere architects determined that AEs version would satisfy the deployment requirements of PeopleSoft customers and would make it easy for owning and administering PeopleSoft Applications based on WebSphere.

15. Will the PeopleSoft Internet Architecture, now that it embeds BEA WebLogic and IBM WebSphere, work with my other corporate web servers and tools?
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 other web applications will not be compromised by this decision. How is this accomplished

16. Is BEA WebLogic the same thing as the web server that was previously on the Tuxedo CD?
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 mechanism for launching the graphical Tuxedo administration console if the Tuxedo administrator didn't already have a web server in place. It was never intended for large-scale, production website use ? only for a system administrator or two.

17. Are disconnected mobile applications supported in PeopleTools 8.1x?
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 for PeopleTools 8.4.

18. Is WebSphere certified on PeopleTools 8.1x?
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 can be found in the whitepaper The IBM WebSphere 8.1x Early Adopter Program. Are there additional license requirements for IBM WebSphere

19. Are there advantages or disadvantages to using BEA WebLogic over IBM WebSphere or vice versa?
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.

20. Is web server load balancing supported with PeopleTools 8.4?
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 clustering with WebLogic, WebSphere and other web servers.

21. Both BEA WebLogic and IBM WebSphere have the ability to plug into many different web servers. Does PeopleSoft support the web servers that they plug into?
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 to support IIS. We have no reason to believe that there will be any issues with other web servers that WebLogic or WebSphere are able to work with through their plug-in architecture, but PeopleSoft GSC will not support these other web servers with PeopleTools 8.4

22. Does Application Messaging work between 8.1xand 8.4 applications?
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 PeopleTools 8.15, can communicate with Financials 8.4applications, which are based on PeopleTools 8.4, using Application Messaging. If specific issues materialize relating to the Application Messages published by certain applications, these new messages will be made available to customers.

23. Why is PeopleSoft no longer supporting Apache Jserv?
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 official releases. v Our customers have exhibited a desire to use commercial products for mission-critical enterprise web application servers rather than open source solutions. Therefore, moving to support Tomcat is not seen as a reasonable solution. v Apache can still be used as an HTTP server with BEA WebLogic .

24. What HTTP servers and Java servlet engine combinations are supported with PeopleTools 8.4?
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/index.asp

25. WorkItem is available in?
WorkList Record

26. Where are workflow work items found ?
Worklist

27. In which platform does Crystal and Psnvision works?
Windows (Correct)

28. You want to update your password and enter a hint for forgotten password. What would you access?
User Profile

29. Question based on changing prompt table, what happens when changing from NO EDIT TO EDIT option?
user can type only prompt table values and the default values gets populated from the database.

30. Customization done in Dev DB, Which tool i will use to move it to Prod DB?
Use App Designer -> Copy DB

31. 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 the database and decide that that the data is not required any more. You ask the DBA to delete the data in the table. Next day you get a call from an irritated user who says that a daily process that took only 1 minute to run is taking about 2 hours today. You look into his process and find that it uses PS_ABC_TAO as a temporary table. What would you suggest the DBA to do ?
Update statistics on the table

32. (Some scenario) Question relating DBA Purging Temporary Table?
Update Statistics

33. How many Message nodes are possible for a database.?
Unlimited

34. How will you get a single output by combining two or more queries?
UNION

35. What BEA product is used for DB transaction in PS?
Tuxedo

36. Which one of the following Data Types is NOT supported by the PeopleCode programming environment?
TIMESTAMP

37. What hyperlinks available in PeopleBooks? Some options with different hyperlinks not available in peoplebooks, select the correct one?
Study all hyperlinks in the first page of people books.

38. The example below demonstrates the use of SQR flags in the configuration manager directories folder: -F C:PSHrmsSqrWhat do the above SQR flags signify to the SQR Report Writer upon execution?
Specifies the output path

39. When a business requirement in Fit/Gap Analysis does not meet by PeopleSoft then?
Some options:
1. Customize PS application (Yes)
2. Buy third party software (Yes)
3. Call PS Development Center for Enhancement (Yes)

40. What are the status available in PeopleSoft Domain Status Menu?
Server, Client and Queue Status

41. Which of the following are part of an AE program ?
Section ,Step and Action

42. Which of the following fires after the database is updated?
SavePostChange

43. What event gets fired after DB Update?
SavePostChange

44. For downloading patches and fixes , you have gone to the customer connection and looking under 8 april, 2000 and see Report IDS like R-CCHEN-VP14JM. What does R stand for ?
Released

45. In which one of the following views would you see the fields, criteria, and other details associated with the current query?
Query view

46. PeopleSoft tracks object changes using a system table. Which PeopleTools System table is used to track object changes?
PSRELEASE

47. 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 identifies the naming convention PeopleSoft uses for system tables?
PSRECORDNAME

48. Which process is used for running AE programs which are to be run at a frequency of less than a day ?
PSDAEMON

49. you can specifically trace the activity of the PSAPPSRV server process by setting the?
PSAPPSRV.tracesql

50. Which of the following is correct in order to start the Process Scheduler Server from the command line using psadmin.?
Psadmin ?p start ?d

51. In the following url http://localhost/Peoplesoft/EMPLOYEE/PSFT_HR/c/PROCESS_SCHEDULER.PRCSTYPEDEFN.GBLwhich one is the component definition?
PRCSTYPEDEFN.GBL

52. I have created a Menu and a Page and given user access to that page, which of the tables gets affected on this (Scenario)?
PeopleTools Tables

53. You are a PeopleSoft Partner and wish to get information on database performance benchmark ( or something like this) Where would you look for the info ?
PeopleSoft Knowledge base SYSAUDIT finds for Orphaned Records

54. Which RDBMS uses Tablespace?
Oracle, DB2, Other Options: SQL Server, Informix, Sybase

55. Changing Prompt Table with NO Edit to Prompt Table with Edit?
Only selection of existing data is possible

56. Which command is valid in both bootstrap and regular mode when operating the data mover?
GRANT_USER

57. PeopleCode events pertaining to Record Field:?
FieldEdit, SaveEdit and RowDelete

58. Which of the following are Record field events ?
FieldChangeSearchSave and SavePreChange

59. Which of the following commands can be run in Bootstrap mode?
ENCRYPT_PASSWORD

60. What commands are valid in BS mode?
ENCRYPT_PASSWORD

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

62. Which of the above record definitions is NOT stored on the database and is therefore NOT required to be built?
Derived/Work Record

63. You have downloaded an Application fix as a project from the customer connection. Where would you upgrade it to ?
Demo

64. PS Query definition is stored on which server?
DB Server

65. How do you login into BS mode?
DB Access Id

66. If you want to log into DataMover in Bootstrap mode, you would login as..?
Database superuser

67. What is added as new option in Build apart from Create Tables, Indexes, Views?
Create Trigger

68. Where will you configure for failover of Application Server (Scenario)?
Configuration.properties

69. Which one of the following is a transaction control statement ?
Commit

70. What Record Changes does not affect Database?
Change in List box in Record Field properties (correct)

71. Which one of the following steps is NOT part of performing an upgrade?
Apply all outstanding patches, prior to upgrade

72. Update and Fixes: R-* files refers to?
Application Updates and Fixes

73. How do you set up table-sharing in PeopleTools applications?
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?

74. What is the default Crystal Report that PeopleSoft Query tool creates?
ACTQRY.RPT

75. (Some scenario) Find which is not part of AE Program, Options would be?
Action,Section,Step,Event

76. Which of the following are true with respect to validate signon with database option enabled in psadmin.?
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.

77. Which of the Following are true for force Shutdown In PeopleSoft Domain Shutdown menu?
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

78. After logging into customer connection, you wish to search for fixes/patches. What are the search criteria's available ?
1. Report ID
2. Date / time
3. Release

79. What are the Search Keys you use to find Patches and Fixes?
1. Release
2. Updated date time
3. Report Id

80. Which one of the following tree types is NOT supported in the PeopleSoft tree manager?
1. Query trees
2. Combination trees

81. Which Web Services is only used as a Proxy Server?
1. MS IIS
2. Apache

82. In PeopleCode Debugger what are the valid values?
1. Go
2. Step Over
3. View Variable Value

83. Select the components which form the part of Integration Broker?
1. File Layout
2. CI
3. app. Messaging

84. what are the views available in App. Designer project workspace (multiple answer)?
1. Development
2. Upgrade

85. What are Menu types available?
1. Component
2. PeopleCode
3. Separator

86. Database Connectivity Drivers should be installed in the following System?
1. Client Workstation in two tier mode (Yes)
2. App Server (Yes)
3. Batch Server (Yes)
4. Data Mover (Yes)

87. Where do you need to install connectivity software?
1. batch server
2. App server
3. two tier client

88. What are the People Tools available for Integration Broker?
1. Appl. Messaging
2. Component Interface
3. File Layout

89. A Customer wants to use a new Image in HRMS, where it is stored?
DB Server

90. Can you access pia from mac OS?
Yes

91. Which language technology is used in app messaging?
XML

92. Which one of the following PeopleCode debugging tools automatically converts values of any data type other than object into string values for viewing during debugging?
WinMessage

93. PIA screens and recognize it?
Where are the work items presentWorkilist

94. Where do u set the web server cache?
webserver configuration.properties file

95. 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 compare the current versions of these COBOL programs with the versions delivered with the new PeopleSoft application release. Which would be the fastest method of comparing these different versions?
Use non-PeopleSoft comparison tools. 5.

96. True or False. A business Process be used as a Navigator Home page ?
true

97. True or False. The physical, dedicated tables are locked at the time the Application Engine program is loaded into memory?
True

98. True or False. State Record can be Dynamic Record?
True

99. True or False. In Call Section ? Action it is possible to leave the Program ID with blank Value in certain cases?
True

100. True or False. You can assign multiple databases and application servers to a single profile. But, each database and application server must be assigned to only one profile?
True


======================
Q. What is the program flow of SQR?

Ans:When SQR Program starts executing. There are two stages in the Program Flow.

1) Compile stage
2) Execution Stage


=Compile Stage.

All the Preprocessor directives are compiled ( which starts with #include).

Ex: All the SQC are run.
Check for the syntax errors for the conditions.

Ex: if for loop while loop are properly ended with the respective syntax.


Allocates memory structure if you are using the Arrays and load look up .


=Execution stage:
Starts interpreting the code line by line.

Check for the begin -program body.
Begin -heading.
Begin- footer.

-------------
1. What are the sections and paragraphs available?
There are five sections and three paragraphs available in SQR programming. The sections include
a. Begin-setup End-setup.
b. Begin-program End-program.
c. Begin-procedure End-procedure.
d. Begin-heading End-heading.
e. Begin-footing End-footing
And the paragraphs include
Begin-select paragraph.
Begin-SQL paragraph.
Begin-document paragraph

2. Is it possible to increase the array size once defined?
No, it is not possible to increase the Array size once defined

3. What is Load-lookup? Give the Syntax for Load-Lookup?
The LOAD-LOOKUP command defines an array containing a set of keys and values and loads it into memory. With LOAD-LOOKUP, you can reduce the number of tables that are joined in one SELECT. Use this command in conjunction with one or more LOOKUP commands.
Syntax: begin-setup
load-lookup
name=prods
table=products
key=product_code
return_value=description
end-setup

4. Can you Call a SQR from another SQR? How?
We can call one SQR program from another SQR program using Call.callsystem. But this is possible only in UNIX Operating system.

5. Briefly explain Most commonly used SQC’s in SQR programs?
: Some of the most commonly used SQC’s are
1.STDAPI.sqc : This Is Process Scheduler Interface which is used to initiate and terminate some field values such as Process_instance & Run_cntl_id
2.SETENV.sqc : This is used to set the Default Environment based on the Database such Printer Type, Paper Size,Date formats Etc….
3.NUMBER.sqc : This file contains generalized routines to format numbers.
4.DATETIME.sqc : This file contains generalized routines to format dates and times.
6.RESET.sqc : This is an important Footing SQc.

6. What are the commands used in filehandling of sqr?
Using File Handling we can Import. Steps are
1. Opening a File Using ‘OPEN FOR-READING’ command.
1. Reading Data From File Using ‘READ’ command.
Writing Data into Table Using ‘BEGIN-SQL’ paragraph & ‘INSERT’ command

7. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes. The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.

8. How can you Debug SQR programs?
We can Debug SQR using Debugging Commands such as
2. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW

9. What is the difference between sqr and sqc?
SQR SQC
1.This is nothing but the Actual 1.This is like a function in SQR.
Source program.
2.This consists of Program Section. 2.This does not consists of program Section.
3.This can be Compiled & Executed. 3.This cannot be Compiled and Executed.
4.We cannot call one SQR from 4.We can call one SQC from another SQC or another SQR
or SQC. SQR program.

10. What are different types of variables in sqr?
Types of variables in SQR are
1. Column Variables.
2. List Variables.
3. System Variables.
4. Document Variables.
5. Substitution Variables.
User Defined Variables

11. Is there any read-only variable in sqr?
Column Variables & System Variables are Read-Only Variables.

12. How to pass Inputs for sqr program while running from windows?
Using ASK & INPUT Commands.

13. How to pass Inputs to the SQR while running through the Process Scheduler?
Using Procedures & SQC’s to access data on Run Control Page (Run Control Fields).

14. What is the purpose of Stdapi.sqc
This is a Process Scheduler Interface sqc which is used to initiate and terminate some field
values such as Process_instance & Run_cntl_id

15. What is the SQT file? What are the advantages of SQT files?
SQT’ file is nothing but resultant file after the compilation (i.e.) Runtime File. By using this SQT file for Execution we can increase the Performance of the program by reduciong the Compilation Time.

16. What is the SQC used to read data from translate table?
‘READXLAT.sqc’ is the SQC used to read data from Translate Table.

17. Which section is mandatory in an SQR program?
‘BEGIN-PROGRAM’ Section is Mandatory for an SQR program.

18. How will you display an image in SQR?
Using ‘DECLARE-IMAGE , END-DECLARE’ command.

19. What is use of SETENV.SQC?
This is used to set the Default Environment based on the Database such Printer Type, Paper Size, Date formats Etc….

20. How will you perform ERROR handling in SQR?
We can do Error handling in SQR using some command line flags such as –O, -L,-ZMF,-XMB and using Error handling commands such as
ON-ERROR = Skip/Warn/Stop (for Compile time errors)
ON-ERROR = Procedure Name (for execution stage errors).

21. How many ways of performance tuning are there in SQR?
1. Using LOADF-LOOKUP & LOOKUP.
2. Using ARRAYS.
3. Using MULTIPE REPORTS.
4. Using SQT Files.
5. Using –Bnn Command line Flag.
6. Running on BATCH SERVER.
7. Using Proper Programming Logic in SQR such as Using BREAK statement in EVALUATE Command.
8. Proper SQL tuning such as using Sub queries instead of Joins.

22. Can you call procedure in oracle from Sqr? How?
To call a database procedure using Begin-select paragraph, the syntax is as follows:
Begin-select
[(report arguments)]
from Dual
End-select
To call from Begin-sql, the syntax will be
Begin-SQL
;;
End-SQL

23. Can you connect more than one database using one Sqr? How?
Yes.

24. What are the differences between Load lookup and Array
ARRAYS LOAD-LOOKUP
1. Arrays can be declared in any section. 1. Load-Lookup is declared in only in
SETUP section only.
2. Number of rows are not automatically 2. Numbers of rows are automatically added. gives a error if the number of added.
Exceeds the specified number.
3. We should insert data in to Array by 3. Rows are automatically inserted in to
programming. Load-Lookup.
4.We can retrive any number of fields. 4.We can retrive only Two fields from
from a table. a table.
5.We have Length & Data type. 5.We don’t have Length & Data type.
6.We cannot directly print from Array. 6.We can directly print from
Load-Lookup.

25. What are the steps required to run the SQR from peoplesoft environment?
Three steps we have to fallow to run the SQR program from the peoplesoft environment (Process Scheduler). These steps include
a. Making the SQR program API aware by calling two procedures (stdapi-init, stdapi-term) from the Begin-program section and including the Stdapi.sqc in the bottom of the program.
b. Create new run control table or using existing run control table and creating run control page, component and register the component. Creating new run control SQC if we create a new run control table.
c. Giving the permission to the user by giving process groups.

26. How to pass command line flags to a sqr report running through process scheduler?
Using override options in the process definition in the Process Scheduler in the People Tools.

27. What are On-break parameters?
ON-BREAK causes the specified action to perform in a tabular report when the value of a field changes . The default action prints the field only when its value changes (PRINT=CHANGE).Mainly used for Redundancy of Printing on a page.

28 .How does peoplesoft Process monitor knows that the process (Say sqr report) is at what stage such as initiated, in process, completed etc
From the Field Value of ‘RUNSTATUSDESCR’field from ‘PS_PMN_PRCSLIST’ table.

29. How can u Debugging SQR programs?
We can Debug SQR using Debugging Commands such as
3. #IF DEBUGxxx
#END-IF
2. DISPLAY and
3. SHOW

30. How to refer a global variable in local procedure?
After special character (ex.#,&) we use underscore(_) after that variable name.

31. What is -Bnn flag?
This is used to specify the number of rows that are to be taken from Dbase to the Buffer because default the system takes 10 rows at a time.

32. What is -Tnn flag?
This is mainly used for testing purpose. We can restrict the system to generate only a specific number of pages instead of generating all pages for testing. This is used in Windows Environment.

33. What is -RS & -RT Flags?
RS is used to generate SPF file ie; stopping the program after the comilation. _RT is used to run the SPF file .This is also one kind of Performance increasing technique by saving the compilation time.
34. What are the sections in Sqr? Which one is necessary?
Setup, Heading, Footing, Program & Procedure Sections. Program section is the Mandatory section.

35. What is -debug command line flag?
This is used for Debugging in SQR.
36. How to place an corporate logo in sqr?
Using “Declare Image” command
37. what are the debugging commands in sqr?
Show & Display are debugging commands
38. what is the difference between them?
Show is used to display more than one variable at a time.
Display is used to display only one variable at a time.


===============

PeopleSoft Interview Questions and Answers– Application Engine

1) There are 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.

2) What are the Different ways pass data between the steps?
1) State records – One row can be passed and can have many state records.
2) Component/Global People code variables
3) Temporary records – Multiple rows of data can be passed.

3) What is Prerequisite for the State record?
1) Should be either Derived work record Or SQL Table.
2) Name of the record must end in AET; this is how the system identifies the record as a state record.
3) PROCESS_INSTANCE must be a key.
4) 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.

4) How to read the runctrl parameters in AE
1) SQL: - %Select (EMPLID) Select EMPLID from PS_AERUNCONTROL where PROCESS_INSTANCE = %PROCESS_INSTANCE and ORPID = %oprid
2) People code: - &SQL = “Select EMPLID from PS_AERUNCONTROL Where PROCESS_INSTACNE =” PS_TEST_AET.PROCESS_INSTANCE “and OPRID =” %oprid.
%PROCESS_INSTANCE or %Bind (PROCESS_INSTANCE) can be used.
%PROCESS_INSTANCE is more efficient and faster.

5) How do you execute Application Engine through Push Button?
1) CreateProcessRequest () , Schedule ()
2) CallAppEngine.
6) What is the syntax for CallAppEngine?
CallAppEngine (applid [, state record]);

7) What are the 3 trace parameters you can pass to your psae.exe?
- TRACE
- TOOLSTRACESQL
- TOOLSTRACEPC
8) Which Trace option is the best place to start for general performance information?
- TRACE 384 – mostly used trace value.

9) 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).

10) What are the 3 common ways to pass a trace parameter and value to your program psae.exe?
Configuration manager, Process Definition, Command prompt.

11) 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.

12) How do you program AE program for the restarts?
Program Level State Record
One of the state record needs to SQL Table, Since All Derived work record will be re-initializing on commit.
Program Properties
On the Advanced tab in the program properties dialog box, make sure that disable restart is not checked.
Configuration manager
In the configuration manager, sure that Disable restart is not selected on the process scheduler tab.
Section Level
Section type
The option for section type are prepare only and critical updates
If the section is preparing data i,e select data, Populating temporary tables, or updating temporary tables then the section should be prepare only.
If the section is updating the permanent application tables in the database, you should select critical update.
Step Level
Add an order by clause
%Select Field Select Field1 from PS_SOME_RECORD Where FIELD1 > %Bind (FIELD1) Order by FIELD1.

Add a switch to the selected table
Delete processed rows.
The only restriction for batch runs occurs when you have restart enabled, and you are inside a Do Select that is of the Select/Fetch type (instead of "Re-select" or "Restartable"). with select/Fetch, all commits inside the loop are ignored, including the commit frequency if it's set.

13) 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 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. With set processing, you only select those rows that meet the filtering criteria and then run the rule once again all the affected rows.

14) Advantages of Set Processing?
Improved Performance: - Our internal testing has revealed that, in an overwhelming majority of cases, set processing performs significantly better than it is -by-row counterpart for “reasonable” batch processing volumes.

Minimized SQL Overhead: - It tends to use fewer Application Engine SQL statements that each processed more data than the statements executed in row-by-row processing.
Easy Maintenance: - if need to make a fix or add an enhancement to SQL, it’s just a matter of modifying the SQL or inserting the new “Chunk”.
Leveraging the RDBMS: - With Set – based processing, you take advantage of the SQL processing engine on the database rather than placing the processing burden and overhead on the application executable.

15) Testing and debugging application engine?
Application Engine Trace file-You can track the step execution of your application execution.
Application Engine Interactive Debugger – First click on the trace tab and turn off the statement timings. Select Profile -> Edit Profile-> Process Scheduler Tab -> Application section Select Debug check box.

(You can dynamically modify the state record run application engine step by step
People Code Debugger for the Application Engine.)
AE Trace files: - AE__.AET
Without the process instance: - AE__.AET


=============

1) Order and flow of action types?

1) Do When
2) Do While
3) Do Select
4) Peoplecode
5) SQL
6) Call Section
7) Message Log
8) XSLT
9) Do until

2) What is Prerequisite for the Temporary record?
1) Should have process Instance as key
2) Name should end with _TAO

3) Different types of Temporary tables
- Dedicated
- Un Dedicated (Shared)

4) Why Parallel Processing required?
Potential performance improvements by splitting the data to be processed into groups and simultaneously running multiple instance of your program to deal with different groups of data.
If you have a one program that uses a temporary table and is invoked multiple times, that single temporary table could be used concurrently in multiple executions of the code. This could create unpredictable results since the different instances of the code would be issuing delete, Inserts and/or updates unsynchronized with each other.
You could solve the problem by creating multiple temporary tables as a pool of tables. Each invocation of your program would have to allocate an unused temporary table,
mark it as ‘in use’ , use it and release it back to the pool when you through with it (for each Application Engine program you write).

5) How running AE program as Batch differs from running it online?
Application Engine programs are designed for two types of execution and each has its own pool of Temporary Tables
Online:
Invoked by CallAppEngine from People code
Run quickly, synchronously, and at random times.
Potential for simultaneous executions
Uses the online Temporary Table pool.
Not restart able.
Psae.exe randomly assigns an instance number from the number range on your online temp tables.
If the instance number is in use psae.exe puts the program in Queue until the assigned instance becomes free.
Unlock on completion, on Crash free from Manage Abends.
Batch:
Invoked through the Process Scheduler.
Run for longer amounts of time, asynchronously, and at scheduled times.
Can be designed for parallel execution for performance.
Uses the Batch/Dedicated Temporary table.
Restart able.
It allocates instance number based on the availability on a record by record basis and psae.exe begins with the lowest instance numbers.If the properties are set continue - Base table is used with Process instance as key.
If Re-starable – Locked across Restarts until completes successfully.
If not Re-startable on Program completion.

6) What are the important steps for implementing the parallel processing?
Define you Temporary Tables.
Set the Temporary Tables Online pool.
Assign Temporary Tables to your Application Engine program in it program.
Set Temporary Table Batch Pool – Instance count in the AE.
Build / Rebuild your Temporary Table record.
Code %Table Meta – SQL as reference to Temporary Tables in your Application Engine program, so that Application Engine can table references to the assigned Temporary Table instance dynamically at runtime.

7) What happens when all the instance of the temporary table are in use?
It behavior can control by AE developer. If the runtime options are set to continue “People Tools will insert rows into the base table using the PROCESS_INSTANCE as a key”. If temp table doesn’t contain PROCESS_INSTANCE as a key field in a Temporary table, you should change the Temp table runtime options to “Abort” in the appropriate Application Engine programs.

8) How can you divide the data to be processed by different instance of the program to perform parallel program?
Run control parameters passed to each instance of the AE program enable it to identify which input rows “belong” to it, and each program instance inserts the rows from the source table into its assigned temporary table instance using %Table.

9) What are the 3 common ways to pass a trace parameter and value to your program psae.exe?
Configuration manager, Process Definition, Command prompt.

10) What is the main purpose of the Access property in the Section?
Basically they have two option, public and private if section declared as public then it be access from other program.Private we cannot call from other program.

11) Which actions are mutually exclusive and why they are mutually exclusive?
Sql and callsection.

12) Error handling or Exception handling in Application Engine ?
Step properties:-
On Error:-
Abort – Write message to message log and terminate.
Ignore - Write message to message log and continue.
uppress – No message will be written, but program will continue.
People code Action: - On return options can used to handle run time errors.
Abort: - Exits immediately – Not recommended.
Break:- Exits the current step and section and control returns to the calling step.
Skip Step:- The program exits the current step, and continues processing at the next step in the section. If this is the last step in the section, the calling step resumes control of the processing.
SQL Action properties:-
No Rows:- When the Sql doesn’t return any rows, you can tell what application engine program should do.
Abort: - Program terminates
Section Break: - Application Engine exits the current section immediately, and control returns to the calling step.
Continue: - The program continues processing
Skip Step: - Application Engine exits the current step immediately and moves on to the next step. When using skip step keep the following in mind:
1) Application Engine ignores the commit for the current step at runtime
2) If the current step contains only one Action, only use skip step at by-pass the commit.
13) What are different types Do Select?
1) Select/Fetch
2) Reselect
3) Restart able

Select/Fetch: -
Opens the cursor only at the first time and retrieve rows one at loop.
Commits inside the step (commits in the Called Section) are ignored if AE is Restart enabled.
Reselect: -
It opens the cursor and closes the cursor on each iteration of the loop.
It will reselect the same row of data.
Logic in Actions of the step should be such that it will be changing the status of the rows in the table the do select is selecting.
Commits are not ignored and will be committed in a reselect loop when the restart is enabled.
Restart able: - similar to select/Fetch but it WILL COMMIT inside the loop thus allowing the checkpoint to the PS_AERUNCONTROL table.

14)What is the maximum limitation on temporary tabel instances in AE.
99

15) what is the difference between the %SELECT and %SELECTINIT meta sql functions.
Ans %select : if any values have not selected then previous value will be there
%selectinit : if any values have not selected then previous value will reinitilate to null

16) what is the difference between exit(0),exit(1) when we are using this functions in AE
Exit (1) causes immediate termination of a PeopleCode program. Use this parameter to rollback database changes.
Exit (0) caused immediate termination of a Peoplecode Program but don’t make rollback in the database.

=============

PeopleSoft HRMS / HCM Interview Multiple Choice Questions and Answers.The answers of the MCQs are highlighted with a (*)

You are setting up a new medical plan that requires employee deductions from pay. Where do you set up the sequencing of the deductions so that this deduction is taken before all others?
A.Medical Plan Table
B.Benefit Plan Table
C.Deduction Table (*)
D.Calculation Rules Table
E.Benefit Program Table

Which statement is true about an Effective-dated row?
A.It can be modified only using Correct History.
B.It copies all data to the new inserted row, including the effective date.
C.It copies all data to the new inserted row, except the effective date. (*)

An existing row can be modified using Update/Display if the effective date is equal to system date.Despite advice from various consulting firms, a local company wants to pay its employees 13 times a year. They currently pay their employees monthly. What can the company do to pay its employees 13 times a year?
A.set up a pay frequency with an annualization factor of 12 and a pay frequency with an annualization of 1 and combine them in Payroll
B.set up a pay frequency with an annualization factor of 13 (*)
C.It is not possible to set up a pay frequency greater than 12.
D.run the last payroll of the year twice
E.set up the annualization frequency with a pay factor of 13

Which components of Multiple Components of Pay comprise the Comprate field on the Job record?
A.Shift components, Supplemental Pay components, and components with the Base Pay checkbox selected
B.U.S. Dollar Base components only
C.components with the Base Pay checkbox selected (*)
D.components with the Base Pay checkbox selected and the Shift checkbox selected
E.all components

You have just added a new department to the Department Table. It is active and its effective date is less than today's date. When you try to transfer an employee to that department on an inserted row with today's date, the new department is NOT showing up. How can you resolve this issue?
A.add the department to the active Department Security Tree (*)
B.run the Update Department Security Tree Processed
C.change the effective date of the record to match the effective date of the new department
D.manually type in the department in the Department field and select Save from the icon menu
E.run the Refresh Employees Table Process

Which table is NOT set up within the Workforce Administration module?
A.Competency Table (*)
B.Volunteer Organizations Table
C.Action/Reason Table
D.Visa Permit Table
E.Title Table

Many businesses are moving valuable, high-profile employees with sought-after skills across borders to where they are needed most. What is the official name for these employees?
A.foreign assignees
B.foreign country nationals
C.expatriates (*)
D.remote workers
E.multinational employees
F.global workers

Which delivered table is a consolidation of employee information from different transaction tables?
A.Person Table
B.Employment Table
C.Consolidated Employee List Table
D.Employees Table (*)
E.Job Table

In the PeopleSoft 8.8 Internet Architecture, what is the static information at the top of the page called?
A.Favorites
B.Breadcrumbs
C.Universal Navigation Header (*)
D.Menu Bar
E.Components

Which three HCM product modules are included in the PeopleSoft HRMS Release Notes? (Choose three.)
A.HRMS Portal Pack (*)
B.Resource Management
C.Global Payroll (*)
D.Recruiting and Admissions
E.Human Resources (*)

Operator A has only update/display access to the Job Data component. Operator A needs to correct the Job Code on EMPLID 10500 job row dated March 12, 2002. Operator A asks the supervisor why he is NOT allowed to make this change. Why can't Operator A perform this correction?
A.The supervisor needs to add Operator A to a different permission list.
B.The effective sequence on the row is equal to one.
C.The row with effective date March 12, 2002 is the current row for EMPLID 10500 (*)
D.Operator A can correct history only

Your client is upgrading from HRMS 7.5 to HRMS 8.8 and is not happy about the removal of the Personal_Data Table. They want to retain this table for use and remove it when they upgrade to HRMS Release 9. What is PeopleSoft's recommended approach?
A.engage PGS to customize the upgrade scripts to retain the table
B.customize the upgrade scripts to retain the table
C.have the client apply the PERSONAL_DATA_RECALL project (*)
D.stay on HRMS 7.5 until HRMS 9 is released

Which common reporting table is used by many PeopleSoft delivered reports, such as PER002-Employee Birthdays and PER005-Employees on Leave of Absence? A.Pers Data Effdt Table
B.Employees Table (*)
C.Employment Table
D.Personal Data Table

What are three security solutions that are delivered with PeopleSoft? (Choose three.)
A.Fast Security 3 (*)
B.Location Security
C.Department Security (*)
D.Company Security
E.Fast Security 2 (*)

Which five tables store the data from the hire process? (Choose five.)
A.Name (*)
B.Department
C.Business Unit
D.Employment (*)
E.Benefits Program Participation (*)
F.Competencies
F.Job (*)
G.Person (*)

Operator A has only update/display access to the Job Data component. Operator A needs to correct the Job Code on EMPLID 10500 job row dated March 12, 2002. Operator A asks the supervisor why he is NOT allowed to make this change. Why can't Operator A perform this correction?
A.The supervisor needs to add Operator A to a different permission list.
B.The effective sequence on the row is equal to one.
C.The row with effective date March 12, 2002 is the current row for EMPLID 10500 (*)
D.Operator A can correct history only

Your client is upgrading from HRMS 7.5 to HRMS 8.8 and is not happy about the removal of the Personal_Data Table. They want to retain this table for use and remove it when they upgrade to HRMS Release 9. What is PeopleSoft's recommended approach?
A.engage PGS to customize the upgrade scripts to retain the table
B.customize the upgrade scripts to retain the table
C.have the client apply the PERSONAL_DATA_RECALL project (*)
D.stay on HRMS 7.5 until HRMS 9 is released

=============

Below are some of the basic Interview Questions asked on PeopleSoft HRMS/HCM Module.

What isEffective Date?
Information Component /Record linked to the data EFFDT. Information changes based on the EFFDT.

What is Effective Sequence?
Identifier to find the order of multiple transactions occurring on a same EFFDT.

What is the effective sequence’s default number?
0

What’s the difference between a position number and a job code?
Position number is the unique identification number for driven by business unit , department ,location , job code and other parameters

What is the purpose of update/display mode?
To add the new information current and future as well view the current data.

What is the purpose of correct history mode?
To correct the past and current information based on the EFFDT.

What is the purpose of include history mode?
To view the past information based on the EFFDT.

What is Employee Record Number?
Number to identify an employee’s different organizational relationships.

What are all the mandatory fields need to key in while add a person on the system?
1) Name
2) Organizational relationship
National ID , Address, Birthdate gives us warning message.

What is employment instance?
Employee relationship with organization. Where employee can have multiple relationship (instances) with the organization.

What is the difference between Set Id and a Business Unit?
Where a Business Unit organizes your company or your organization,
SetIDs help you organize your data within the system. The HRMS system uses tables
(Control Tables or Prompt Tables) that use a high-level key that enables
you to identify and retrieve data from the system. A secondary high-level
key,referred to as a SetID, has also been added on various tables. SetIDs are
simply the labels used to identify a TableSet. Business Unit and SetID
functionality in PeopleSoft also provides you with a higher business
level for reporting purposes and other business data roll-up.

What is HCCPALL?
Delivered primary permission list with access to all the components and pages

What is HCDPALL?
Delivered row level security permission list with full access.

What is the default tree name need to give while creating the new tree?
Dept_Security followed by any name as per your requirement.

What would be the default effective date for creating the new tree?
1/1/1900 or 1/1/1901

=============
Please find below some of the basic Interview Questions asked on PeopleSoft HRMS Module. PeopleSoft HRMS/HCM Interview

What are all the tree manager definitions?
• Level
• Node
• Parent
• Sibiling
• Child

What are all the various types of SJT?
• SJT_CLASS
• SJT_CLASS_ALL
• SJT_PERSON
• SJT_DEPARTMENT

What are all the organisational instance components?
• Add Employment Instance (Job_Data_Emp)
• Add Contingent Worker Instance (Job_Data_CWR)
• Add Person of Interest Job (Jon_Data_POI)

What are all the job instances used for POIs?
• COBRA qualified beneficiaries
• Stock employees not administered in Human Resources
• Global Payroll Employees
• Pension Payees
• Stock board members

What are all the purpose of the Job Earnings Distribution Information Page?
We can distribute the worker’s compensation on the basis of the following:
• Department
• Job Code
• Earnings Code
• Business Unit
• Shift
• Position Number
• General Ledger Pay type

What are all the job level defaults?
• Work
• Job Information
• Job Labor
• Payroll
• Salary Plan
• Compensation
• Employment Information
• Benefit Program Participation
• Earnings Distribution

What are all the main components for setting the hire template?
• Template Record/Field
• Template Section
• Template Category Table
• Template Creation

What are all the statuses used to define templates?
• Test (Default Value)
• Active
• Inactive

What are all the statuses available on the template hire status page?
• Pending Hires
• Cancelled Hires
• Processed Hires

What are the methods available to update worker’s compensation packages?
• Seniority Pay increases
• Grade Advance increases
• Automated step increases
• Step increases using review bands
• Amount increases
• Percentage increases

What are all the components available under Setup HRMS?
• Install
• Security
• Upgrade
• Foundation Tables
• Common Definitions
• Product Related
• System Administration
==============


Which pay component comprises the Compensation Rate on the Job Table?
A.Annual Benefits Base Rate
B.Non-Base Pay
C.Rate Code Group
D.Non-Base Supplemental Pay
E.Base Pay (*)

Where do you define user related defaults?
A.Department Security Tree
B.Org Defaults By Permissions Table (*)
C.Row Security Table
D.Roles Table

Business Unit Options Defaults Table
You have been asked to set up the Job Code Table. Which two foundation tables should you set up initially? (Choose two.)
A.Pay Group Table
B.SetID Table (*)
C.Salary Plan Table (*)
D.Career Plan Table
E.Job Description Table

An employee has been promoted and you are adding the new Job row to his record. When you try to enter the Job Code, it does not show up in the prompt table search results. What are three possible causes of this problem? (Choose three.)
A.The effective date on the Job Code is greater than the effective date on the Job row. (*)
B.The Job Code has no salary plan or grade associated with it.
C.Your security does not include access to the Job Code's SetID. (*)
D.The SetID of the Job Code is different from the SetID assigned to the employee's Business Unit on the TableSet Control Table (*)

Which PeopleSoft-delivered benefit plan types are assigned to 30 through 39?
A.life insurance plans
B.health plans
C.disability plans (*)
D.pension plans
E.leave plans

Which PeopleSoft-delivered benefit plan types are assigned to 20 through 29?
A.life insurance plans (*)
B.health plans
C.disability plans
D.leave plans
E.pension plans

The dependent age limit is 19 for all benefits. Which table should you use to exclude disabled dependents from the age limit?
A.Benefit Program Table (*)
B.Calculation Rules Table
C.Dependent/Beneficiary Table
D.Benefit Plan Table

What three elements of a benefit deduction are specified on either the benefit plan or plan specific tables? (Choose three)
A.a calculation routine for the deduction (*)
B.vendor information for payment of the deduction
C.the deduction code (*)
D.the priority of the deduction
E.how to handle arrears for the deduction

You are going to set up a long term disability plan. Which plan type group should you use?
A.5X
B.9X
C.LTD
D.3X (*)

A company has a maximum coverage of $1,000,000 over all life insurance plans. The maximum coverage for each plan is: Life - $600,000 Supplemental Life - $300,000 AD/D - $300,000 If an employee selects the maximum coverages for each life insurance plan, what will be the saved coverages for each plan type?
A.Life - $600,000; Supplemental Life - $300,000; AD/D - $300,000
B.Life - $600,000; Supplemental Life - $300,000; AD/D - $100,000 (*)
C.Life - $333,333; Supplemental Life - $333,333; AD/D - $333,333
D.Life - $400,000; Supplemental Life - $300,000; AD/D - $300,000
E.Life - $600,000; Supplemental Life - $100,000; AD/D - $300,000

The PeopleSoft system is configured to allow partial deductions and deduction arrears. An employee has net pay of $300 and deductions totaling $500. Which partial deduction is taken?
A.$400
B.$0
C.$300 (*)
D.$200
E.$500

On which benefits setup table do you associate health plans and providers?
A.Benefit Plan Table (*)
B.Deduction Table
C.Health Plan Table
D.Benefit Program Table
E.Provider/Vendor Table

=============================
Please find below some of the basic Interview Questions asked on PeopleSoft HRMS Module.

What are all the components will have data permission security control access?
• Departments
• Employee, Contingent Worker, and POI with Jobs.
• POI without jobs.
• Recruiting Federal People with jobs.
• Template based hires.

What are all the organisational relationships available while hiring an employee?
• Employee
• Contingent Worker
• Person of Interest (POI)

List down the people part of the POI?
• COBRA Participants
• Pension Payees
• Global Payroll Payees
• Stock non-HR Person
• Stock board members
• External Instructor
• Payroll Employees
• External Trainers

What are all the People Tools Security?
• Permission List
• Roles
• User Profiles

What are all the default programs you need to run after the creating the user profile?
• Refresh SJT CLASS ALL
• Refresh Trans. SJT tables
• Refresh SJT OPR CLS

What are all the default Permission List used while creating the User ID?
• Navigator Homepage Permission List
• Process Profile Permission List
• Primary Permission List

What are all the methods for assigning Data Permission Access to Permission List?
• Tree based data permission security
• Role based data permission security

What are all the Access types for Department security sets?
• Departments by Tree
• Departments by non – tree
• Departments by set id

What are all the Access types for People with jobs security sets?
• Job department tree
• Job location
• Jon business unit
• Job Company
• Job regulatory region
• Job salary grade
• Person organisation
• Department ID – non tree
• Company – Pay group

What are all the Access types for People without jobs security sets?
• POI Business Unit
• POI Location
• POI Institution
• Person of Interest

What are all the Access types for Recruiting Job Opening security sets?
• RS Company
• RS Business Unit
• RS Department ID
• RS Location
• Recruiting Team

What are all the Access types for Template Based Hire security sets?
• Template ID
• Template Category
• Person Organisation
• Country

==============================

Peoplesoft Interview Questions - Component Interface Builder

1) What are the main elements in the component Interface ?
Main elements of component Interface
• Component interface name
• Keys
• Properties and collections
• Methods

2) Difference between Get keys, find keys and Create Keys ?
Get keys: - These are mapped to the fields marked as scrh in the component’s search record. Automatically “Search key” fields in search record become Get keys.
We cannot change it.

Find keys: - These are mapped to fields marked as Alt or Srch in the component search record. You may remove Find keys that you do not wish to make available for searching.
Create Keys: - It is generated from the key fields for the search record. If Add search record is present then its key fields are taken. We cannot change it.

3) How do you provide security for the component interface?
• Open the Permission list
• On the Component Interface tab
• Add row and select the newly created Component Interface
• Edit the permissions to give permission for the standard methods
• Get, Create, Save, cancel, find.

4) What the steps that you need to do in people code to invoke Component Interface?
• Establish a user section
• Get the component interface definition
• Populate the create keys
• Create an instance of the component interface
• Populate the required fields
• Save the component Interface.

&Session = GetSession();
&CI = &Session.GetcompIntfc(CompIntfc.INTERFACE_NAME)
&CI.KEY_FILED_NAME = ‘NEW’
If not &CI.Create () Then

Else
Populate other fields
End-if;

Populate the other fields

If not &CI.Save () Then
Else
End-if;

5) How do you test Component Interface?
• Using the Component Interface tester
• Give values in the tester for options
• Get Existing, Create new, Find and perform the operation from the CI Tester

6) Catching error message in the component Interface? Or
Use of PSMessages in the CI ?
This function needs to be called when ever methods like Find, Save, Create methods return false.
Error text and Error type can be printed in the log message for any other action in to the log messge.

Function CheckErrorCodes()

&PSMessages = &Session.PSMessages;
&ErrorCount = &PSMessages.Count;
For &i = 1 To &ErrorCount
&ErrorText = &PSMessages.Item(&i).Text;
&ErrorType = &PSMessages.Item(&i).Type;
End-For;

End-Function;

7) What is method? What are the different types of method?
Methods: - A method is an object that performs a very specific function on a component interface at run-time.
Standard methods and user-defined methods.
Standard methods: - Automatically generated upon the creation of a new component Interface in Application.
Apart from the Standard methods there are Standard methods available for the use with any collection.
User-Defined methods: - User-defined methods are those that you can create to meet the requirements of an individual component interface.

8) What are properties?
The Fields in the level 0 in the component are the properties of the component.

Standard properties User-Defined properties
Createkeyinfocollection Developer can further control the exposed Getkeyinfocollection field properties.
Findkeyinfocollection
Property Info collection
GetHistoryItems (Update/Display mode or Correction mode)
EditHistory Items
InteractiveMode.

9) Traversing the Collections in the Component Interface?
COLL_JOB – Collection
Coll_JOBItm – Row in the collection.
&COLL_JOBCol = &CI_JOB_DATA.COLL_JOB;
For &i = 1 to &COLL_JOBCol.Count
&COLL_JOBItm = &COLL_JOBCol.Item (&i);
&COLL_JOB_JRCol = &COLL_JOBItm.COLL_JOB_JR;
For &J = 1 to &COLL_JOB_JRCol.Count
&COLL_JOB_JRItm = &COLL_JOB_JRCol.Item (&j);
&COLL_JOB_JRItm.KEYPROP_EFFDT =;

10) 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.
Get History Items alone: - Update display all - modes will be used.

=============================================

IBM Interview Questions and Answers on Peoplesoft

1. What is a set ID or Table set?
It is going share common control table values.

2. What is an object group?
Collection of one or more objects that form a logical group for security purpose.

3. What is business Process Map?
It is an alternative method for accessing panels or it is a graphical representation of a map.

4. What is an activity?
It is a collection of logical steps. It represents specific transaction a user might need to perform.

5. What is a business Process?
It is a collection of activities and it represents broad area functionality, categorizing the several activities.

6.What is a Process?
A task involved by the system.

7. What is a process instance?
It is a process number used to request process.

8. What is a process server agent?
It is going to initialize, select and parse the program.

9. What is a command line parameter?
The executable (.EXE) file is nothing but command line parameter. E.g. C:/SQLbin\SQL.exe.

10. What is Parameter List?
It defines under what database, platform will the program. (Nothing but the meta-strings)

11. What is Application Upgrade?
It is a migration of object from one database to another and updating other system components such as application software.

12. What is Mass change and explain the uses of Mass change?
Mass change is a SQL generator you can use to develop and perform custom applications. Using mass change, a developer can set up a series of INSERT, UPDATE, OR DELETE SQL statements that the end user can execute to perform business functions.
The overall structure of Mass change is similar to that of People soft Query
Except that Query retrieves data from the database while mass change actually updates the database.
The uses of Mass change are as follows.
1. It is used to perform high volume set oriented transactions.
2. Copy data from table or table
3. Archive table data (Archive means that the data does not have backup file and uses to update the values)

13. Why use Mass change and why not SQL execute to update a record, which is not attached to the panel?
The reason why Mass change is preferred over SQL exec is….
1. Two- Three Mass change program can work at a single time.
2. Data / information need not be defined in Mass change
3. Mass change can be used for file download upload.

14. What are the steps involved in Mass change?
The following are the order of steps involved in Mass change.
`1. Define type
2. Assign to template
3. Operator security
4.Mass change definition

15. What is Mass change group?
Adding all Mass change into a group. (i.e., Multiple Mass change definitions can be executed simultaneously).

16. What is workflow?
To an extent all the business processes defined using the Application designer involve workflow. However we usually reserve the term to refer to processes that involve multiple users and the routing of data between the users. People soft workflow tools help you build the routings into your computer systems. You use them to tie together the individual steps so that the system can help coordinate the activities.

17. How Workflow is controlled?
It is controlled by Decision Point (it is graphically denoted by a (?)). Where user has to choose which activity is appropriate towards the next step.

18. What are the key fields used in Key list?
7 key fields used in a key list. They are as follows..
1. Busprocname- (Business Process Name)
2. Activity name
3. Event name
4. Work list name
5. Instance Id
6. Transaction Id
7. Emplid

Note: While defining the above fields in the record definition, a key has to be assigned in the record field properties.

19. What is routing in workflow?
Transfer of roles / users

20. Why workflow is used and explains the advantage of workflow in People soft application?
Workflow typically eliminates the job tasks associated with controlling paper flow, and frees people the once performed clerical functions to do more meaningful work.
• Tasks that don’t require user involvement
• Tasks that involve non People soft users
• Tasks that several users work on together.

21. Define the components of workflow?
There are 3 underlying components of workflow i.e., Rules, Roles, Routing.

Rules
Rules are your company’s business practices captured in software. Rules determine what activities are required to process your business data. The rules are contained in policies and procedures documents.

Roles
Roles describe how people fit into the workflow. A role is a class of users who perform the same type of work, such as clerks or managers. Your business rules typically specify what user role needs to do an activity.
Roles direct the work to types of people rather than to individuals. Identifying roes instead of individual users makes your workflow more flexible and easier to maintain. Roles remain stable even as people change jobs.

Routings
Routings connect the activities in the workflow. They are the systems means of moving information from one place to another, from one step to the next. Routings bring the flow into workflow. The network of routings creates a business process from what used to be isolated activities. Routings make it possible to deploy applications throughout the enterprise. They work through the levels and departments of an enterprise to bring together the role that are necessary to complete complex tasks.

==========================

Peoplesoft Interview Questions and Answers listed below.
1. What is an ERP?
It is a process of integrated flow of Information, which binds on the organization together.

2. What is an ERP system?
It is an integrated application software module providing operational, managerial and strategic Information for improving productivity, quality and quantity to improve competence.

3. Describe the Life Cycle of a Project (ERP Implementation)?
The Project passes through the following stages.
1. Analysis
2. Designing
3. Coding
4. Testing
5. Implementation
6. Maintenance.

4. Define People Tools?
A Collection of software programs, utility scripts and (reports, messages, Cobol SQL statements, database tables and data that provide the frame work for creating, using and modifying people soft applications. People tools provide built in business functionally and maintains the capability that directly increase productivity and simplify system design.

5. What does Application Designer mean?
It is an integrated development environment that is used to develop People soft applications.

6. Functionality of Application Designer?
The following are the uses of Application Designer.
1. Design and create database tables.
2. Design on-line panels
3. Controlling on-line processing flow.
4. Create application windows and menus
5. Providing security for the database.

7. Difference between Two-tier and Three-tier architecture?
Incase of three-tier architecture an application server is connected between the database server (Back end) and the client (front end).
Incase of two-tier architecture the server is directly connected to the client.

8. Advantages of three-tier architecture?
The advantages of three-tier configuration are…
1. Reduce the LAN traffic.
2. Built-in functionality
3. Increase the productivity.
4. No SQL at the client level.
5. Improved performance over WAN.
6. Increased Scalability. (regardless of the number of users connected you can maintain constant performance level)

9. What is a project?
User defined collection of related definitions (fields, records, panels, panelgroups and menus).

10. What are the steps for building an application?
The following are the steps to create application designer.
1. Defining an application.
2. Create field definition.
3. Create Record definition using the fields.
4. Create SQL table.
5. Create Panel.
6. Add panel to the panel group.
7. Add panel group to the Menu.
8. Authorize operators to access Pan.
9. Test.


==============


What is SQR used for ?

Ans: It is a Reporting Tool for creating customised reports to be run from PeopleSoft panels for formatting reports, data transfer, data uploading/downloading etc.



How SQR identifies where we keep sqr files (Path of SQR files)?

Ans: It is specified in Configuration Manager.



3) Which SQC file is used for From Date and To Date.

Ans: AskEfdt.sqc



How do we Debug SQR ?

Ans: a) by using #Debug, or #Ifdef Debugx #endif.

using Show or Display command.



How do you Optimise SQR ?

Ans: a) You can optimise SQR by breaking big sql statements into simple sql statements.

b) Using LoadLookup command.

Using an Array or flat file instead of database tables.

Examining Cursor Status by using -S flag while executing sqr.



What is a difference between Ask & Input command ?

Ans: Ask is a compile time substitute variable which is defined in Begin-Setup. It is used to take an input at compile time. For example you want to accept a printer from user at compile time. Input command is used to accept user input at runtime.



How do we Convert Number to String in SQR ?

Ans: Using Tochar function or even by assigning. #var is numeric, $var is string.



How do you accept Date variable as an Input from a user ?

Ans: Input $Fieldname type-date format ‘dd/mm/yyyy’



How do you Fetch values from Arrays in SQR ?

Ans: Get & Put is used for inserting values in array.



How to find out Which SQL is running in SQR ?

Ans: Using -S flag while executing SQR at runtime.



What is Extract in SQR ?

Ans: Extract copies a portion of string into a string variable & substring is to extract a string from a string variable.





What are Open & Read functions of file opening in SQR ?

Ans: Open ‘Vendor.dat’ as 1 for-reading record=50:vary

Open ‘C:\sqrtemp\vendor2.txt’ as #1 for-writing record=93:FIXED

If #filestat=0 (file opened successfully)

Write #1 FROM $iSalVCode:3

End-If



How do we Concatenate String in SQR ?

Ans: Using Concat function or || as pipes.



How do we work on Effective dated rows on SQR ?

Ans: Write a subquery to get current effective date & then write an outer query for matching effective dated rows from a record.



How do I Reference Global variable in a local procedure in SQR ?

Ans: I can access Global variable with #_VariableName from local procedure.



How do you Declare a local procedure in SQR ?

Ans: Using Begin-Procedure local



How do you Place a Date into Heading Section of SQR ?

Ans Use Date-Time function in SQR & Page-Number.



How do you trap Errors in SQR ?

Ans: a) Using BEGIN-SELECT ON-Error=ErrorProcedureName

b) In procedure display #SQL-Error to show ErrorNumber & $SQL-Error to display message.



What the use of ON-Break in SQR ?

Ans: Syntax: ON-Break Level=1 skiplines= 4 After = ProcedureName vcc

Usage: It is used to group set of records for each level & break at each level.



What is a syntax of LoadLookup ?

Ans: It is declared in Begin-Setup.

Syntax: Load-Lookup Name=

Table =

Key =

Return_value =

Where = FIELDNAME=



What are the statements used in Begin-Procedure ?

Ans: Begin-SQL, Begin-Select, Begin-Document etc.





21) What is a difference between Begin-Select & Begin-SQL ?

Ans: BEGIN-SELECT has only one SQL statement.

BEGIN-SQL can have any number of DML statements & it can also have PL- SQL statements for oracle & each statement should end with double semi colon (;;).



22) Can Multiple Columns be retrieved in LoadLookup command in SQR ?

Ans: Yes, it has to be joined by a double pipe symbol ( || ).



23) Which SQC tells you that some Job is completed ?

Ans: Eoj.sqc tells you about that.



24) Which SQC is responsible for system memory allocations ?

Ans: AllMaxes.max



How do you control the number of iterations or fetch records firing SQL statement in SQR.

Ans: By using Begin-Select Loops= statement.



What SQC’s you have written while customisation.

Ans:



How do you Enter a line in an SQR ?

Ans: Print ‘-’ (y,x,100) FILL



How do you know in SQR on which cursor position you are residing ?

Ans: #Cursor-pos



How do you Use XLATT table in SQR ?

Ans: a) Include ReadXlat.sqc.

b) Put values into $fieldName, $fieldValue

c) Call procedure read-translate-table

d) Get $XLATLongName & $XLATShortName from XLATTABLE of PeopleSoft database.



How do you Define arrays in SQR ?

Ans: Syntax: #define array-size 50

Begin-Setup

CREATE-ARRAY NAME= SIZE=

FIELD=::

End-Setup



How do you differentiate printing a database column & any other variable in a select statement ?

Ans: Database fields should start with the 1st column.

Indent other print statements with at least one column right.



How do you print a document/letter using SQR ?

Ans: Using Begin-Document, End-Document in a procedure.

Call this procedure before From Clause in Begin-Select to print for each record.



What is a difference between EDIT & Format in SQR ?

Ans: EDIT is used for formatting while printing & Format is used while Input specially for date.



How do you put a blank line in Begin-Document End-Document ?

Ans: Using .b



What is STOP QUIET used for in SQR ?

Ans: Stops execution of SQR & come out of it.



How do you refer to a Constant in SQR ?

Ans: A constant is referred in curly braces { }.



How do you Execute SQR using Process Scheduler ?

Ans : a) Include some RunControl panel having OperatorID & RunCntlID.

b) This panel includes PRCSRUNCNTRL table & RUNCNTRL table having OperatorID & RunCntlID.

c) Add your own input fields to this RunControl record & also drag drop it onto your panel.

d) Write PeopleCode OPRID = %OperatorID; in RowInit event of OPRID field.

Write procedure into SQR code which would have an SQL statement to fetch you fields from RUNCNTL table. Remark all input fields. Execute this procedure in else part of If $prcs_process_instance = ‘’ which means that this sqr is to be executed from Process Scheduler.



How to Avoid double declaration of an SQC file ?

Ans: To check this write all procedure of an SQC in the following :

#Ifdef

#define



#endif



What Commands are used to show Output on Screen of an SQR at runtime ?

Ans: Display & Show are the commands for that.





Difference between SQR/Crystal/nVision ?

SQR ReportCrystal ReportNVision ReportGUI It does not provide GUI interface to create reports. It provides GUI Interface for creating reports. It provides GUI Interface for creating reports. Interface writing. Uploading/Downloading data from flat file to PS & vis-a-versa.Cannot be used for Interface writing.Cannot be used for Interface writing.Programming Language SQR language for reporting is a programming language in which you can create your own SQC’s libraries for reusability & also you can hold intermediate data for processing etc. You cannot write complex programs, at the most you can use few If-Else statements based on the data fetched. You cannot hold intermediate data.Only prints reports based on PSQueries. Excel Specific Output SQR Report output can be on text file, word document etc. Crystal Report output can be of any type.It provides output only for Excel spreadsheets.

What are the Common Flags used for SQR’s ?

-A : Causes reporting output to be appended to an existing file of the same name.

-C : Cancel dialog box appears so that user can terminate the program.

-DEBUG: Used in conjunction with #debug command to display additional information when troubleshooting SQR programs.

-E : Specifies that an error file be created and allows you to specify the filename.

-I : Location of *.SQC or other include program files.

-F : Specifies a file or directory where the *.lis file should be created, instead of in the default location.

-O : Filename for the log file.

-RS : Creates a runtime version of your SQR. Creates a file with the *.sqt extention. PeopleSoft does not use runtime SQR programs.

-M :SQR configuration file. Used to modify default SQR properties(AllMaxes.max)

-PRINTER : Causes printer type to be specified.

-S :Displays the status of the all cursors at the end of the run. This is used for troubleshooting SQR programs.

-Tnn : Specifies you to run SQR in test mode for the specified(nn) number of pages.

-CB : Forces communication box.

-XCB :Do not use communication box. Request for input will be made in Windows dialog boxes.



42) How can I suppress display of the SQR banner line when running SQR ?

Ans: Use the -XB flag.



43) Are SQR commands and variables case sensitive ?

Ans: No. Commands can be spelled with any case combination. The SQR variable $string is equivalent to $STRING.



44) Do SQR programs require a .sqr extension? Do SQR runtime files require a .sqt extension ?

Ans: SQR programs do not require a .sqr extension. SQR runtime files require a .sqt extension.



45) Can a .sqt file be "de-compiled" into the original SQR code ?

Ans: No. This is not possible.



46) What is the limit for SQR command line length on PC/Windows ?

Ans: The limit is 128 characters. This is a PC limitation not an SQR limitation.You may want to have the SQR BINW directory on your PATH so that the full pathname to the SQRW executable is not needed. Arguments can be put into a report argument file that is specified with @file on the command line.



47) Can I set the current page number in an SQR program ?

Ans: Yes. Move the desired value to the SQR variable #page-count.



48) What is the maximum record length for the OPEN command ?

Ans: The maximum is 32K bytes (32767).



49) How can I read in variable length delimited fields from a sequential file ? An example format would look like this: field1|field2|field3|...

Ans: Instead of reading a record into individual fields, read the entire record into one field and then use the SQR unstring command to separate the delimited fields.

Example :

begin-report

open 'test.dat' as 1 for-reading record=80:vary

while 1

read 1 into $record:80

if #end-file

break

end-if

unstring $record by '|' into $field1 $field2 $field3 ...

show $field1 ' ' $field2 ' ' $field3 ...

end-while

close 1

end-report



50) How can I insert a null value into a numeric field in the database ? I tried not giving a #variable a value but that did not work, 0 was inserted.

Ans: When doing the insert, list only the fields for which a value is known. All other fields will get the null value.



51) If I get a duplicate key warning message when SQR loads a lookup table, will the lookup table still work correctly.

Ans: No. Use of a lookup table is dependent on not having duplicate keys.



52) How can I find out if rows are selected by a BEGIN-SELECT paragraph? Can I use the SQR variable #sql-count?

Ans: #sql-count indicates the number of rows affected by a DML statement (insert, update, or delete). It cannot be used for a BEGIN-SELECT paragraph. The solution is here below:



begin-procedure main1

move 0 to #count ! This is optional unless main1 is called more than once

begin-select

column1

column2

column3

add 1 to #count

from table1

end-select

if #count > 0

show 'Number of rows selected was ' #count edit 999

else

show 'No rows selected'

end-if

end-procedure main1



53) What is the value used with -C flag of BEGIN-SELECT?

Ans: BEGIN-SELECT -Cflag (Oracle, Ingres, SQL Base) - sets query buffer size. If the value of the -C flag is up to 256 it is in kilobytes, any number over 256 is in bytes only.For Oracle the default is set by the context_area parameter in the init.ora file - the default is 4096.



54) Can I write a matrix report in SQR ?

Ans: Yes. Example of a SQR cross-tab (matrix) report

Example:

Begin-Setup

Page-Size 60 133

declare printer

type = postscript

orientation = landscape

line-size = 8

char-size = 6

End-Setup





55) Can I use 'dynamic column names' in Begin-Select (versions prior to v3.0)?

Ans: Yes, see following workaround. This SQR report will actually write another SQR code with column names supplied by the user and execute it. Note that in SQR Version 3.0, dynamic columns are directly supported.

Example:

begin-procedure main

move 'DEPTNO' to $col1 ! You might use INPUT here to prompt the user

move 'ENAME' to $col2 ! to enter the column and table names instead.

move 'EMP' to $tab

move 'sqrout.sqr' to $sqrpgmnam

let $syscmd = 'sqr '||$sqrpgmnam||' user/password'

move 100 to #flatfileid

open $sqrpgmnam as #flatfileid for-writing record=132

write #flatfileid from 'BEGIN-REPORT'

write #flatfileid from ' DO MAIN'

write #flatfileid from 'END-REPORT'

write #flatfileid from 'BEGIN-PROCEDURE MAIN'

write #flatfileid from 'BEGIN-SELECT'

write #flatfileid from $col1 ' (+1,1)'

write #flatfileid from $col2 ' (,30)'

write #flatfileid from 'from ' $tab

write #flatfileid from 'END-SELECT'

write #flatfileid from 'END-PROCEDURE MAIN'

close #flatfileid

call system using $syscmd #status

display 'Status of call is ' noline

display #status

end-procedure



56)How can I prevent the printing of the empty page at the end of every

.LIS file?

Ans: Delete the last line in the .LIS file through an editor or this can be automated with CALL SYSTEM USING command which would execute the following SQR code.This program reads an ASCII file, removes the last line (the line having the Form Feed) from it and writes the output to another ASCII file.



57) In BEGIN-SELECT do the FROM and WHERE clause have to be aligned to the left margin ?

Ans: No. Only the selected columns have to be.





58) How to use the -F command line flag for multiple reports ?

Ans: Lets look at the following example. The program "ex20a.sqr" creates 3 reports.

Example:

sqr ex20a tutorial/secret -Flabel.lis -Fletter.lis -Flisting.lis



59) In the above example, what would be the names of the SPF files if we use a -keep command line flag ?

Ans: The names will be:

label.spf

letter.s01

listing.s02



60) How many DECLARE-PRINTER commands can a program have ?

Ans: At the most, one for each printer type (lp, hp, ps) for each report plus one declaration for 'default-lp', one for 'default-ps' and one for‘default-hp'. SQR will produce an error message if you declare two hp printers for the same report (or two ps printers, etc.). SQR will issue an error if you define 'default-ps' twice, etc.



61) Do I have to have the DECLARE-LAYOUT before a DECLARE-REPORT that uses it?

Ans: No, you can have them in any order.



62)How do I have different reports generate output for different printers in the same program ?

Ans: You have to place an appropriate USE-PRINTER-TYPE after the corresponding USE-REPORT. For example:

Example:

begin-program

use-report listing

use-printer-type ps

use-report labels

use-printer-type hp

use-report form_letter

use-printer-type lp

do main

end-program



63) What's the effect of the -PRINTER command line flag in a multiple report program?

Ans: It overrides the printer type for all the report.



64) How can unique temporary file names be generated in SQR ?

Ans: One technique is to combine the report name (minus the extension) with the system process ID. The SQR pre-defined variables $sqr-report and #sqr-pid are used. The following example will create a temporary file named techtip1234.tmp for program techtip.sqr ran as process ID 1234. The temporary file is deleted at the end of the procedure.



65) How can I reset the page number that is printed with the PAGE-NUMBER command?

Ans: Move the desired value to the #PAGE-COUNT reserved variable. For example:

move 1 to #page-count.



66) How do I right justify a text string ?

Ans: Use the LPAD function of the LET command to add blanks to the start to the string. For example: let $s = lpad($s, 80, ' ')



67) Standard SQCs

· Askftd.sqc - This asks from/thru date for reporting of heading

· Askaod.sqc - Procedure to call is Ask-As-of-Date

· CurDtTim.sqc - Gets the Current Date Time from System

· DateTime.sqc - Convert date from system format calling InitDate-Time procedure to set format.

· DateMath.sqc - Converts Native Date format to YYYY-MM-DD.

· Eoj.sqc - determines End of job for an SQR report.

· FSHdg01.sqc,FSHdg04.sqc - for Standard Headers for PS Financials.

· Number.sqc - Provides Number related Functions

· Opsys.sqc - Operating system settings.

· PrcsApi.Sqc - Used in Process Scheduler SQR Programs, to get Run control parameters

· RDBMS.sqc - Database Settings. These files uses #DEFINE command to set the variables.

· ReadXlat.sqc - Read the Translate Table for the desired values (Very Important)

· Reset.sqc - Used for Footing Section that prints ‘End-of-Report’.

· SetEnv.sqc - Sets Environment for Country, Printer-Paper, Language, Date, Platform specific parameters, It also contains Opsys.sqc, RDBMS.sqc

· Setup01.sqc - This is generally called from Begin-Setup section for Portrait Size

· Setup02.sqc - This is generally called from Begin-Setup section for Landscape Size

· STDHDGTR.sqc - Performs Language Conversion

· STDHDG01.sqc - Provides Standard heading for language conversion

· StdApi.sqc - Gets Std API calls

· Trancntrl.sqc - Purpose is to COMMIT, ROLLBACK etc. across DB platforms



· Convertcurrency.sqc



· AllMaxes.max - It is used for dynamic memory allocations before the execution of SQR.



68) What is Declare-Layout used for ?

Ans: It is used for defining Page Layout & includes Paper Size, Margins in Begin-Setup. Such as Left-Margin = 1, Top-Margin=1.



69) What is Master Detail Report ?

Ans: Report where tables with one to many relationships are involved.

Project, Tasks, Resources, Efforts. On-Break Level =1 etc.



70) How do you run SQR Report from DOS Prompt using a Batch File ?

Ans: C:\FDM75SU\sqrbinw\SQRW.EXE c:\sqrtemp\%1.sqr EPDMO/SYSADM/SYSADM -Ic:\FDM75SU\sqr\

-Mc:\FDM75SU\sqr\AllMaxes.max -Oc:\SQRTEMP\sqr.log(LogFile)

-Fc:\sqrtemp\%1.lis(Output File)

-ZIFc:\FDM75SU\sqr\Pssqr.ini -lockrl

REM -XCB (do not display Communication Box)



71) What is a Syntax for using SQC's in SQR ?

Ans: #include 'setenv.sqc'.



72) What is #, $, & used for ?

Ans: #Numeric, $String, and &Database field values.



73) How to print current date in SQR ?

Ans: Print $current-date (1,1) EDIT ‘DD/MM/YYYY’ or use internal function or DateNow for current date & time.



74) How to Define Constant & its usage in Begin-Select:

Ans: #define MAX_LABEL_LINES 10



75) Functions (Most commonly used)

Ans:

Isnull- Returns a value of 1 if source_val is null, otherwise returns a value of 0.

Instr- Returns the numeric position of sub_value in source_value or 0 if not found.

Length- Returns the number or characters in source_value.

Lpad- Pads the source_value on the left to a length of length_value using pad_value and returns the result.

Ltrim- Trims characters in source_value from the left until a character is not in set_value and returns the result.

Nvl- Returns y_value if the x_value is null, otherwise returns x_value.

Example: let $city = nval(&city, ‘-- not city -‘)

Round(#avg_length,0)

Substr- Extracts the specified portion of source_value.

To_char- , To_Number,

String-This creates a string, Opposite of this is Unstring

Extract-Copies a portion of a string into string variables generally used in file manipulations. Example: EXTRACT $area_code from &home_phone 0 3

Print is most commonly used stmt. Show and Display are also used

Evaluate

Example: EVALUATE

WHEN =

WHEN =

WHEN-OTHER



END-EVALUATE



SQR provides internal, reserved variables with values maintained & updated by SQR.

#Current-Line : Current physical line on a page

$Current-Date : Current date time on the local machine when sqr is running.

#Current-Column : Current column on page.

#Page-Count : Current page number (can be reset).

#End-File : set to 1 if end of file occurs.

#Return-Status : value returned to operating system when sqr exits.

#Sql-Count : The # of rows affected by an SQL DML statement.

#Sql-Status : Status value from database after each query is compiled/executed. This value is database dependent.

$Sqr-Database: The database type for which SQR was compiled. Valid values are ORACLE, INGRES, DB2, INFORMIX, SQLBASE,SYBASE and ODBC.

$Sql-Error: Text message of error returned from DBS.

$Sqr-Locale : The name of the current locale being used.

#Sqr-pid: The process ID of the current SQR process.

$sqr-platform: The hardware/operating system type for which SQR was compiled. Valid values are WINDOWS, VM,MVS,WINDOWS-NT, UNIX, VMS.

$sqr-program: The name of SQR program file.

$sqr-ver: The text string shown with -ID flag.



Mostly used Format commands in SQR:

CENTER: Center text

EDIT: uses masks to control the format of the output

FILL : fills the specified length with characters specified.

ON-BREAK: allows you to specify an action/procedure in tabular reports when break occurs in the value of the field.

BEGIN-SETUP includes following commands:

Ask : Prompts the user for substitution variable.

BEGIN-SQL : Begins an SQL paragraph.

CREATE-ARRAY: Creates an array of fields to store and process data

DECLARE-CHART: Defines attributes of a chart.

DECLARE-IMAGE: Defines the type, size and source of an image.

DECLARE-LAYOUT: Defines attributes of a report layout.

DECLARE-PRINTER : Overrides the printer defaults.

DECLARE-PROCEDURE

DECLARE-REPORT: Defines reports and their attributes.

DECLARE-VARIABLE : Allows user to explicitly declare a variable name.

LOAD-LOOKUP : Loads columns into an internal array.

USE : Overrides default database (Sybase and MSSQLServer only)



SQR consists of 5 Sections:

Report or program

Setup

Heading

Footing

Procedures



Processing sequence of SQR

Compile Stage

All #Include external source file (SQCs) are inserted into the source.

All #commands are evalueated. The #DEFINE text substitution variables are placed into the program source.

The SETUP section is processed, including allocation and population of memory arrays created by the Load-Lookup and Array commands.

Work buffers are allocated.

Optimization of the SQL data access path is determined.

Syntax of SQR source program is checked.

Execution Stage

Processes data for the Body section

Processes HEADING section

Processes FOOTING section

Writes entire page buffer to file.



What is Process Monitor used for ?

Ans: A centralized utility allowing you to monitor the status of process requests that you have submitted, by displaying a list of currently logged requests waiting to be processed. From this list you can view the active list of Process Scheduler Servers and stop their execution depending on your level of security.



What is the only required section of a SQR Program ?

Ans: The only required section of SQR program is BEGIN-PROGRAM with its corresponding END-PROGRAM.



How does SQR calculate the number of rows available for the body of the page ?

Ans: The rows available to the body of your report are calculated from the rows defined in PAGE-SIZE minus the number of rows reserved by the BEGIN-HEADING and BEGIN-FOOTING sections.



How do you make a zero value blank on a report ?

Ans: Print #varname (+1,1,10) EIDT bbb9