Skip to main content
M
mpaisley901-Visitor
1-Visitor
June 3, 2021
Solved

Manufacturing Apps 9.1 Site UID and Product UID

  • June 3, 2021
  • 1 reply
  • 2940 views

I have added a site and then line and a few assets, and have the KPI's working to the database. I would like to know how to se the Sit UID and Product UID so that this is in the same table as the KPI elements. There are columns for this and right now they are null. I cannot find any information as to how to set these.

 

My site is a ISA95 site but my lines are KepserverBasedPhysicalTemplates.

 

Not sure where to go from here.

 

Thanks in advance.

Best answer by abjain

@mpaisley90 : I checked on this. For siteuid to appear in the kpivalue table , you need to provide the corresponding siteUid for all your shifts. You can do this by running the 'UpdateShifts' service for all your shifts in the PTC.SCA.SCO.DefaultShiftManager(you can check the updated values by running the 'GetShifts' service). When KPI is calculated next time the siteUid field would also be populated in the kpivalue table. Regarding joborderid,if you are using shifts to calculate KPIs than I think joborderid is not required. This field will be used in case you are calculating KPIs based on job orders rather than shifts.

1 reply

A
abjain15-Moonstone
15-Moonstone
June 8, 2021

@mpaisley90 : If you are checking for defining sites ,shifts, then here you can find information on that:https://support.ptc.com/help/thingworx/apps/r9.1/en/#page/thingworx_apps%2FCustomizing_the_Apps%2Fdefining_sites_shift_schedules_and_shifts.html

I was checking the production KPI page at my end and did not found any columns for site uid or product uid.

abjain_0-1623132146213.png

 

 

M
mpaisley901-VisitorAuthor
1-Visitor
June 8, 2021

This would not be in Manufacturing apps itself it is in the Database MSSQL or Express what ever you are using. In the kpivalue table, just looking to see where I input this information in so that it records and later I can use tools to look up KPI values based on SKU's or job id and or Site id. 

mpaisley90_0-1623154932290.png

 

 

A
abjain15-MoonstoneAnswer
15-Moonstone
June 9, 2021

@mpaisley90 : I checked on this. For siteuid to appear in the kpivalue table , you need to provide the corresponding siteUid for all your shifts. You can do this by running the 'UpdateShifts' service for all your shifts in the PTC.SCA.SCO.DefaultShiftManager(you can check the updated values by running the 'GetShifts' service). When KPI is calculated next time the siteUid field would also be populated in the kpivalue table. Regarding joborderid,if you are using shifts to calculate KPIs than I think joborderid is not required. This field will be used in case you are calculating KPIs based on job orders rather than shifts.

Terms & ConditionsCookie settingsAccessibility statement