Skip to main content
Solved

Serial Object Location

B
Do Gooder (Customer)
Forum|alt.badge.img+6

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

Best answer by Mayura Wasantha

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.

 

View original
Did this topic help you find an answer to your question?

2 replies

Mayura Wasantha
Superhero (Employee)
Forum|alt.badge.img+18
  • Mayura Wasantha
  • Superhero (Employee)
  • 469 replies
  • Answer
  • May 17, 2024

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.

 

/ mayura
B
Do Gooder (Customer)
Forum|alt.badge.img+6
  • BABPAULS
  • Author
  • Do Gooder (Customer)
  • 22 replies
  • May 17, 2024

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

Mayura Wasantha
1 person likes this
  • Mayura Wasantha
    Mayura Wasantha

Reply


Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings