Implementing Oracle Hrms : my daily adventures

Making Quickpay faster

2012-01-15T18:05:00.001+01:00

For years we know that quickpay is not the fastest payroll process, and we pointed to the wait time of the concurrent manager. But we had a closer look, and saw that even an empty Quickpay took always at least 5 seconds, excluding the time doing nothing in a concurrent queue. A sql trace file was generated at concurrent program level. OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTScall

Some challenges

2011-09-08T13:51:00.001+02:00

Designing a payroll system for a few million employees. Mapping cash management reconciliation, costing of payments, continuous calculations and voiding of payments on the core process.

eBS 12.2 : summer sleep

2011-05-18T20:17:00.002+02:00

We went throught the updated RCD docs today on metalink and very little has been added for HCM. Succession planning got some extra features.For Payroll, they only announced that Enhanced Retropay will be the only supported flavor of Retropay. So when you upgrade to 12.2, and your localisation is not yet on Enhanced Retropay, you have to pay attention.

Fusion HCM

2011-04-24T10:27:00.003+02:00

The radio silence of Oracle around Fusion is over. Last week a webcast explained the Next Generation of Hr software in the cloud.If the Easter tea leaves are right, Fusion HCM will be available within a few weeks. Fusion Talent management will be Saas-ed by Oracle.

mission accomplished : apex on apps

2011-04-22T10:46:00.004+02:00

Years ago we developed a solution to integrate Apex with Oracle's eBusiness suite.It worked fine on 11i, and we came with a jsp solution for some of our initial R12 customers.We had sometimes the "Apex is not supported by Oracle for the EBusiness Suite" discussion.On the Apex site you can now read the "official" white paper how to integrate Apex on Apps. You should be on a recent 12.1.3, and it

Upgrade stories : Web Adi again

2011-02-18T14:29:00.002+01:00

We had a nasty web ADI issue on a few of the upgraded instances. It worked before, it works on some other R12 instances, but we are not able to make it working again.It throws all the time "Mail Merge Aborted due to error in creating the Mail Merge Data Source". Nothing in the log files.Escalated the P2, but no reactions from support side. After some background fighting, a senior support analyst

Upgrade stories : Apex integration

2011-02-18T14:22:00.002+01:00

The security model in 12.1.3 is a little bit more picky, so we had to add a few more configuration steps to made the secured HR views working again. Without these 2 steps, the secured views returned 0 rows.First, we registered the APEX_PUBLIC_USER in eBS via the regular Forms, and then a little update was needed to make it working. update fnd_oracle_userid a set a.read_only_flag = 'U' where

No electricity, but the application is up

2011-02-10T08:38:00.002+01:00

Dakar is having more troubles then normal with electricity. Never thought that the SaaS model would be that useful when the light goes out. And the extra battery in the office dies, and the router goes down. But you still can access the application over your smartphone and finish your payroll run.And hope you can charge your phone's battery some time in the evening ...

Payroll 13th month

2010-12-20T19:33:00.002+01:00

A monthly payroll has 12 periods, but a customer requested a 13th run, so that all corrections made over 2010 would still be processed in 2010.By using the standard processes a little bit smarter, we achieved the goal.Retropay was launched so that the differences were created in December again.The Payroll ran again for December with an element set, that contained only retro element types. So only

Upgrade stories : Bursting

2010-10-29T13:12:00.002+02:00

The parameters of the concurrent "XML Publisher Report Bursting Program" have changed between 11i and R12. Oracle added a new parameter, before the previously defined 2 parameters.The new and hidden parameter is called "Dummy for Data Security", and is defaulted by "select xdo_cp_data_security_pkg.get_concurrent_request_ids from dual".

Upgrade stories : Web Adi error

2010-09-12T09:46:00.002+02:00

Launching Web ADI from HR forms throws a http 404 error under Internet Explorer. Firefox shows a more meaningful "Resource /OA_HTML/oracle.apps.bne.webui.BneApplicationService not found on this server".After some digging, it was found that the web html call of seeded and custom Web ADI forms functions had 'oracle.apps.bne.webui.' before 'BneApplicationService'.It looks like the upgrade scripts do

Upgrade stories : 12.1.2 or 12.1.3

2010-09-12T09:33:00.003+02:00

So which version to choose from?12.1.2 is out for a while, so a nice list of fixes exists already. 12.1.3 is new on the block from August 2010 on. Going for this version brings you to the latest and finest verion of the eBusiness Suite. And will fix some previous bugs. And will introduce some new bugs.To make things a little more complicated, Metalink states:"R12.HR_PF.B.Delta.3 (9114911) -

Upgrade stories : Extended support for 11.5.10

2010-09-12T09:17:00.003+02:00

Plan is to blog some articles about ongoing R12 upgrades, within the HCM domain. If you are on 11.5.10 right now :- Premier support ends by November 2010- you are forced into Extended support from December 2010 on- Oracle does not bill extra money for the extended support for the first year- So you pay extra money for Extended support from December 2011 onYou can avoid the extra money, if- you

Retropay by Employee

2010-07-17T10:14:00.002+02:00

I'm posting the last time a lot about Apex. While in reality I'm mainly busy with Oracle Payroll.If your legislation uses advanced or enhanced retropay, there is the RetroNotifications process to run, to identify which employees have retrospective changes.And in a next step, you run the RetroPay process. The enhanced version does not have any assignment set parameter anymore. In other words, the

Apex 4.0

2010-06-18T12:37:00.002+02:00

Oracle will never confirm this, but I guess Apex 4.0 will see the light before the end of the worldcup.This could be understood in between the lines of what was told at the OBUG Apex SIG day in Belgium yesterday.The feature list looks impressive, and with all demonstrations seen yesterday, I have a way better understanding of the way forward.But I'm still wondering how to use Websheets in an

Apex on R12 - patch 7377023

2010-05-01T10:14:00.004+02:00

This patch brings back the good old SSWA plsql menu functions on R12. And in more recent versions of R12, they are part of the base install.That does not mean that the eBS team supports mod_plsql. No. But it gives more possibilities to integrate Apex on Apps.Again:- Oracle supports Apex- Oracle supports mod plsql- Oracle does not support customizations- Oracle eBS does not support customizations-

Fusion on the iPad?

2010-04-06T18:51:00.002+02:00

Too many posts these days about the iPad, so one more will not make the difference.The last (and only) demo I saw from Fusion looked a lot like Flash. But there is not a lot of love lost between Apple and Flash. Meaning that Oracle has still to release their next gen platform, but will not be able to use the next gen client device.

Apex 4.0 Release date

2010-03-01T10:07:00.002+01:00

Patrick Wolf shows again a good reason why we should look forward for the 4.0 release of Apex. Cascading LOVs for dummies.But one little phrase makes me think that the 4.0 production release is not yet for tomorrow. "(Note: Popup LOV and List Manager will be added as well in the final product)". So not yet code complete ...

Busy busy busy

2010-01-23T14:01:00.002+01:00

3 customers are live this month with payroll in the Netherlands. So i hope you understand that there was not that much time to maintain this blog.So 14000 people more receive an Oracle payslip this month.The errors we correct next month with Retropay.

NL Daily tax tables

2009-07-06T21:52:00.002+02:00

Two NL Payroll customers ask in the same week if one can activate the NL daily taxation tables. Coincidence.While i answered the first time NO, except when an employee is hired or fired in the middle of the month, the second time i dived a little deeper in the seeded fast formulas and plsql functions, to discover a hidden fast formula to configure.Define the fast formula

Apps - Apex on R12

2009-04-08T15:16:00.002+02:00

We just got the Apps-Apex integration working on R12.Yes you need a separate Apache server, but the rest is almost the same. Nothing has to be changed within the Apex application, you still set the VPD call to initialize the apps session. Only the menu function to launch Apex from is changed from a plsql based one, into a jsp menu function. So yes, an extra jsp page needs to be compiled on the

Exit 2.0 & SOA

2009-02-14T14:39:00.002+01:00

The cloud is now the buzzword. SOA and Web 2.0 are losing popularity.I tried also to translate Web 2.0 concepts into HR processes, but no luck. It looked good on the powerpoint, but not on the workfloor. Oracle Fusion development started within the SOA and 2.0 hype period. Curious how marketing will convert that into the buzzword popular at the time Fusion will pop up.Good things is that

One more customer on R12

2009-01-27T18:25:00.002+01:00

One of our HR customers in the Netherlands upgraded to R12 last weekend. It was mainly a technical DBA exercise. Operating system became linux, the database became a full 10 and the upgrade scripts pumped the eBusiness Suite up to the 12.0.6 level.

Release 12.1: Oracle Payroll for India

2009-01-24T20:43:00.003+01:00

I never saw a functional business driver to migrate towards the 12 Release. R12.1 should overcome that. I hope. I hoped. For payroll, only some stuff for our India colleagues is present.For some more details in the other HR modules, check the RCD doc.

back to basics

2008-11-22T10:53:00.002+01:00

We wanted to extend the Dutch localization so that the mandatory assignment extra info fields where defaulted automatically when entering a new employee.First step was to cook up some plsql, based on api's, that creates the assignment extra infos. Easy.Now we only need to fire that code when they create a new employee.So a user hook would be nice, but since the assignment screen is still not