Oracle E-Business Suite
Oracle E-Business Suite aka Oracle Applications, PeopleSoft, Siebel, JD Edwards and Retek related articles.
Oracle Workflow, a brief introduction – Part 1 Setting up an environment
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 >
Oracle Data Mining meets performance method "GAPP"
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 >
Incentive Compensation – Classification Ruleset stays in status Install Pending.
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 />
How to change the retained earnings account in General Ledger
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.
Oracle Incentive Compensation – bad performance due to Custom Flag setting
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…)
Not able to open forms pages
Last week I installed some updates for windows and internet explorer. After installing I tried to open a form page, but instead of opening forms my internet explorer disappeared without any warning. (more…)
Recent Comments