A day in the life of an Oracle Applications Consultant

HRMS & Payroll

Tuesday, June 22, 2004

The HR Global Driver

The Hrms implementation guide describes a post-install step for Oracle hrms: the global driver. This driver or patch is so famous he got a name. The result of the driver is that low-level seeded data is loaded within the hrms tables.

First step is Data Installer, a java tool to select the legislations and modules you want to load. Your selection is stored within the Hr_legislation_installations table.

Next step is to run the global driver through adpatch, the standard tool to launch a Apps patch. The global driver will mainly load data for the selection made earlier.

Apply the global driver always, even if your legislation in not within the list of available legislations. In that case, the global driver will load common data, necessary for all hrms legislations.

Check some tables to verify if the data was really loaded, and watch the last_update_date. For payroll, I check in 11i the Pay_balance_dimensions table for the ZZ legislation.

One last remark, when you arrive new at an Hrms project, and you notice some surprising behavior, check if the hr global driver was successfully applied. It is not the first time that the dba ensures me he applied the global driver, but that I found out that the data was not loaded.

Friday, June 18, 2004

Speeding up Oracle Hrms API debugging

One of my personal favorites is a little trick to speed up development and debugging of Oracle Hrms API’s.

The code behind the API’s has lots of trace statements. You can turn it on by calling “hr_utility.trace_on;”. But the output is now only available through a tool called PYUPIP. This is the one support asks many times for.

Just add one extra call to the previous one, and the trace messages are rerouted to dbms_output.


Wednesday, June 16, 2004

Oracle HRMS (Human Resources Management System) and Payroll Blog

Thierry Vergult an experienced Oracle HRMS and Payroll consultant has a blog entitled “Implementing HRMS: My Daily Experiences”. This post contains details of the blog.

According to Thierry “After 6 years implementing Oracle HRMS, I want to share my experiences and personal opinions about it. I’m an independent consultant, and have been busy on several projects, mainly in Europe and Africa, implementing all the HRMS modules. My personal favourite by far is Payroll. I do project Management, functional stuff and technical development. Application tuning is my cup of tea”. The blog can be found at You should also check out OPAYRA, another site that Thierry has started up.

I’ve asked Thierry if he would like to blog for this site under the HRMS and Payroll category. He has very kindly agreed, so welcome aboard Thierry!! You can read Thierry’s membership profile here or if you’re a member you can e-mail Thierry via the profile e-mail console.

Page 3 of 3 pages  < 1 2 3