500 Internal Server Error

oracle.apps.fnd.common.AppsException: oracle.apps.fnd.common.PoolException: Exception creating new Poolable object.

If you are getting the above error while running the page from Jdeveloper that means you have opened so many sessions and not logged out them.

For this you will have to ask DBA to kill the sessions.

Once you start running page from JDeveloper, every time log out instead of directly closing the window.

if it does not solve the issue then run below query in sql developer.

SELECT node_id,

 platform_code,

 support_db D,

 support_cp C,

 support_admin A,

 support_forms F,

 support_web W,

 node_name,

 server_id,

 server_address,

 domain,

 webhost,

 virtual_ip,

 status

FROM fnd_nodes

ORDER BY node_id;

take server_id value from the above query and put in the DBC file parameters against APPL_SERVER_ID and save the DBC file and retest the issue.

How to find out nth highest salary of an employee

SELECT Salary, id
FROM
(
SELECT Salary,id,DENSE_RANK() OVER(ORDER BY Salary ASC) Row_numbr from emp1
) tbl
WHERE Row_numbr=n

In the above example if you want to find out the 3rd higest salary of an employee, then pass 3 in place of n.