Blogging About Oracle Applications

Running Oracle VM Templates on Oracle Linux guide (Part 1 of 6)

 

In the coming few weeks I will be posting a full and detailed guide for installing Oracle VM Templates on Oracle Linux. I was inspired by Jim Marions blog about running OVM Templates on OL (Part 1 and Part 2). I was very surprised with how much ease and little time you can set up a fully configured environment. This is perfect for creating your own sandbox. This guide will be based on his tutorial on how to install and run the templates, but I will be giving you a step by step detailed guide. Continue reading

Using RTE enabled fields in BI Publisher with PeopleTools 8.52

In PeopleTools 8.50 adding a Rich Text Editor to Long fields was introduced. With this RTE users are able to actually format text like you would do in for example Microsoft Word. This was a great feature for online entry and presentation in PeopleSoft. Unfortunately this does have a downside. The text that is entered and formatted using RTE gets stored in the database as HTML. This means that when you are using PSQuery to query the data, the data is presented as plain text with the HTML tags and therefor also not usable in any BI Publisher reporting.

With PeopleTools 8.52 a new tempate is introduced that solves this issue and renders the HTML tags in the Long field to the actual formatting the same way as presented in online PeopleSoft.

Continue reading

I’m Speaking at Oracle OpenWorld. Join Me.

I am proud and honored to announce that I will be speaking at Oracle Open World, among many more community spreakers. To see the full list of spreakers and subjects, please use the following link.

 

 

 

 

 

 

I will be giving a presentation on Five Reasons to Upgrade to PeopleTools 8.52:

  • Feature Packs
  • BI Publisher Enhancements
  • Secure Enterprise Search
  • Dashboards
  • InterWindow Communication
Time and speaking ground:
  • Wednesday, Oct 3rd
  • 3:30 PM 
  • Moscone West 3011
You can also follow me on twitter @hakanbiroglu, where I will try to give a live report on the Oracle Open World experience.
Haven’t registered for Oracle Open World yet ? Use the banner below to access the registration site.

Hope to see you there.

 

Direct Reports and loading the component

In Manager Self service, Direct Reports are being used to choose an employee and applying the self-serivce for this employee. The Direct Reports are called from peoplecode, which should be added to the post-build peoplecode of the MSS component. But however, the post-build peoplecode is fired after the component has been loaded initially. The initial load is based on the search record, and if this is the Installation record, then it is filled initially with the Emplid of the user, in this case the manager. If there is a database record being used on one of the pages of the component, then it will be filled with the data of the manager. If then after that a scroll flush and scroll select are being used with the data of the employee chosen from the direct reports, then the data of the manager will be overwritten. This could result in a  database update!

An example: Manager John wants to use a Manager Self Service, for instance a position change for employee Jack. Suppose that for this self Service there is a new custom made Self Service, with direct Reports. When hitting the link, the page is initially filled with the data of manager John. But this is not yet visible. Now John sees the Direct Reports instead, and picks his employee Jack. Behind the screens, a scroll flush and a new scroll-select take place. So the data in the page containting the info of John is erased and replaced by the data of Jack. Now if there is a database record on the page, it results after a save in a database update, in which the data of John is replaced by the data of Jack. The could also be a read-only record on the page, that is only there for informational reasons, for instance a view on Job Data. Then a row of Job is updated with another emplid.

One solution, also used by PeopleSoft self, is a derived record on level 0, and on the scroll or grid on level 1 check “no auto select”. And the same for level 2 etc. Then the scroll-select after picking an employee from Direct Reports it is always considered as an insert. Another solution is using derived records only. And then insert from  the SavePostChange peoplecode.