[OFBIZ-12153] Error in deleting Financial Account

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 17.12.06, 18.12.01
• Component/s: accounting
• Assignee: Pawan Verma
• Reporter: Lalit Dashora
• Created: 23/Jan/21 11:33
• Updated: 15/Mar/21 07:55
• Resolved: 15/Mar/21 07:55

Description

1. Navigate to URL: accounting/control/FindFinAccount
2. Click on Find button. List of fin account will be displayed.
3. Click on delete button near available balance column.

The Following Errors Occurred:
Error doing entity-auto operation for entity FinAccount in service deleteFinAccount: org.apache.ofbiz.entity.GenericEntityException: org.apache.ofbiz.entity.GenericDataSourceException: Exception while deleting the following entity: [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key (SC_CHECKING). The statement has been rolled back.)) (Exception while deleting the following entity: [GenericEntity:FinAccount][finAccountId,SC_CHECKING(java.lang.String)] (SQL Exception while executing the following:null (DELETE on table 'FIN_ACCOUNT' caused a violation of foreign key constraint 'FINACT_STTS_FNA' for key (SC_CHECKING). The statement has been rolled back.)))