Maximo Open Forum

Expand all | Collapse all

Increase the length and scale of a OOTB field in Maximo version 7.6.0.4

  • 1.  Increase the length and scale of a OOTB field in Maximo version 7.6.0.4

    Maximo Certified
    Posted 7 days ago
    We know that the field with data type amount has the length and scale as read only from the database configuration application.As use case has come up for us as the asset purchase price value needs to be set which is exceeding the length as 10 and scale as 2 which has been predefined.

    Could anyone please suggest as to what approach needs to be followed to increase the length and scale as we will be unable to do it from the front end and only approach would be to change it from the data dictionary tables(maxattributecfg and maxattribute) and do a server bounce.Is there any reason as to why the product limits us from changing the length and scale of the amount fields and what enhancements have happened in the later versions.We are at version 7.6.0.4
    #Administration
    #Assets
    #EverythingMaximo
    #MaximoUserGroups

    ------------------------------
    Mahadevan Ramakrishnan
    ------------------------------


  • 2.  RE: Increase the length and scale of a OOTB field in Maximo version 7.6.0.4

    Maximo Certified
    Posted 7 days ago
    Expect a lengthy process, and test, test, test. 

    Start here: https://www.ibm.com/support/pages/increasing-length-or-scale-quantity-attributes or here: https://www.ibm.com/support/pages/changing-length-and-scale-attribute-maximo and keep in mind:  https://www.ibm.com/support/pages/node/533279 

    The Field Length and Format action is what you are looking for, but there is more planning and work involved.

    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------