ERROR: ORA-12560: TNS:protocol adapter error: No listener.

Problem: You are trying to access oracle database using sqlplus, or using forms builder, or using oracle reports builder and Toad. ERROR: ORA-12560: TNS:protocol adapter error: No listener. Solution: check the status of the Database listener by Running the Command Prompt with this code : lsnrctl status if the command completed unsuccessfully start the Listener […]
Continue reading…

 

Error REP-0756 Unable to find PL/SQL library ‘inv.pll’ when Opening a Report in Oracle Reports Builder

You are trying to open a Report in Oracle Reports Builder and you are getting an error: Error REP-0756 Unable to find PL/SQL library ‘inv.pll’… Login to the Application Server under $AU_TOP/plsql. Copy the file inv.pll to your PC. Open the report again in Oracle Reports Builder. When the error pops up … open the inv.pll file from […]
Continue reading…

 

Oracle Views return no data due to NLS LANGUAGE Settings

In Oracle E-Business Suite, and if there are multiple languages installed, and if you are not able accesses data from tables like fnd_lookup_values_vl or any other VL tables. Usually views with a condition of: LANGUAGE = USERENV (‘LANG’)in the where clause will not return data if the NLS LANGUAGE is not setup correctly. Set USERENV(‘LANG’) […]
Continue reading…