[
https://issues.apache.org/jira/browse/OFBIZ-12153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17301180#comment-17301180
]
Jacques Le Roux commented on OFBIZ-12153:
-----------------------------------------
Thanks Pawan,
Works on both R17 and R18, + for commit
> 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
> Assignee: sourabh jain
> Priority: Major
> Attachments: FinAccountDelete.png, OFBIZ-12153.patch,
> OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch, OFBIZ-12153.patch,
> OFBIZ-12153.patch
>
>
> 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)
