Maximo Open Forum

 View Only
  • 1.  Database configuration Application designer and domains

    Posted 05-16-2023 07:22

    need to create 5 fields in mrline and prline and cross over the value from mrline to prlinr when pr is created from requisitions. Can you please explain step by step.


    #EverythingMaximo

    ------------------------------
    Gaurav Sharma
    ------------------------------


  • 2.  RE: Database configuration Application designer and domains

    Posted 05-19-2023 11:01

    Since you mention the applications involved, I assume you're comfortable using database configuration to add the new attributes to both tables. The only thing I will call out is that when you add the attributes to PRLINE to make sure you set the Same As Object/Same As Attribute to match the attributes on MRLINE. This is important when you're crossing over attributes because an increase of the field size on MRLINE needs to increase the field size on PRLINE. Example of a field declaration on PRLINE below

    You will then need to Apply Configuration Changes in the Database Configuration application before proceeding. This is a structural change so it will require you to put the application into admin mode before proceeding. Once the configuration changes are done, turn off admin mode.

    Then on the MRLINENUM attribute on PRLINE is where you will add the crossover domain in database configuration. Use the Go To functionality to open the domains application and create a new crossover domain. The object will be MRLINE with a validation where clause of mrnum=:mrnum and mrlinenum=:mrlinenum and siteid=:siteid

    Source field will be EMXNEWFIELD in my example and the destination field will be EMXNEWFIELD. But you would add every field you define that you want to crossover (so all 5 fields)


    Click OK and then filter for the domain you created and choose to return with value to bring it back. 



    Save the changes. Apply configuration changes. This is non-structural so can be done without admin mode enabled.

    Now you will add the attributes to the screen in application designer. CREATEDR is a special application where most of the controls are imported from the library XML so you will need to export that and find id="createreq_tabgroup_st2". Then add in your new control there wherever you want to place it. PR is a traditional application that you can add with a simple drag and drop of the control.


    Then go through the steps to create the desktop requisition and have it create a PR and you should see it crossover. 



    ------------------------------
    Steven Shull
    IBM
    ------------------------------