Data not visible in _VL AND _TL tables ORACLE APPS

            HOW TO SELECT DATA FROM _VL TABLES


Some times we will not be able to see the data in _vl tables in TOAD or SQL DEVELOPER when others are able to see the same data.

The reason for this is the USERENV('LANG') is set to 'GB'

When you run query select USERENV('LANG') FROM DUAL you get 'GB'

Actually _vl tables gets the data from _tl tables with condition USERENV('LANG')='US'


Solution:

We can change the NLS Lang parameters.

SQL Developer: Go to SQL Developer -> Tools -> Preferences..>Database ->NLS
Set the Language ='AMERICAN', Territory ='AMERICA' , Date Lanugage ='AMERICAN'

Now you can select data from _vl table


TOAD: Go to Toad -> Database ->Administer->NLS Parameters
Set the NLS_LANGUAGE='AMERICAN' ,NLS_DATE_LANGUAGE ='AMERICAN'

Now you can select data from _vl table