List of Service Logistics Lookups

Refer to the table for a list of the lookups that Service Logistics uses. You can only view and edit the extensible lookups in the Manage Service Logistics Lookups UI.

Name/Code	Description	Seeded Values	Extensible?
EGP_MATERIAL_BILLABLE_TYPE	Identifies items used in Service Logistics debrief and parts ordering.	CONSUMABLE, LABOR, MATERIAL, EXPENSE	Yes
ORA_RCL_ADDRESS_TYPE	Categorizes the shipping address into different address types.	CUSTOMER, TECHNICIAN, WAREHOUSE	No
ORA_RCL_BILLING_CATEGORY	Identifies the item as Labor, Material, Expense, or a Fixed Charge item.	EXPENSE, LABOR, MATERIAL, FIXCHARGE	No
ORA_RCL_BUSINESS_PROCESS	Identifies the type of service being provided to the customer. All service activity codes are assigned to one of these business processes.	FLDSRV (Field Service), CUSTSUPPORT (Customer Support), DEPOTREPAIR ( Depot Repair), EXCHANGE (Parts exchange), DRLOGISTICS (Depot Repair Logistics).	No
ORA_RCL_COST_ORG_PRF_VAL	Specifies whether to default the cost organization from the asset operating organization or the field technicians default subinventory in the Manage Charges page and API.	ASSET, TECHNICIAN	No
ORA_RCL_DEBRIEF_STATUS	Defines the status of a debrief line.	NEW, POSTED, ERROR	No
ORA_RCL_ESTIMATE_STATUS	Indicates whether the estimated charges are new, awaiting approval, approved, rejected, or canceled.	NEW, AWAITING_ APPROVAL, APPROVED, REJECTED, CANCELED	No
ORA_RCL_IMT_STATUS	Indicates the status of a material transfer.	SHIPPED, NOTSHIPPED, SHIPPEDLATE, NOTSHIPPEDLATE, SUBMITTED, SUPPLY_REQUEST, CANCEL_SUBMITTED	No
ORA_RCL_PART_SOURCING_CS	Defines part search methods and sequences for customer support part requirements.	MANNED, GOP	No
ORA_RCL_PART_SOURCING_FS	Defines part search methods and sequences for field service parts requirements.	SITE_DDCTD (Site Dedicated), TECHNICIAN, UNMANNED, MANNED, GOP (Global order promising sourcing method), REPLENISH (Inventory replenishment rules)	No
ORA_RCL_QUANTITY_LEVEL	Indicates the quantity level of items or parts in the technicians' trunk stock.	SHORTAGE, EXCESS	No
ORA_RCL_RET_RULE_SRC_TYPE	Identifies the source type for the return routing rules.	INV (organization and subinventory), ZONE (zone)	No
ORA_RCL_RETURN_TYPE	Identifies the return routing rule type.	DEFECTIVE, EXCESS	No
ORA_RCL_SOURCE_DOC_TYPE	Identifies the Service Logistics source document type, for example, whether it's a service work order or service request from the Fusion Service UIs or a third party work order or service request.	EC_SR (Engagement Cloud Service Request), EC_WO (Engagement Cloud Work Order), REPLENISHMENT (Replenish Technician Trunk Stock), REPL_WAREHOUSE (Replenish warehouse)	Yes
ORA_RCL_STOCK_LOC_CONDITION	Identifies whether the stocking location is good/usable or defective.	GOOD, DEFECTIVE	No
ORA_RCL_STOCK_LOC_TYPE	Identifies the stocking location type.	TECHNICIAN, UNMANNED, MANNED, SITE_DDCTD (Site Dedicated Warehouse)	No
ORA_RCL_USAGE_CODE	Identifies how a part is used to resolve the work order.	USED, UNUSED, DOA(defective on arrival)	No
ORA_RCL_WORK_AREA	Identifies the work areas on Fusion Service work orders and Oracle Field Service Cloud (OFSC) activities. The lookup meaning must match the work area string on the Fusion Service work order. Used as a filter on the Service Logistics landing page and the Manage Work Orders and Charges page when searching for Fusion Service work orders. Used as a filter in the Manage Part Requirements page. Used to default the FS Tech inventory organization in the Add Part window when parts are added to a work order before a field technician has been assigned to the Fusion Service work order. The default destination inventory organization is entered for each work area in the Tag column of the lookup. OFSC Work Areas We are using the work area lookup when setting a value for the profile Default Parent Resource Name. The value from this profile is used to assign a parent node when creating technician and truck resources in OFSC. The lookup code should be equal to the External ID in OFSC. The parent resource must already exist. It isn't possible to create a resource without a parent through REST services. Work Area is another type of resource in OFSC. The resource type has the role Bucket. The resource name is passed to the Fusion Service work order and is stored on the work order (must match the work area lookup meaning in Service Logistics).	None.	Yes
ORA_RCL_YES_NO	Indicates a yes or no condition.	Y, N	No