ORA-20001: HR_51855_QUA_CCY_INV

Getting the error ORA-20001: HR_51855_QUA_CCY_INV when creating the pay element.


Select * From Fnd_New_Messages
where message_name='HR_51855_QUA_CCY_INV'

This currency code is invalid as it does not exist in the fnd_currencies table.


I have verified the Currency and its enabled. And checked the API parameters and all..The error message is  not clear to debug. Finally set the p_effective_date  => '01-JAN-1951'  from SYSDATE then its working.

Cannot find a J2SE SDK installed ( Sql Devloper)

Steps to add path in Windows 7 64bit is as follows:

1. Right click on My computer, then click on properties.
2. On left pane click on "Advanced system settings".
3. Click on "Advanced>Envionment Variables"
4. In system variables box under Variable column look for text "Path".
5. Select that row and click on Edit. 
6. In "Variable Value" text box append the path of java installation seperated by other path with ";" in my case I appened it with ";C:\Program Files\Java\jdk1.7.0\bin"
7. Then just click on ok and then run the application which is giving you this error.