BI Publisher: Run Date and Run Time in the Output Report

In Reports, we generally place the Report Run Date and Run Time in the Output Report.

Lets see how this can be done in BI Publisher.

Open the BI Publisher Template (RTF), insert the Form field and in the options select the Field Type asCurrent date for Run Date  and Current Time for Run Time.

Below are the snapshot for the same.

 Now save the template and check the Output in the Preview. Below is the sample Output.

SET ID , BUSINESS UNIT , Transaction table and control table

Business Units

Business units are logical units that you create to track and report specific business information. Business units have no predetermined restrictions or requirements; they are a flexible structuring device that enable you to implement PeopleSoft HRMS based on how your business is organized.

You must define at least one business unit. The BUSINESS_UNIT field is included on all transaction tables.

Tablesets and SetIDs

Tablesets and setIDs are devices that enable you to share – or restrict – information across business units. For example, with tablesets and setIDs you can centralize redundant information such as country codes while keeping information such as departments and job codes decentralized. The overall goal of tablesets and setIDs is to minimize data redundancy, maintain data consistency, and reduce system maintenance tasks.

You must define at least one tableset/setID. The SETID key field is included on all control tables.

Control Tables

Control tables store information that is used to process and validate the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.

The information stored in control tables is common and shared across an organization, for example, master lists of customers, vendors, applications, items, or charts of accounts. By storing this shared information in a central location, control tables help to reduce data redundancy, maintain data integrity, and ensure that users have access to the same basic information.

The information stored in control tables is generally static and is updated only when fundamental changes occur to business policies, organizational structures, or processing rules.

Note. Control tables are tables that include the SETID key field (setID). As you set up control tables, you’ll notice that it is the setID that enables control table information to be shared across business units.

Few control tables in ps hrms:PAY_PRIOR_ALL,PS_DEPT_TBL

Transaction Tables

Transaction tables store information about the day-to-day business activities (transactions) users perform with PeopleSoft HRMS applications.

The information stored in transaction tables often changes and is updated more frequently than the information stored in control tables.

Few Transaction  tables in ps hrms: PS_HISTORY,PS_HUP_WORK

Note. Transaction tables are tables that include the BUSINESS_UNIT field (which may or may not be used as a key field).

Difference between do-while, do-when, do-until and do-select in app engine.

The condition in an app engine DO-WHILE contruct is true if the associated SQLSELECT statement returns any rows. Any subsequent action executes until the SQL statement doesn't return any more rows. 

In contrast, the DO-UNTIL construct executes the actions first and then runs the SQL. The condition is true if the SQL statement returns any row and terminates the loop. 

DO-SELECT executes the actions for each row returned by the SQL statement. It is like a 'FOR LOOP'. 

DO-WHEN is like an 'IF Statement'. If the SQL returns a row, then the actions are executed, otherwise they're skipped.

peoplecode validation : How To Put Validation On Field To Accept Characters Only Using Peoplecode

Question : I have an employee information page in which there is employee name field I want to put a validation so that at run time on click save button. It shows a message to user that it will not accept any other value than characters. Please reply me soon.

Ans:You can use IsAlpha function. 

If ?Not IsAlpha(MYRECORD.NAME.Value) Then 
/* do error processing */ 
Error MsgGet(<MsgSet>, <MsgNum>, "default error message"); 
End-if;

IsAlpha:

Syntax

IsAlpha(String)

Description

Use the IsAlpha function to determine if String contains only textual characters, including alphabetic

characters

Returns:

A Boolean value: true if the string contains only alphabetic and textual characters, false if it contains any numbers, punctuation or spaces.

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.