Service Object Null Operational Status

Hi ​@EdBurton_Cr ,

We have faced same issue and we got to solve it.

Error was with OPERATION_STATUS field value in EQUIPMENT_OBJECT_TAB, some Service Objects had "In Operation" value instead of "IN_OPERATION" which seems to be the value required for this field.
 

EQUIPMENT_OBJECT view generates OPERATIONAL_STATUS and OPERATIONAL_STATUS_DB as follows from EQUIPMENT_OBJECT_TAB table:

• Serial_Operational_Status_API.Decode(nvl(operational_status, Part_Serial_Catalog_API.Get_Operational_Status_Db(part_no, mch_serial_no)))
• nvl(operational_status, Part_Serial_Catalog_API.Get_Operational_Status_Db(part_no, mch_serial_no))

Part_Serial_Catalog_API.Get_Operational_Status_Db(part_no, mch_serial_no) - This call separatedly retrieved the correct value, but as the wrong data was in the table, nvl function retrieved the stored value instead of calling the API.meethod which happens when OPERATIONAL_STATUS in EQUIPMENT_OBJECT view had a value different to null.
 

Once we set these values to null through a Migration Job, the API.method call was done and correct values were retrieved.
 

Hope this helps!

Have a nice day,
Best Regards.

Thanks we will give it a try.

We tried updating the status, but nothing happens. We also attempted changing the status to different values on the Part Serial to trigger an update on the Equipment Object, but there’s still no change — even though the Part Serial status itself updates correctly. We’re fairly certain this is a bug in our version of IFS.

On a related note, for equipment that’s in inventory, we had to migrate the inventory first, then set the Part Serial to Service Aware before migrating all of the related data to the Equipment. For those pieces of equipment in inventory, the operational status is working as expected.

Hi ​@EdBurton_Cr and ​@Álvaro,

Could you please share the IFS version you experienced this in? Did this occur in the manual creation of the service object?

/Pubudika