View source | Discuss this page | Page history | Printable version   
Toolbox
Main Page
Upload file
What links here
Recent changes
Help

PDF Books
Add page
Show collection (0 pages)
Collections help

Search

API changes

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.


PI

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

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 Legazy attributes and methods have disappeared. Now SimpleCallout class 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. Low 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.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.

Retrieved from "http://wiki.openbravo.com/wiki/API_changes"

This page has been accessed 19,778 times. This page was last modified on 7 December 2016, at 14:32. Content is available under Creative Commons Attribution-ShareAlike 2.5 Spain License.