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 />

(more…)