Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0025912Openbravo ERP00. Application dictionarypublic2014-03-05 16:242014-03-10 10:11
Reportershankarb 
Assigned Toshankarb 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionProfessional Appliance
Product Version 
Target Version3.0PR14Q2Fixed in Version3.0PR14Q2 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0025912: API Change Request : Drop constraint AD_TABLE_CLASSNAME_PACKAGE_UN from AD_Table
DescriptionRelated to issue[1], the issue is still reproducible in Oracle. Case based indexes are not getting exported from Oracle. So the proposed solution is to drop the constraint and add an event handler handling the same logic.


[1] https://issues.openbravo.com/view.php?id=025557 [^]
Steps To ReproduceIt is not possible to enter more than one datasource table in ORACLE.

For example:

Record 1
CLASSNAME: NULL
AD_PACKAGE_ID: 123

Record 2
CLASSNAME: NULL
AD_PACKAGE_ID: 123
Proposed SolutionDrop constraint AD_TABLE_CLASSNAME_PACKAGE_UN and add an event handler handling the same logic.
Additional Information
TagsNo tags attached.
Relationships
related to defect 00255573.0PR14Q2 closed shankarb Is not possible to enter more than one datasource table in ORACLE 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2014-03-05 16:24shankarbNew Issue
2014-03-05 16:24shankarbAssigned To => AugustoMauch
2014-03-05 16:24shankarbModules => Core
2014-03-05 16:24shankarbOBNetwork customer => No
2014-03-05 16:24shankarbTriggers an Emergency Pack => No
2014-03-06 05:32shankarbAssigned ToAugustoMauch => dmitry_mezentsev
2014-03-06 10:03dmitry_mezentsevNote Added: 0064895
2014-03-06 10:03dmitry_mezentsevAssigned Todmitry_mezentsev => shankarb
2014-03-06 11:18shankarbRelationship addedrelated to 0025557
2014-03-06 13:24shankarbReview Assigned To => AugustoMauch
2014-03-06 13:25shankarbIssue Monitored: AugustoMauch
2014-03-06 13:27hgbotCheckin
2014-03-06 13:27hgbotNote Added: 0064912
2014-03-06 13:27hgbotStatusnew => resolved
2014-03-06 13:27hgbotResolutionopen => fixed
2014-03-06 13:27hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/api-checks/rev/f98a40f834cc61e54e9dfa665cb79b6884703134 [^]
2014-03-10 10:11AugustoMauchStatusresolved => closed
2014-03-10 10:11AugustoMauchFixed in Version => PR14Q2

Notes
(0064895)
dmitry_mezentsev   
2014-03-06 10:03   
Approved.
(0064912)
hgbot   
2014-03-06 13:27   
Repository: erp/devel/api-checks
Changeset: f98a40f834cc61e54e9dfa665cb79b6884703134
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Thu Mar 06 11:26:36 2014 +0530
URL: http://code.openbravo.com/erp/devel/api-checks/rev/f98a40f834cc61e54e9dfa665cb79b6884703134 [^]

Fixes Issue 0025912: Drop constraint AD_TABLE_CLASSNAME_PACKAGE_UN from AD_Table

Constraint has been removed and the same logic has been added to event handler.

---
M model/src-db/database/model/tables/AD_TABLE.xml
---