Search Results process_schedule

Overview

FTE_LANE_LOADER is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Oracle Transportation Management (formerly E-TRM) bulk load framework. Its purpose is to load and process transportation lane data into the scheduling structures used by the FTE (Freight and Transportation Execution) module. In EBS 12.1.1 and 12.2.2, this package operates as a specialized loader that feeds lane-level scheduling information, complementing the broader load orchestration performed by FTE_BULKLOAD_PKG.

The package is classified as an "OTHER" API rather than a public, customer-facing API. It functions as an internal component of the transportation scheduling and rating setup flow. By separating lane-specific loading logic from the master bulk load driver, Oracle isolates the lane data handling (schedules, service definitions, and rating setup) so that the same load framework can be reused for parcels and other scheduling entities.

Key Procedures and Functions

• PROCESS_DATA — Handles the core processing of lane load data. It is the general-purpose entry point for consuming staged lane records and applying them to the appropriate scheduling tables.
• PROCESS_SERVICE — Processes transportation service definitions associated with a lane, ensuring the service structure referenced by the lane is created or validated during the load.
• PROCESS_SERVICE_RATING_SETUP — Processes the rating setup for a service, establishing the rating-relevant configuration needed to support lane-based scheduling and cost calculation.
• PROCESS_SCHEDULE — Processes schedule information tied to lanes, writing the schedule records that define lane timing behavior.
• SUBMIT_LANE — Submits a lane for loading, acting as the control point that initiates processing for an individual lane record within the bulk load run.

Each procedure is called as part of a controlled load sequence rather than independently, and parameter lists are not published because the package is not part of the supported public API surface.

Tables Accessed

The package interacts with two documented tables referenced through APPS synonyms:

• FTE_SCHEDULES — The central table for schedule definitions. FTE_LANE_LOADER reads and writes this table to persist the schedules generated for lanes during the load. This is the primary target of the PROCESS_SCHEDULE logic.
• PLITBLM — The PL/SQL index-by table maintenance utility used within EBS for transient, in-memory table storage and manipulation. Its presence confirms that the package uses intermediate PL/SQL collection structures to stage and transform data before committing to the persistent tables.

Usage Notes

FTE_LANE_LOADER is not intended for direct invocation from Oracle Forms or by end users. It is invoked programmatically by FTE_BULKLOAD_PKG, which acts as the parent orchestrator of the bulk load process. The dependency metadata also shows FTE_LANE_LOADER referencing FTE_BULKLOAD_PKG, indicating a reciprocal relationship in which shared utilities and control procedures are reused across the two packages.

The package is additionally referenced by FTE_PARCEL_LOADER and by itself, reflecting the shared design of the loader family. In practice, lane and parcel loading are driven through concurrent programs that call the bulk load driver; the driver then dispatches to the entity-specific loaders such as FTE_LANE_LOADER. Customizations should not call the individual procedures directly, because the load sequence, validation, and commit boundaries are managed by the parent bulk load package. Customers extending the framework should integrate at the bulk load level. The package existed in both 12.1.1 and 12.2.2 with validity confirmed in APPS, and the presence of PLITBLM usage is consistent across releases.