Raghava asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:
For currencies, I told him that in EBS all currencies are enabled. I executed the following query:
It returned 71 rows.
Total rows in fnd_currencies was 249.
However, I thought of a more logical way of getting this data. That would be to query transaction tables. Which transaction table to query here ? I queried dba_segments for the largest objects:
order by bytes desc;
After the usual fnd_lobs etc., gl_interface table came up. So I created this query:
SQL> select currency_code,count(*)
group by currency_code; 2 3
VND = Vietnamese Dollar
SGD = Singapore Dollar
JPY = Japanese Yen
EUR = Euro
USD = US Dollar
I feel that this query does give a good estimate about the currencies in use.
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps