Skip to main content

Hi

When assigning a Serial Object to another Serial Object (as part of an assembly), is there a way of seeing the the Functional Object that the parent Serial Object is assigned to from the child Serial Objects?

When sending an engineer to repair a child item of equipment, we need to show its location (Functional Object) in the Work Order screen and prints. 

I was hoping that the Location in the following SQL would find it but, no, it returns the same parent ID as SUP_MCH_CODE

select 
  MCH_CODE OBJECT_ID,
  MCH_NAME OBJ_DESCRIPTION,
  PART_NO,
  SERIAL_NO,
  SUP_MCH_CODE BELONGS_TO_OBJ_ID,
  LOCATION_MCH_CODE LOCATION,
  ifsapp.EQUIPMENT_FUNCTIONAL_API.GET_MCH_NAME(contract, location_mch_code) FL_NAME,
  OPERATIONAL_STATUS
from EQUIPMENT_SERIAL_UIV

 

We are using Apps9 SP11

Hi @BABPAULS  -

I understand your concern. Unfortunately, there isn't a straightforward method to directly determine the location of the functional parent higher up in the hierarchy.

However, one workaround could be to propagate the Location/Address of the Top Parent downwards through the structure. This way, service engineers will encounter the same address as that of the parent during their work.

Alternatively, some of our customers opt to create the Work Order (WO) on the top functional object and manage the work based on serials. I'm uncertain if this aligns with your specific requirements.

I trust this information proves helpful to you.

 

Many thanks @Mayura Wasantha 

I was thinking along the same lines as you have suggested - raise the WO at the Serial parent level. In our case, it will pick up the Functional Obj it is assigned to, which would suffice. 

 

Thanks for your help

Reply


Terms & ConditionsCookie settings