Maximo has a powerful integration framework called the MIF. Often when integrating with external systems you need to apply certain rules or transformations to the incoming or outgoing data. Basic transformations can easily be performed without having to resort to writing code.
CHARTOFACCOUNT (COA) is a common integration. Maximo 7.5+ determines whether a given COA record is able to be used on records based on its ACTIVEDATE/EXPIRYDATE fields. In Maximo the Active flag is readonly and updated based on the Active and Expiry dates.
The incoming integration needs to replicate the rules in the GUI which means they will provide ACTIVE/EXPIRY dates.
If COA is ACTIVE:
-
ACTIVEDATE=Now
-
EXPIRYDATE=(Null)
If COA is INACTIVE:
-
ACTIVEDATE=Now
-
EXPIRYDATE=Now
If the external system Maximo is integrating with only has boolean ACTIVE/INACTIVE we can replicate the above logic with integration rules in the Enterprise Services application.
Create 2 new integration rules:
On Activate:
-
RULE = SETACTIVE
-
ACTION = SET
-
[Add/Modify Conditions]
-
FIELD = ACTIVE
-
EVALUATION TYPE = EQUALS
-
EVALUATE WHEN = ALWAYS
-
VALUE = 1
-
[Sub-Record Fields] – Create all 3
-
FIELD = ACTIVEDATE
-
REPLACEWHENNULL = [Checked]
-
VALUE = &SYSDATE&
-
FIELD = EXPIREDATE
-
REPLACEWHENNULL = [Checked]
-
VALUE = [Null]
-
FIELD = ACTIVE
-
REPLACEWHENNULL = [Checked]
-
VALUE = [Null]
On Deactivate:
-
RULE = SETINACTIVE
-
ACTION = SET
-
[Add/Modify Conditions]
-
FIELD = ACTIVE
-
EVALUATION TYPE = EQUALS
-
EVALUATE WHEN = ALWAYS
-
VALUE = 0
-
[Sub-Record Fields] – Create all 3
-
FIELD = ACTIVEDATE
-
REPLACEWHENNULL = [Checked]
-
VALUE = &SYSDATE&
-
FIELD = EXPIREDATE
-
REPLACEWHENNULL = [Checked]
-
VALUE = &SYSDATE&
-
FIELD = ACTIVE
-
REPLACEWHENNULL = [Checked]
-
VALUE = [Null]
Now the external system can update the Maximo COA by simply setting the ACTIVE=1/0 and not have to worry about the activate and expiry dates. A basic web service can be tested with the following:
<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:max="http://www.ibm.com/maximo">
<soapenv:Header/>
<soapenv:Body>
<max:SyncMXCOAInterface>
<max:MXCOASet>
<max:CHARTOFACCOUNTS>
<max:ACCOUNTNAME>Test Account</max:ACCOUNTNAME>
<max:ACTIVE>0</max:ACTIVE>
<max:GLACCOUNT>
<max:VALUE>A.B.C</max:VALUE>
</max:GLACCOUNT>
<max:GLCOMP01>A</max:GLCOMP01>
<max:GLCOMP02>B</max:GLCOMP02>
<max:GLCOMP03>C</max:GLCOMP03>
<max:ORGID>ATH_THRM</max:ORGID>
</max:CHARTOFACCOUNTS>
</max:MXCOASet>
</max:SyncMXCOAInterface>
<!--<span class="hiddenSpellError" pre=""-->soapenv:Body>
Maximo Tech Blog 