Financial Report Writer: Error - The row template is currently being used.

Issue:
The user receives warning message (see below) when entering particular report number under Reports>Miscellaneous Reports>Financial Report Writer.


‘The row template is currently being used. Please choose another row template.’

Cause:
This issue is caused when record for the particular report exists in t_gls_lock.

Solution:
1. Get equivalent rep_code of report_no with issue in a_misc_report_def
2. Check which user is using the report in t_gls_lock.
3. Check u_audit_trail_users if the user using the report is logged in
3.1. If the user using the report is not logged in, perform script below:
delete from
t_gls_lock
where rep_code = [rep_code with issue]
3.2. Else, check u_audit_trail_users to verify what program the user is in
3.2.1. If the program is not Financial Report Writer, execute script from 2.1
3.2.2. Else, inform user with issue that he/she needs to wait for user using the report.