0025731: Error when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #25731		[ All Revisions ] [ Back to Issue ]
Summary	0025731: Error when trying to delete transaction from "Cash" financial account and Gain/Loss/Fee account is not defined

Revision	2014-03-04 11:04 by maite
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'

Revision	2014-02-27 07:59 by maite
Steps To Reproduce	1. Access Financial Account "Caja" and add any transaction 2. Access "Accounting Configuration" tab and edit record in grid to leave "Bank Revaluation Gain Account" empty 3. 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'