MaintenanceWorkOrderResources
The Maintenance Work Order Resources resource manages the resources that the work order requires to perform a maintenance operation.
Columns
| Name | Type | Description |
| WoOperationResourceId [KEY] | Long | Value that uniquely identifies the resource for work order operation. This attribute is read-only. The value of this attribute is generated when the application creates the operation resource. |
| OrganizationCode | String | Abbreviation for the maintenance organization of the work order. |
| OrganizationId | Long | Value that uniquely identifies the maintenance organization of the work order. |
| WorkOrderId | Long | Value that uniquely identifies the work order. This attribute is read-only. The value of this attribute is derived from the work order number when the application creates the work order. |
| WorkOrderNumber | String | Number that identifies the work order. This number is unique in the organization. The user can manually assign the number when creating the work order, or allow the application to create a unique number from the numbering scheme that the following Plant parameters define: Work Order Prefix or Work Order Starting Number. |
| WoOperationId | Long | Value that uniquely identifies the work order operation. This attribute is read-only. The value of this attribute is generated when the application creates the work order operation. |
| WoOperationName | String | Name of the work order operation. The operation name is required to create an operation. |
| WoOperationDescription | String | Description of the operation to be performed during the work order execution. The operation description is optional to create the work order operation. |
| StandardOperationId | Long | Value that uniquely identifies the standard operation for work order operation. This attribute is read-only. |
| StandardOperationCode | String | Abbreviation that identifies the standard operation for work order operation. This attribute is read-only. |
| OperationSequenceNumber | Decimal | Number that identifies the sequence to use when performing the work order operations. The operation sequence is required to create an operation. It must be a positive integer. Its value must be unique within the work order operations. If it isn't provided, then the last operation sequence incremented by 10 is used as sequence to create an operation. |
| CountPointOperationFlag | Bool | Contains one of the following values: true or false. If true, then make this operation a count point operation. If an operation occurs on the shop floor, the user must manually report it in the application when the operation occurs. If false, then don't make this operation a count point operation. The user doesn't need to report the operation. It's recommended that you configure each work order so that it includes at least one count point operation, and to make sure that the last operation that the work order performs is a count point operation. The default value is true. |
| AutoTransactFlag | Bool | Contains one of the following values: true or false. If true, then automatically report the operation when the operation occurs on the shop floor. If false, then don't report this operation automatically. If the operation isn't significant, it's recommended that you set AutoTransactFlag to true. The Count Point attribute and the Automatically Transact attribute are mutually exclusive. You must make sure that each of these attributes do not both contain true. If the Count Point and Automatically Transact attributes each contain false, then the operation is optional. Note that the user can manually report component usage and resource usage for an optional operation. The default value is false. |
| ResourceSequenceNumber | Decimal | Number that identifies the sequence of the resource in the work order operation. The sequence is required to create an operation resource. The last operation resource sequence incremented by 10 is used as sequence to create an operation resource. |
| ResourceId | Long | Value that uniquely identifies the resource assigned to the work order operation. You must provide either the resource identifier or the resource code to create a work order operation resource. |
| ResourceName | String | Name of the operation of the resource assigned to the work order operation such as labor or equipment. This attribute is read-only. The value of this attribute is derived from the resource. |
| ResourceCode | String | Abbreviation that identifies the resource assigned to the work order operation. You must provide either the resource identifier or the resource code to create an operation resource. |
| ResourceDescription | String | Description of the operation of the resource assigned to the work order operation such as labor or equipment. This attribute is read-only. The value of this attribute is derived from the resource. |
| ResourceType | String | Abbreviation that identifies the type of the resource assigned to the work order operation such as labor or equipment. This attribute is read-only. The value of this attribute is derived from the resource. |
| UOMCode | String | Abbreviation that identifies the unit of measure of the operation material quantity. |
| UnitOfMeasure | String | Unit of measure of the material component quantity to be issued. It is the primary unit of measure of the item. This attribute is read-only. The value of this attribute is derived from the material component item. |
| WorkCenterId | Long | Value that uniquely identifies the work center in which the operation is performed. This attribute is read-only. The value of this attribute is derived from the operation. |
| WorkCenterName | String | Name of the work center in which the operation is performed. This attribute is read-only. The value of this attribute is derived from the operation. |
| WorkCenterDescription | String | Description of the work center in which the operation is performed. This attribute is read-only. The value of this attribute is derived from the work center identifier. |
| BasisTypeCode | String | Abbreviation for the basis type of material defined for the work order operation. Valid values are contained in the lookup EGP_BOM_BASIS_TYPE. |
| BasisType | String | Contains one of the following values: 1 or 2. If 1, then the resource consumption is fixed. It does not change according to work order quantity. If 2, then the resource consumption is not fixed. It might change according to work order quantity. The default value is 2. A list of accepted values is defined in the lookup type EGP_BOM_BASIS_TYPE. For maintenance work orders the work order quantity is always one. |
| ChargeTypeCode | String | Abbreviation for the charge type of material defined for the work order operation. Valid values are contained in the lookup ORA_WIS_CHARGE_TYPE. |
| ChargeType | String | Abbreviation that identifies how the resource is charged. A list of accepted values is defined in the lookup type ORA_WIS_CHARGE_TYPE. The charge type is required. Valid values include MANUAL or AUTOMATIC. For a count point operation, the value must be AUTOMATIC for automatic transact operations and MANUAL for optional operations. |
| UsageRate | Decimal | Resource usage rate that the plant requires to make the required work order quantity. The resource usage rate is used to calculate the required usage based on the basis type and the work order quantity. For maintenance work orders the work order quantity is always one. |
| RequiredUsage | Decimal | Resource usage that the plant requires to make the required work order quantity. The application calculates this value depending on whether the basis type is fixed or variable. Fixed: the required usage equals the usage rate. Variable: the required usage is the product of the usage rate and the work order quantity. For maintenance work orders the work order quantity is always one. |
| PlannedStartDate | Datetime | Date when the resource is planned to start. The scheduling application sets this date. The planned start date must not occur before the operation start date or after the operation finish date. This attribute is required. The default value is the operation start date. |
| PlannedCompletionDate | Datetime | Date when the resource is planned to finish. The scheduling application sets this date. The planned completion date must not occur before the operation start date or after the operation finish date. This attribute is required. The default value is the operation end date. |
| PrincipalFlag | Bool | Contains one of the following values: true or false. If true, then this resource is the principal resource among the group of simultaneous resources. If false, then this resource is not the principal resource. Note that one of the simultaneous resources must be a principal resource. The default value is false. |
| ScheduledFlag | Bool | This attribute is not currently used for Oracle Maintenance Cloud. You must use the ScheduledIndicator attribute instead. |
| ScheduledIndicator | String | Contains one of the following values: YES or NO. If YES, then scheduling schedules the resource and computes the start date and completion dates. If NO, then scheduling does not schedule the resource and it sets the start date equal to the completion date. A list of accepted values is defined in the lookup type ORA_WIS_RESOURCE_SCHEDULE. The default value is YES. |
| AssignedUnits | Decimal | Number of resource units required to perform the operation. |
| ReportedUsage | Decimal | Number of resource units reported for the operation. |
| ReportedUsagePerAsset | Decimal | Number of resource units reported for the operation per asset. |
| OpenUsage | Decimal | Value that is the difference between the required usage and the reported usage. |
| MntResourceQualifiedFlag | Bool | Contains one of the following values: YES or NO. If YES, then the logged in user is qualified to report resource usage for the resource. If NO, the user is not qualified for the resource. |
| MntResourceAssignedFlag | Bool | Contains one of the following values: YES or NO. If YES, then the logged in user is assigned to the resource. If NO, the user is not assigned to the resource. |
| EqpQualProfileId | Long | Value that uniquely identifies the qualification profile. Values are predefined and created for equipment qualifications. This attribute is applicable only for equipment type resources. When it's specified, only those equipment resource instances that meet the qualifications can be reported for resource transactions. It's a non-mandatory attribute for a work order operation resource. |
| ProfileId | Long | Value that uniquely identifies the work order operation resource's job profile. The application generates this key value. |
| ProfileCode | String | Indicates the skills and qualifications that make up the resource's job profile. The lookup value is taken from the employee's human resource talent profile and must be a valid and active PROFILE_CODE. |
| EqpQualProfileCode | String | Abbreviation that uniquely identifies the qualification profile. Values are predefined and created for equipment qualifications. This attribute is applicable only for equipment type resources. When it's specified, only those equipment resource instances that meet the qualifications can be reported for resource transactions. It's a non-mandatory attribute for a work order operation resource. |
| ReasonForRepairCodeId | Long | Value that uniquely identifies the reason for repair of the maintenance work order operation material. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair. |
| ReasonForRepairCode | String | Abbreviation that identifies the reason for repair of the maintenance work order operation resource. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair. |
| ReasonForRepairName | String | Name of the reason for the repair code. |
| RepairTransactionCodeId | Long | Value that uniquely identifies the repair transaction of the maintenance work order operation material. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Transaction code. |
| RepairTransactionCode | String | Abbreviation that identifies the repair transaction for the maintenance work order operation resource. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Repair Transaction. |
| RepairTransactionName | String | Name of the repair transaction code. |
| WorkAccomplishedCodeId | Long | Value that uniquely identifies the work accomplished of the maintenance work order operation material. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Work accomplished. |
| WorkAccomplishedCode | String | Abbreviation that identifies the work accomplished against the maintenance work order operation resource. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair. |
| WorkAccomplishedName | String | Name of the work accomplished code. |
| CreatedBy | String | Session login associated with the user who created the record. |
| CreationDate | Datetime | Date when the record was created. |
| LastUpdatedBy | String | Session login associated with the user who most recently updated the record. |
| LastUpdateDate | Datetime | Date when the record was most recently updated. |
| InverseRequiredUsage | Decimal | Inverse of the usage rate. The application uses this inverse when the resource usage rate is a fraction, but the inverse of this rate is an integer. |
| RequestMaintenanceFlag | Bool | Value that identifies whether the Request Maintenance action is enabled. |
| WorkMethodCode | String | Abbreviation that identifies the method that the work order uses such as DISCRETE_MANUFACTURING or MAINTENANCE. |
| ResourceExceptionFlag | Bool | Value that indicates the presence of open resource type exceptions for a resource requirement in a work order operation. |
| ResourceInstanceNames | String | List of comma separated resource instance names. Restricted to the first 50 characters. |
| ActualResourceUsage | Decimal | Actual resource usage recorded for the assigned resources. |
| ResourceActivityCode | String | Code for the activity to be performed by this operation resource. |
| ResourceActivityMeaning | String | Definition of the task to be performed by this operational resource. |
| BindAssetId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the asset. |
| BindWorkCenterId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the work center. |
| BindWorkMethodCode | String | A finder used to filter data using Finder column. Value that uniquely identifies the work method code. |
| BindWorkOrderId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the work order. |
| Finder | String | Finder criteria used to filter maintenance work order resources based on specific search parameters and conditions. |