Cannot save new Rows after adding a new Table to a screen in Maximo

Steps:

1. Go to "Database Configuration" application.
Enter the following for this new object on the Object tab:
Object = RISK
Description = RISK
Service = WORKORDER
Do NOT select the “Main Object” checkbox.
Level = SITE
​




2. Go to the Attributes tab and add the following attributes with these values:
RISKID: BIGINT 19 search type =EXACT
DESCRIPTION: ALN 50 search type =WILDCARD
GROSSRISK: INTEGER 12 search type =EXACT
RISK: ALN 50 search type =WILDCARD
SITEID: UPPER 8 same as "SITE.SITEID" search type=EXACT
ORGID: UPPER 8 same as "ORGANIZATION.ORGID" search type=EXACT
WONUM: UPPER 10 sameas "WORKORDER.WONUM" search type = WILDCARD

Save the record.





3. On the Index tab, add a system (unique) index on the RISKID attribute.




​
4. Turn on Admin Mode.
Select the "Apply Database Configuration Changes" action.
Turn off Admin Mode.

5. Filter for "WORKORDER" object.
Create a new "relationship" called "RISKLINK" having a child object of "RISK" and a Where clause 

  wonum=:wonum and siteid=:siteid

​




6. In Application Designer, export the application definition for record WOTRACK. Add a table in the wotrack.xml to allow users to enter "Risk" information.

For example, add a table just before the "Multiple Assets,Locations and CIs" section in the main "work order" tab in Work Order Tracking application.  Attached is an example wotrack.xml (Line 149)

Example tags for the table:

  <table id="RISK_table" label="Plant Risk Assessment and Control" relationship="RISKLINK" startrow="0">       <defaultvalue dataattribute="wonum" defaulttype="INSERT" fromattribute="WONUM" fromdatasrc="MAINRECORD" id="1436240639650"/>       <tablebody displayrowsperpage="6" filterable="true" id="14338080369044_1">            <tablecol filterable="false" id="1433808036919_1" mxevent="toggledetailstate" mxevent_desc="Show Detail" sortable="false" type="event"/>            <tablecol dataattribute="WONUM" id="1511088200846" label="wonum" sortable="false"/>            <tablecol dataattribute="RISK" id="1511088327798" label="Risk" sortable="false"/>            <tablecol dataattribute="DESCRIPTION" id="14338080369194_1" label="DESCRIPTION" sortable="false"/>            <tablecol dataattribute="GROSSRISK" id="14338080369194_2" label="Gross Risk" sortable="false"/>            <tablecol filterable="false" id="14338080369354_1" mxevent="toggledeleterow" mxevent_desc="Mark Row for Delete" mxevent_icon="btn_garbage.gif" sortable="false" type="event"/>  </tablebody>  <tabledetails id="risk_table_1">       <section id="risk_table_1_grid11" label="Details">            <sectionrow id="risk_grid7_row1">                 <sectioncol id="risk_grid7_row1_col1">                      <section id="risk_1_grid7_col1">                           <textbox dataattribute="wonum" id="risk_table_1_grid11_1" lookup="wonum" menutype="normal" />                           <textbox dataattribute="RISK" id="risk_table_1_grid11_10" menutype="normal" />                           <textbox dataattribute="DESCRIPTION" id="risk_table_1_grid11_11" menutype="normal" />                           <textbox dataattribute="GROSSRISK" id="risk_table_1_grid11_5" menutype="normal"/>                      </section>                 </sectioncol>            </sectionrow>       </section>  </tabledetails>  <buttongroup id="14338080369972_1">       <pushbutton default="true" id="14338080369973_1" label="New Row" mxevent="addrow"/>  </buttongroup>  </table>

7. Import the modified xml file via Application Designer.
Log out and log back in to Maximo.

8. Go to the Work Order Tracking application.
Create a new record.
Click the "New Row" button in the "Plant Risk Assessment and Control" section.
"WONUM" defaults to the new Work Order number.
Populate the "Risk", "Description" and "Gross Risk" fields.
Save the record.

​



9. Query the RISK table for the new Work Order record (for example, Work Order '1857').

select * from risk where wonum='1857'





The risk information is saved to the database when the user enters the data via the modified Work Order Tracking application.