Maximo Open Forum

 View Only

 Update Siteid and Orgid on related record (Data Fix)

  • Maximo Application Suite
Abhay Bhatnagar's profile image
Abhay Bhatnagar posted 08-21-2025 19:42

Hi All,

I have a question here, or I should say I have an issue here.

In our MAS8 environment, there is a custom process to create a work order from SR application and once the work order is created, SR is linked to the related record. 

Now the issue - 

Due to some oversight, the developer forgot to set the siteid and orgid in the related record table, but setting the relatedrecsiteid and relatedrecorgid. Related record is being added using MboSet.add() where MboSet is NOT taken through a relationship. Because of this, the custom reports built on related records are not showing any records, due siteid and orgid being blank. Is there a way to update the siteid and orgid without triggering any underlying logic, something through MIF? Like completely replacing the record with new values.

Steps that I performed - 

  1. Created an enterprise Service with WO as main Object and RELATEDRECORD as child object.

2. Imported this xml

<?xml version="1.0" encoding="UTF-8"?>
<max:SyncTESTRELATEDREC xmlns:max="http://www.ibm.com/maximo" creationDateTime="2008-09-28T19:49:45" baseLanguage="EN" transLanguage="EN" messageID="111">
  <max:TESTRELATEDRECSet>
    <max:WORKORDER action="Change">
      <max:SITEID></max:SITEID>
      <max:WONUM></max:WONUM>
      <max:RELATEDRECORD>
        <max:CLASS></max:CLASS>
        <max:ORGID></max:ORGID>
        <max:RECORDKEY></max:RECORDKEY>
        <max:RELATEDRECCLASS></max:RELATEDRECCLASS>
        <max:RELATEDRECKEY></max:RELATEDRECKEY>
        <max:RELATEDRECORDID></max:RELATEDRECORDID>
        <max:RELATEDRECORGID></max:RELATEDRECORGID>
        <max:RELATEDRECSITEID></max:RELATEDRECSITEID>
        <max:RELATETYPE></max:RELATETYPE>
      </max:RELATEDRECORD>
    </max:WORKORDER>
  </max:TESTRELATEDRECSet>
</max:SyncTESTRELATEDREC>

I got the error that related record is already related. 

There are about 50K records that I need to update.

There is a limitation put in place that we are not suppose to execute any SQL statement for some reason beyond my comprehension.

Hoping to get some help here.

Thank you.

Related Content