Posts tagged Compensation
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 />
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…)