Home » Applications » Oracle Fusion Apps & E-Business Suite » Unable to terminate applicant
Unable to terminate applicant [message #266278] Mon, 10 September 2007 06:18 Go to next message
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.

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.


Re: Unable to terminate applicant [message #266361 is a reply to message #266278] Mon, 10 September 2007 11:41 Go to previous message
Messages: 21148
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?
Previous Topic: Procudure
Next Topic: Territory Management R12
Goto Forum:

Current Time: Mon Aug 21 11:01:44 CDT 2017

Total time taken to generate the page: 0.01349 seconds