Technology Stack - EBS (MOSC)

MOSC Banner

HR_PERSON_ABSENCE_API.create_person_absence Troubleshooting

edited Aug 20, 2021 11:00AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi I am trying to create absence record for employee using HR_PERSON_ABSENCE_API.create_person_absence.

But every time I run the script I receive below err:

         

ORA-01403: no data found

Below is the code I am using with minimum required parameters:

DECLARE

    L_ABSENCE_ATTENDANCE_ID       NUMBER;

    L_OBJECT_VERSION_NUMBER       NUMBER;

    L_OCCURRENCE                  NUMBER;

    L_DUR_DYS_LESS_WARNING        BOOLEAN;

    L_DUR_HRS_LESS_WARNING        BOOLEAN;

    L_EXCEEDS_PTO_ENTIT_WARNING   BOOLEAN;

    L_EXCEEDS_RUN_TOTAL_WARNING   BOOLEAN;

    L_ABS_OVERLAP_WARNING         BOOLEAN;

    L_ABS_DAY_AFTER_WARNING       BOOLEAN;

    L_DUR_OVERWRITTEN_WARNING     BOOLEAN;

    L_ABSENCE_DAYS                NUMBER := NULL;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center