Unable to terminate applicant [message #266278] |
Mon, 10 September 2007 06:18 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
spjk
Messages: 4 Registered: September 2007
|
Junior Member |
|
|
hi all,
i am unable to terminate an applicant.
while terminating an applicant in oracle hrms screen we are getting the following error
ORA-01403: no data found
ORA-06512: at "APPS.PER_APPLICATIONS_PKG", line 2338
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-01403.
please let me know the way to resolve this error.
Steps
--------
1. Create an applicant on 01-Jan-2007
2. Give an address detail for him
3. Date track to 15-Jan-2007
4. Go to ‘End Application’ form.
5. Give Terminated date as 15-Jan-2007 and click on Terminate button. The error pops up at this stage.
thanks,
|
|
|
Re: Unable to terminate applicant [message #266361 is a reply to message #266278] |
Mon, 10 September 2007 11:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
I'm not familiar with the product(s) you use, but here's what happened: there's a SELECT statement in the ON-UPDATE trigger (or is being called by this trigger, somewhere from the package) which doesn't return anything and, moreover, author "forgot" to include the exception handler to deal with the NO-DATA-FOUND error.
Do you have access to this code?
Did you, perhaps, not enter required information which caused code not to work properly?
|
|
|