Search Results qp_process_id_s

Overview

APPS.FTE_LTL_LOADER is a VALID PL/SQL package body in the Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2 environment that supports the Oracle Transportation Management and Freight and Tariff Enablement (FTE) functionality. Its principal role is to load Less-Than-Truckload (LTL) rate and tariff data into the EBS pricing and transportation interface tables, bridging FTE bulk-load input data with Oracle Advanced Pricing and the Oracle Shipping (WSH) region and carrier model. The package reads staged data from the FTE_BULKLOAD tables, validates it against lanes, zones, services, and pricing parameters, and then writes pricing list headers, lines, attributes, and qualifiers into the QP interface tables for import into Oracle Advanced Pricing. It also leverages WSH region and carrier definitions to resolve geographic and carrier-specific rate information. The package depends on a broad set of foundation and application utilities, including FND_CONCURRENT, FND_REQUEST, FND_MESSAGE, and FND_PROFILE, indicating that it can be driven from concurrent programs and reports execution status through the standard concurrent manager infrastructure.

The dependency listing explicitly includes QP_PROCESS_ID_S, the Advanced Pricing sequence that supplies process identifiers for pricing interface records. The presence of this sequence in the FTE_LTL_LOADER dependency chain explains why a search for "qp_process_id_s" surfaces this package body: the loader uses QP_PROCESS_ID_S to stamp or group interface rows so that Oracle Advanced Pricing can identify a single pricing import run and reconcile the resulting list headers and lines. It also depends on QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES, QP_INTERFACE_PRICING_ATTRIBS, and QP_INTERFACE_QUALIFIERS, the standard interface tables into which pricing data is loaded prior to submission of the pricing interface program.

Key Procedures and Functions

• VERIFY_TARIFF_CARRIER — Validates that the tariff carrier referenced by the load file exists and is consistent with carrier definitions. It relies on WSH_CARRIERS and HZ_PARTIES to confirm carrier identity before rate data is processed.
• GET_TARIFF_RATECHARTS — Retrieves the rate charts and associated lane rate information that govern how a given tariff should price LTL shipments. It draws on FTE_LANE_RATE_CHARTS and related lane tables to build the pricing model used downstream.
• QP_PROCESS — Performs the pricing interface processing step, inserting or staging pricing records into the QP interface structures and associating them with a process identifier obtained from QP_PROCESS_ID_S. This procedure is the core link between FTE tariff data and Oracle Advanced Pricing.
• PROCESS_LTL_DATA — The main driver that iterates over staged LTL data, applies validation through FTE_VALIDATION_PKG, resolves lanes, zones, services, and commodities, and coordinates the loading of pricing list records. It orchestrates the work performed by the other documented procedures.

Tables Accessed

The package reads and writes several documented base and interface tables through APPS synonyms. On the FTE side, it consumes staged input from FTE_BULKLOAD_DATA, FTE_BULKLOAD_DATA_S, and FTE_BULKLOAD_FILE, and resolves reference data from FTE_INTERFACE_ZONES, FTE_INTERFACE_LANES, FTE_LANES, FTE_LANES_S, FTE_LANE_COMMODITIES, FTE_LANE_RATE_CHARTS, FTE_LANE_SERVICES, FTE_LANE_SERVICES_S, and FTE_PRC_PARAMETERS. Carrier and party identity is validated against HZ_PARTIES. On the Oracle Shipping side, geographic and carrier structures are read from WSH_REGIONS_TL and related WSH tables. On the pricing side, the loader populates QP_INTERFACE_LIST_HEADERS, QP_INTERFACE_LIST_LINES, QP_INTERFACE_PRICING_ATTRIBS, and QP_INTERFACE_QUALIFIERS, and references QP_LIST_HEADERS_TL, QP_LIST_LINES, QP_PRICING_ATTRIBUTES, and QP_QUALIFIERS, with QP_PROCESS_ID_S supplying process identifiers. These accesses support the transformation of flat LTL rate input into Advanced Pricing list structures.

Usage Notes

FTE_LTL_LOADER is typically invoked indirectly rather than from an end-user form. Its documented dependencies on FND_REQUEST and FND_CONCURRENT indicate that it is driven from concurrent programs, commonly as part of the FTE bulk-load and LTL tariff import flow. A user uploads or stages LTL rate data into the FTE bulk-load tables, then submits the relevant concurrent request; the loader validates the carrier, resolves rate charts and lanes, processes the LTL rows, and pushes pricing records into the QP interface tables for subsequent import by Oracle Advanced Pricing. Because the package body status is VALID and it is referenced by at least one other package but does not itself reference external database objects outside its listing, it functions as an internal integration utility. Customizations should avoid modifying the package directly; instead, extensions should consume the documented procedures or operate on the FTE and QP interface tables between the load and import phases. The QP_PROCESS_ID_S sequence should be treated as the correlation key that ties a single LTL load run to its resulting pricing interface records.