Results for “fte_source_line_consolidation”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FTE_SOURCE_LINE_CONSOLIDATION is an Oracle EBS Applications (APPS) package body that belongs to the Oracle Transportation Management / Freight and Trade Execution (FTE) family of logistics modules. Its principal responsibility is to consolidate source document lines — typically order, shipment, or delivery lines — that share a common origin, carrier, or routing context, into a unified payload for downstream freight rating, carrier selection, and cost calculation. The package operates in the context of WSH (Shipping) execution infrastructure, as evidenced by its references to WSH_CARRIERS, WSH_CARRIER_SERVICES, and the WSH_DEBUG utility layer. The header revision (FTELNCNB.pls, version 120.2, dated January 2008) indicates this is a legacy-shipped object that remains intact through EBS 12.1.1 and 12.2.2 releases.

A distinguishing design feature is the package-level use of a hash table to bucket source headers. The declarations g_hash_base NUMBER := 1 and g_hash_size NUMBER := power(2, 25) reveal an open-addressing or partitioning scheme, where each source header is hashed into one of approximately 33.5 million slots and stored in g_source_header_hash_tab as a record of con_id and hash_string. This "create_hash" construct — referenced by users searching for the term — is the mechanism by which the package avoids redundant consolidation work and enables O(1) lookup of already-processed header combinations.

Key Procedures and Functions

Only one procedure is documented in the ETRM metadata for the 12.2.2 release: CONSOLIDATE_LINES. This is the entry point invoked by callers to perform the actual consolidation of source lines. Based on the package's cached hash table and the reference to DBMS_UTILITY and PLITBLM, CONSOLIDATE_LINES is responsible for iterating over incoming source lines, computing or retrieving a hash key, grouping lines with matching keys, and returning the consolidated result set.

Although not enumerated in the ETRM procedure list, the source excerpt also reveals the private helper get_org_default_uoms, which retrieves and caches the default weight and volume units of measure for a given organization (g_weight_uom_tab, g_volume_uom_tab). It follows the standard WSH debug tracing convention and returns a status code via WSH_UTIL_CORE.G_RET_STS_SUCCESS. A cursor c_get_generic_carrier_flag resolves the generic_flag for a ship_method_code by joining WSH_CARRIERS and WSH_CARRIER_SERVICES, informing carrier-agnostic consolidation decisions.

Tables Accessed

• MTL_SYSTEM_ITEMS — referenced to obtain item master attributes (weight, volume, units of measure) required to normalize source lines before consolidation.
• WSH_CARRIERS and WSH_CARRIER_SERVICES — joined in c_get_generic_carrier_flag to determine whether a ship method is a generic (non-carrier-specific) service, which affects whether lines may be pooled.
• DBMS_UTILITY — used for hash computation routines (the "create_hash" behavior), converting string keys into numeric bucket indices.
• PLITBLM — a PL/SQL associative-array utility package supporting the in-memory hash table operations.

Usage Notes

FTE_SOURCE_LINE_CONSOLIDATION is typically invoked from shipping execution flows — most commonly from concurrent programs or internal shipping APIs that prepare freight rating requests. It is referenced by one other package in the ETRM dependency graph, indicating a layered call pattern within the WSH shipping suite. Developers searching for "create_hash" in the context of this object are likely investigating how the package deduplicates or partitions source lines during consolidation. Because the hash table is package-global and initialized at session load, the cache persists for the duration of a database session, making this package best suited to set-based batch processing rather than short interactive transactions. Custom code should invoke CONSOLIDATE_LINES only through the documented interface and honor the WSH return status values, since the package relies on WSH_DEBUG_SV logging for diagnostics and does not raise exceptions directly to callers.