Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0025731 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] Z. Others | major | always | 2014-02-13 23:17 | 2014-03-21 15:59 | |||
| Reporter | maite | View Status | public | |||||
| Assigned To | AtulOpenbravo | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | c6e0222a04cd | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Oracle | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | maite | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Advanced Payables and Receivables Mngmt | |||||||
| Support ticket | 26615 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0025731: Error when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined | |||||||
| Description | Error when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined | |||||||
| Steps To Reproduce | 1. 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 Solution | Problem 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0065010) AtulOpenbravo (viewer) 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 (developer) 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 (viewer) 2014-03-21 09:08 |
verified |
|
(0065362) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2014-02-13 23:17 | maite | New Issue | |
| 2014-02-13 23:17 | maite | Assigned To | => dmiguelez |
| 2014-02-13 23:17 | maite | Modules | => Advanced Payables and Receivables Mngmt |
| 2014-02-13 23:17 | maite | OBNetwork customer | => Yes |
| 2014-02-13 23:17 | maite | Support ticket | => 26615 |
| 2014-02-13 23:17 | maite | Triggers an Emergency Pack | => No |
| 2014-02-13 23:18 | maite | Resolution time | => 1395270000 |
| 2014-02-13 23:18 | maite | Issue Monitored: networkb | |
| 2014-02-14 13:32 | dmiguelez | Assigned To | dmiguelez => jonalegriaesarte |
| 2014-02-19 13:11 | jonalegriaesarte | Assigned To | jonalegriaesarte => pramakrishnan |
| 2014-02-27 07:59 | AtulOpenbravo | Assigned To | pramakrishnan => AtulOpenbravo |
| 2014-03-04 11:04 | maite | Steps to Reproduce Updated | View Revisions |
| 2014-03-10 09:56 | AtulOpenbravo | Status | new => scheduled |
| 2014-03-10 09:56 | AtulOpenbravo | fix_in_branch | => pi |
| 2014-03-11 06:09 | AtulOpenbravo | Note Added: 0065010 | |
| 2014-03-21 06:15 | AtulOpenbravo | Review Assigned To | => maite |
| 2014-03-21 06:15 | AtulOpenbravo | fix_in_branch | pi => |
| 2014-03-21 06:21 | hgbot | Checkin | |
| 2014-03-21 06:21 | hgbot | Note Added: 0065322 | |
| 2014-03-21 06:21 | hgbot | Status | scheduled => resolved |
| 2014-03-21 06:21 | hgbot | Resolution | open => fixed |
| 2014-03-21 06:21 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/c6e0222a04cd80c808340436a6468799243d90a6 [^] |
| 2014-03-21 09:08 | maite | Note Added: 0065336 | |
| 2014-03-21 09:08 | maite | Status | resolved => closed |
| 2014-03-21 15:59 | hudsonbot | Checkin | |
| 2014-03-21 15:59 | hudsonbot | Note Added: 0065362 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |