-
AE actions
What is the difference between dowhen and doselect?
sharathkedika
- Jun 15th, 2008
Sry ....DoWhen is some thig like IF statment. it is the first acation in execution order. if the query written in the Do When action returns any rows then the subsequent actions will be executed.In a simple way DoWhen is a conditional actionDoSelect is a looping action
sharathkedika
- Jun 15th, 2008
DoSelect : here we don't need to increase the counter. pointer to the next row in the selected data will be moved automatically.DoWhen: here we need to write the select query to skip the processed row.
-
What the main differences between versions of the foll.Peoplesoft CRM 8.8 and CRM 8.9? Peoplesoft HRMS 8.8 and HCM 8.9? Peoplesoft Finance 8.8 and 8.9?
kishorev1
- Jun 21st, 2008
Peoplesoft 8.9 came up with AAF (Active Analytics Framework), a powerful front end tool for workflow, which was absent in 8.8 crm (though 8.8 has workflow, its not that powerful) as 8.8In generic 8.9 ...
-
SQL injection what is it?
hemsiri
- Jul 15th, 2008
SQL injection is a technique that exploits a security vulnerability occurring in the database layer of an application. The vulnerability is present when user input is either incorrectly filtered for s...
-
Table set sharing and Set ID
What is Table set sharing and Set ID?What is the difference between Master table, Transaction table and Control table?
PeoplesoftSarada
- Nov 7th, 2008
Set ID is the highest level key in Peoplesoft. Its very important to understand the concepts of SET ids and table set sharing for the purpose of centralisation and decentralisation of data. Control ta...
-
Difference between Save PreChanges and Save PostChanges w.r.t saveedit?
dharmendragohil
- Nov 20th, 2008
Save pre event is mainly use for checking validation and Save Post is mainly use for DML Statments like Insert and Update on the basis of validation.
priya
- Mar 21st, 2006
save edit validates data and gives messages or warnings.when no error/warnings exist then saveprechange fires. it helps by doing one last check before the save process. save post change...
-
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
karam_amit
- Dec 6th, 2008
System Tables Will Have Convention as " PSREORDNAME" and Non System table will have as "PS_RECORDNAME"Where in the above both the cases the RECORDNAME is the name of the actual record.
priya
- Mar 21st, 2006
peoplesoft categorises tables into 3 types with naming convention assystem catalog tables start with sys like systables, syscolumns, sysindexespeopletools tables psrecdefn application tables ps_recname.
-
What is the difference between a Grid and a scroll?
charankreddy
- Jan 20th, 2009
In the scroll?you can view?only one?records at a time, where as in the grid you can view many records.
Neo
- Dec 1st, 2006
One of the differences between a grid and scroll is that a Grid can be inserted into a scroll but vice-versa is not possible. In fact a Grid is incapable of housing another grid.From an end-user ...
-
Explain the Process flow in Billing, AR, AM. GL, AP, PO ?
sachinkanth
- Feb 13th, 2009
Process Flow in GL---------------------------1) Journal Entry - Online Journal Entry &n...
kiranreddyt
- May 2nd, 2008
Process flow in Billing, AR1. The sale is captured in Billing. Load Bills from an external system into PS Billing through Billing Interfaces Process2. Billing creates the invoice to send to the custom...
-
What are the various peoplecode events?
bamaboy
- Apr 13th, 2009
There are 15 record level peoplecode events 1.Field Change2.Field Default3.Field Edit4.Field Formula5.Prepopup6.Row Delete7.Row Init8.Row Insert9.Row Select10.Row delete11.Search Init12.Search save13....
PeopleSoft Tech
- Aug 21st, 2006
Besides above..:actiavte event : pageprepopup event: menu
-
Recordchanged method
What is Recordchanged method in PeopleSoft?
Meena_peoplesoft
- May 27th, 2009
Use the RecordChanged function to determine whether the data in a specific row has been modified since it was retrieved from the database either by the user or by a PeopleCode program.
-
What are the limitations of PS query?
sreddy09
- Jun 11th, 2009
The other limitation of PS query is that if the resultset of the query is too large, then not all the data can be extracted into Excel or CSV file due to file size limitations.
sharry
- Jan 10th, 2008
@ mmtani
You are absolutely correct in your statement, but leaving the temp table with data and clearing it before next use is not a good programming practice isint it.This is the reason I wrote the above thing. -
How do I research the processes listed on the Process Profile Permissions link for a Process Profile?
c2kviji
- Aug 20th, 2009
We can get the list of process linked to a process profile group from the following table :PS_PRCSDEFNGRP
-
Difference between sql statements and metasql statements?
bandisdevi
- Oct 25th, 2009
Sql: - Insert, update, create, delete. Meta Sql: - %Bind, %Execute Edits, %Select, %Selectinit, %Sql, %Table, %Truncate Table. Sql statements are platform dependent where as meta sql statements r platform independent.
Nitesh.Balakrishnan
- Nov 28th, 2008
Meta Sql are peoplesoft specifiy terms which were used to replace platform dependent SQL statements to common terms.Using Meta Sql you can write platform independent SQL statements.
-
Activate Event is Valid for following:
Standard & Secondary
desipsguru
- Dec 23rd, 2009
Activate event is valid only for pages that are defined as standard or secondary. This event is not supported for subpages. Above verbiage is from PeopleBooks..
Ashia
- Feb 4th, 2007
Activate Event is valid for Standard Page, Secondary Page as well as for Sub Page.
-
Site Branding
You can set branding options for sites within the PeopleSoft Enterprise Portal. What is meant by this site branding?
ambar_hitman
- Feb 19th, 2010
Site branding means you can brand up your peoplesoft portal. For example, now you see Oracle logos on your login/logout pages and above the menu you can see Peoplesoft symbol. You can replace it with your organization's symbol, essentially rebranding it.
-
What is process of setting up a payroll/generating a pay cheque in Ps Payroll module
Shreya13
- Apr 1st, 2010
For setting up a payroll, you need to setup an elements under element group then eligibility group and then pay group. Afterwards, you need to create a calendar for the month you wnat to run payroll f...
-
What is pay cycle and pay cycle manager?
HimanshuR
- May 22nd, 2010
To be precise & direct, Pay Cycle is one of the methods of making payments (to Vendors) in the Accounts Payable (AP) module of PeopleSoft Financials.To run a Pay Cycle, you need to specify &#...
kiranchitla
- Jul 7th, 2006
vaibhav that was a good reply but as far as knowledge goes, Pay Cycle is the period between two dates..ie Paystart date and Payend.I mean an employee gets his after the end of evry pay cycle. For eg i...
-
Search and Add Search Record
What is the difference between search record and add search record
m4monki
- Aug 2nd, 2010
Search Record: Search Keys and Alternate Search Keys of the Search Record will show up at the Search mode.Add Search Record: Search Keys of the Add Search Record will show up at the Add mode, when Search Record is not Level 0 record.
srinivas.bandarapu
- Jun 15th, 2010
Search Record: It is the record which provides search options, basically search record itself also Add Search Record. But in some cases we need to maintain Row level Security at that time w...
-
How many Grids can we insert in a single component or page?
m4monki
- Aug 2nd, 2010
Any number of grids can be inserted in a page, as long as they are at the same occurs level. Where as in a scenario where nested levels exist on a page - grid should be at the last occur level, since grids cannot be inserted into grids or a scroll area into a grid.
m4monki
- Aug 1st, 2010
Since in a page any number of records can exist at the same occurs level, any number of grids can exist at the same occurs level.
-
In the URL identify Portal and Component name?
m4monki
- Aug 2nd, 2010
Consider following is the URL:-http://xx.x.x.xx:xxxx/psp/hruat/EMPLOYEE/HRMS/c/Z_SET_QA.Z_SET_QA.GBL?FolderPath PORTAL_ROOT_OBJECT.Z_ARINDAM_TEST.Z_SET_QA_GBL&IsFolder false&IgnoreParamTempl FolderPat...
Vibhavi
- Feb 1st, 2007
Consider following is the URL:-http://10.1.0.25:8375/psp/hruat/EMPLOYEE/HRMS/c/Z_SET_QA.Z_SET_QA.GBL?FolderPath=PORTAL_ROOT_OBJECT.Z_ARINDAM_TEST.Z_SET_QA_GBL&IsFolder=false&IgnoreParamTempl=FolderPat...
Peoplesoft Interview Questions
Ans