ERP/3.0/API changes

From InfiniteERP Wiki
Revision as of 07:31, 18 November 2021 by Wikiadmin (talk | contribs) (Created page with "== Openbravo ERP 3.0 Distribution - API changes == This document explains all changes happened in the public API of the modules contained in the 3.0 release. These changes ar...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Openbravo ERP 3.0 Distribution - API changes

This document explains all changes happened in the public API of the modules contained in the 3.0 release. These changes are a potential risk of module breakage so all of them have been reviewed and explicitly approved. Every time a new change happen it will be included in this list and communicated as an alert through openbravo-development mailing list and Developers forum. Check here for more details of this flow.

master

ID Module Type Description Risk Comments
22Q1 Core Change FIN_Payment.description to NVARCHAR Change DESCRIPTION column from VARCHAR to NVARCHAR type in FIN_PAYMENT table Low See 47840
22Q1 Core Remove Javassist library Removed library that is no longer a hibernate dependency and was already not being use by default. None See 47800
22Q1 Core Change type to CLOB from Varchar on C_POC_EMAIL* tables body columns body column in C_POC_EMAIL and C_POC_EMAILDEFINITION tables has its type changed from VARCHAR to CLOB to allow more than 4000 characters. It shouldn't have limits after this change.

Note: If running update.database and using Oracle database, it requires a table recreation for C_POC_EMAIL and C_POC_EMAILDEFINITION tables. In postgres it will not be necessary.

Low See 47945

PR21Q4

ID Module Type Description Risk Comments
20Q4.1 Core Removed ad_process entries without any content
  • Column c_projectline.dopricing
    • AD_COLUMN_ID: 9873
    • AD_FIELD_ID: 800097
    • generated java code for this column
      • field org.openbravo.model.project.ProjectLine.PROPERTY_PRICING
      • method org.openbravo.model.project.ProjectLine.isPricing()
      • method org.openbravo.model.project.ProjectLine.setPricing(java.lang.Boolean)
  • AD_PROCESS entries
    • with ids: 115,120,121,124,127,128,129,130,131,132,133,138,139,151,155,159,160,161,180,189,190,192,198,202,203,204,205,208,213,217,218,221,222,223,224,225,226,228,229,230,800073,800081,800092,800100,800102,800123,800124,800145,800156,800187,1005400002
  • AD_PROCESS_PARA entries (associated to above processes)
    • See associated issue for the list of ids
  • AD_MENU entries (which were pointing to above AD_PROCESS
    • with ids: 194,195,197,202,210,211,212,213,214,215,227,231,231,252,256,350,383,393,398,399,400,401,402,403,404,405,800084,800091,800103,800118,800177,800178
  • AD_TREENODE entries (related to removed AD_MENU)
    • See associated issue for the list of ids
  • AD_ELEMENT entries removed by "Synchronize terminology"
    • AD_ELEMENT - ID: 1613
    • AD_ELEMENT - ID: 1615
    • AD_ELEMENT - ID: 1727
    • AD_ELEMENT - ID: 1790
    • AD_ELEMENT - ID: 1922
    • AD_ELEMENT - ID: 1981
    • AD_ELEMENT - ID: 2153
    • AD_ELEMENT - ID: 2182
    • AD_ELEMENT - ID: 2184
  • Generated methods in ActionButtonData class
    • method org.openbravo.erpCommon.reference.ActionButtonData.process155(org.openbravo.database.ConnectionProvider, java.lang.String)
    • method org.openbravo.erpCommon.reference.ActionButtonData.process180(org.openbravo.database.ConnectionProvider, java.lang.String)
Low See: 47421

PR21Q3

ID Module Type Description Risk Comments
PR21Q3.1 Core Removed some logo APIs
  • Column: AD_SYSTEM_INFO.SHOWFORGELOGO
    • AD_COLUMN - ID: 949E626A5896C713E040A8C0BD062033
    • AD_FIELD - ID: 949E69B5A9C84B28E040A8C0BD062024
  • Message: "Forge Logo cannot be hidden in Community Instances"
    • AD_MESSAGE - ID: 643C242A10AE4A4495EA6D82B99C1F86
  • Servlets: GetOpenbravoLogoGen.png and GetOpenbravoLogo.png
    • AD_MODEL_OBJECT - ID: 8993A79B45F8457CB56FC27F084FF5C6
    • AD_MODEL_OBJECT - ID: 8A935F84A79B45F8457CB91B09764786
    • AD_MODEL_OBJECT_MAPPING - ID: 372045A027A74A08B6EBE5761AE7F061
    • AD_MODEL_OBJECT_MAPPING - ID: 38247A747684E7CA774A08A08B6EBE55
  • class org.openbravo.erpCommon.obps.GetOpenbravoLogo
  • class org.openbravo.erpCommon.obps.GetOpenbravoLogoGen
Low See: 46363
PR21Q3.2 Core Removed OBDB2v97Dialect class OBDB2v97Dialect class has been removed as it was long obsolete and part of abandoned db2 database support None See: 47062
PR21Q3.3 Core Reduced method visibility ImportEntryManager.submitRunnable method visibility has been reduced from public to package and return type changed from void to boolean. None See: 47146
PR21Q3.4 Core Change of superclass GenerateEntitiesTask no longer extends ant Task None See: 47193
PR21Q3.4 Core Remove some old EMail classes
  • class
    • org.openbravo.erpCommon.businessUtility.EMail
    • org.openbravo.erpCommon.businessUtility.EMailAuthenticator
  • xsql file (public)
    • org/openbravo/erpCommon/businessUtility/EMail_data.xsql
Low See: 47229

PR21Q2.1

ID Module Type Description Risk Comments
PR21Q2.1.1 Core Reduced method visibility ImportEntryManager.submitRunnable method visibility has been reduced from public to package and return type changed from void to boolean. None See: 47146

PR21Q2

No Changes

PR21Q1.4

ID Module Type Description Risk Comments
PR21Q1.4.1 Core Reduced method visibility ImportEntryManager.submitRunnable method visibility has been reduced from public to package and return type changed from void to boolean. None See: 47146

PR21Q1

ID Module Type Description Risk Comments
PR21Q1.1 Core Removed HttpServletCalloutInformationProvider class HttpServletCalloutInformationProvider class has been removed because the old-callouts based on HttpServletBased have been removed for generated Windows and it is note necessary anymore. Low See: 44803


PR21Q1.2 Core Removed rebuild + restart from MMC DB + AD:
  • AD_Error_Log table with it's AD components (ad_table, ad_column and ad_element).
  • Apply Modules process and it's model object and mapping.
  • ExternalRebuild preference

Java:

  • class org.openbravo.base.BuildTask
  • class org.openbravo.erpCommon.ad_forms.ShowLogFile
  • class org.openbravo.erpCommon.ad_process.ApplyModulesCallServlet
  • class org.openbravo.erpCommon.utility.AntExecutor
  • class org.openbravo.model.ad.system.ErrorLog
  • class org.openbravo.service.system.RestartTomcat
  • class org.openbravo.utils.OBRebuildAppender
  • method org.openbravo.base.AntExecutor.closeLogFile()
  • method org.openbravo.base.AntExecutor.setLogFileAndListener(java.lang.String)
  • method org.openbravo.erpCommon.ad_forms.ModuleManagement.canRebuildFromMMC()
  • method org.openbravo.erpCommon.ad_process.ApplyModules.getBuildFromXMLFile()
  • method org.openbravo.erpCommon.ad_process.ApplyModules.getBuildTranslationFromFile(java.lang.String)
  • field org.openbravo.erpCommon.ad_forms.TranslationManager.BUILD_FILENAME
Low See: 45227
PR21Q1.3 Core Activated property and entity deprecation by default if marked as so in AD Properties and entities are now deprecated by default instead of optionally if those are marked as so in Application Dictionary. A few methods have been removed/modified as a result:
  • removed method org.openbravo.base.gen.GenerateEntitiesTask.shouldAddDeprecation()
  • removed argument from method org.openbravo.base.model.ModelProvider.addHelpAndDeprecationToModel(boolean)
Low See: 45260


PR21Q1.4 Core Removed feature restrictions
  • AD_Message removed rows:
    • 48F0550A900840B0A9D9D74A23EA2E28 | FEATURE_OBPS_ONLY
    • 11509F0E2D6E4D4A96518FECB69A5B8F | LearnHowToActivate
    • FB074AB5BE884C2FAEE6159575A47F09 | NoRestrictionsFile
    • 0FC7B0C6F4FC4F04BEAD06F30E895516 | OBPSAnyEdition
    • 672907E8CED54518ACFA037420623845 | OBPSGoldenKeyRestricted
    • C8433C64354D44C6A76F2A09CAF85907 | OBPSNeededForAudit
    • 17F9F89C2965434E9190E5E6FF92CF20 | OBPSStandardEdition
  • Removals in org.openbravo.erpCommon.obps.ActivationKey
    • field FeatureRestriction.GOLDEN_RESTRICTION
    • field FeatureRestriction.TIER1_RESTRICTION
    • field FeatureRestriction.TIER2_RESTRICTION
    • method hasLicencesTabAccess
Low See: 45298
PR21Q1.5 Core Removed Apache tika-core library and a couple of utility methods
  • Removed two methods from org.openbravo.erpCommon.utility.MimeTypeUtil:
    • method getMimeType(byte[])
    • method setInstance(MimeUtilType)
Low See: 45388

PR20Q4

ID Module Type Description Risk Comments
PR20Q4.1 Core Removed CallOut from Application Dictionary The CallOut SL_MInOutTraceReports has been removed from Application Dictionary. The Servlet however can be used still Low See: 44812
PR20Q4.2 Core Removed CallOut code and its references in Database The CallOut SL_CreateLines_Conversion_UOM has been removed completely from Openbravo. Code and Database references are gone. Low See: 44813
PR20Q4.3 Core Removed org.openbravo.client.kernel/docs code and its references in Database org.openbravo.client.kernel/docs has been removed entirely from Openbravo, this involves the removal of the following elements:
  • DocumentationComponent class
  • KernelConstants DOCUMENT_COMPONENT_ID constant
  • Removed row from table OBCLKER_TEMPLATE - ID: DBAC211182304F7784DAB4EDE7B6AA1D
None See: 45028
PR20Q4.4 Core Changed a parameter sent from M_INOUT_CREATE to M_GET_STOCK_PARAM Database procedure Functional API Change. When calling the M_GET_STOCK_PARAM procedure from the M_INOUT_CREATE one, the v_record_id parameter sent was the c_order_id. This has been change to send the c_orderline_id instead, which gives more context to the developer. Low See: 45092

PR20Q3

ID Module Type Description Risk Comments
PR20Q3.1 Core Removed old Tree implementation Old tree implementation has been removed, removing the following elements:
  • AD_MESSAGE - ID: 800066
  • AD_MESSAGE - ID: 800067
  • AD_MESSAGE - ID: 800156
  • AD_MESSAGE - ID: 04DDD225150B48C1B9A94E673BEF2ED9
  • AD_MODEL_OBJECT - ID: 800671
  • AD_MODEL_OBJECT_MAPPING - ID: 802671
  • AD_REF_LIST - ID: 67C9AE863A644F46BC21F563E4910F6C

removed class org.openbravo.erpCommon.utility.WindowTree removed many methods from org.openbravo.erpCommon.utility.WindowTreeData

Low See: 43978
PR20Q3.2 Core Removed HB custom queries Removed the following DB components and their AD (tables, columns, window, tabs and fields):
  • table: AD_HB_LOG_CQUERY
  • table: AD_HB_LOG_CQUERY_ROW
  • column: AD_SYSTEM_INFO.ISCUSTOMQUERYENABLED
None See: 44089
PR20Q3.3 Core Removed obsolete Reset Accounting implementations based on DB procedure FACT_ACCT_RESET and based on Java class ResetAccountingProcess Removed following candidates
  • Removed DB procedure FACT_ACCT_RESET
  • Removed class org.openbravo.erpCommon.ad_process.ResetAccountingProcess
  • Removed method org.openbravo.erpCommon.reference.ActionButtonData.process175
  • Removed AD_PROCESS

AD_PROCESS_ID = 175 - Resubmit Posting, AD_PROCESS_ID = 176 - Reset Accounting Old, AD_PROCESS_ID = E264309FF8244A94936502BF51829109 - Reset Accounting) and its related references from AD_TREENODE, AD_MENU, AD_PROCESS_PARA, AD_MODEL_OBJECT

Low See: 44116
PR20Q3.4 Core Remove obsolete OrderPO Print process Removed below candidates
  • Removed references from AD_PROCESS (AD_PROCESS_ID = 800004 - OrderPO Print), and its related AD_MODEL_OBJECT, AD_MODEL_OBJECT_MAPPING and AD_TEXTINTERFACES
  • Removed Java class org.openbravo.erpReports.RptC_OrderPO
  • Removed method org.openbravo.erpCommon.reference.ActionButtonData.process800004
Low See: 44117


PR20Q3.5 Core Changed signature of method getProductIds() in class ImportProductInDiscount The method signature has changed from:
protected List<String> getProductIds(String productKey) {

To

protected List<String> getProductIds(String clientId, String orgId, String productKey) {

The reasons is that now product key is not unique globally is unique only in the context of the same client and same legal entity. So client and org must be passed to the method.

Low See: 44645

PR20Q2

ID Module Type Description Risk Comments
PR20Q2.1 Core Changed API isIndevelopment method has been removed from these classes and replaced by parent BaseComponent isInDevelopment method:
  • AttachmentWindowComponent
  • ParameterWindowComponent
  • StandardWindowComponent
Low See: 42595
PR20Q2.2 Core PrintInvoices This process is inactive and not used hence class and its related AD Components are safely removed. Low See: 43070


PR20Q2.3 Core Sales Order Open Item Report This report is inactive and not used hence its related class AD Components are safely removed. Low See: 43071
PR20Q2.4 Core Invoice Consignment Report This report is inactive and not used hence its related class AD Components are safely removed. Low See: 43072
PR20Q2.5 Core M_Storage_Pending - Change in F.K for M_Product_ID Foreign key for column M_Product_ID is change to ON DELETE CASCASE instead of NO ACTION. This way when no other transactions are associated with product being deleted, records from M_Storage_Pending are deleted automatically. None See: 43368
PR20Q2.6 Core Remove deprecated properties Removed deprecated columns from DB table
  • C_BP_BANKACCOUNT.SHOWACCOUNTNO
  • C_BP_BANKACCOUNT.SHOWIBAN
  • C_INVOICE.PAYMENTRULE
  • C_INVOICELINE.TAXAMT
  • GL_JOURNALLINE.DATEACCT

Removed fields and its getter and setter methods from java classes are

  • org.openbravo.model.common.businesspartner.BankAccount.PROPERTY_SHOWGENERIC
  • org.openbravo.model.common.businesspartner.BankAccount.PROPERTY_SHOWIBAN
  • org.openbravo.model.common.invoice.Invoice.PROPERTY_FINORIGPAYMENTSCHEDULELIST
  • org.openbravo.model.common.invoice.Invoice.PROPERTY_FORMOFPAYMENT
  • org.openbravo.model.common.invoice.InvoiceLine.PROPERTY_TAXAMOUNT
  • org.openbravo.model.common.invoice.InvoiceV2.PROPERTY_FORMOFPAYMENT
  • org.openbravo.model.financialmgmt.gl.GLJournalLine.PROPERTY_ACCOUNTINGDATE
  • org.openbravo.model.financialmgmt.payment.FIN_PaymentDetailV.PROPERTY_INVOICEPAYMENTPLAN
  • org.openbravo.model.financialmgmt.payment.FIN_PaymentSchedInvV.PROPERTY_FINPAYMENTDETAILVLIST
Low See: 43391

PR20Q1

ID Module Type Description Risk Comments
PR20Q1.1 Core Changed API Changes in password management:
  • New API to handle passwords. See here.
  • AD_USER.PASSWORD column size increased from 40 to 255 characteres
  • Removed org.openbravo.utils.CryptoSHA1BASE64 class
Low See:
PR20Q1.2 Core Removed legacy cost engine support Removed column M_Product.Coststd, M_Product.Costtype, M_Costing.M_INOUTLINE_ID, M_COSTING.M_PRODUCTIONLINE_ID and its references from AD as well DB, its related fields, getter & setter methods from java class, removed DB functions MA_PRODUCTION_COST_GENERATE, M_GENERATE_AVERAGE_COSTS, M_GENERATE_STANDARD_COSTS, M_GET_PARETO_ABC_LEGACY, M_GET_TRANSACTION_COST, M_GET_TRX_AND_PRODUCT_COST, M_UPDATE_PARETO_PRODUCT0LEGACY, M_UPDATE_PARETO_PRODUCT_LEGACY, its related AD_PROCESS, AD_PROCESS_PARA, AD_MENU, AD_MESSAGE, AD_TREENODE, AD_MODEL_OBJECT, AD_MODEL_OBJECT_MAPPING, java classes CostingMigrationProcess, CostingStatus, ReportInvoiceCustomerDimensionalAnalysesJR_legacy, ReportParetoProductLegacy, ReportValuationStock_legacy, java methods ProductInfo.getProductCosts, ProductInfo.getProductItemCost, ActionButtonData.process1000500001, ActionButtonData.process182, ActionButtonData.process800085, ActionButtonData.process800151 Medium See 41422
PR20Q1.3 Core Changed API Simplified OBScheduler API:
  • Removed OBScheduler.schedule(String, ProcessBundle, Class<? extends Job>) and OBScheduler.schedule(ProcessBundle, Class<? extends Job>) methods. Now it is not possible to provide the job class because DefaultJob is always used internally.
  • OBScheduler.schedule(String,ProcessBundle) is no longer throwing ServletException
  • Removed OBScheduler.format(Date) method
  • Removed TRIG_INVALID_DATA AD_MESSAGE
Low See:
PR20Q1.4 Core Changed API Removed TestComponent and testResources as they're not needed anymore. Tests should be implemented using Jest:
  • Removed TestComponent class.
  • Removed method getTestResources from ComponentProvider and all of its implementations.
Medium See:

PR19Q4

ID Module Type Description Risk Comments
PR19Q4.1 Core Removed one-to-many properties in DAL generated entities (Functional) Many one-to-many properties in DAL generated Functional entities have been removed. This removal can be reverted with hb.generate.all.parent.child.properties=true in Openbravo.properties. High See 41227
PR19Q4.2 Core Removed VersionUtility.pool field and its setter Removed VersionUtility.pool field and its setter None See 41440
PR19Q4.3 Core Removed SOAP support SOAP support has been removed from standard Openbravo. In case it is required, the alternatives are:
  • (recommended) migrate services/clients to Apache CXF module
  • Install (unsupported) Axis Legacy module, which includes old Axis library to keep backwards compatilibity without additional changes.
Low See 41440
PR19Q4.4 Core Delete obsolete db functions that have been deprecated Removed db functions m_get_offer_price, m_get_offer_std_price, m_get_offers_price, m_get_offers_std_price, signature of method getOffersPriceCurrency of class GetPriceOfferData changed Low See 41334
PR19Q4.5 Core Remove Old Payment Monitor used in Openbravo 2.50 Removed java class for PaymentMonitor, PaymentMonitorProcess, InvoicePaymentMonitor, UPDATEPAYMENTMONITOR column from table C_INVOICE, AD_FIELD used in Purchase and Sales Invoice Header Tab, its AD_COLUMN & AD_ELEMENT record, deletes PROPERTY_UPDATEPAYMENTMONITOR property, isUpdatePaymentMonitor & setUpdatePaymentMonitor method, its related AD_PROCESS, AD_MODEL_OBJECT & its MAPPING Low See 41320
PR19Q4.6 Core Prevent duplicated names for Non Variant Product Characteristics Added Database constraint to prevent duplicated names for a same Product Characteristic Low See 41485
PR19Q4.7 Core Changed generic type of method argument DataToJsonConverter.toJsonObjects method accepts a list of any class extending BaseOBObject instead of directly a list of BaseOBObjects None See 41516
PR19Q4.8 Core Remove unused methods from AdvPaymentMngtDao, FIN_Utility, PaymentReportDao Remove methods getReconciliationDetailReport & getReconciliationSummaryReport from AdvPaymentMngtDao, getFinancialAccountList, getInStrList, getInStrSet,

getOrderedPaymentDetailList and getPaymentMethodList from FIN_Utility and getInvoicePaymentSchedule from PaymentReportDao

Low See 41619

PR19Q3

ID Module Type Description Risk Comments
PR19Q3.1 Core Removed constructor Removed constructor HttpServletCalloutInformationProvider(java.util.ArrayList<org.mozilla.javascript.NativeArray>) None See 40548
PR19Q3.2 Core New parameters in Customer Statement report Two new paramaters have been included in the Customer Statement report: 'Sum Initial Balance' and 'Multicurrency' Low See 40505
PR19Q3.3 Core Adding private constructor in ReportsUtility class Adding private constructor in ReportsUtility class as this class only contains static utility functions and it is not instantiable. Low See 40506
PR19Q3.4 Core Method return type change Return this instance instead of void in several OBQuery/OBCriteria methods in order to support method chaining. Medium See 40614
PR19Q3.5 Core Library removal Removed xstream-1.3.1 library from core. Low See 40860
PR19Q3.6 Core Reduce class visibility ApplyModulesResponse class is no longer declared as public. None See 40861


PR19Q3.7 Core Removed one-to-many properties in DAL generated entities (Platform) Many one-to-many properties in DAL generated Platform entities have been removed. This removal can be reverted with hb.generate.all.parent.child.properties=true in Openbravo.properties. High See 40931
PR19Q3.8 Core Removed ApplicationDictionaryValidator class This class has no use. None See 40937
PR19Q3.9 Core Remove Transaction Old 2 Tab, its fields, Delete & Modify Transaction The tab is inactive and not used any more. Removal of related components is safe and manageable. Low See 40920
PR19Q3.10 Core Remove Transaction Old Tab The tab is inactive and not used any more. Removal of related components is safe and manageable. Low See 40561
PR19Q3.11 Core Remove process Match Statement & Match Statement Force The processes are inactive and not used any more and removal of related components is manageable and safe. Low See 40563

PR19Q2.2

No Changes

PR19Q2.1

No Changes

PR19Q2

ID Module Type Description Risk Comments
PR19Q2.1 Core Removed methods Removed methods in ToolBar None See 40098
PR19Q2.2 Core Class scope changed EntityPersistenceEventObserver declared as an @ApplicationScoped bean Low See 40066
PR19Q2.3 Core Removed FOP support Capability to render FOP reports is now removed from core. Low See 40133
PR19Q2.4 Core Removed some old reports Some old reports have been removed from core. None See 40132
PR19Q2.5 Core Updated createfromorder and createfrominouts columns from c_invoice table as non mandatory This columns are behind a button and not need a default value. None See 40167
PR19Q2.6 Core Remove org.openbravo.erpCommon.ad_reports.ReportWorkRequirementDailyEnv class ReportWorkRequirementDailyEnv is not reference at all in AD so unused None See 40183
PR19Q2.7 Core Remove Create From Multiple process Remove Create From Multiple process and related callouts as they are not used anymore. If column behind the button is used in any query, should be removed.See here Medium See 40200
PR19Q2.8 Core Reduce class visibility With the cleanup done in EntityPersistenceEventObserver classes, they have been extracted from the public API as they are now declared as package protected. None See 40100
PR19Q2.9 Core Create/Process Production process parameter to force use of warehouse of selected Storage Bin A new parameter "forceUseOfWHOfSelectedLocator" flag with default value "No" is added in Create/Process Production button process in Bills Of Material Production in order to support Warehouse of the selected Bin to be sent as the Priority Warehouse in the call to the m_get_stock_param. Low See 40450

PR19Q1.2

No Changes

PR19Q1.1

No Changes

PR19Q1

ID Module Type Description Risk Comments
PR19Q1.1 Core Build tasks Removed restart option from ant smartbuild. Medium See 39140
PR19Q1.2 Core Removed class Removed class ReloadContext None See 39433
PR19Q1.3 Core Removed methods Removed methods in OBContext None See 39502
PR19Q1.4 Core Removal and changes related to log4j 1.x SetPriority screen used to change logger configuration in ERP have been removed.

Also removed web.xml parameters related to log4j configuration.

OBRebuildAppender changed.

None See 39626
PR19Q1.5 Core Removed methods Removed unused methods in TreeUtility None See 39461
PR19Q1.6 Core Removed methods Removed Logger getters and setters in ad_forms classes None See 39657
PR19Q1.7 Core Method return type change Changed return type of DataSourceUtils.getSelectedRecordsFromCriteria from List<String> to Set<String> and it desn't JSONException. None See 39819

PR18Q4.3

No Changes

PR18Q4.2

No Changes

PR18Q4.1

No Changes

PR18Q4

ID Module Type Description Risk Comments
PR18Q4.1 Core API Changes due to Hibernate library upgrade Read Hibernate_5.3_Migration_Guide to check the changes required to be done to make modules work with new Hibernate version.

See here the full list of API changes.

High See 39021
PR18Q4.2 Core API Change: remove Fact_Acct_End_Year_v view Replace Fact_Acct_End_Year_v view by HQL Table because of performance problems. Low See 39115
PR18Q4.3 Core API Change: Required by Create Invoice Lines From Refactor Replaced the old Create Lines From button by two new ones.

Removed fields:

* AD_FIELD - ID: 4244
* AD_FIELD - ID: 4246
* AD_FIELD - ID: 7995

Removed java methods:
* CreateFrom.printPageInvoice()
* CreateFrom.saveInvoice()
Low See 39155


PR18Q4.4 Core Removed parameter Removed sourcePath parameter from InitialOrgSetup.createOrganization method. Low See 39254

PR18Q3.5

No Changes

PR18Q3.4

No Changes

PR18Q3.3

No Changes

PR18Q3.2

No Changes

PR18Q3.1

No Changes

PR18Q3

ID Module Type Description Risk Comments
PR18Q3.1 Core Removed RptM_Inout, RptM_Movement, RptC_Settlement, PromissoryNote reports Those 4 reports are based on old obsolete FOP rendering technology which is being phased out. Apart they were not accessible by default for a long time but only via editing/creating references to them.

Full list of removed elements

  • classes
    • org.openbravo.erpReports.RptC_Settlement
    • org.openbravo.erpReports.RptM_Inout
    • org.openbravo.erpReports.RptM_Movement
    • org.openbravo.erpReports.RptPromissoryNote
  • removed rows from table ad_process: 117, 800050, 800070, 800101
  • removed rows from table ad_model_object: 800794, 800839, 800874, 800882
  • removed rows from table ad_model_object_mapping: 801057, 801093, 801137, 801145, 801502, 801503, 801504, 801507, 801508, 801512, 801513, 801514
Low See 38320
PR18Q3.2 Core Change Required Quantity in Work Effort Reference from Integer to BigDecimal Change Required Quantity in Work Effort Reference from Integer to BigDecimal to allow having decimal figures. Low See 38292
PR18Q3.3 Core Delete of obsolete URL mappings for callouts Since 17Q1 no url-mappings in web.xml are generated for any callout. This change removes the obsolete rows from table ad_model_object_mapping None See 38368
PR18Q3.4 Core Removed code to keep hg revision in the system Removed:
  • org.openbravo.erpCommon.businessUtility.Heartbeat_data_xsql
  • Removed columns
    • AD_HEARTBEAT_LOG.CODE_REVISION
    • AD_MODULE.VERSION_ID
    • AD_MODULE_INSTALL.VERSION_ID
    • AD_SYSTEM_INFO.CODE_REVISION
None See 38297
PR18Q3.5 Core Removed unused old callouts Removed:
  • Row from table AD_CALLOUT - ID: 6C7A1DC738044D2880CF60856508FC81
  • Row from table AD_CALLOUT - ID: 8D5A298D3BEF4E14BB9B9C2A7D0CFA18
  • src/org/openbravo/erpCommon/ad_callouts/SE_Calendar_For_Org.java
  • src/org/openbravo/erpCommon/ad_callouts/SE_Years_For_Calendar.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Locator.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Locator_data.xsql
  • src/org/openbravo/erpCommon/ad_callouts/SL_Invoice_Tax.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_MovementAll_Locator.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_Payment_Amounts.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_Payment_Amounts_data.xsql
  • src/org/openbravo/erpCommon/ad_callouts/SL_Payment_DocType.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_Payment_DocType_data.xsql
  • src/org/openbravo/erpCommon/ad_callouts/SL_Payment_No_Verify.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_WorkRequirement_Sequence.java
  • src/org/openbravo/erpCommon/ad_callouts/SL_WorkRequirement_Sequence.xsql
Low See 36362
PR18Q3.6 Core Unique constraint added in M_Warehouse table Added a unique constraint in M_Warehouse table in order to avoid duplicated data for the same client and warehouse value. Medium See 38504
PR18Q3.7 Core Removed table Removed ad_session_status DB table. High See 38642
PR18Q3.8 Core Removed columns Removed ad_system_info.servlet_container and ad_system_info.servlet_container_version columns None See 38763

PR18Q2.3

No Changes

PR18Q2.2

No Changes

PR18Q2.1

No Changes

PR18Q2

ID Module Type Description Risk Comments
PR18Q2.1 Core Removed Cash Flow Report The Cash Flow Report is outdated, it has been inactive for several years already and it is not thread safe, so it has been removed from the Product. There are other Reports, like Cash Flow Forecast, that can be used to retrieve the same information. None See 37663


PR18Q2.2 Core Removed some obsolete Java classes/methods/fields Some very old and obsolete Java classes/methods/fields have been removed:
  • classes
    • org.openbravo.dal.core.DalUUIDHexGenerator
    • org.openbravo.erpCommon.utility.CalculateCoreRevision
    • org.openbravo.service.datasource.DataSourceJavaScriptCreator
  • fields
    • org.openbravo.dal.xml.XMLConstants.DATE_TIME_ATTRIBUTE
    • org.openbravo.dal.xml.XMLConstants.OB_REVISION_ATTRIBUTE
    • org.openbravo.dal.xml.XMLConstants.OB_VERSION_ATTRIBUTE
  • methods
    • org.openbravo.dal.xml.EntityXMLConverter.addSystemAttributes(org.xml.sax.helpers.AttributesImpl)
    • org.openbravo.erpCommon.utility.OBVersion.getVersionId()
    • org.openbravo.service.datasource.BaseDataSourceService.getJavaScriptCreator()
None See 37770
PR18Q2.3 Core API Changes due to Apache HttpComponents upgrade In the new Apache HttpComponents libraries updated in core, there are several changes on their public API. Low See 37910
PR18Q2.4 Core API Changes due to Jackson JSON processor libraries upgrade In the new Jackson JSON processor libraries updated in core, there are several changes on their public API. Low See 37962
PR18Q2.5 Core Removed Java class org.openbravo.base.secureApp.OrgTree has been removed in favor of OrganizationStructureProvider which implements the same functionality with a better performance. Low See 37997
PR18Q2.6 Core Removed some deprecated methods/constants There are some methods and constants marked as deprecated in the Javadocs but not annotated, which is marked as a warning in JDK 9. All of them are removed as they were deprecated a long time ago. Low See 38055
PR18Q2.7 Core Changed ExternalConnectionPool.getInstance(String) to throw ReflectiveOperationException To remove the JDK 9 warning of deprecated clazz.newInstance(), it was replaced by clazz.getDeclaredConstructor().newInstance(). This changes the exceptions thrown by ExternalConnectionPool.getInstance(String). Low See 38000
PR18Q2.8 Core Add new parameter to some tax rounding functions Add document currency standard precision as new parameter to some tax rounding functions:
  • C_INVOICELINETAX_ROUNDING: removed unneeded "p_linefrom" parameter and add new "p_stdprecision" parameter.
  • C_INVOICELINETAX_ROUNDING_AMT: removed unneeded "p_linefrom" parameter.
  • C_INVOICETAX_ROUNDING: add new "p_stdprecision" parameter.
  • C_ORDERLINETAX_ROUNDING: removed unneeded "p_linefrom" parameter and add new "p_stdprecision" parameter.
  • C_ORDERLINETAX_ROUNDING_AMT: removed unneeded "p_linefrom" parameter.
  • C_ORDERTAX_ROUNDING: add new "p_stdprecision" parameter.
Medium See 38207

PR18Q1.3

No Changes

PR18Q1.2

No Changes

PR18Q1.1

No Changes

PR18Q1

ID Module Type Description Risk Comments
PR18Q1.1 Core Column size change Resized AD_Alert.record_ID None See 33621
PR18Q1.2 Advanced Payables and Receivables Mngmt Remove method Removed unused method getPeriod from TransactionsDao class (as it wont be used after the related issue is fixed.) None See 37219
PR18Q1.3 Core Removed field + web.xml param Removed field + web.xml param that were used to implement support for remote fop printing which has been also removed. None See 37396
PR18Q1.4 Core Removed obsolete code As part of the Copy From Order Refactor project, this obsolete code has been removed:
  • class org.openbravo.erpCommon.ad_actionButton.CopyFromPOOrder
  • Removed row from table AD_MODEL_OBJECT - ID: 801387
  • Removed row from table AD_MODEL_OBJECT_MAPPING - ID: 802082
  • Removed row from table AD_PROCESS - ID: 800165
Low See 37383
PR18Q1.5 Core Added extra parameter to Java method As part of the fix for Issue 37302 a new parameter has been added to the method PriceDifferenceProcess.processPriceDifference to be able to filter the Price Correction by Legal Entity Low See 37412
PR18Q1.6 Core Openbravo doesn't serve SOAP web services by default SOAP web services are not served by default anymore. Instances deploying SOAP web services, will need to enable them. Medium See 37750

PR17Q4.1

ID Module Type Description Risk Comments


PR17Q4.1.1 Core Openbravo doesn't serve SOAP web services by default SOAP web services are not served by default anymore. Instances deploying SOAP web services, will need to enable them. Medium See 37750

PR17Q4

ID Module Type Description Risk Comments
PR17Q4.1 Core Removed parameter Removed useless parameter from Utility.getCommunityBrandingUrl None See 36517
PR17Q4.2 Core Removed method Removed unused debugging CryptoUtility.main method None See 36431
PR17Q4.3 Core Removed obsolete elements Some components were still present from 2.50 style windows which were unused for a long time.
  • Full Java classes:
    • org.openbravo.erpCommon.businessUtility.Buscador and its AD_MODEL_OBJECT (800662) and AD_MODEL_OBJECT_MAPPING (800833) row
    • org.openbravo.erpCommon.businessUtility.BuscadorData (generated from xsql file)
    • org.openbravo.erpCommon.utility.DataGrid and its AD_MODEL_OBJECT (96ED899EC5704BA9961340A934B62133) and AD_MODEL_OBJECT_MAPPING (3CCD2540F0B2441484C256772EBBCC93) row
    • org.openbravo.erpCommon.utility.ExportGrid and its AD_MODEL_OBJECT (801433) and AD_MODEL_OBJECT_MAPPING (802179, 802668, 802669, 802670) rows
    • org.openbravo.erpCommon.utility.KeyMap
    • org.openbravo.erpCommon.utility.ModelSQLGeneration
  • In org.openbravo.erpCommon.utility.TableSQLData:
    • Everything is removed except:
      • constant maxRowsPerGridPage
      • method calcAndGetBackendPage
    • class does no longer implement Serializable
  • In org.openbravo.erpCommon.utility.ExecuteQuery
    • method executeStatement
    • method selectAndSearch
    • enum SearchType
  • In org.openbravo.erpCommon.utility.ComboTableData
    • method fillParametersFromSearch
  • In org.openbravo.erpCommon.utility.Utility
    • fillTableSQLParameters
  • In org.openbravo.erpCommon.WindowAccessData (xsql generated)
    • method hasnotDeleteAccess
  • In org.openbravo.referenace.ui.UIReference (and all sub-classes)
    • member:
      • addSecondaryFilter
      • conn
      • strIsSOTrx
      • trReplaceWith
    • methods:
      • generateFilterAcceptScript
      • generateFilterHtml
      • generateSQL
      • getFilter
      • getGridType
      • hasSecondaryFilter
      • identifier
      • setReplaceWith
      • setStrIsSOTrx
  • In org.openbravo.reference.ui.UIReferenceUtility
    • method addFilter
    • method addUniqueElement
    • method checkTableTranslation
    • method fieldtoProperties
Low See 36499
PR17Q4.4 Core Functional callouts have been changed from implementing Servlet to SimpleCallout. Now the only way to extend them is documented here: http://wiki.openbravo.com/wiki/How_to_create_a_callout_that_extends_from_another_callout Medium See 36617
PR17Q4.5 Core Removed obsolete code Remove obsolete code in src-wad code-generation related to already removed 2.50 style windows.
  • method removals in class org.openbravo.wad.controls.WADControl
    • addAdditionDefaulJavaFields
    • addAdditionDefaulSQLFields
    • columnIdentifier
    • getDefaultValue
    • getDisplayLogic
    • getLinkColumnId
    • getReadOnlyLogicColumn
    • getSQLCasting
    • has2UIFields
    • isLink
    • isText
    • processSelCol
    • processTable
    • toJava
  • class org.openbravo.wad.WadUtility removed public visibility
  • Removed xsql generated classes
    • org.openbravo.wad.EditionFieldsdata
    • org.openbravo.wad.TableRelationData
  • Removals in xsql generated class org.openbravo.wad.FieldsData
    • identifierColumns
    • parentsColumnName
    • parentsColumnReal
    • select
    • selectSequence
    • tableKeyColumnName
Low See 36819
PR17Q4.6 Core Removed field Removed protected username field in AuthenticationManager which was not thread-safe. Medium See 35164
PR17Q4.7 Core Platform callouts have been changed from implementing Servlet to SimpleCallout. Now the only way to extend them is documented here: http://wiki.openbravo.com/wiki/How_to_create_a_callout_that_extends_from_another_callout Medium See 36599
PR17Q4.8 Core Remove obsolete code Some obsolete / unused code was removed:
  • servlets:
    • org.openbravo.erpCommon.ad_forms.HeartbeatConfirm
    • org.openbravo.erpCommon.ad_forms.RegistrationConfirm
  • RequestFilter: org.openbravo.utils.CacheFilter
  • servlet: org.openbravo.erpCommon.businessUtility.TabFilter
    • related entry in table ad_model_object (id: 800663)
    • related entry in table ad_model_object_mapping (id: 800834)
  • obsolete ant targets:
    • ant import.sample.data.old
    • ant export.sample.data.old
    • java classes implementing those:
      • class org.openbravo.service.db.ExportReferenceDataTask
      • class org.openbravo.service.db.ImportReferenceDataTask
      • class org.openbravo.service.db.ReferenceDataTask
  • obsolete ant target:
    • ant check.window.compatibility
    • class implementing it org.openbravo.client.application.WindowsInClassicModeTask
Low See 36923

PR17Q3

ID Module Type Description Risk Comments
PR17Q3.1 Core Removed obsolete elements After the Login page cleanup, some compoenents became obsolete and were removed.
  • Full Java classes:
    • org.openbravo.erpCommon.utility.Log and its AD_MODEL_OBJECT row (800666)
    • org.openbravo.erpCommon.utility.Home and its AD_MODEL_OBJECT row (800668)
    • org.openbravo.erpCommon.ad_forms.AlertManagement and its AD_MODEL_OBJECT row (801432)
    • org.openbravo.erpCommon.ad_forms.Role nd its AD_MODEL_OBJECT row (801419)
    • org.openbravo.erpCommon.utility.MenuData
  • In org.openbravo.erpCommon.utility.Utility:
    • OB_MOBILE_JAVAPACKAGE field
    • isMobileBrowser method
    • hasTabAttachments method (and hasTabAttachments in UtilityData)
  • Removed org.openbravo.erpCommon.utility.VerticalMenu.getUrlStringStatic method
  • Removed "Home_Purpose_Tooltip" AD_MESSAGE
  • Removed "ServletSinIdentificar" Context Parameter
Low See 35386
PR17Q3.2 Core Functional API change after AD_IsOrgIncluded refactor The current AD_IsOrgIncluded function implementation works fine with organizations in any status, however after the refactor it only works with organizations set as ready Low See 35595
PR17Q3.3 Core Java methods removed Removed some unused methods in UsageAudit class None See 35865
PR17Q3.4 Core Added unique constraint in ad_orgmodule table Added a unique constraint in ad_orgmodule table in order to avoid duplicated data for the same client, org, module and version. Low See 35970
PR17Q3.5 Core Disabled Purchase Order Report Report and Process Puchase Order Report has been moved to a Process Definition. Old report has been disabled. Low See 35718
PR17Q3.6 Core Remove Purchase Order Report Report and Process Puchase Order Report has been moved to a Process Definition. Old report has been removed. Low See 36171

PR17Q2.4

No Changes

PR17Q2.3

ID Module Type Description Risk Comments
PR17Q2.3.1 Core Redefine I18NComponent as a session dynamic component With this change the I18NComponent extends SessionDynamicTemplateComponent. This implies that the I18NComponent inherits the getETag() method as a final method. None See 37266

PR17Q2.2

No Changes

PR17Q2.1

No Changes

PR17Q2

ID Module Type Description Risk Comments
PR17Q2.1 Core ApplicationDictionaryCachedStructures is no longer Serializable The ApplicationDictionaryCachedStructures is now application scoped. While session scoped beans require to be Serializable, application scoped ones do not. None See 35030
PR17Q2.2 Core OBDal class is no longer a singleton The OBDal class is no longer a singleton: it will not implement OBSingleton anymore but OBNotSingleton instead. Low See 34942
PR17Q2.3 Core Removed two tabs Two tabs that were not used have been removed. None See 35155

PR17Q1.3

No Changes

PR17Q1.2

No Changes

PR17Q1.1

No Changes

PR17Q1

ID Module Type Description Risk Comments
PR17Q1.1 Core Deleted the org.openbravo.model.materialmgmt.cost.CostAdjustment class from AD_MODEL_OBJECT It was incorrectly defined. None See 34217
PR17Q1.2 Core AD_ROLE.CLIENTLIST and AD_ROLE.ORGLIST columns have been removed. The have been deprecated for a long time and they should not be in use by any module. Low See 34297
PR17Q1.3 Core Servlet API has been updated to 3.0 This might affect any class implementing interfaces in javax.servlet.* packages. Low See 34100
PR17Q1.4 Core Changed public java methods Add MaterialTransaction parameter to CostingUtils.getCurrentStock and CostingUtils.getCurrentValuedStock methods. Add Currency parameter to CostAdjustmentUtils.getStockOnTransactionDate and CostingUtils.getCurrentStock methods. Low See 34184
PR17Q1.5 Core Added Constraint in Database Add Constraint in C_Conversion_Rate table, divideBy and multiplyBy columns must have always a positive value. Low See 34689
PR17Q1.6 Core Some constants have been defined as final. There were some constants which needed to be defined as final. Low See 34698
PR17Q1.7 Core Two fields of OBScheduler have been declared as private. The fields "dateTimeFormat" and "sqlDateTimeFormat" of OBScheduler are no longer public static fields. Now those fields are declared as private. None See 34788
PR17Q1.8 Core Remove PreferenceEventHandler class. PreferenceEventHandler class was being used to detect changes on the preference values cached by the CachedPreference class. This class has been changed to @SessionScoped therefore the cache will not be invalidated anymore as its values will persist now just along the life cycle of every session. Low See 34536
PR17Q1.9 Core Change in OBUIAPP_REPORT_TMP_CHK check The OBUIAPP_REPORT_TMP_CHK check was verifying that a process definition report template must had a template defined: PDF or XLS. With the inclusion of the HTML output, this constraint has been updated to consider this new type of template. Low See 34247

PR16Q4.3

No Changes

PR16Q4.2

No Changes

PR16Q4.1

No Changes

PR16Q4

ID Module Type Description Risk Comments
PR16Q4.1 Core Deleted the Register.java and modified the AD_MODEL_OBJECT.xml and the AD_MODEL_OBJECT_MAPPING.xml. The Register class is not longer used, so this has been deleted and its mappings also. None See 32991
PR16Q4.2 Core Modified constructor for OBDynamicPropertyHandler Getter and Setter classes Constructors for OBDynamicPropertyHandler Getter and Setter have been modified to accept the class they are used for. None See 33457
PR16Q4.3 Core Changed column length M_Inventory.name column length increased from 60 to 100 characters. Low See 33517
PR16Q4.4 Core Changed public java method AccountTreeData.selectFactAcct() signature change. The method now has a new String parameter compareTo to avoid getting useless data in case of launching a non-comparative Balance Sheet and Profit and Loss report Low See 33463
PR16Q4.5 Core Callouts are no longer Servlets
  • Callouts extending SimpleCallout do not extend HttpSecureAppServlet anymore, it extends from DelegateConnectionProvider instead of HttpSecureAppServlet. For this reason, lots of legazy attributes and legazy methods (See attached file in issue 33886) have disappeared. It has implemented its own ConnectionProvider in DelegateConnectionProvider.
  • The rest of callouts even extending HttpSecureAppServlet, are not treated as servlets, therefore not included in web.xml.
Medium See 33886
PR16Q4.6 Core Changed public java methods Add MaterialTransaction parameter to CostingUtils.getCurrentStock and CostingUtils.getCurrentValuedStock methods. Add Currency parameter to CostAdjustmentUtils.getStockOnTransactionDate and CostingUtils.getCurrentStock methods. Low See 34184

PR16Q3.5

No Changes

PR16Q3.4

No Changes

PR16Q3.3

ID Module Type Description Risk Comments
PR16Q3.3.1 Core Changed public java methods Add MaterialTransaction parameter to CostingUtils.getCurrentStock and CostingUtils.getCurrentValuedStock methods. Add Currency parameter to CostAdjustmentUtils.getStockOnTransactionDate and CostingUtils.getCurrentStock methods. Low See 34184

PR16Q3.2

No Changes.

PR16Q3.1

No Changes.

PR16Q3

ID Module Type Description Risk Comments
PR16Q3.1 Core Deleted the getFilterClause and getWhereClause methods of OBViewGridComponet class and the getWhereClause method of the SelectorComponent class. These methods are no longer used. Low See 32597
PR16Q3.2 Core Some new weld injections have been added in the BaseDataSourceService.java, DefaultDataSourceService.java and SelectorDataSourceFilter.java. Some new weld injections have been added to be able to use the new "Allow Where Parameter" preference http://wiki.openbravo.com/wiki/Preference#Preferences_Definition Low See 32653
PR16Q3.3 Core It is no longer possible to send the _where parameter. The standard datasources would not accept the "_where" parameter. High See 32619
PR16Q3.4 Core Deleted unused methods and class Deleted class:
  • org.openbravo.client.application.window.AttachmentsAH this class has been moved to new package org.openbravo.client.application.attachment

Deleted methods that are not longer used:

  • org.openbravo.client.application.window.OBViewParameterHandler.setParamWindow
  • org.openbravo.client.application.window.OBViewParameterHandler.setProcess
Medium See 32690
PR16Q3.5 Core Renamed cumqty column in M_Costing table. Renamed cumqty column in M_Costing table to cumstock and deleted data from it. Low See 32703
PR16Q3.6 Core A new weld injection has been added in the BaseDataSourceService.java. A new weld injection has been added to be able to use the new "Allow Unsecured Datasource Request" preference http://wiki.openbravo.com/wiki/Preference#Preferences_Definition Low See 32753
PR16Q3.7 Core Added checkEditDatasourceAccess and checkFetchDatasourceAccess methods in DataSourceService interface. These methods are going to be used to check entity access, so they need to be added. High See 32730
PR16Q3.8 Core The unused QueryBuilder class has been deleted. The QueryBuilder class is no longer used so it has been deleted. Low See 32321
PR16Q3.9 Core The unused SetContextInfoActionHandler class has been deleted. The SetContextInfoActionHandler class is no longer used so it has been deleted. Low See 30935
PR16Q3.10 Core Added getAdditionalMessage() method in ModuleLicenseRestrictions interface. This method is going to be used to retrieves extra information to be displayed in Instance Activation window. Low See 32881
PR16Q3.11 Core EntityResolver.setLookForTranslatedIDs method has been deleted This method is no longer used, so it has been deleted Low See 32994
PR16Q3.12 Core The PLSQL function hex_to_int has been deleted The function is no longer used, so it has been deleted Low See 32994
PR16Q3.13 Core The PLSQL function is_trigger_enabled has been deleted The function is no longer used, so it has been deleted Low See 32994
PR16Q3.14 Core The PLSQL function to_date has been deleted The function is no longer used, so it has been deleted Low See 32994
PR16Q3.15 Core The PLSQL function ad_shortname has been deleted The function is no longer used, so it has been deleted Low See 32994
PR16Q3.16 Core Methods Removed Removed methods that are not longer used:
  • org.openbravo.client.myob.MyOpenbravoComponent.getAvailableWidgetClasses() method.
  • org.openbravo.client.myob.MyOpenbravoComponent.getAvailableWidgetClasses(String roleId) method.
  • org.openbravo.client.myob.MyOpenbravoComponent.getAvailableWidgetClasses(String roleId, boolean isAdminMode) method.
Low See 33144

PR16Q2.4

No Changes.

PR16Q2.3

No Changes.

PR16Q2.2

No Changes.

PR16Q2.1

No Changes.

PR16Q2

No Changes.

PR16Q1.3

No Changes.

PR16Q1.2

No Changes.

PR16Q1.1

No Changes.

PR16Q1

ID Module Type Description Risk Comments
PR16Q1.1 Core Defaults defined as Preference prevail over defaults at column level If a field has a default value defined in its associated column and there is a preference to set a default value for this same field, preference value will be taken into account instead of the column level one. Low See 31038
PR16Q1.2 Core New unique index added in m_product_ch_conf A new unique index added in table, now is possible to insert or delete rows. Low See 31447
PR16Q1.3 Core Warehouse rules will now make partial reservations Warehouse rules will now make partial reservations in case it exists stock for the reservation but not enough to cover it completely. Medium See 30961
PR16Q1.4 Core Upgrade of commons-io library can cause build errors The commons-io 2.4 version introduces the toByteArray(Reader input, Charset encoding). This method can conflict with the existing method toByteArray(Reader input, String encoding) if NULL was passed to the second parameter. Low See 31432
PR16Q1.5 Core Upgrade of jdt-compiler library jdt-compiler library has been upgraded. It changes API. Low See 31878
PR16Q2.1 Core Removed public UnpagedRequestCachedPreference class UnpagedRequestCachedPreference class has been removed. The new CachedPreference class is replacing it. Low See 32041
PR16Q2.2 Core Upgrade of fop library fop library has been upgraded. It changes API. Besides, the ConfigParameters.getFopLogger() public method has been deleted as it not needed anymore. Low See 32123
PR16Q2.3 Core Upgrade of jackson libraries jackson libraries have been upgraded. They have some changes on their public API. Low See 32161
PR16Q2.4 Core Deleted methods in AddPaymentOrderInvoicesTransformer getOrderByClause() and appendOrderByClause() protected methods are no longer used. They have been removed. Low See 32145
PR16Q2.5 Core M_Transaction_Trg will only call M_Update_Inventory if a core column was updated M_Transaction_Trg will only call M_Update_Inventory if a no costing related core column was updated. Low See 32036
PR16Q2.6 Core Deleted class ChildTabRecordCounterActionHandler The class has been deleted because it is no longer used. Low See 32294

PR15Q4.6

No Changes.

PR15Q4.5

No Changes.

PR15Q4.4

No Changes.

PR15Q4.3

No Changes.

PR15Q4.2

No Changes.

PR15Q4.1

No Changes.

PR15Q4

ID Module Type Description Risk Comments
PR15Q4.1 Core Removed 2 ForcedLink preferences from Return windows. The Extend Navigation Model project has implemented a new method to define the window that needs to be opened when navigating. These ForcedLink preferences have been replaced by Navigation Rules. Low See 30496

PR15Q3.5

No Changes.

PR15Q3.4

No Changes.

PR15Q3.3

No Changes.

PR15Q3.2

No Changes.

PR15Q3.1

No Changes.

PR15Q3

ID Module Type Description Risk Comments
PR15Q3.1 OpenID Service Integration Removed all content except AD_TABLE, AD_COLUMN and guice, httpclient, httpcore and httpmime libraries. The 'Google Sign In' method based in OpenID has been deprecated. The new system based in OAuth2 has been implemented in a new commercial module. Low See 29895
PR15Q3.2 Integration with Google APIs Removed all content except AD_TABLE and AD_COLUMN The 'Google Sign In' method based in OpenID has been deprecated. The new system based in OAuth2 has been implemented in a new commercial module. Low See 29895
PR15Q3.3 Core Change in public constructor of a class which belongs to the JasperReports API. The JasperReports library has been upgraded to version 6.0.0. In this new version the constructor of the ListOfArrayDataSource class has been modified. Now it is as follows: public ListOfArrayDataSource(List<Object[]> records, String[] columnNames) Low See 29882
PR15Q3.4 Core Change in java package and terms of use of the new iText library. The new JasperReports library requires version 5.5.0 of iText library. The com.lowagie.text package is not available anymore. Also due to the license of this new iText library it is only allowed to use it through interfaces provided in the Jaspersoft LGPL Library. The complete text license can be seen in the /legal/iTextpdf_license.txt file of the Openbravo distribution. Low See 29882
PR15Q3.5 Core Container life cycle enforcement for CDI DefaultJsonDataService can't be instantiated with new, container should manage its life cycle instead. Low See 31371

PR15Q2.6

No Changes.

PR15Q2.5

No Changes.

PR15Q2.4

No Changes.

PR15Q2.3

No Changes.

PR15Q2.2

No Changes.

PR15Q2.1

No Changes.

PR15Q2

ID Module Type Description Risk Comments
PR15Q2.1 Core Removed Foreign Key AD_PINSTANCE_MSTOCKPROPOSED Removed Foreign Key AD_PINSTANCE_MSTOCKPROPOSED in M_STOCK_PROPOSED table High See 28823
PR15Q2.2 Core The size of AD_EXTENSION_POINTS.DESCRIPTION column has changed The size of AD_EXTENSION_POINTS.DESCRIPTION column has changed from 255 to 2000 Low See 28823
PR15Q2.3 Core AD_ORGINFO.DUNS column has changed into non mandatory AD_ORGINFO.DUNS column has changed into non mandatory Low See 28283
PR15Q2.3 Client Application Process Definition Client side validation js function change Client side validation JavaScript function for Process Definition receives an extra function parameter which needs to be invoked in case of validation failed. Medium See 29418

PR15Q1.5

No Changes.

PR15Q1.4

No Changes.

PR15Q1.3

ID Module Type Description Risk Comments
PR15Q1.3.1 Client Application Process Definition Client side validation js function change Client side validation JavaScript function for Process Definition receives an extra function parameter which needs to be invoked in case of validation failed. Medium See 29416

PR15Q1.2

No Changes.

PR15Q1.1

No Changes.

PR15Q1

ID Module Type Description Risk Comments
PR15Q1.1 Weld Google Collections library has been replaced by Guava This affects to modules including Guava library. Medium See 27781
PR15Q1.2 Core New mandatory columns in both M_STORAGE_DETAIL and M_RESERVATION_STOCK tables with default value. The column M_ATTRIBETESETINSTANCE_ID has been set as NOT NULL and has a default value and an OnCreateDefault value as well. Low See 27980
PR15Q1.3 Kernel Java changes in infrastructural kernel classes Classes wrapping HTTP requests, responses and sessions have been modified to better support tomcat 7 (Servlet 3.0 specs). These classes are rarely directly used by others. Medium See 28129

Details

PR15Q1.4 Core Removal of widget in reconciliation window View behind the widget was being exported different depending on postgresql version. Low See 27741
PR15Q1.5 Core Removal of not used view (C_ORDER_LINETAX_VT). View is not used neither referenced by any known module. Low See 27742
PR15Q1.6 Core New Check constraint for Journals. Required for multi-accounting schema journal entries Low See 27104
PR15Q1.7 Core Removal of RTV and RFC pick and edits manual datasources RTV and RFC manual datasources have been replaced by RTV and RFC based on HQL Datasources Low See 28259

PR14Q4

ID Module Type Description Risk Comments
PR14Q4.1 Client Application Removed preference type Unimplemented OBUIAPP_UIStartTabURL has been removed from available preferences Low See 27164
PR14Q4.2 Core Add Organization ID in the unique constraint C_Bpartner_Value Business partner with the same search key can be defined in different organization of the same client. Earlier business partner with same search key were not allowed to defined in the same client, No matter in which organization it belong too. None See 25997
PR14Q4.3 Core Add on delete cascade constraint to FK The AD_Pinstance_ID Foreign Key on M_Stock_Proposed table now has an on delete cascade constraint. None See 27259
PR14Q4.4 Core Add assert* methods for test classes Test classes now do not extend TestCase so all assert* methods are added. Medium See 27290
PR14Q4.5 Core Test classes removed from main path Test classes are now not part of main class path Low See 27320
PR14Q4.6 Core Mandatory columns in Fin_Finacc_Transaction statementdate, dateacct and trxtype columns in Fin_Finacc_Transaction table marked as mandatory and not null Low See 27614
PR14Q4.7 Core New constraint in Fin_Finacc_Transaction table Constraint: FIN_TRANS_AMOUNTS_CHK defined as: (PAYMENTAMT <> 0) OR (DEPOSITAMT <> 0) Low See 27614
PR14Q4.8 Core The size of ENTITY_ALIAS column has changed The size of AD_COLUMN table ENTITY_ALIAS column has changed from 60 to 2000 Low See 27614
PR14Q4.9 Core New mandatory column in M_TRANSACTION_COST without default value The column DATEACCT has been added to the table and does not have a default value. Low See 27724
PR14Q4.10 Core A process has been removed from AD_PROCESS_ID "Validate Costing Rule" process has been removed from AD_PROCESS_ID table and a OBUIAPP_PROCESS has been created to replace the functionality Low See 28423
PR14Q4.11 Core The reference of an AD_COLUMN changed from Number to Integer The reference of Line No. column has been changed from Number to Integer in Landed Cost Cost table Low See 28600

PR14Q3.8

No Changes.

PR14Q3.7

No Changes.

PR14Q3.6

No Changes.

PR14Q3.5

No Changes.

PR14Q3.4

No Changes.

PR14Q3.3

No Changes.

PR14Q3.2

No Changes.

PR14Q3.1

ID Module Type Description Risk Comments
PR14Q3.1.1 Core Unused entry removed from AD_TABLE_TREE The FinancialMgmtAccountingReport table had an entry in the ad_table_tree table that should not have been there, because it actually belonged to the FinancialMgmtAccountingRptElement table. Therefore the entry from FinancialMgmtAccountingReport has been removed. Low See 28141

PR14Q3

ID Module Type Description Risk Comments
PR14Q3.1 Core Change reference type of time fields in production run to DateTime Change reference type of starttime and endtime in production run to DateTime. This will enable the user to see both date and time in start time and end time fields. Low See 26230


PR14Q3.2 Core Change FK or c_orderline_id column in m_requisitionorder table. Change the FK of c_orderline_id column adding an on delete cascade clause. This will automatically delete the relation between order lines and requisition lines. There is a trigger that only allows to delete this relation on not closed requisitions. Low See 26468
PR14Q3.3 Core Two public methods have been removed from OBViewParameter class. The and methods were only public because Freemarker needed them that way to be able to access them. No developer should be affected by this change. Low See 26912

PR14Q2.6

No Changes.

PR14Q2.5

No Changes.

PR14Q2.4

No Changes.

PR14Q2.3

No Changes.

PR14Q2.2

No Changes.

PR14Q2.1

No Changes.

PR14Q2

ID Module Type Description Risk Comments
PR14Q2.1 Advance Payable and Receivable Module Remove IsCustomerBalanceRestored preference from Advance Payable and Receivable Module Remove IsCustomerBalanceRestored preference from Advance Payable and Receivable Module, If it is not present in the preferences modulescript UpdateCustomerBalance creates preference IsCustomerBalanceRestored and sets Module as NULL for this preference. None See 25469
PR14Q2.2 Core Module Remove M_Storage_Detail_Id in M_Reservation_Stock table Remove M_Storage_Detail_Id in M_Reservation_Stock table,This column is not used at all in core and it's neither populated. Low See 0025427
PR14Q2.3 Core Module Add Report Type Parameter to Customer Statement Report A new Parameter has been added to Customer Statement Report to allow showing also vendor information. Low See 0024665
PR14Q2.4 Core Module Change the definition of column processing to column processed. The problem was that button "Process/Unprocess" expense sheet was using column processing and it was wrong, because the button needs to change from processing to unprocess when processed has value 'Y' and the only way to do that is using processed column. Medium See 0025449
PR14Q2.5 Core Editable online help and xinha library have been removed Editable online help and xinha library have been moved to Legacy Features Module. Low See 25749
PR14Q2.6 Core Module Remove C_RM_ORDER_PICK_EDIT_LINES and M_RESERVATION_PICK_EDIT For performance issues, C_RM_ORDER_PICK_EDIT_LINES and M_RESERVATION_PICK_EDIT views that are used in pick and edits windows are changed by manual data source Medium See 0025833
PR14Q2.7 Core Changed the Rejected Qty column definiton of the Production Run tab Now it is possible to introduce decimals in the Rejected Quantity of the Production Run tab. Low See 25687

MP31.4

No Changes.

MP31.3

No Changes.

MP31.2

No Changes.

MP31.1

No Changes.

MP31

No Changes.

MP30.3

No Changes.

MP30.2

No Changes.

MP30.1

No Changes.

MP30.1

ID Module Type Description Risk Comments
MP30.1.1 Core Removed Tabs & Fields related to Cash VAT Management Cash VAT Management is a feature that should be used by a reduced number of users, however the impact in the user interface is very high, affecting important windows like Purchase/Sales Orders/Invoices, Tax Rate, Business Partner or Organization. In order to make it transparent for the users, we have decided to move only the UI artifacts related to the Cash VAT (Tabs & Fields) to an external module (called Cash VAT Management), that can be manually installed by the users interested in this feature. None See 25411

MP30

ID Module Type Description Risk Comments
MP30.1 Core Add a new contraint Constraint to update C_InvoiceLine_ID in Expense sheet line to null when deleting the invoice line Low See 25177

MP29.4

No Changes.

MP29.3

No Changes.

MP29.2

No Changes.

MP29.1

No Changes.

MP29

ID Module Type Description Risk Comments
MP29.1 Core Grid Datasource Request When the datasource is called from the grid, only the visible columns are fetched. As a consecuence, unless a register is open in form view, some of its columns will not have its values loaded. Low See 24403

MP28.5

No API Changes

MP28.4

No API Changes

MP28.3

No API Changes

MP28.2

No API Changes

MP28.1

No API Changes

MP28

No API Changes

MP27.1

No API Changes.

MP27

ID Module Type Description Risk Comments
MP27.1 Core Properties for Computed columns Properties for Computed columns in generated DAL classes is not present anymore due to lazy evaluation. High See 24495

See documentation.

MP26.4

No API Changes

MP26.3

No API Changes

MP26.2

No API Changes

MP26.1

No API Changes

MP26

ID Module Type Description Risk Comments
MP26.1 Core Retrieving attachments API Change API change to change the attachment model. Earlier attachments were stored in this format, tableId-recordId. Now it will changed as per the specifications in alternate 2 in issue https://issues.openbravo.com/view.php?id=20623. [^] It a critical change that would affect java process that uses the earlier format to access the attachments. For existing attachments in the old model, it will be retrieved and can be downloaded/deleted from the Application as before.

Backwards compatibility is maintained. If we want to follow the old model, we can set the preference "SaveAttachmentsOldWay"

Low See 24289
MP26.2 Core Deletion of ant load.logoimages & ImageToDatabaseloader class ant create.database is now able to handle images, so the special code in the ImageToDatabaseLoader does no longer serve any and has been deleted. Also the internal ant target load.logoimages to call it has been deleted, however that was never needed to be called manually before either. Low See 24249
MP26.3 Core Changed column length AD_AUXILIARINPUT.CODE column length increased from 510 to 2000 characters Low See 24414

MP25.2

No API Changes

MP25.1

No API Changes

MP25

No API Changes

MP24.2

No API Changes

MP24.1

No API Changes

MP24

No API Changes

MP23.2

No API Changes.

MP23.1

No API Changes.

MP23

ID Module Type Description Risk Comments
MP23.1 Core Amount (or Quantity) column in breakdown tables must be mandatory Amount (or Quantity) column in breakdown tables must be mandatory in database and application dictionary. Low See 23099
MP23.2 Core DalUtil.copy should not copy non-child one-to-many association contents The DalUtil.copy also copies the content of non-child one-to-many list-associations. This is incorrect, for example when copying a UOM, its list of orderlines should not be copied as they belong to the original/source UOM. Low See 23640
MP23.3 Core Change a column definition Change the reference of one column from integer with length 2 to number length 12. Low See 23696
MP23.4 Core Add a new contraint The constraint checks that the price list, name of the price list version and valid from date are unique. Low See 23636

MP22.3

No API Changes

MP22.2

No API Changes

MP22.1

No API Changes

MP22

ID Module Type Description Risk Comments
MP22.1 Core Removed SmartSprites functionality The functionality SmartSprites has been removed to fix a library dependency inconsistency. Low See 23344
MP22.2 Core Added argument to doPostInsert and doPostUpdate functions It affects to DefaultJsonDataService class Low See 23432

MP21.1

No API changes.

MP21

ID Module Type Description Risk Comments
MP21.1 Core Change the package name from src.org.openbravo.Event to src.org.openbravo.Event and change the name of the class PeriodEnventHandler to PeriodEventHandler Change the javapackage and the name of the class Low See 23175

MP20

ID Module Type Description Risk Comments
MP20.4 Core Add new parameter to m_reserve_stock_manual Add new parameter to m_reserve_stock_manual Low See 22958
MP20.3 Client Application Removed org.openbravo.client.application.window.StandardWindowComponent.TEMPLATE_MAP This was previously used by Pick & Execute windows, now as they have been refactored by Parameter Windows projects, it is not needed anymore. Low See 22917
MP20.2 Core Removed Business Partner from the Open Items Restriction The field "Business Partner" should not be mandatory while creating a payment from a G/L Journal line, because it is possible to create a "G/L Item" payment do not linked to a BP either in the Payment In/Out windows. Low See 22804
MP20.1 Core Removed columns from database including two from AD_User table and java classes. Multiple columns and java classes were included into when fixing an Issue that has been reverted. Now this columns and classes has been removed. The Issue that removes them is 22809.

The two columns from AD_User (ISBILLINGCONTACT and ISDEFAULTBILLINGCONTACT) were included into MP19 being wrongly auto-populated for users created before MP19

None See 22828 Note this is the same change as MP19.1.1

MP19.3

No API Changes

MP19.2

No API Changes

MP19.1

ID Module Type Description Risk Comments
MP19.1.1 Core Removed columns from database including two from AD_User table and java classes. Multiple columns and java classes were included into when fixing an Issue that has been reverted. Now this columns and classes has been removed. The Issue that removes them is 22809.

The two columns from AD_User (ISBILLINGCONTACT and ISDEFAULTBILLINGCONTACT) were included into MP19 being wrongly auto-populated for users created before MP19

None See 22828

MP19

No API Changes

MP18.4

No API Changes

MP18.3

No API Changes

MP18.2

No API Changes

MP18.1

No API Changes

MP18

ID Module Type Description Risk Comments
MP18.4 Core Name column length increased fro table AD_TREE. This column length has been increased from 60 to 255. This can affect any module which is using this column and assuming its length is 60. Low See 22467
MP18.3 Core Related to User1 and User2 implementation. This columns had a reference type String as there were no table implementation behind these IDs. Now these tables have been created and so there is a new reference for this properties in DAL objects pointing to the new object (User1 or User2). Medium See 22467
MP18.2 Core M_PRODUCT_PO.VENDORPRODUCTNO column goes from not nullable to nullable. This column is in a unique constraint that needs to be removed due to 21886 issue. The unique constraint is that each product needs to have one unique vendorproductno for each business partner and this is not right, because two partners may have the same vendortproductno for the same product. Low See 22339
MP18.1 Core Cascade on delete options for m_inoutline_id in m_matchpo Cascade on delete options for m_inoutline_id in m_matchpo Low See 21933

MP17.3

No API Changes

MP17.2

No API Changes

MP17.1

No API Changes

MP17

ID Module Type Description Risk Comments


MP17.4 Core The NOT NULL constraint has been deleted from the following columns:

C_ACCTSCHEMA_DEFAULT - CH_EXPENSE_ACCT, C_ACCTSCHEMA_DEFAULT - CB_EXPENSE_ACCT, C_ACCTSCHEMA_DEFAULT - CB_RECEIPT_ACCT, C_CASHBOOK_ACCT - CB_EXPENSE_ACCT, C_CASHBOOK_ACCT - CB_RECEIPT_ACCT

These accounts are no longer used and they were mandatory on the DB Low See 22274
MP17.3 Core FIN_Payment_Schedule - DueDate Flagged as NOT NULL DueDate was not mandatory column due to a design error. Now it has been flagged as NOT NULL and mandatory in AD Low See 22094 Note this is the same change as MP14.2.1
MP17.2 Core For the AD_Field tab: the 'show Summary' field has been removed from the AD_Field tab, the column remains in the AD_Field table but has been deprecated. The show summary field is not needed as there is already a summary function field which can be used to signal/define that a summary function should be used to generate/compute a summary row.

Note: if you have an ad_field record with show summary == 'Y' then you should fill in the summary function column in that record (set it to the value: sum) and then set the show summary value to 'N' (in the database).

Low See 21992
MP17.1 Core Auxiliar Inputs 0B9C4236A03943D69F2D86E50AD24E7D and 76CC2F23C4D1416FB518609BCE17CBF8 have been deleted. These auxiliar inputs were created to be used in Process Plan and Work Requirement windows to make them be as purchase windows for the product complete selector. The same need appeared for the Manufacturing Plan tab. The decission was to change the selector's field's default expression and let the windows behave as sales windows as they should be. Low See 21761

MP16.3

No API Changes

MP16.2

ID Module Type Description Risk Comments
MP16.2.1 Core The NOT NULL constraint has been deleted from the following columns:

C_ACCTSCHEMA_DEFAULT - CH_EXPENSE_ACCT, C_ACCTSCHEMA_DEFAULT - CB_EXPENSE_ACCT, C_ACCTSCHEMA_DEFAULT - CB_RECEIPT_ACCT, C_CASHBOOK_ACCT - CB_EXPENSE_ACCT, C_CASHBOOK_ACCT - CB_RECEIPT_ACCT

These accounts are no longer used and they were mandatory on the DB Low See 22274

MP16.1

ID Module Type Description Risk Comments
MP16.1.1 Core FIN_Payment_Schedule - DueDate Flagged as NOT NULL DueDate was not mandatory column due to a design error. Now it has been flagged as NOT NULL and mandatory in AD Low See 22094 Note this is the same change as MP14.2.1

MP16

ID Module Type Description Risk Comments
MP16.4 Core Foreign keys are now defined as ON DELETE CASCADE FIN_Orig_Paymemnt_Schedule and FIN_Orig_Paym_Scheddetail Tables are now deprecated. They are present in the database only for users to being able to recover the information. Therefore the Foreign Keys defined in the tables should not block deleting records from other ones. That is why all Foreign Key references had changed to ON DELETE CASCADE, and in the Application Dictionary, they are no longer defined as Link To Parent Column. Low See 21767
MP16.3 Core Increased column size for several columns C_BP_BANKACCOUNT.ACCOUNTNO from 20 to 100. C_BP_BANKACCOUNT.DISPLAYEDACCOUNT from 34 to 120. FIN_FINANCIAL_ACCOUNT.ACCOUNTNO from 20 to 120. This increase allows users to enter any possible value for account numbers, like the concatenation of routing numbers, control digits, etc. Low See 21737
MP16.2 Core Added delete on cascade constraint A delete on cascade constraint has been added to obuiapp_note.ad_table_id column to allow to delete tables even if notes have been defined on them. Low See 21672
MP16.1 Core The reference of Ad_Module_Id column in the Ad_Ref_Data_Loaded table has been change The AD_Ref_Data_Loaded table stores the corresponding ids for imported reference data. The Module column points to the module which contained the data originally. This module can subsequently be uninstalled, so attempting to preserve referential integrity here doesn't make sense. Therefore, the reference of the column has been changed to a non-foreign key one, to prevent validation problems when importing clients with DAL. Low See 21259

MP15.2

ID Module Type Description Risk Comments
MP15.2.1 Core FIN_Payment_Schedule - DueDate Flagged as NOT NULL DueDate was not mandatory column due to a design error. Now it has been flagged as NOT NULL and mandatory in AD Low See 22094 Note this is the same change as MP14.2.1

MP15.1

No API Changes

MP15

ID Module Type Description Risk Comments
MP15.1 Core EM_APRM_MODIF_PAYM_SCHED and EM_APRM_MODIF_PAYM_OUT_SHCHED Columns from C_Invoice table have been deleted. This columns were used for creating a button in the Invoice header, that has been moved to the Payment Plan tab. Therefore this columns were no longer needed. Low See 21624

MP14.2

ID Module Type Description Risk Comments
MP14.2.1 Core FIN_Payment_Schedule - DueDate Flagged as NOT NULL DueDate was not mandatory column due to a design error. Now it has been flagged as NOT NULL and mandatory in AD Low See 22094

MP14.1

ID Module Type Description Risk Comments
MP14.1.1 Core EM_APRM_MODIF_PAYM_SCHED and EM_APRM_MODIF_PAYM_OUT_SHCHED Columns from C_Invoice table have been deleted. This columns were used for creating a button in the Invoice header, that has been moved to the Payment Plan tab. Therefore this columns were no longer needed. Low See 21624 Note this is the same change as MP15.1

MP14

ID Module Type Description Risk Comments
MP14.1 Core M_PRODUCT_BOM_CHECK stored procedure has been removed. The same functionality is implemented in a Java process: org.openbravo.erpCommon.ad_process.VerifyBOM Low See 20711

MP13.2

No API Changes

MP13.1

No API Changes

MP13

ID Module Type Description Risk Comments
MP13.1 Core Change in the format used by the server to send a time field value to the client. Time fields used to be sent from the server to the client in the 'HH:mm:ssZZZZZ' format. Now they are sent using the GMT time zone with the 'HH:mm:ss' format. This change may only affect those who receive time fields from the server and use non-standard functions to parse them to dates. Low See 20751
MP13.2 Core Change classname length to 1000 in AD_AcctProcess table The length of the Classname column inside the AD_AcctProcess table is 60, and it is clearly not enough. Low See 20748

MP12.2

No API changes.

MP12.1

No API changes.

MP12

ID Module Type Description Risk Comments
MP12.1 Core Delete validation in ad_val_rule "M_Product_Category in Product Sequence Orgs" validation is deleted in ad_val_rule Low See 20426
MP12.2 Core Add mandatory constants The "name"/"identifier" of an item inside a json response, should not cointain the dot (".") as a separator (in case it has one):

To avoid the use of a hardcoded separator, the following change is needed:

Javascript handling the json: replace the "." by OB.Constants.FIELDSEPARATOR

Example:

  • prop. + OB.Constants.IDENTIFIER; (or prop._identifier);

turns into

  • prop + OB.Constants.FIELDSEPARATOR + OB.Constants.IDENTIFIER;


Java returning the json: replace the "." by DalUtil.FIELDSEPARATOR (import org.openbravo.dal.core.DalUtil)

Example:

  • key + "." + JsonConstants.IDENTIFIER (or key + "._identifier")

turns into

  • key + DalUtil.FIELDSEPARATOR + JsonConstants.IDENTIFIER

NOTE: This change could already be optionally done in MP11, but is mandatory from MP12.

Medium See 20397
MP12.3 Core Added new unique constraint and modified two existing ones Created new unique constraint inside C_BP_GROUP_ACCT table [C_ACCTSCHEMA_ID, C_BP_GROUP_ID] to ensure no duplicated accounting information per Accounting Schema and Business Partner Category can be entered.

The Status column has been removed from the C_BP_CUSTOMER_ACCT_BPARTNER_UN unique constraint inside C_BP_CUSTOMER_ACCT table.

The Status column has been removed from the C_BP_VENDOR_ACCT_ACCTSCHEMA_UN unique constraint inside C_BP_VENDOR_ACCT table.

This Status column was used by the previous financial flow and it is not used anymore by the new Advanced Payables and Receivables functionality.

A build validation rule has been included to ensure no wrong records exist when updating the system. In case a wrong record is detected, the system will automatically create a new alert to help fixing the problem.

Low See 13691
MP12.4 Core Change username to NVARCHAR Change username column to NVARCHAR type in ad_user table Low See 20470
MP12.5 APRM APRM_PENDING_PAYINV_PAYMENT foreign key from on delete do nothing to on delete cascade. APRM_PENDING_PAYINV_PAYMENT foreign key of table APRM_PENDING_PAYMENTINVOCE changes from on delete do nothing to on delete cascade. Low See 20598
MP12.6 Core 'Out' selector fields removed The location identifier and contact fields of the business partner selector have been removed. If someone had implemented a callout that received them, they will receive an empty string. Low See 20648

MP11.1

No API changes.

MP11

ID Module Type Description Risk Comments
MP11.1 Core Columns reference modified In ADModuleInstall table, column AD_Language will change from String to Table(AD_language) Low See 20307
MP11.2 Core Columns reference and definition modified
  • In the database, the column factaccttype of the table Fact_Acct has been changed from char of 1 to varchar of 60
  • In the Application Dictionary, it's reference has been changed from a yes/no reference to a list reference.
  • The same reference change has been made for the views aprm_finacc_transaction_acct_v and aprm_finacc_trx_full_acct_v in the Application Dictionary.
Low See 20327
MP11.3 Core Columns reference The reference has been changed from Number to Integer for the column Delaymin Low See 20344
MP11.4 Core Add constraints in database Two constraints have been added to AD_ORG_ACCTSCHEMA table Low See 20353
MP11.5 Core Delete process in ad_process "C_Payment_Post Online" process is deleted in ad_process Low See 20359

MP10.3

No API changes.

MP10.2

No API changes.

MP10.1

No API changes.

MP10

No API changes.

MP9.3

No API changes.

MP9.2

No API changes.

MP9.1

No API changes.

MP9

ID Module Type Description Risk Comments
MP9.1 Core Columns definition modified In S_TIMEEXPENSE table, column PROCESSED will change from VARCHAR 60 to CHAR 1 and column PROCESSING will change from CHAR 1 to VARCHAR 60.. Low See 19355

MP8.4

No API changes.

MP8.3

No API changes.

MP8.2

No API changes.

MP8.1

No API changes.

MP8

ID Module Type Description Risk Comments
MP8.1 Core Column definition modified The length of EMAILUSER column of the AD_USER table has been changed from 20 to 40. Low See 19257
MP8.2 Core Removed generated xsql methods in action button 2 generated methods in action button have been removed as the menu entries for associated processes are not active anymore None See 19569

MP7.3

No API changes.

MP7.2

No API changes.

MP7.1

No API changes.

MP7

ID Module Type Description Risk Comments
MP7.1 Core API changes in BaseWebServiceServlet class
  • Made final method org.openbravo.service.web.BaseWebServiceServlet.service
  • Removed method org.openbravo.service.web.BaseWebServiceServlet.doBasicAuthentication
  • Removed method org.openbravo.service.web.BaseWebServiceServlet.isLoggedIn
Low See 19337
MP7.2 Core API changes in AD_Field
  • Removed deactivated fields from core.
Low See 19346

MP6.2

No API changes.

MP6.1

ID Module Type Description Risk Comments
MP6.1.1 Core API changes in AD_Field
  • Removed deactivated fields from core.
Low See 19346 Note this is the same change as MP7.2

MP6

ID Module Type Description Risk Comments
MP6.1 Core Removed AD_Model_Object and AD_Model_Object_Mapping ReportGeneralLedgerJournalDetail mapping moved from ReportGeneralLedgerJournal process to ReportGeneralLedgerJournalDetail process. Low See 0019059
MP6.2 Workspace & Widgets Java API change Return type of org.openbravo.client.myob.WidgetClassMenuTrl.getLanguage() changed from String to Language. setLanguage method in the same class accepts Language instead of String. Low See 19201

MP5.3

No API changes.

MP5.2

No API changes.

MP5.1

No API changes.

MP5

ID Module Type Description Risk Comments
MP5.1 Core Column definition modified Email server username field in User window gets its length increased from 20 to 40. Low See 18717

MP4.2

No API changes.

MP4.1

No API changes.

MP4

ID Module Type Description Risk Comments
MP4.1 Core Refactor AuthenticationManager The AuthenticationManager interface and LoginHandler class had mixed concerns. With this refactor we separate the concerns and improve the modularity of this artifacts Medium See 18492
MP4.2 Client Application Refactor Generation of javascript for window/tab/field The generation of the window/tab/field javascript has been reworked to generate less javascript code and to clean up code. Only code which is assumed to be used internally by Openbravo has been changed. Low See 18467 and 18470
MP4.3 Core Change in Product Register window As part of a change to fix issue 18575, the Product Register window has been moved to the client.application module, and some AD components have been deleted. Low See 18615
MP4.4 Core Removed Delete client old implementation As part of a change to fix issue 17641, the old delete client implementation (which consisted on two PL/SQL functions) and a couple of related PL/SQL utility functions (used to disable/enable constraints) have been removed. Low See 17641

MP3.2

No API changes.

MP3.1

No API changes.

MP3

ID Module Type Description Risk Comments
MP3.1 Client Application Column made mandatory The ad_tab_id column of the UI_Personalization table has been made mandatory.

The risk is low as entries in this table are mostly created automatically (which sets a value on this column), and because the table has been introduced in MP2, so it is a 'young' table.

Low See 18299
MP3.2 Core Java deletion of public methods The fix for issue 18519 does revert 4 API additions done earlier and deletes those public methods again as they produce wrong results / are no longer applicable. All of the removed methods have been added only recently in MP2 so chance of code using it rather low. Low See 18610 Note this is the same change as MP2.3.1

MP2.4

No API changes.

MP2.3

ID Module Type Description Risk Comments
MP2.3.1 Core Java deletion of public methods The fix for issue 18519 does revert 4 API additions done earlier and deletes those public methods again as they produce wrong results / are no longer applicable. All of the removed methods have been added only recently in MP2 so chance of code using it rather low. Low See 18610

MP2.2

No API changes.

MP2.1

No API changes.

MP2

ID Module Type Description Risk Comments
MP2.1 Core Column definition modified Length of EMAIL column in table AD_USER has changed from 40 to 255. Low See 18083
MP2.2 Core Removed AD_Model_Object and AD_Model_Object_Mapping ReportTrialBalanceDetail mapping moved from ReportTrialBalance process to ReportTrialBalanceDetail process. Low See 18136

MP1

ID Module Type Description Risk Comments
MP1.1 Core Column definition modified Column CALCOST in tables MA_SEQUENCE_EMPLOYEE,MA_SEQUENCE_IC and MA_SEQUENCE_MACHINE has changed from numeric(10,0) to numeric. Low See 17495
MP1.2 Core Column reference modified AD_MODULE_TRL.AD_LANGUAGE changed from String to Table ref None See 17647
MP1.3 Core Changes to java-api Method getIcon from navigationbarcomponents.QuickLaunchComponent has been removed None See 17742
MP1.4 Core Removed unused and not implemented call-out Call-out SE_Assignment_Product was defined in AD, but not implemented in any Java. It has been removed from core. Low See 15999
MP1.5 Core Column moved to mandatory in AD C_Invoice.FIN_Payment_Method column has changed to Mandatory Low See 15485

MP0

No API changes.

RC7

ID Module Type Description Risk Comments
RC7.1 APRM Preferences removed 4 Preferences have been removed to allow processes on financial account window open on modal windows. None This API change was introduced while migrating Financial Account window to new ui.
RC7.2 core Changes to java-api Related to the library update work 3 groups of api-changes have been done: a.) Removal of the 'LAM authentication manager' from pi (now available as a module) b.) Changes related to the rewrite of generate.entities and change of template engine used for it c.) Changes to some dal-core classes as the hibernate classes they extend changed with the new hibernate version used. Low The full list of changes can be seen in the int-api mentioned in the issue: 16988
RC7.3 core Methods removed Related to the code-cleanup done for 3.0 some deprecated java-methods have been removed. More concrete only those methods have been removed which were marked as deprecated already in the stable 2.40 release and which were used in core in the 2.35 release for the last time. Low The full list of changes can be seen in the int-api mentioned in the issue: 17091

RC6.1

No API changes.

RC6

ID Module Type Description Risk Comments
RC6.1 core Mandatory column added STATUS mandatory column added on AD_ALERT without default values. Medium This API change was introduced while redesigning Alert Management window.

RC5.1

No API changes.

RC5

No API changes.

RC4

ID Module Type Description Risk Comments
RC4.1 core Constraints added. Constraints have been added for both MA_SEQUENCEPRODUCT and MA_WRPHASEPRODUCT tables. Medium This API change was introduced while fixing issue 15139

Note: this is the same change like 2.50MP25.1

RC4.2 core Constraint added. Unique constraint has been added in FIN_FINACC_TRANSACTION table. Low This API change was introduced while fixing issue 15400

Note: this is the same change like 2.50MP25.2

RC4.3 core Removed AD_Model_Object and AD_Model_Object_Mapping All Model Object and Model Object Mapping entries for generated windows have been removed from AD.

Modules making direct use of mapping entries to generate links in manual code will have to be changed, the preferred way of obtaining the link is by using the org.openbravo.erpCommon.utility.Utility.getTabURL method.

Medium This API change was introduced while fixing issue 14236
RC4.4 core Tab Removed Removed Class and Mapping tabs from Tab tab in Window, Tab and Field window. These tabs were used for the Model Object and Model Object Mapping setting, which now is not used anymore. (See API change RC4.3) None This API change was introduced while fixing issue 14236
RC4.5 core Method Removed Removed org.openbravo.erpCommon.utility.UtilityData.selectObjectMapping method. Low See15534
RC4.6 core Class Removed Removed org.openbravo.erpCommon.utility.TabData class Low See 15534
RC4.7 QueryList widget Class Removed Removed org.openbravo.client.querylist.QueryListComponent class Low See 15536
RC4.8 Parameter utilities Java API change (methods moved) Methods moved from ApplicationUtils to ParameterUtils Low See 15561
RC4.9 Client Application Module Interface made private The interface org.openbravo.client.application.window.OBViewFormComponent.OBViewFieldDefinition has been made private. Low See 15573
RC4.10 Kernel Module Class Moved Moved org.openbravo.client.kernel.reference.FKSelectorUIDefinition class to org.openbravo.userinterface.selector.reference.FKSelectorUIDefinition Low See 15578
RC4.11 MyOpenbravo Module Widget Class Removed The example Show all parameters widget class has been removed. Low See 15586
RC4.12 User Interface Client Kernel Template removed OBCLKER_TEMPLATE - ID: 7130F3674BCC434C8F939DFC2F58002B Low
RC4.13 User Interface Application Renamed messages OBUISEL_CALLOUT_JS_EXPR_ERROR renamed to OBUIAPP_CALLOUT_JS_EXPR_ERROR

OBUISEL_CALLOUT_JS_EXPR_RESULT renamed to OBUIAPP_CALLOUT_JS_EXPR_RESULT

Low
RC4.14 User Interface Selector Removed element Element "Modelproperty" (833F03D315A241F6A1B8E45DF6CB110B) has been removed. Low
RC4.15 Client Application Classes moved OBBindings and OBBindingsConstants classes moved to Client Application module. Low
RC4.16 Weld/Seam Seam replaced by Weld modules The Seam module has been replaced by the JBoss Weld module. Several initialization methods of base framework classes have been removed. These methods are normally not used externally. See the Projects/Weld Openbravo Weld project page for more information. Low See 15531
RC4.17 Client Application QuickCreateComponent class hierarchy changed The class hierarchy of the QuickCreateComponent has changed, it now directly inherits from its original grand parent class. Low See 15619
RC4.18 Client Application Test method removed A test method which was not relevant anymore was removed:

org.openbravo.client.application.test.ApplicationTest.testMainLayoutComponentGeneration()

Low See 15620
RC4.19 Client Application Non-relevant class removed A class method which was never used has been removed:

class org.openbravo.client.application.window.EntityWindowMappingComponent: missing in 793

Low See 15621
RC4.20 Client Kernel Different method for working with static resources Static resources are now concatenated together into one js file, several not-needed methods have been removed, see the issue for more information. Low See 15622
RC4.21 Client Application Removed constructor Removed org.openbravo.client.application.window.OBViewTab.ButtonField() constructor None See 15629
RC4.22 Advanced Receivables and Payables Modified interface for Matching Algorithm Interface for Matching Algorithm (FIN_MatchingAlgorithm) now implements a new method for unmatching transactions which forces any existing algorithm to implement that logic Low
RC4.23 Core Modified column data type Column type change from VARCHAR to CLOB: column:AD_PROCESS_RUN.LOG Low See 15755
RC4.24 Core Modified column size Column size changed from 255 to 200: column: FIN_MATCHING_ALGORITHM.DESCRIPTION Low See 15792

Note: this is the same change like 2.50MP27.1

RC4.25 Core Modified column size The column AD_CREATEFACT_TEMPLATE.CLASSNAME increases its length from 60 to 1000 characters. Low See 15828
RC4.26 Client Application Changed return type of a public method ParameterUtils.getParameterFixedValue() method's returns Object instead of String Low See 15848
RC4.27 core Removed AD_Model_Object entries Removed the CacheFilter from tomcat None See 15380
RC4.28 core Changed function behavior ModelProvider.getTables() was changed to only return the list of tables usable with DAL instead of all tables defined in ad_table (now consistent with other public methods in the same class) None See 15900
RC4.29 core Removed AD_Message entry Removed AD_Message 153CA3EF567C4985810C3FC5710FFAFB None See 15977

RC3

ID Module Type Description Risk Comments
core API-check started to be run after 3.0RC3. Note that RC3 is based on same codeline as 2.50MP24.