13 Replies Latest reply on Oct 12, 2013 4:07 PM by 3868a729-3d39-4606-a63c-45b90daf46fe

    absence reason in BG_ABSENCE_DURATION

    igwe
      Hello, is the a way to check the absence reason in the BG_ABSENCE_DURATION formula?
      I have a requirement to set the duration to a specific value when the reason for a leave type is a certain value.
      I looked at patch 14639948 but it doesn't seem to contain absence_attendance_reason_id or anything similar.
      Many Thanks
        • 1. Re: absence reason in BG_ABSENCE_DURATION
          clive_t
          There doesn't seem to be any database items around absence reasons. I guess you could write a simple UDF to retrieve it?

          Clive
          • 2. Re: absence reason in BG_ABSENCE_DURATION
            igwe
            Hi Clive, sorry but what is a UDF?
            • 3. Re: absence reason in BG_ABSENCE_DURATION
              clive_t
              My apologies, a UDF or User-Defined Function is a piece of pl/sql which is written to retrieve the information you want, which when registered within the application becomes available for use in Fast Formula.
              • 4. Re: absence reason in BG_ABSENCE_DURATION
                igwe
                Thanks for the explanation Clive. Problem is, there is no entry point for doing this as the absence is not saved yet.
                I noticed I can use inputs like ABS_INFORMATION1, ABS_INFORMATION2 e.t.c
                What I have done is to add a forms personalization.
                When validate record, I set ABS_INFORMATION1 to the absence reason.
                Thanks for the input
                • 5. Re: absence reason in BG_ABSENCE_DURATION
                  igwe
                  Sorry, these are the steps:

                  1. Modify DFF (Additional Absence Detail Information)

                  Set the following:

                  Code - SA (legislation code for your business group)
                  Name - Saudi Legislation (or whatever name you want to give)
                  Description - Saudi Flex Segments (or whatever description you want to give)

                  Create Segments:

                  10 - Absence Reason - Value Set (LEAVE_REASONS, this can link to the ABSENCE_REASONS lookup) - segment ABS_INFORMATION1

                  2. In BG_ABSENCE_DURATION formula:

                  INPUTS ARE days_or_hours(text),
                  date_start (date),
                  date_end (date),
                  time_start (text),
                  time_end (text),
                       ABS_INFORMATION1 (text),
                  ABSENCE_ATTENDANCE_TYPE_ID (Number)

                  DEFAULT FOR days_or_hours IS 'D'
                  DEFAULT FOR time_start IS '09:00'
                  DEFAULT FOR time_end IS '17:00'
                  DEFAULT FOR date_start IS '0001/01/01 00:00:00' (DATE)
                  DEFAULT FOR date_end IS '4712/12/31 00:00:00' (DATE)
                  DEFAULT FOR ABS_INFORMATION1 IS ' '

                  We can then use ABS_INFORMATION1 or any segment in our absence duration formula
                  • 6. Re: absence reason in BG_ABSENCE_DURATION
                    Vigneswar Battu
                    Sorry, dint see the thread.
                    Yes this is supported only from 12.1.1
                    More info below -
                    How To Access The DFF Additional Absence Detail Information Segments In The BG_ABSENCE_DURATION Fast Formula? [ID 1124769.1]
                    • 7. Re: absence reason in BG_ABSENCE_DURATION
                      igwe
                      Thanks Vignesh, took me a while to figure a way round that one
                      • 8. Re: absence reason in BG_ABSENCE_DURATION
                        Sanjay Singh
                        Hi iqwe,

                        We too had same kind of requirement where in we needed the absence reason to determine some validation.

                        in R.12.1.3 you can directly use ABSENCE_ATTENDANCE_REASON_ID as one of the inputs and achieve your requirement.

                        example
                        INPUTS ARE days_or_hours(text),
                        date_start (date),
                        date_end (date),
                        time_start (text),
                        time_end (text),
                        ABS_INFORMATION_CATEGORY (text),
                        ABS_INFORMATION1(text),
                        absence_attendance_type_id,
                        absence_attendance_id,
                        ABSENCE_ATTENDANCE_REASON_ID

                        Thanks,
                        Sanjay
                        • 9. Re: absence reason in BG_ABSENCE_DURATION
                          Dinesh Kumar Raju

                          Hi Sanjay,

                          Could you please let me know more details about ABSENCE_ATTENDANCE_REASON_ID in BG_ABSENCE_DURATION. I have similar requirement and we are using R12.1.3. Am trying to use this parameter and is giving error "The definition of the absence duration Fast Formula is incorrect. Please ask your System Administrator to verify that the inputs and outputs of the formula are passed and that they are of the correct type."

                           

                           

                          Thanks,

                          Dinesh

                          • 10. Re: absence reason in BG_ABSENCE_DURATION
                            3868a729-3d39-4606-a63c-45b90daf46fe

                            Hello,

                            I'm  stumped with the following absence management requirement:

                            We need to restrict the Eligibility of absences based on the absence reason,   tried passing the  abs_attendance_reason_id to the

                            BG_ABSENCE_DURATION but can't get that to work. This would have to work in r12   12.1.3. 

                            Thank you upfront for any input/help. 

                            • 11. Re: absence reason in BG_ABSENCE_DURATION
                              3868a729-3d39-4606-a63c-45b90daf46fe

                              Hi Sanjay,

                              Could you please let me know more details about ABSENCE_ATTENDANCE_REASON_ID in BG_ABSENCE_DURATION. I have similar requirement and we are using R12.1.3. Am trying to use this parameter and is giving error "The definition of the absence duration Fast Formula is incorrect. Please ask your System Administrator to verify that the inputs and outputs of the formula are passed and that they are of the correct type."

                               

                               

                              Thanks,

                              Dinesh

                               

                              Hi Dinesh,

                               

                              Getting the same error with our R12.1.3

                              Did you ever get this resolved ?

                               

                              Thanks,

                              Victor

                              • 12. Re: absence reason in BG_ABSENCE_DURATION
                                Sanjay Singh

                                Hi Dinesh,

                                 

                                ABSENCE_ATTENDANCE_REASON_ID is available in BG_ABSENCE_DURATION as one of the inputs, try using it as below:

                                 

                                INPUTS ARE days_or_hours(text),

                                           date_start (date),

                                           date_end (date),

                                           time_start (text),

                                           time_end (text),

                                           ABS_INFORMATION_CATEGORY (text),

                                           ABS_INFORMATION1(text),

                                           absence_attendance_type_id,

                                           absence_attendance_id,

                                           ABSENCE_ATTENDANCE_REASON_ID

                                 

                                Thanks,

                                Sanjay

                                • 13. Re: absence reason in BG_ABSENCE_DURATION
                                  3868a729-3d39-4606-a63c-45b90daf46fe

                                  Hi Sanjay,

                                   

                                  Getting the following error when using absence_attendance_reason_id , any ideas why ?

                                   

                                    "The definition of the absence duration Fast Formula is incorrect. Please ask your System Administrator to verify that the inputs and outputs of the formula are passed and that they are of the correct type."



                                  Thank You for the prompt reply.

                                  Victor