Skip to main content

 

Wondering why the service object operational status below is null.  How do I set it to operational.

 

When I look at the Part Serial the Operational Status is “In Operation”

 


I’m can’t find the serial in maintenance aware.
 

 

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.

Terms & ConditionsCookie settings