Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajoralways2012-04-23 13:112012-04-26 10:33
ReporterdmiguelezView Statuspublic 
Assigned Todmiguelez 
PriorityimmediateResolutionfixedFixed in Version3.0MP12
StatusclosedFix in branchpiFixed in SCM revisione22cf4269bbf
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_18
OS VersionCommunity ApplianceDatabase version8.3.9Ant version1.7.1
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo



The definition of FACT_ACCT.FACTACCTTYPE is as of today as yes/no reference in the AD and a char of 1 in the database. But this is wrong, and has generated some issues.
It should be defined as a list reference in the AD and as a varchar of 60 in the database.

Why the change is needed:

Right now through DAL, since it is a yes/no reference, only 'Y' or 'N' values can be inserted or retrieved. But it was expected that other values were possible to be inserted, so it has generated some issues that, in the end, can result in an incorrect accounting balance.

Possible risks:

Since the description of the database is going to change, we already know that some views that are retrieving information from this table must be changed. We also know that the module '' [^] has plenty of views that must be changed.
All the modules that were using DAL to retrieve information will be affected too, but since it was not working properly to begin with, we assume that the risk taken is not that huge.
Steps To ReproduceLogin as Openbravo/openbravo
Change the rol to System Administrator.
Go to Tables and Columns.
Select the row with the DB Table Name: Fact_Acct
Go the Column Tab.
Select the row with the DB Table Name: FactAcctType
Realize that the Reference is defined as YesNo
Proposed SolutionChange the AD definition to a list reference.
Change the Database definition to varchar of 60.
Change the AD definition of the views that are affected and belong to core.
Raise an issue to change the AD definitions of the views present in the accounting tab module.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0011411 closeddmiguelez FacAcctType column of Fact_Acct table does not have a correct reference 

-  Notes
iciordia (manager)
2012-04-23 13:38

Before moving forward lets validate -querying the central repository- that there are no modules affected.

dmiguelez (developer)
2012-04-25 09:45
edited on: 2012-04-25 09:45

We have done two more tests:

First we checked in some clients whether they have different values from what was expected inserted for this column in their database. They did not.

Secondly, we checked the Centra Repository to find if there was any module that uses DAL to call the previous method, because it would be affected and there would be problems compiling. But we found no one.

So we can say that this change won't break any module and it is unlikely to find a client with different data in their database.

iciordia (manager)
2012-04-25 12:39

Thanks for the double-check. Approved.

hgbot (developer)
2012-04-25 18:11

Repository: erp/devel/api-checks
Changeset: e22cf4269bbf6d0344ed5d126a5e92e8160e3cc0
Author: David Miguelez <david.miguelez <at>>
Date: Wed Apr 25 18:04:42 2012 +0200
URL: [^]

Fixes issue 20327: Changed a yes/no reference to a list reference.
Changed the length of the column in the database.
Changed related views.

M model/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_COLUMN.xml
M model/modules/org.openbravo.advpaymentmngt/src-db/database/sourcedata/AD_FIELD.xml
M model/src-db/database/model/tables/FACT_ACCT.xml
M model/src-db/database/sourcedata/AD_COLUMN.xml
M model/src-db/database/sourcedata/AD_REFERENCE.xml
M model/src-db/database/sourcedata/AD_REF_LIST.xml
hgbot (developer)
2012-04-26 08:58

Repository: erp/devel/api-checks
Changeset: 14692b1b47602ca577d5437a16ffcedce878fd49
Author: David Miguelez <david.miguelez <at>>
Date: Thu Apr 26 08:58:02 2012 +0200
URL: [^]

Related to issue 20327: Changed generated java classes.

M java/reference/java.japi.gz
mirurita (developer)
2012-04-26 10:33

API build established

FactAcctType column is a List containing the following values
N: Normal
C: Close
R: Regularization
O: Open

Physical definition of the column has been changed to VARCHAR(60)

- Issue History
Date Modified Username Field Change
2012-04-23 13:11 dmiguelez New Issue
2012-04-23 13:11 dmiguelez Assigned To => iciordia
2012-04-23 13:11 dmiguelez Modules => Core
2012-04-23 13:11 dmiguelez Relationship added related to 0011411
2012-04-23 13:38 iciordia Note Added: 0047877
2012-04-25 09:45 dmiguelez Note Added: 0047944
2012-04-25 09:45 dmiguelez Note Edited: 0047944 View Revisions
2012-04-25 12:39 iciordia Note Added: 0047959
2012-04-25 12:40 iciordia Assigned To iciordia => dmiguelez
2012-04-25 16:41 dmiguelez Status new => acknowledged
2012-04-25 16:41 dmiguelez Status acknowledged => scheduled
2012-04-25 16:41 dmiguelez fix_in_branch => pi
2012-04-25 18:11 hgbot Checkin
2012-04-25 18:11 hgbot Note Added: 0047972
2012-04-25 18:11 hgbot Status scheduled => resolved
2012-04-25 18:11 hgbot Resolution open => fixed
2012-04-25 18:11 hgbot Fixed in SCM revision => [^]
2012-04-26 08:58 hgbot Checkin
2012-04-26 08:58 hgbot Note Added: 0047986
2012-04-26 10:33 mirurita Note Added: 0047992
2012-04-26 10:33 mirurita Status resolved => closed
2012-04-26 10:33 mirurita Fixed in Version => 3.0MP12

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker