Openbravo Issue Tracking System - Openbravo ERP |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0025731 | Openbravo ERP | Z. Others | public | 2014-02-13 23:17 | 2014-03-21 15:59 |
|
| Reporter | maite | |
| Assigned To | AtulOpenbravo | |
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | | |
| Target Version | | Fixed in Version | | |
| Merge Request Status | |
| Review Assigned To | maite |
| OBNetwork customer | |
| Web browser | |
| Modules | Advanced Payables and Receivables Mngmt |
| Support ticket | |
| 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 |
| Additional Information | |
| Tags | No tags attached. |
| Relationships | |
| Attached Files | |
|
| 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 | 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 | bug_revision_view_page.php?rev_id=5523#r5523 |
| 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 | |
|
Notes |
|
|
|
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
|
|
|
|
|
(0065336)
|
|
maite
|
|
2014-03-21 09:08
|
|
|
|
|
|
|