What languages and currencies are enabled in EBS
One of my colleague asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:
select language_code
from fnd_languages
where installed_flag='I'
For currencies, I told him that in EBS all currencies are enabled. I executed the following query:
select CURRENCY_CODE,symbol
from apps.fnd_currencies
where enabled_flag='Y'
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:
select object_name,bytes
from dba_segments
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(*)
from apps.gl_interface
group by currency_code; 2 3
CURRENCY_CODE COUNT(*)
--------------- ----------
VND xxx
EUR xxx
USD xxx
SGD xxx
JPY xxx
VND = Vietnamese Dollar
SGD = Singapore Dollar
JPY = Japanese Yen
EUR = Euro
USD = US Dollar
One of my colleague asked me about the languages and currencies being used in a new instance which has gone live. For languages we have this query:
select language_code
from fnd_languages
where installed_flag='I'
For currencies, I told him that in EBS all currencies are enabled. I executed the following query:
select CURRENCY_CODE,symbol
from apps.fnd_currencies
where enabled_flag='Y'
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:
select object_name,bytes
from dba_segments
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(*)
from apps.gl_interface
group by currency_code; 2 3
CURRENCY_CODE COUNT(*)
--------------- ----------
VND xxx
EUR xxx
USD xxx
SGD xxx
JPY xxx
VND = Vietnamese Dollar
SGD = Singapore Dollar
JPY = Japanese Yen
EUR = Euro
USD = US Dollar
0 comments:
Post a Comment