We've got a problem when trying to change Rounding Factor
for a a currency (€).

Error message is :
Currency still used in other file; cannot delete or change.

In 'log.oracle8' :
Log_mesg: Refcntd = 8 for tcmcs002 ( key `EUR` ) => can't delete


My question is, what are these two fields 'refcntd' and 'refcntu', in table 'tcmcs002' ?

Can I just update the table and set the value of these fields to 0 ?

/ Vesa

Aren't those ref* fields the reference counters?

It are indeed the reference counters. I guess the right way to fix this is to reorganize the table with repair reference counter option.

However if you are sure for yourself that they are no longer used you can update them as well with sqlplus. But....
I am not sure if Customer Support will like that!

Rgrds,
Han