Search Results process_origin

Overview

The APPS.FTE_PARCEL_LOADER package is a server-side PL/SQL component within the Oracle E-Business Suite Freight and Transportation Execution (FTE) module. Its principal business function is to support the bulk loading of parcel rating and routing configuration data into the ETRM (Enterprise Transportation and Rate Management) repository. Rather than requiring users to enter rating zone charts, rating setups, origins, destinations, and zone-to-lane relationships manually through individual forms, this package parses and processes structured data blocks and applies the appropriate validation and insert logic for each configuration type. The package header carries the source control identifier FTEPCLDS.pls 120.0, indicating it is an original FTE component dating to the mid-2000s. Note that the object is returned by a search for "ALP Parcel service"; while the loader is named for parcel data, it is a generic bulk-load driver that dispatches to type-specific processing routines. The package is classified under ETRM as OTHER (not a public, supported API), so it should be treated as an internal utility rather than a documented integration surface.

Key Procedures and Functions

• PROCESS_DATA — The principal entry point. It accepts an incoming configuration block and dispatches control to the correct type-specific processing routine based on the block type (rating zone chart, rating setup, origin, or destination). It returns a status indicator, where a value of -1 signifies no error, along with an optional error message.
• PROCESS_RATING_ZONE_CHART — Processes the lines of an incoming block as a rating zone chart definition, validating and loading zone chart data used to map geographic zones.
• PROCESS_RATING_SETUP — Handles the bulk load of rating setup records, which define the rating parameters applied when pricing parcel and freight shipments.
• PROCESS_ORIGIN — Processes origin location definitions contained in the uploaded block.
• PROCESS_DESTINATION — Processes destination location definitions contained in the uploaded block.
• PROCESS_ZONES_AND_LANES — Processes combined zone and lane configuration data, establishing the relationships between defined zones and the transportation lanes that connect them.

Each procedure observes a consistent convention: block header and block data tables are passed in, a starting line number is supplied for error reporting, and status and error message values are returned through OUT parameters. The loader relies on the shared types FTE_BULKLOAD_PKG.block_header_tbl and FTE_BULKLOAD_PKG.block_data_tbl to represent the parsed input.

Tables Accessed

• FTE_LANES — Stores transportation lane definitions; accessed when processing zones-and-lanes data.
• WSH_REGIONS and WSH_REGIONS_TL — Hold region definitions and their translated names, supporting geographic zone and location validation.
• WSH_ZONE_REGIONS — Associates zones with regions, forming the basis of zone chart and zone/lane mapping.
• PLITBLM — The Oracle Applications PL/SQL table maintenance package, used internally for index-by-table handling during bulk processing.

Usage Notes

FTE_PARCEL_LOADER is typically invoked from the ETRM bulk-load/upload framework, where a concurrent program or a dedicated loader form reads a flat file or interface table, packages the rows into the block structures defined in FTE_BULKLOAD_PKG, and then calls PROCESS_DATA to route each block to the correct handler. Because the package is classified as OTHER rather than a supported public API, it is not intended for direct calls from external applications; custom code that references it should be validated against the target release, as the FTE bulk-load internals are subject to change between 12.1.1 and 12.2.2. Implementers performing data migration of parcel rating and routing configuration should prefer officially documented interfaces and use this package only through the standard upload mechanism for which it was designed.