Ora-01403

[vamsioracle]

Hi all,

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

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


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

Vamsi

[OraMaster]

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

[amitpatel66]

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?

[vamsioracle]

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

[amitpatel66]

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

[vamsioracle]

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.