Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025731Openbravo ERPZ. Otherspublic2014-02-13 23:172014-03-21 15:59
Reportermaite 
Assigned ToAtulOpenbravo 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned Tomaite
OBNetwork customerOBPS
Web browser
ModulesAdvanced Payables and Receivables Mngmt
Support ticket26615
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025731: Error when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined
DescriptionError when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined
Steps To Reproduce1. Access Financial Account "Caja" and add any transaction
2. Access "Accounting Configuration" tab and delete records
3. Create new records for "españa" and "international group" general ledgers leaving "Bank Revaluation Gain Account" empty.
4. Come back to "Transactions" tab and try to delete transaction.

Following error will be raised:
Error:
ORA-04091: table ERP_MAIN_ORACLE.FIN_FINANCIAL_ACCOUNT is mutating, trigger/function may not see it ORA-06512: at "ERP_MAIN_ORACLE.APRM_FIN_FINACC_ACCT_CHECK_TRG", line 30 ORA-04088: error during execution of trigger 'ERP_MAIN_ORACLE.APRM_FIN_FINACC_ACCT_CHECK_TRG' ORA-06512: at "ERP_MAIN_ORACLE.FIN_FINANCIAL_ACCOUNT_TRG", line 66 ORA-04088: error during execution of trigger 'ERP_MAIN_ORACLE.FIN_FINANCIAL_ACCOUNT_TRG'
Proposed SolutionProblem is that FIN_FINANCIAL_ACCOUNT_TRG is updating fin_financial_account_acct table and APRM_FIN_FINACC_ACCT_CHECK_TRG is querying FIN_FINANCIAL_ACCOUNT table
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-02-13 23:17maiteNew Issue
2014-02-13 23:17maiteAssigned To => dmiguelez
2014-02-13 23:17maiteModules => Advanced Payables and Receivables Mngmt
2014-02-13 23:17maiteOBNetwork customer => Yes
2014-02-13 23:17maiteSupport ticket => 26615
2014-02-13 23:17maiteTriggers an Emergency Pack => No
2014-02-13 23:18maiteResolution time => 1395270000
2014-02-13 23:18maiteIssue Monitored: networkb
2014-02-14 13:32dmiguelezAssigned Todmiguelez => jonalegriaesarte
2014-02-19 13:11jonalegriaesarteAssigned Tojonalegriaesarte => pramakrishnan
2014-02-27 07:59AtulOpenbravoAssigned Topramakrishnan => AtulOpenbravo
2014-03-04 11:04maiteSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=5523#r5523
2014-03-10 09:56AtulOpenbravoStatusnew => scheduled
2014-03-10 09:56AtulOpenbravofix_in_branch => pi
2014-03-11 06:09AtulOpenbravoNote Added: 0065010
2014-03-21 06:15AtulOpenbravoReview Assigned To => maite
2014-03-21 06:15AtulOpenbravofix_in_branchpi =>
2014-03-21 06:21hgbotCheckin
2014-03-21 06:21hgbotNote Added: 0065322
2014-03-21 06:21hgbotStatusscheduled => resolved
2014-03-21 06:21hgbotResolutionopen => fixed
2014-03-21 06:21hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c6e0222a04cd80c808340436a6468799243d90a6 [^]
2014-03-21 09:08maiteNote Added: 0065336
2014-03-21 09:08maiteStatusresolved => closed
2014-03-21 15:59hudsonbotCheckin
2014-03-21 15:59hudsonbotNote Added: 0065362

Notes
(0065010)
AtulOpenbravo   
2014-03-11 06:09   
Test Plan in an Oracle instance.
- Navigate to Financial Account "Caja" and add any transaction.
- Go to "Accounting Configuration" tab and delete records.
- Create new records for "España" and "International group" general ledgers leaving "Bank Revaluation Gain Account" empty.
- Go to "Transactions" tab and try to delete transaction.
- Transactions should be deleted successfully.
(0065322)
hgbot   
2014-03-21 06:21   
Repository: erp/devel/pi
Changeset: c6e0222a04cd80c808340436a6468799243d90a6
Author: Atul Gaware <atul.gaware <at> openbravo.com>
Date: Tue Mar 11 10:29:27 2014 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/c6e0222a04cd80c808340436a6468799243d90a6 [^]

Fixes Issue 25731 Trigger Mutating when deleting trxns from financial account

---
M src-db/database/model/triggers/FIN_FINANCIAL_ACCOUNT_TRG.xml
---
(0065336)
maite   
2014-03-21 09:08   
verified
(0065362)
hudsonbot   
2014-03-21 15:59   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/e18c6c3d258e [^]
Maturity status: Test