0005071: Creating a new accounting report fails due to a trigger error

Description

When you try to save a new accounting report, the following error raises:

ORA-01403: no data found ORA-06512: at "TAD_TRUNK.AD_ACCOUNTINGRPT_ELEMENT_TRG", line 38 ORA-04088: error during execution of trigger 'TAD_TRUNK.AD_ACCOUNTINGRPT_ELEMENT_TRG'

Steps To Reproduce

Go to Financial Management || Accounting || Analysis Tools || Accounting Report || Accounting Report, create a new record, check off the report field and try to save it

Proposed Solution

The AD_TREENODE table now has a AD_TREENODE_ID column, so the insert into this table done inside the trigger must fill this column using the get_uuid() function.

Moreover, inside this insert, it is necessary to change:
CASE :NEW.IsSummary
          WHEN 'Y'
          THEN '100'
          ELSE '999'
        END
by
CASE :NEW.IsSummary
          WHEN 'Y'
          THEN 100
          ELSE 999
        END

because the seqno column is numeric and not varchar.

Tags

UUID project

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

defect

0005207

closed

rafaroda

'Tax Report Setup' does not work due to trigger fail

Notes
(0009049) svnbot (reporter) 2008-09-17 13:42	Repository: openbravo Revision: 7404 Author: eduardoargal Date: 2008-09-17 13:41:55 +0200 (Wed, 17 Sep 2008) Fixes bug 0005071: Creating a new accounting report fails due to a trigger error --- U trunk/src-db/database/model/triggers/AD_ACCOUNTINGRPT_ELEMENT_TRG.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=7404&sc=1 [^]

Issue History
Date Modified	Username	Field	Change
2008-09-16 16:29	vmromanos	New Issue
2008-09-16 16:29	vmromanos	Assigned To	=> eduardo_Argal
2008-09-16 16:29	vmromanos	sf_bug_id	0 => 2114300
2008-09-16 16:29	vmromanos	Regression testing	=> No
2008-09-16 16:29	vmromanos	Tag Attached: UUID project
2008-09-17 13:42	svnbot	Checkin
2008-09-17 13:42	svnbot	Note Added: 0009049
2008-09-17 13:42	svnbot	Status	new => resolved
2008-09-17 13:42	svnbot	Resolution	open => fixed
2008-09-17 13:42	svnbot	svn_revision	=> 7404
2008-09-23 16:34	rafaroda	Relationship added	related to 0005207
2008-12-03 13:49	krishna	Status	resolved => closed