NLS_LANGUAGE FOR R12 In client/SQL Developer

[admin]

If you are connected with Oracle EBS R12 instance and trying to get data but it is showing no record then do this setting,

1. select * from hr_operating_units;
no data

2.ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN';

select * from nls_session_parameters;

3. select * from hr_operating_units;
Now it will show data.

if you are using Oracle SQL developer then do these setting,

Tools>Preferences>Database>NLS: Language = AMERICAN