List of Service Logistics Lookups
See 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 |
Predefined 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, SUPPLIER WARRANTY |
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. Note: See the Use the Document Type Lookup to Create
Custom Document Types section that follows for more information.
|
|
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're 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 |
Use the Document Type Lookup to Create Custom Document Types
You can also use the document type lookup (ORA_RCL_SOURCE_DOC_TYPE) to create custom document types. The following table shows the predefined document types that you can use and the tag information you'll need for your custom document types. These tags decide where your custom lookups appear within Service Logistics.
|
Document Type |
Tag |
Predefined |
Where does this document type appear? |
Where's this document type stored? |
|---|---|---|---|---|
|
Replenish Technician Trunk Stock Lookup Code: REPLENISHMENT |
Null |
Yes |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) |
Part Requirement Header |
|
Replenish Warehouse Lookup Code: REPL_WAREHOUSE |
Null |
Yes |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) |
Part Requirement Header |
|
Return Material Authorization Lookup Code: RMA |
Null |
Yes |
Depot Repair Workbench (display only) Depot Repair in Redwood UI |
Debrief Header |
|
Service Request Lookup Code: EC_SR |
Null |
Yes |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) Part Requirements Search page in Redwood UI (filter chip) Part Requirements Header Page in Redwood UI (LOV value) Part Requirement Detail page in Redwood UI (display only) |
Part Requirement Header |
|
Work Order Lookup Code: EC_WO |
Null |
Yes |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) Part Requirements Search page in Redwood UI (filter chip) Part Requirements Header page in Redwood UI (LOV value) Part Requirement Detail page in Redwood UI (display only) Manage Work Orders and Charges (display only) Manage Charges and Estimates, Edit (display only) Manage Charges and Estimates, Create (LOV value) Work Order Charges Search page in Redwood UI (filter chip) Work Order Charges Header page in Redwood UI (LOV value) Work Order Charges details page in Redwood UI (display only) |
Part Requirement Header Debrief Header |
|
Customer-defined Service Request |
EC_SR |
No |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) Part Requirements Search page in Redwood UI (filter chip) Part Requirements Header Page in Redwood UI (LOV value) Part Requirement Detail page in Redwood UI (display only) |
Part Requirement Header |
| Customer-defined Work Order |
EC_WO |
No |
Manage Part Requirements (display only) Create/Edit Part Requirement (LOV value) Part Requirements Search page in Redwood UI (filter chip) Part Requirements Header page in Redwood UI (LOV value) Part Requirement Detail page in Redwood UI (display only) Manage Work Orders and Charges (display only) Manage Charges and Estimates, Edit (display only) Manage Charges and Estimates, Create (LOV value) Work Order Charges Search page in Redwood UI (filter chip) Work Order Charges Header page in Redwood UI (LOV value) Work Order Charges details page in Redwood UI (display only) |
Part Requirement Header Debrief Header |