ANC_ABS_TYP_NAME returned no data — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ANC_ABS_TYP_NAME returned no data

edited Aug 13, 2025 8:46AM in Workforce Management 1 comment

Summary:

We have a validation fast formula for a leave type for which we are trying to fetch the data for ANC_ABS_TYP_NAME. The formula is working for some employees but not working for few.

The error while applying for the leave is as follows: An error has occurred. (ANC-3405194) Contact your absence administrator with the following details: Module ProcessesCommon, Method executeAbsenceFastFormula and Error Exception during fast formula execution. ORA-20001: Formula ANNUAL_LEAVE_VALIDATION, line 619, no data returned. Details: Item ANC_ABS_TYP_NAME returned no data. This error most commonly occurs when a database item query returns no data, but the database item is configured not to allow no return data. It can also occur within a formula function call. ORA-06512: at "FUSION.FF_EXEC", line 3796 ORA-06512: at "FUSION.FF_EXEC", line 397 ORA-06512: at "FUSION.FF_EXEC", line 3710 ORA-06512: at

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!