Skip to main content

BPA - general routing lead time calculation

  • January 27, 2026
  • 2 replies
  • 17 views

Forum|alt.badge.img+4

Hello community, 

 

I am facing a question here… how to calculate the lead time for all routing alternates with status buildable at once in IFS Cloud? 

 

 

I can do it one by one but when I mark two or more, the option disappears. 

I was thinking about BPA but as I am not an IT girl, I asked GPT for help. Can somebody confirm that this would be doable or propose suitable adjustements? 

 

START (Scheduled or Manual)

routing_alternatives =
  SELECT contract,
         part_no,
         routing_revision,
         alternative_no
  FROM Routing_Alternative
  WHERE objstate = 'Released'

FOR EACH routing_alternative IN routing_alternatives
LOOP
   CALL Routing_Alternative_API.Calculate_Manufacturing_Lead_Time(
        contract          => routing_alternative.contract,
        part_no           => routing_alternative.part_no,
        routing_revision  => routing_alternative.routing_revision,
        alternative_no    => routing_alternative.alternative_no
   )
END LOOP

END

 

Thank you for your support,

 

BR

Petra

 

 

2 replies

matt.watters
Ultimate Hero (Partner)
Forum|alt.badge.img+26
  • Ultimate Hero (Partner)
  • January 27, 2026

Can you create a schedule for this Database Task of ‘Manufacturing Lead Time Calculation’?

 


SNIRLK
Hero (Employee)
Forum|alt.badge.img+8
  • Hero (Employee)
  • January 27, 2026

Hi ​@PetaKu,

According to Calculate Routing Lead Time in IFS Cloud:

“The routing alternate lead times on routings valid today and in the future are calculated for a part or for all parts on a site.”

This means the batch calculation is supported only at part level (single part) or site level (all parts) not at the individual routing alternate level.

 

Calculate Routing Lead Time;

https://docs.ifs.com/ifsclouddocs/24r2/MfgStandard/ActivityCalculateRoutingLeadtime.htm

 

BPA Automation (Yes, it’s doable)

Seems you are in the right track.

SELECT contract, part_no, routing_revision, alternative_no
FROM Routing_Alternative
WHERE objstate = 'Released';

I will further look in to this and get back. 

Thanks & Regards,

SN