ORCL-BRT-MNT-OFS-CONFIG Lookup

Lookup Name: ORCL-BRT-MNT-OFS-CONFIG

Lookup Keys and Usages:

Lookup Key Usage
WOStatusToSyncOFSActivity

The list of statuses in Oracle Maintenance that are synced to Oracle Fusion Field Service.

You can add multiple Work Order Status(s) separated by commas.

For example: ORA_RELEASED, AWAIT_PARTS

ActivityTypeDefaultDuration Default duration of activity types created as part of the Standard Operation sync.
ActivityTypeSegmentMinDuration

Minimum duration of activities for segmentable activity types (applicable only if segmenting flag is enabled).

ActivityTypeSegmentMaxDuration

Maximum duration of activities for segmentable activity types (applicable only if the segmenting flag is enabled).

ActivityTypeCreateSegmentedTypes Controls whether activity types created are segmentable.
DefaultActivityTypeName Name of the default activity type created in Oracle Fusion Field Service used for syncing ad hoc operations.
DefaultActivityTypeGroupName Group Name of the default activity type created in Oracle Fusion Field Service used for syncing ad hoc operations.
DefaultActivityTypeLabel Label of the default activity type created in Oracle Fusion Field Service used for syncing ad hoc operations.
DefaultActivityTypeGroupLabel Group Label of the default activity type created in Oracle Fusion Field Service used for syncing ad hoc operations.
IntegrationUser

Used for echo suppression, this field contains the clientID for the Oracle Fusion Field Service connection used in Oracle Maintenance flow.

ScheduleActivityEnabled

When this flag is set to true, it creates the Oracle Fusion Field Service activity in the Scheduled pool. When set to false, all the synced activities are created under non scheduled pool.

For example: true

Basis

Mandatory field to create a new resource under a Oracle Maintenance Operation. If the value is 1, then the resource consumption is fixed. It doesn't change according to work order quantity. If the value is 2, then the resource consumption isn't fixed. It might change according to work order quantity.

For example: 1

UsageRate

Usage rate of the new resource created under an existing work order operation. Resource usage rate that the plant requires to make the required work order quantity.

For example: 1

RequiredUsage

Required usage of the new resource created under an existing work order operation. Resource usage that the plant requires to make the required work order quantity.

For example: 1

MNTSourceSystemCode

The Source System Code in Fusion. It is required for the transactions. This denotes the source system that started the transactions.

For example: OFS

MNTSourceSystemType

The type of the source system, INTERNAL/EXTERNAL.

For example: EXTERNAL

SupplyInventoryDelimiter

The delimiter used to separate parts used in forming an inventory identifier. It is used in both Activity Required Inventory and Inventory Sync Integrations.

For example: .

MNTAssetMaxNoOfMeters It holds the maximum number of meters a single asset can hold. Currently it supports only a maximum value of 2.
NewWOStatusFromOFSToMNT

This is the work order status set whenever a new activity is created in Oracle Fusion Field Service and synced to Oracle Maintenance.

For example: ORA_RELEASED

WOStatusUpdateFlag

This flag indicates whether work order status must be moved to custom statuses whenever an activity status changes in Oracle Fusion Field Service.

For example: true

InitialOpSeqNumber

The operation sequence number with which a new operation is created whenever a new activity that's created in Oracle Fusion Field Service is synced to Oracle Maintenance.

For example: 10

ShouldCreateUserForEquipment

This flag indicates whether to create user for equipment instances while syncing Resource Instances from Oracle Maintenance to Oracle Fusion Field Service. If set to false, the user isn't created for equipment type resource instances.

For example: false

TravelArea

This is used while syncing work centres from Oracle Maintenance to Oracle Fusion Field Service.

For example: MaintenanceTA

ReservationSupplySourceType

This is the value of SupplySourceType the inventory reservation.

For example: On hand

ShouldCreateEquipmentResource

This flag indicates whether to sync equipment type resource instances. If set to false, such resource instances aren't synced.

For example: true

ShouldCreateResourceBucket

This flag indicates whether to create resources as buckets. If set to false, all instances are synced under a Oracle Maintenance org.

For example: false

UserType

This indicates the user type of labor resource instances synced from Oracle Maintenance to Oracle Fusion Field Service.

For example: mobile worker

ParentResourceId

The resource id of the parent bucket where the resources are to be synced.

For example: maintenance_root

BucketResourceType

The resource type of buckets. It is used to create resource and Oracle Maintenance org.

For example: BK

EquipmentResourceType

The resource type of equipment instances synced from Oracle Maintenance to Oracle Fusion Field Service.

For example: tool

LaborResourceType

The resource type of labour instances synced from Oracle Maintenance to Oracle Fusion Field Service.

For example: PR

WO_STATUSES_ACTIVITY_CANCEL

The work order status(es) that are allowed to cancel all the corresponding activities in Oracle Fusion Field Service.

For example: ORA_CANCELED

WO_STATUSES_ACTIVITY_DELETE

The work order status(es) that are allowed to delete all the corresponding activities in Oracle Fusion Field Service.

For example: ORA_ON_HOLD,ORA_UNRELEASED

SkipMntOperationsStatus

When a work order is in this status, OIC skips the updates from Oracle Maintenance. This is to avoid deleting an activity from the Oracle Fusion Field Service, if the activity is moved to another resource instance that's not present in the organisation.

Action for customer : Customer must create a custom Work Order status in Oracle Maintenance using the value RESCHEDULE.

For example: RESCHEDULE

OICInstanceName

This field is required to get the instance details to call the OIC factory API.

The screenshot highlights the field required to get the instance details to invoke the OIC factory API
WareHouseResourceType Warehouse Resource type label from Oracle Fusion Field Service. Mandatory, if PreferredWarehouseEnabled is set to true.
setOrgAsPreferredWarehouse If true, Inventory Organization Warehouse will be assigned as Preferred Warehouse. Otherwise, Subinventory warehouse will be assigned.
PreferredWarehouseEnabled If true, Preferred Warehouse feature will be enabled.
EventsForWOUpdate Enter one or more Field Service activity events, separated by commas. Supported values include, activitySuspended, activityMoved, activityStarted, activityNotDone, activityCanceled, activityCreated, and activityUpdated.
ActivityMoveConditions Enter one or more move conditions, separated by commas. Supported values include, bucketToResource, resourceToBucket, resourceToResource, and bucketToBucket. If no value is specified, only bucketToResource and resourceToBucket will be handled by default.
EventsForMeterUpdate Enter one or more Field Service activity events, separated by commas. Supported values include, activitySuspended, activityStarted, activityCreated, and activityUpdated.
EventsForDFFUpdate Enter one or more Field Service activity events, separated by commas. Supported values include, activitySuspended, activityStarted, activityNotDone, activityCanceled, activityCreated, and activityUpdated. If the lookup is empty, DFF updates will occur only on the activityCompleted event.
Default Values:
  • List of business units to be tracked as part of integration

  • Subinventory groups and whether they must be tracked, or if they're to be treated as trucks for road call scenarios.

Note:
  • Accelerator allows the update of resource instance to a work order when an activity is assigned to technician or when an activity completed from Oracle Fusion Field Service. To enable the update of resource instance as part of activity completion, enable the look up configuration ORCL-BRT-MNT-OFS-CONFIG->SkipWOResInstanceUpdate as True. This is the recommended flow if you are performing bulk operation of activity assignment /movement / reschedule operation from Oracle Fusion Field Service.

  • If there is no value configured for this lookup accelerator will take the value of the ORCL-BRT-MNT-OFS-CONFIG->SkipWOResInstanceUpdate as false. And the resource instance details will get updated into the work order when an activity is assigned to a field resource from Oracle Fusion Field Service.