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
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
Littlefoot
Messages: 20897
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: regarding more inf for Vocation Rule
Next Topic: Territory Management R12
Goto Forum:
  


Current Time: Wed Dec 07 08:48:48 CST 2016

Total time taken to generate the page: 0.11208 seconds