Finding the Languages Installed in Oracle Applications

Finding the Languages Installed in Oracle Applications

The below query can be used for the finding the languages installed in Oracle Application.

SELECT Language_code, NLS_language, Installed_flag
  FROM fnd_languages
 WHERE installed_flag IN ('I', 'B')

The Installed_Flag has 3 values

I- Installed

B- Base

D- Disabled

 

 

 

Tables which are purged with FND_CONC_CLONE.SETUP_CLEAN

When EXEC FND_CONC_CLONE.SETUP_CLEAN is executed various tables are purged.

To know which tables are purged/cleaned we can view $FND_TOP/patch/115/sql/AFCPCLNB.pls

 

Thanks 

Srini