Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049743Openbravo ERP02. Master data managementpublic2022-07-06 14:052022-08-09 08:49
Reporterkousalya_r 
Assigned Toablasco 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionPR22Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket45413
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049743: Ad_Tree Node is Inactive even after changing the record to active
DescriptionCreate a "Product Category" and save it initially with the Active checkbox unchecked. Saving will create an AD_TreeNode, also marked "Active = 'N'". If we now go and edit the "Product Category" to mark the "Active" check, the Category is activated correctly but its AD_TreeNode remains marked as Active = 'N' forever.
This also happens with other records like the Season (c_campaign).
Steps To Reproduce1. In Product Category window create new record and enter mandatory fields and uncheck Active check box. Save the record.
2. Saving will create an AD_TreeNode, also marked "Active = 'N'".
3. Edit the same record and check the Active checkbox, the Category is activated correctly but its AD_TreeNode remains marked as Active = 'N' forever.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-07-06 14:05kousalya_rNew Issue
2022-07-06 14:05kousalya_rAssigned To => Triage Omni OMS
2022-07-06 14:05kousalya_rOBNetwork customer => OBPS
2022-07-06 14:05kousalya_rModules => Core
2022-07-06 14:05kousalya_rSupport ticket => 45413
2022-07-06 14:05kousalya_rTriggers an Emergency Pack => No
2022-07-11 09:27aferrazAssigned ToTriage Omni OMS => Triage Platform Base
2022-07-27 09:15AugustoMauchAssigned ToTriage Platform Base => ablasco
2022-07-27 09:15AugustoMauchStatusnew => scheduled
2022-07-28 14:06hgbotMerge Request Status => open
2022-07-28 14:06hgbotNote Added: 0139673
2022-08-09 08:48hgbotMerge Request Statusopen => approved
2022-08-09 08:49hgbotResolutionopen => fixed
2022-08-09 08:49hgbotStatusscheduled => closed
2022-08-09 08:49hgbotFixed in Version => PR22Q4
2022-08-09 08:49hgbotNote Added: 0139992
2022-08-09 08:49hgbotNote Added: 0139993

Notes
(0139673)
hgbot   
2022-07-28 14:06   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/657 [^]
(0139992)
hgbot   
2022-08-09 08:49   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: bb3d4dd7d1c74e7fbe7251820aed831c570b9867
Author: adrian.blasco <adrian.blasco@openbravo.com>
Date: 09-08-2022 08:49:05
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/bb3d4dd7d1c74e7fbe7251820aed831c570b9867 [^]

Fixes ISSUE-49743 Triggers from tree tables checks isActive field in Ad_treenode table

Check tables fire triggers

---
M src-db/database/model/triggers/AD_MENU_TRG.xml
M src-db/database/model/triggers/AD_ORG_TRG.xml
M src-db/database/model/triggers/A_ASSET_TRG.xml
M src-db/database/model/triggers/C_CAMPAIGN_TRG.xml
M src-db/database/model/triggers/C_COSTCENTER_TRG.xml
M src-db/database/model/triggers/C_ELEMENTVALUE_TRG.xml
M src-db/database/model/triggers/C_PROJECT_TRG.xml
M src-db/database/model/triggers/C_SALESREGION_TRG.xml
M src-db/database/model/triggers/M_CH_VALUE_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_BOM_TRG.xml
M src-db/database/model/triggers/M_PRODUCT_CATEGORY_TRG.xml
---
(0139993)
hgbot   
2022-08-09 08:49   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/657 [^]