ORA-20001: You cannot update an approved salary date. [message #295948] |
Thu, 24 January 2008 00:13 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vamsi_opt1
Messages: 4 Registered: January 2008
|
Junior Member |
|
|
Hello All,
I am getting an error while updating the salary for an employee - ORA-20001: You cannot update an approved salary date.
I am using the hr_maintain_proposal_api.cre_or_upd_salary_proposal/hr_maintain_proposal_api.update_salary_proposal.
Could you please let me know if there is a way to update an employee's salary/
Thanks In Advance,
Vamsi.
|
|
|
Re: ORA-20001: You cannot update an approved salary date. [message #295959 is a reply to message #295948] |
Thu, 24 January 2008 00:45 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
Oracle errors in range from -20000 to -20999 are specified by user (actually, an application developer). In other words, Oracle corp. didn't create these messages.
The same goes for your exception: 20001 and its text were written by someone who created that piece of an application, so - in order to "update an approved salary date", you'll have to find the author and ask him/her what to do.
Basically, you can't fool Oracle. I believe it was done by a database trigger, so - the only way to override it would be to connect as a schema owner and disable the trigger, modify salary date and enable the trigger again. I'm not sure you have required privileges to do that, so - I'd say that (in your case) salary date can not be modified at all.
However, talk to the developer.
|
|
|
Re: ORA-20001: You cannot update an approved salary date. [message #296078 is a reply to message #295959] |
Thu, 24 January 2008 09:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/45399.jpg) |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
Vamsi,
Are you too busy to look at the Oracle Applications Forum Guide?
At least you could have post the version / release.
Seems it is a valid error with the message_code HR_51349_PYP_CNT_UPD_CHG_DATE. You may check the code in the package hrpypapi.pkb, if you have apps access.
Anyway as it says, "You cannot update an approved salary date."
Littlefoot,Quote: | In other words, Oracle corp. didn't create these messages.
| I think you are intend to say Oracle corp (database team). But as my knowledge, Oracle corp E-Business Suite team creates messages using user defined error codes.
By
Vamsi
[Updated on: Thu, 24 January 2008 09:25] Report message to a moderator
|
|
|
|
|
Re: ORA-20001: You cannot update an approved salary date. [message #296132 is a reply to message #296078] |
Thu, 24 January 2008 15:34 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
vamsi kasina wrote on Thu, 24 January 2008 16:14 | Oracle corp E-Business Suite team creates messages using user defined error codes.
|
ORA-20000, ORA-20001, ORA-20002, ..., ORA-20999 are error messages raised in an application and are written by developers. Basically, I don't care was that particular developer my neighbour, you, me, or someone who works for Oracle corp. in the Oracle Apps. development team.
If there were two stored procedures, both of them might have ORA-20001 and they might look different.
I don't know this product (Apps.) so - I'll allow that developers did use one and only one ORA-20001 there and it was the one OP mentioned.
But in the world outside of Oracle Apps., things really are such as described above.
|
|
|
|