Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0009052
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 06. Material requirement planning (MRP)minorhave not tried2009-05-15 16:462009-07-21 00:00
ReportermtaalView Statuspublic 
Assigned Torafaroda 
PriorityurgentResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009052: MRP: Default value in database and application dictionary differ, they need to be the same

DescriptionSee the following remarks:
Column MaterialMgmtShipmentInOutLine.Movement Quantity: the Application Dictionary and the database have differing default values, AD: 1 DB: 0
Column MaterialMgmtInternalMovementLine.Movement Quantity: the Application Dictionary and the database have differing default values, AD: 1 DB: 0
Column ProductBOM.BOM Quantity: the Application Dictionary and the database have differing default values, AD: 1 DB: 0
Tags250mp2
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
duplicate of feature request 0009968 newiciordia Support default values in AD fields 
blocks defect 0008900pi closedmtaal Inconsistencies between database default values and application dictionary default values 

-  Notes
(0016396)
mtaal (viewer)
2009-05-15 19:08

 Hi Rafa,
I can't really say anything about the default values for data in the MRP tables. Someone knowledgeable on MaterialRequirementsPlanning should take on this one imo.

gr. Martin
(0018340)
harikrishnan (viewer)
2009-07-17 06:44

 Discussion for "MaterialMgmtShipmentInOutLine.Movement Quantity":

Their is no Inconsistency in table structure and value in the DB column definitions.

only in the structure src-db/database/model/tables/M_INOUTLINE.xml the set default value for this field is '0' in xml as well in the DB.


<column name="MOVEMENTQTY" primaryKey="false" required="true" type="DECIMAL" autoIncrement="false">
        <default><![CDATA[0]]></default>
        <onCreateDefault/>
      </column>

We should not confuse the column properties in the ad_column (its not about structure...its about data)
In the src-db/database/sourcedata/AD_Column the default value is "1"

<AD_COLUMN>
<!--3540--> <AD_COLUMN_ID><![CDATA[3540]]></AD_COLUMN_ID>
<!--3540--> <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
<!--3540--> <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
<!--3540--> <ISACTIVE><![CDATA[Y]]></ISACTIVE>
<!--3540--> <NAME><![CDATA[Movement Quantity]]></NAME>
<!--3540--> <DESCRIPTION><![CDATA[The number of items being moved from one location to another.]]></DESCRIPTION>
<!--3540--> <HELP><![CDATA[The Movement Quantity indicates the quantity of a product that has been moved.]]></HELP>
<!--3540--> <COLUMNNAME><![CDATA[MovementQty]]></COLUMNNAME>
<!--3540--> <AD_TABLE_ID><![CDATA[320]]></AD_TABLE_ID>
<!--3540--> <AD_REFERENCE_ID><![CDATA[29]]></AD_REFERENCE_ID>
<!--3540--> <FIELDLENGTH><![CDATA[10]]></FIELDLENGTH>
<!--3540--> <DEFAULTVALUE><![CDATA[1]]></DEFAULTVALUE>

we do agree the default value is 1 here. as far my concern it seems ok.

If you want default 1 in the DB, we have to fix it in the structure(src-db/database/model/tables/M_INOUTLINE.xml)

Thanks

hari
(0018427)
rafaroda (viewer)
2009-07-20 16:11

 This issue will be addressed by feature request 0009968

- Issue History
Date Modified Username Field Change
2009-05-15 16:46 mtaal New Issue
2009-05-15 16:46 mtaal Assigned To => rafaroda
2009-05-15 16:46 mtaal OBNetwork customer => No
2009-05-15 16:46 mtaal Regression testing => No
2009-05-15 16:53 mtaal Relationship added related to 0008900
2009-05-15 16:55 mtaal Relationship replaced blocks 0008900
2009-05-15 16:57 mtaal Tag Attached: 250mp2
2009-05-15 16:57 mtaal Priority normal => urgent
2009-05-15 18:05 rafaroda Status new => scheduled
2009-05-15 18:06 rafaroda Assigned To rafaroda => mtaal
2009-05-15 19:08 mtaal Note Added: 0016396
2009-05-15 19:08 mtaal Assigned To mtaal => rafaroda
2009-07-17 06:44 harikrishnan Note Added: 0018340
2009-07-20 16:11 rafaroda Relationship added duplicate of 0009968
2009-07-20 16:11 rafaroda Status scheduled => closed
2009-07-20 16:11 rafaroda Note Added: 0018427
2009-07-20 16:11 rafaroda Duplicate ID 0 => 9968
2009-07-20 16:11 rafaroda Resolution open => duplicate
2009-07-21 00:00 anonymous sf_bug_id 0 => 2824522
2016-01-04 18:14 shuehner Relationship added blocks 0031817

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker