5.1 Configuring Report Lock Period

If a user forgets to log off from the OFSRR application or if the OFSRR screen is closed while accessing a report, the report gets locked for a pre-configured duration. By default, the duration is 60 minutes. This duration can be altered as per your requirement.

To alter the duration, execute the following SQL using OFSRR atomic schema user:

UPDATE APPLN_PARAMETERS SET V_ATTRIBUTE_VALUE1= '<DURATION IN MINUTES>' WHERE V_ATTRIBUTE_NAME1= 'LOCK PERIOD IN MINUTES';

COMMIT;