Search Results create_trips

Overview

CSF_TRIPS_PUB is a public PL/SQL package in the APPS schema that belongs to the Oracle E-Business Suite Field Service (CSF) module family. It operates as the trip management application programming interface, providing the business logic required to model, schedule, and maintain trips within the Field Service scheduling engine. A trip in this context represents a service visit or travel segment assigned to a field service resource, encompassing the origin, destination, timing, and associated resource and task assignments. The package allows callers to search existing trips, create new trips, modify or delete them, and invoke scheduling and optimization routines that operate on one or many trips at once. It also participates in the broader scheduling architecture through its role in generating trips from tasks and shifts, optimizing work across multiple trips, and applying dispatch-center-level trip logic. Because it is classified as a PUB package, it is intended as a supported entry point for external callers, including other EBS packages, forms, and custom code, rather than as an internal implementation detail. The package is a dependency of CSF_TASKS_PUB and CSF_TASK_ASSIGNMENTS_PUB, reflecting the tight coupling between trip records, task records, and resource assignments in the Field Service data model.

Key Procedures and Functions

The documented interface exposes seventeen procedures and functions. The search-oriented members are FIND_TRIP and FIND_TRIPS, which retrieve one or many existing trip records according to caller-supplied criteria. The maintenance members are CREATE_TRIP, CREATE_TRIP1, NEW_TRIP1, UPDATE_TRIP, DELETE_TRIP, and FIX_TRIP; these cover trip creation (including alternate creation paths), attribute updates, deletion, and correction or settlement of a trip record. Bulk scheduling operations are provided by GENERATE_TRIPS, CREATE_TRIPS, and OPTIMIZE_ACROSS_TRIPS, which build trip collections and evaluate scheduling efficiency across multiple trips simultaneously. Dispatch-center-oriented logic is supplied by CREATE_DC_TRIP and UPDATE_DC_TRIP. Shift and task integration is handled by CREATE_SHIFT_TASKS1 and UPDATE_SHIFT_TASKS, which translate shift definitions into task records associated with trips. PROCESS_ACTION provides a generic action-dispatch entry point, allowing the caller to request a named trip operation through a single interface.

Tables Accessed

Through APPS synonyms, the package reads and writes tables supporting resources, tasks, and scheduling. JTF_TASKS_B and JTF_TASK_ASSIGNMENTS hold task and assignment data, with JTF_TASK_STATUSES_B supplying status values. JTF_RS_RESOURCE_EXTNS, JTF_RS_RESOURCE_EXTNS_TL, and JTF_RS_ROLES_B provide resource attributes, translated resource descriptions, and role information. CAC_SR_OBJECT_CAPACITY and CSF_R_RESOURCE_RESULTS store capacity and scheduling result data. FND_FLEX_VALUE_SETS and FND_FLEX_VALUES_TL support flexfield validation of scheduling attributes; FND_PROFILE_OPTION_VALUES supplies profile settings; FND_TIMEZONES_B and MTL_UOM_CONVERSIONS support time-zone handling and unit-of-measure conversions; FND_NEW_MESSAGES and JTF_OBJECTS_B support messaging and object reference lookups.

Usage Notes

CSF_TRIPS_PUB is typically invoked from Field Service scheduling and dispatch forms, from concurrent programs that generate or optimize trips in batch, and from custom extensions that must create or amend trip records. Because it is a PUB API, custom code should call these procedures rather than inserting directly into the underlying tables, preserving the integrity of the scheduling model. Callers should be aware that trip creation and optimization are resource-intensive and should be batched where possible, and that dependent packages such as CSF_TASKS_PUB and CSF_TASK_ASSIGNMENTS_PUB will already be present in the application’s call path when trips are manipulated. Behavior is consistent across EBS 12.1.1 and 12.2.2.