Home » Applications » Oracle Fusion Apps & E-Business Suite » ORA-20001: You cannot update an approved salary date.
ORA-20001: You cannot update an approved salary date. [message #295948] Thu, 24 January 2008 00:13 Go to next message
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 messageGo to next message
Littlefoot
Messages: 20894
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 messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
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 #296082 is a reply to message #295948] Thu, 24 January 2008 09:41 Go to previous messageGo to next message
vamsi_opt1
Messages: 4
Registered: January 2008
Junior Member
Thanks Littlefoot.

I am raising a TAR with oracle on this. There should be some way of updating the salaries with the API.

Thanks for your suggestions.
--Vamsi.
Re: ORA-20001: You cannot update an approved salary date. [message #296084 is a reply to message #296082] Thu, 24 January 2008 09:50 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Check the Metalink first, before raising the TAR.

By
Vamsi
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 messageGo to next message
Littlefoot
Messages: 20894
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.
Re: ORA-20001: You cannot update an approved salary date. [message #296231 is a reply to message #296132] Fri, 25 January 2008 03:28 Go to previous message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Agreed.... Cool
Previous Topic: Oracle Manufacturing Functional Documents
Next Topic: How is Siebel CRM better then EBiz CRM ???
Goto Forum:
  


Current Time: Mon Dec 05 10:40:33 CST 2016

Total time taken to generate the page: 0.09364 seconds