MES Stateless API

UpdateSpecific Method (OeeExec)

Save PDF

TABLE OF CONTENTS

UpdateSpecific Method (OeeExec)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The UpdateSpecific() method updates selected columns of the specified OEE exec record in the Oee_Exec table.

For this overload of the method, the lastEditAt parameter is optional.

The UpdateSpecific() method updates selected columns of the specified OEE exec record in the Oee_Exec table.

Syntax

'Declaration
 
Public Shared Sub UpdateSpecific( _
   ByVal sessionId As Integer, _
   ByVal entId As Integer, _
   ByVal jobEntId As Nullable(Of Integer), _
   ByVal utilEntId As Nullable(Of Integer), _
   ByVal targetPerf As DBDouble, _
   ByVal currentPerf As DBDouble, _
   ByVal targetQual As DBDouble, _
   ByVal currentQual As DBDouble, _
   ByVal defProdRate As DBDouble, _
   ByVal prodUom As Nullable(Of Integer), _
   ByVal batchSize As Nullable(Of Double), _
   ByVal stdItemId As DBString, _
   ByVal targetOee As DBDouble, _
   ByVal currentOee As DBDouble, _
   ByVal basis As Nullable(Of Integer), _
   ByVal lastEditComment As DBString, _
   ByRef lastEditAt As Nullable(Of Date) _
)

'Usage
 
Dim sessionId As Integer
Dim entId As Integer
Dim jobEntId As Nullable(Of Integer)
Dim utilEntId As Nullable(Of Integer)
Dim targetPerf As DBDouble
Dim currentPerf As DBDouble
Dim targetQual As DBDouble
Dim currentQual As DBDouble
Dim defProdRate As DBDouble
Dim prodUom As Nullable(Of Integer)
Dim batchSize As Nullable(Of Double)
Dim stdItemId As DBString
Dim targetOee As DBDouble
Dim currentOee As DBDouble
Dim basis As Nullable(Of Integer)
Dim lastEditComment As DBString
Dim lastEditAt As Nullable(Of Date)
 
OeeExec.UpdateSpecific(sessionId, entId, jobEntId, utilEntId, targetPerf, currentPerf, targetQual, currentQual, defProdRate, prodUom, batchSize, stdItemId, targetOee, currentOee, basis, lastEditComment, lastEditAt)

public static void UpdateSpecific( 
   int sessionId,
   int entId,
   Nullable<int> jobEntId,
   Nullable<int> utilEntId,
   DBDouble targetPerf,
   DBDouble currentPerf,
   DBDouble targetQual,
   DBDouble currentQual,
   DBDouble defProdRate,
   Nullable<int> prodUom,
   Nullable<double> batchSize,
   DBString stdItemId,
   DBDouble targetOee,
   DBDouble currentOee,
   Nullable<int> basis,
   DBString lastEditComment,
   ref Nullable<DateTime> lastEditAt
)

Parameters

sessionId

Required. Holds the session ID and thus the user who is making this method call.

entId

Required. Holds the ID of the entity whose OEE exec record is being updated.

jobEntId

Optional. Holds the ID of the entity from which production data is obtained for this entity.

utilEntId

Optional. Holds the ID of the entity from which utilization data is obtained for this entity.

targetPerf

Optional. Holds the target performance value.

currentPerf

Optional. Holds the actual current performance value.

targetQual

Optional. Holds the target quality value.

currentQual

Optional. Holds the actual current quality value.

defProdRate

Optional. Holds the default production rate.

prodUom

Optional. Holds the production UOM value.

batchSize

Optional. Holds the standard batch size for reporting production rate.

stdItemId

Optional. Holds the standard item to use for reporting production rate.

targetOee

Optional. Holds the target OEE value.

currentOee

Optional. Holds the actual current OEE value.

basis

Optional. Holds an integer that is used to indicate how OEE is to be displayed for this entity. 0=OEE displayed by shift (default); 1=OEE displayed by job.

lastEditComment

Optional. Holds comments that describe why this record is being updated.

lastEditAt

Optional. Holds the date/time when this record was added or last updated, for optimistic concurrency control. If it is specified, the passed value must match the lastEditAt value in the record for the update to succeed.

Output. Holds the date/time value when the record was updated by this called method.

MES Stateless API