Ora-01403

Hi all,

I get this error suddenly when i try to apply a leave from the self service hrms.

Formula BG_ABSENCE_DURATION:Ora-01403.No data found ORA-01403: mo data found cause.


I got this suddenly. There were no changes to the Test.

Vamsi

re: Ora-01403

BG_ABSENCE_DURATION is this function or procedure? Please post the complete code so that you will get desire solution.

re: Ora-01403

Are you trying to input lots of data which is causing no data found exception?
Provide more detail on what exactly you are trying to input when applying for leave?

re: Ora-01403

Hi amit,

Bg_absence duration is the seeded fast formula that is used for business validations.

At the time of applying leave, we input the leave type, dates and the reason.

How ever the error subsided automatically without any change. This occurs occasionally. Any specific reason for this


vamsi

re: Ora-01403

Vamsi,

Is it possible for you to post the fast formula code here for reference? It occurs occasionally becuase based on the input that you are giving, the database is not returning any value which is causing NO DATA FOUND exception

re: Ora-01403

HI Amit,

I checked with the DBA and found that the bg_absence duration formula is not used at all from a long time, in the instance i tried to make changes. Now when i made changes, it became invalid and we got this error app-pay-33681.

I will post the fast formula in my next post, i need to get it from the DBA.