Peoplesoft technical Interview Questions!!

Here are some of the techical iquestions that I came across in different company's  interview.


Application Engine

1. How Application engine are better than SQR??(Here dont forget to include restart ability of AE in your answer).
2. At what all level can one have commit in AE?
3. Explain with example different steps to make an AE restartable?
4. Can AE have no Default state record?Give Example.
5. Explain parallel processing in application engine?
6. Which 2 action are mutually exclusive?? and WHY?( WHy then Peoplecode and Call section are not as peoplecode can also have sql in form of sqlexec)
7. Different ways to call application engine??
8. Difference between: %select and %selectinit?
9. Different ways to handle error in Application engine??At section,step and action level? for sql and peoplecode??
10. Order of action ??
11. How to dynamically call a section ??
12. Can there be an AE without MAIN section ?
13. Explain how to create Application lib??
14. How does AE knows from where to restart??(explain all about state record and aeruncontrol table)
15. Different types of DoSelect??
16. CODE:  Read a file using an AE and load to component using CI.

Auto refresh Peoplesoft page after regular interval/Javascript

I love JavaScript as it is FAST and reduces load from the server.
lots of stuff that javascript does can be done very easily  by peoplecode.

Like if one wants to show an alert message using javascript.

For that One can simply use the messagebox function in peoplecode.

For checking the length of the field, one can write an logic on the field change and check the length using the field class.
But for that you may need to make the page or field interactive, that means the page will go to server after each interaction and thus again increasing the load on the server.
Therefore I prefer Javascript.

Now coming to the  Auto refresh of peoplesoft page.
There is a delivered button that one can use (Refresh )

Or second method will be:

getlevel0().refresh();  this will refresh the page and bring new data in the component buffer.

But our requirement is that the page should refresh itself without user intervention.

For that I used a simple combination of 2 functions in javascript.

One need to place a HTML on peoplesoft page, now you can have it as constant or as the field in derived work record.

For field in derived work record  you will have to create an HTML definition, Place the script in the definition and provide the value with getHTMLtext function.You can choose the event on which you

want to fire the code/script.

For auto reload a page:
Place a HTML tag in the page:

Here I have created no function as i want to fire the script as soon as it loads.

Using the function:setintervel we tell the code the time diff to fire the reload process.

With this code in place the page will refresh itself after the time interval defined.

This can useful if somebody wants to monitor real time numbers coming on real time basis. 

XSLT mapper with Application designer.

I was trying to include Jdeveloper for XSLT mapping in application designer,but was not able to do so with the documents provided by peoplebooks.


So here is series of step I following to make to it work:

1) Install JDeveloper
- I installed 11.1.1.5.0 to C:\Oracle\Middleware
2) Install SOA extensions
- JDeveloper > Help > Check for Updates
- Follow Wizard, select to manually locate file, navigate to the soa-jdev-extension.zip file and install
3) Copy JDK into JDeveloper Home
- JDeveloper 11.1.1.5.0 installs jdk160_24
- Copy C:\Oracle\Middleware\jdk160_24 to C:\Oracle\Middleware\jdeveloper\
- Rename C:\Oracle\Middleware\jdeveloper\jdk160_24 to C:\Oracle\Middleware\jdeveloper\jdk , else JDeveloper won't find the JDK.
4) Configure PS client
- Run PSCFG.exe
- On the "Crystal ... /JDeveloper" tab:
  - Enter JDeveloper HOME path C:\Oracle\Middleware\jdeveloper
  - Enter "Launch Mapper Classpath" (ensure there are no linefeeds in path else it won' work, all jar files outside JDeveloper HOME need absolute paths, jar files in the JDeveloper HOME use relative paths to the JDeveloper HOME)
    jdev\extensions\oracle.bpm.mapper.jar;integration\lib\bpm-ide-common.jar;ide\lib\javatools.jar;jdev\lib\xmleditor.jar;C:\Oracle\Middleware\oracle_common\modules\oracle.xdk_11.1.0\xmlparserv2.jar;C:\Oracle\Middleware\oracle_common\modules\oracle.xmlef_11.1.1\xmlef.jar;C:\Oracle\Middleware\oracle_common\modules\oracle.javatools_11.1.1\javatools-nodeps.jar;