These video describes how you can expand the existing Inspection functionality from Maximo 7609 to new modules in Maximo.

This demonstration was dome to implement Inspection Forms to be used during the Inventory Receiving process for items that require inspection, so instead of just change the status saying that the inspection was completed, you'll also conduct an inspection during the receiving. Watch it out !

Demo:

High Level Information on How to Implement it:

Artifacts required:

1) new value on domain INSPFORMTYPE, synonym of INSP with value Receiving Inspection

2) new table domain called INSPECTIONFORM, using the table INSPECTIONFORM and the following criteria:

type like '%Receiving%'  and status in (select value from synonymdomain where domainid = 'INSPECTFORMSTATUS' and maxvalue='ACTIVE')

3) new attribute on POLINE object called INSPFORMNUM, sameasobject=INSPECTIONFORM, sameasattribute=INSPFORMNUM, using the table domain created before. Also  add a lookupmap to the attribute INSPFORMNUM only.

4) new relationship from POLINE to INSPECTIONFORM object using the following whereclause:

inspformnum=:inspformnum and status in (select value from synonymdomain where domainid = 'INSPECTFORMSTATUS' and maxvalue='ACTIVE')

5) new relationship from MATRECTRANS to INSPECTIONRESULT object, using the following whereclause:

referenceobjectid=to_char(:MATRECTRANSID) and referenceobject='MATRECTRANS' and siteid=:siteid

After running the configdb:

6) create a new lookup in Maximo using the following definition:

<table id="inspectionform" inputmode="readonly" orderby="NAME" selectmode="single">

<tablebody displayrowsperpage="20" filterable="true" filterexpanded="true" id="inspectionform_lookup_tablebody">

<tablecol dataattribute="INSPFORMNUM" id="inspectionform_lookup_tablebody_col_0" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>

<tablecol dataattribute="NAME" id="inspectionform_lookup_tablebody_col_1" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>

<tablecol dataattribute="REVISION" id="inspectionform_lookup_tablebody_col_2" mxevent="selectrecord" mxevent_desc="Go To %1" sortable="true" type="link"/>

</tablebody>

</table>

7) expose the new attribute on Purchase Order app

<multiparttextbox applink="INSPECTORsup" dataattribute="INSPFORMNUM" descdataattribute="INSPECTIONFORM.NAME" descinputmode="readonly" id="1525894569133" lookup="INSPECTIONFORM" menutype="normal" sigoption="READ"/>

8) expose the relationship on Inventory Receiving app

<tablecol applink="inspector" applinkrel="inspectionresult.resultnum" dataattribute="INSPECTIONRESULT.RESULTNUM" id="1525896952637" label="Inspection Result" menutype="normal"/>

Script 1: Create Pending Inspection (jython) ... MaximoCreatePendingInspection.py

Script 2: Check Inspection Result status (jython) ...  MaximoCheckInspectionStatus.py