| Unable to terminate applicant [message #266278] |
Mon, 10 September 2007 06:18  |
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  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
