Oracle E-Business Suite
Oracle E-Business Suite aka Oracle Applications, PeopleSoft, Siebel, JD Edwards and Retek related articles.
Last night, the AMIS crew that visited the Oracle Open World conference reported their findings in a 3.5 hour session. In segments on SOA & BPM, Middleware, Database, Oracle Applications (AIA) and Development technology, we presented the highlights from close to 1900 sessions – no small feat. And utterly incomplete of course. However, all in all, for people who did not attend the "red party" the evening gave a very useful overview of what Oracle is doing and where it is heading.
Maybe the following question will arise after reading the title: Oracle Workflow isnâ€™t that obsolete technology?
The answer can be very short: Yes it is. (Read the SOD on http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html)But itâ€™s still interesting enough to dive into it. Oracle Workflow is heavy used in the E-Business Suite and also used by Warehouse Builder, with, in both cases, workflow customizations. There are also a lot of customers using the standalone variant. Imagine they all want to convert to Oracle BPELâ€¦ Then it would be nice to know something about it.
In the next (at least) 3 blogs, i will give you a brief look into the world of Oracle Workflow, consisting of the following subjects:
â€¢ Building a simple workflowâ€¢ Setting up a workflow with email communicationâ€¢ Using the Business Event System
What do you need for a start?Download the Oracle database 10.2.0.1 and the corresponding Companion CD from OTN. You also need the Workflow builder software (in a later stage). It can be found at the following link: http://www.oracle.com/technology/software/products/workflow/index.html
The basic installation of the database software with More >
Sunday 21 September 2008 at Oracle Open World, I had the opportunity to present my method "GAPP" once more (HOTSOS 2008 and Planboard may 2008). This time I also mentioned how the method can be used with Service Oriented Architectures (SOA). For people not knowing what "GAPP" is all about I give a small introduction to the method. I also like to tell you why I started with â€œGAPPâ€ in the first place and what the added value is of the method above other methods.
"GAPP" means General Approach Performance Profiling and can be used to find out where in your architecture the most wait time variance can be explained from your business process. "GAPP" makes it possible with very little data, in higly complex technical infrastructures, still be able to find the performance bottlenecks for a specific business process. The nice thing about the method is that it is not only able to pinpoint a bottleneck which is already there, it is also able to pinpoint a future bottleneck in a normal running system. This is something what only "GAPP" can do.
What makes â€œGAPPâ€ special:
- The method can analyse the full infrastructure, so from front-end to back-end
- The method is not focussing on one More >
Recently we where doing a test at our customer site and part of that test was changing an existing Classification Ruleset. This had been done before, but for some reasons when we tried it then the Synchronization of the Rulesets completed successfully but the Ruleset itself stayed in status Install Pending. With a Ruleset in this status you canâ€™t do any calculations in Oracle Incentive Compensation.We looked at metalink but couldnâ€™t find anything. We issued a SR with Oracle, they couldnâ€™t find anything either and kept us waiting for over 2 month. In the meanwhile another project also required us to change the Ruleset, but we couldnâ€™t wait much longer. So I started working my way to the trace files for the Synchronize Rulesets myself. A big file with a large number of queries. It was the first time Iâ€™ve really looked at a trace file so maybe I was a bit lucky when I stumbled upon this step:select oracle_username <br />from<br />APPS.fnd_oracle_userid where install_group_num = 1 and read_only_flag = 'U' <br />
Changing the retained earnings account in General Ledger is pretty easy. Just go to the define Set of Books form and change the retained earnings account. But is this a proper method?No it isn’t. If you change the retained earnings since 11i there will be a warning displayed. In this warning also the steps that you have to perform are displayed.This warning appears if you change the retained earnings account from one account into another account. Off course this new account must exist in your SOB.
While implementing some additions to the existing Oracle Incentive Compensation implementation at our customer site we got complaints from the end users about the performance of some of the processes in Incentive Compensation.
Specifically adding a new rate table to an existing plan element was taking a lot more time then expected. At our customer site this is actually done using a customization which first duplicates all existing rate tables of one month to the next month and then, after updates are made by the users, links the new tables to the existing plan elements. This linking process was taking about 25 minutes. (more…)