MES Stateless API

Update Method (OeeExec)

Save PDF

TABLE OF CONTENTS

Update Method (OeeExec)

Save PDF

Last UpdatedNov 06, 2025
3 minute read

The Update() method updates all columns of the specified entity's OEE exec record in the Oee_Exec table.

This overload of the method includes the batchSize and stdItemId input parameters.

Syntax

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

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

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

Parameters

sessionId

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

entId

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

jobEntId

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

utilEntId

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

targetPerf

Required. Holds the target performance value.

currentPerf

Required. Holds the actual current performance value.

targetQual

Required. Holds the target quality value.

currentQual

Required. Holds the actual current quality value.

defProdRate

Required. Holds the default production rate.

prodUom

Required. Holds the production unit of measure.

batchSize

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

stdItemId

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

targetOee

Required. Holds the target OEE value.

currentOee

Required. Holds the actual current OEE value.

basis

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

lastEditComment

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

lastEditAt

Required. Holds the date/time when this record was added or last updated, for optimistic concurrency control. 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