Unable to edit Request Type field configuration after previously deleting a required custom field

Summary

Delete required custom field used for Customer portal will return an error when editing fields in the Request type

Steps to Reproduce

1. Create a new custom field.
2. Add the Custom field in the Request type field. (Project Settings > Request types > Edit fields > Add field > Select (Custom field).
3. Set the custom field to be Required.
   
4. Go to Custom field and delete the custom field
   
5. Go back to Request type settings > Edit fields will return error "Cannot Delete a field that is required by Jira or Jira Service Desk"
   

Expected Results

Jira warns the user that the custom field is used by Customer portal and cannot be deleted. If the user deletes the custom field required by Customer portal, the field in Edit field should be shown properly without error.

Actual Results

No warning when user deleted required custom field used by Customer portal. If we edit the request type that associated with deleted custom field error below will appear.

Workaround

The current workaround is to edit the "AO_54307E_VIEWPORTFIELD" in the database and set the Required value to false.

1. Run below SQL to list out the Request types in the Service Desk

   SELECT * from "AO_54307E_VIEWPORTFORM";
   

   Take note of the ID of the affected request types

2. Run below SQL to list all the field in the request type affected.

   SELECT * FROM "AO_54307E_VIEWPORTFIELD" where "FORM_ID" = <ID from Previous query>;
   

3. Update the deleted customfield value and set the required value to 'f'

   UPDATE "AO_54307E_VIEWPORTFIELD" SET "REQUIRED" = 'f' where "FIELD_ID" = 'customfield_11301';
   

   Please change the "FIELD_ID" to follow your customfield name, in this case the customfield affected is customfield_11301

4. Restart JIRA.