Hi,

this happens because you have specified wrong index number here is the example of how this error are raised:

alphabet=[‘a’,’b’,’c’];print(alphabet[3])
IndexError: list index out of range

in above example we want to to print the last element in the list which is (‘c’), but we have passed the wrong index number because the correct one is print(alphabet[2]).

that’s because list index starts with 0 not with 1

This example have been taken from this article here

you can refer to it for better understanding.

I hope this will help you.

Hi albert

To fix this error, you will need to apply the following:

1. Go to %DOMAIN_HOME%\config\fmwconfig\servers\WLS_REPORTS\applications\reports_11.#\configuration and open rwservlet.properties (make a backup first).
2. Add the following parameter below the <inprocess> parameter:
   • <!–webcommandaccess>L1</webcommandaccess–>
   • Then change the value from L1 to L2
   • <webcommandaccess>L2</webcommandaccess>
3. Save and close the file
4. Restart WLS_REPORTS

Hello mahendra try this code now :

SELECT DISTINCT PAA.ABSENCE_ATTENDANCE_ID
               ,PAA.ABSENCE_ATTENDANCE_TYPE_ID
               ,PAA.ABS_INFORMATION1
               ,PAA.PERSON_ID
               ,PAPF.FULL_NAME FNA
               ,PAPF.EMAIL_ADDRESS EM
               ,PAA.REPLACEMENT_PERSON_ID
               ,PAPF1.FULL_NAME FNR
               ,PAA.AUTHORISING_PERSON_ID
               ,PAPF2.FULL_NAME FNAUT
               ,PAA.DATE_NOTIFICATION
               ,PAA.DATE_START
               ,'\ \\\\\\for a period of \\\\\\\' || PAA.ABSENCE_DAYS || '\\\\\\\ days up to\\\\\\\'
               ,PAA.DATE_END
INTO   &ABSENCE_ATTENDANCE_ID
      ,&ABSENCE_ATTENDANCE_TYPE_ID
      ,&ABS_INFORMATION1
      ,&PERSON_ID
      ,&FULL_NAME
      ,&EMAIL_ADDRESS
      ,&REPLACEMENT_PERSON_ID
      ,&FULL_NAME
      ,&AUTHORISING_PERSON_ID
      ,&FULL_NAME
      ,&DATE_NOTIFICATION
      ,&DATE_START
      ,&ABSENCE_DAYS
      ,&DATE_END
FROM   PER_ABSENCE_ATTENDANCES PAA
      ,PER_ALL_PEOPLE_F PAPF
      ,PER_ALL_PEOPLE_F PAPF1
      ,PER_ALL_PEOPLE_F PAPF2
WHERE  1 = 1
AND    PAA.ABSENCE_ATTENDANCE_ID = 132128
AND    PAA.PERSON_ID = PAPF.PERSON_ID
AND    PAA.REPLACEMENT_PERSON_ID = PAPF1.PERSON_ID(+)
AND    PAA.AUTHORISING_PERSON_ID = PAPF2.PERSON_ID(+)
AND    TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF1.EFFECTIVE_START_DATE AND PAPF1.EFFECTIVE_END_DATE
AND    TRUNC (SYSDATE) BETWEEN PAPF2.EFFECTIVE_START_DATE AND PAPF2.EFFECTIVE_END_DATE

but in the next time you create a question could you please leave more details about what you are trying to do or the error text along with error code you face to be able to help you efficiently.