Lalit Dashora created OFBIZ-12153: ------------------------------------- Summary: Error in deleting Financial Account Key: OFBIZ-12153 URL: https://issues.apache.org/jira/browse/OFBIZ-12153 Project: OFBiz Issue Type: Bug Components: accounting Reporter: Lalit Dashora Attachments: FinAccountDelete.png
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.))) -- This message was sent by Atlassian Jira (v8.3.4#803005)