csc peoplesoft interview questions

1)what modules did u worked
2) what are the benfit plans did  u worked
Ans :     health plan participation
    life insurance participation

3) did u hire any employee in ps
4) i have 10 fields on page i want to save 5 fields only
Ans :using dosavenow()
5)how u can use global values in procedures
Ans:$_global _variablename
6) how u can access one procedure variables in another procedure

7) %select and %selectinit
ans:1> if unable to get present value then previous value will be present.
       2>if unable to get persent value then pervious value will be innitialized to zero.
8)she asked one req. useing hr tables ,what table u use.
9)what unix commanddid u used  in sqr
10)serach record and add search record
search record search key will display in search page and
add search record serch key will display in search page when when the component is in add mode.
11) what tools u used to handle tickets in u r supporting project.
Ans: quality center (QC)

>>>..stil she asked few questions i didn't remenber ...<<<<

cedar peoplesoft interview questions

1. What are the types of Query? tell me about Process Query and Role Query?

2. Did you Work on workflow? if yes tell me about  that?

3.How can we turn to the main page from secondary page? tell me the process?

Ans

 Using EndModal(0) and EndModal(1) we can do this task see my blog (surya)

4. How can we access the secondary page?

Ans: We can access secondary page using pushbutton DoModal function and by setting

         destination   =secondary page ,give secondary page name.

5.Diffrence  B/w dowhile and doselect?  what options are availble for do select explain each? using do select what  did you do?

6.Tell me about Mass upload program? Why did you use Filelayout for  that? what validations it performs? Can you insert rows directly into Target tables from Staging Tables?

7.What is instance count?  we can set the instance count from Application Designer and online. What is      the difference between them?

    Ans: in pia peopletools -àutilities-àadministration àpeopletools options 

1.      The main difference is when we are running AE using app. designer then it will take that instance count

2.      When we run AE using process scheduler then it takes this instance count.

8.Tell me About The employee ID Delete Processing?

9. What is the Reuse options? Give me the scenario When did you use bulk insert?

10.Tell me what did you perform the online developments?

11. What is Translate values?

12. Difference b/w Dynamic View and Dynamic Prompt?

13.How to get the field from second  level of the page? Write on this Paper?

14.If we want to  send  an  email to the immediate manager  What to do? tell me the process?

15.Can We place Grid after the scroll at same level?

Ans :  yes

16.On the resignation page, If user clicks on submit button without entering all the required information, will it send an email to immediate manager ? How can you stop the email if user does not enter the required information ?

17.When we drag the CI into peoplecode action  of the AE program Psedo code will be Generated. If we comment execute save execute cancel  What will happen?

18. Assume a value 10 is assigned at FieldDefault Event and 20 at RowInit. When you add a New row from the search page, what value will be assigned?

Ans : RowInit

19. How to Pass Run Control  Input Values  when You run  AE Program through  CreateProcessRequest?

peoplesoft app. engine interview questions

1. what  is  application engine ?

A. It is a people tool designed to develop background SQL processing program. Application Engine does not generate, parse, or understand SQL, it does execute SQL that you provide This tool is intended to be used by developers with knowledge of SQL, SQL tools, and People Code.

2. What is application library?

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

application library with standalone program.

3) What are the Different types of Application Engine?
Standard: Standard entry-point program.
Upgrade Only: Used by PeopleSoft Upgrade utilities only.
Import Only: Used by PeopleSoft Import utilities only
Daemon Only: Use for daemon type programs.
Transform Only: Support for XSLT Transform programs.

4.What is the difference between the %select and %select init meta sql functions?

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

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

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

A. Dedicated

     Un Dedicated

6) what are the different types of variables in the Application Engine people code?
Local variable – These are available for the duration of the program in which they are declared.
Global / Component – These variables are available while the Application Engine program is running. They are saved at commits and checkpoints,So they can be used for restarts. Component variables are same as Global incase of the AE.

7) What are the Different ways pass data between the steps?
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.

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

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

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

11) What is the syntax for CallAppEngine?
CallAppEngine (applid [, state record]);

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

14) What is the difference between a Trace value and Trace parameters?
A Trace parameter determines which type of trace is turned on.
A Trace parameter determines what type of data is recorded in your trace files (s).

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

16) How do you program AE program for the restarts?

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.

17) What is Set Processing? 
Set Processing uses SQL to process groups or sets of rows at one time rather than processing each row individually. With 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.

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

19) Why call section and sql are mutually exclusive?

A. Both CallSection and SQL are used to perform DML operations so we will use either SQL are CallSection.

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

A.

Temp Tables:
used to store the immediate values during the processing of the AE.
Help in batch processing by creating multiple instances and there by facilitating parallel processing.
If used properly they can greatly improve the performance.
State Records:
 used to pass on values from one section/step/program  to the other.
These can be a max of 200 state records  that can be used in a single AE but only one of them can be default.  state record name must end with _AET.

 

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

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

22)what are the peoplecode events used for CallAppEngine function.

A.  Save PreChange ,SavePostChange, WorkFlow , FieldChange.

23)What is the Order of Action Events?

 Do When ,do while , Do select  ,People Code  , SQL/Call Section,MessageLog,Do Until.

24)What are the prerequisites for Temporary Record ?

A. Process instance as  a key and  name should end with _TAO

25) What are different types Do Select ?

             select/Fetch

              Reselect

              Restartable

26)What is the difference between the exit(0),exit(1) when we are using this function in AE?

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

Exit(0) causes immediate termination of a peoplecode program but don’t make rollback in the database.

27) What is the difference b/w %select, %bind?

   %select—used for inserting

   %Bind----- used for retrieving.

sqr interview questions peoplesoft

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.

       5.   RESET.sqc :  This is an important Footing SQc

      

6.  What are the commands used in file handling of sqr?

        Using File Handling we can Import.

 Steps are

1.      Opening a File Using ‘OPEN FOR-READING’ command.

2.       Reading Data From File Using ‘READ’ command.

3.      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 to avoid Redundancy of Printing on a page.

8. How can you Debug SQR programs?

We can Debug SQR using Debugging Commands such as

1. #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  SQC                           4.We can call one SQC from another SQC or another SQR                                                                

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.

And  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 , we can increase the Performance of the program by reducing 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
<Procedure name> [(report arguments)]
from Dual
End-select

To call from Begin-sql, the syntax will be
Begin-SQL
<procedure-name>;;
End-SQL

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

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.

    Added.                                                                       gives a error if  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
                                                                                       table

5. have  Length & Data type.                                   5.  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

     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.

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

1. #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(_) before 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 is -debug command line flag?

This is used for Debugging in SQR.

35. How to place an corporate logo in sqr?

Using “Declare Image” command

36. what are the debugging commands in sqr?

Show & Display are debugging commands

37.  what is the difference between these?

Show is used to display more than one variable at a time.
Display is used to display only one variable at a time.

38.