Search Results fte_location_parameters_s

Overview

The APPS.FTE_LOCATION_PARAMETERS_PKG package body is a valid, compiled PL/SQL unit in the Oracle E-Business Suite 12.1.1 and 12.2.2 environments. It resides in the APPS schema and is classified as an "OTHER" API type within the ETRM repository. The package serves as a foundational data maintenance utility for Oracle Freight and Transportation Execution (FTE), a module in the E-Business Suite supply chain execution suite. Its core business function is to establish, validate, and retrieve the geographic and organizational parameters required to define freight locations and facilities used during transportation planning, rating, and carrier selection. These parameters underpin origin and destination definitions for shipments, including latitude, longitude, time zone, and associated operating unit or inventory organization attributes.

Key Procedures and Functions

The ETRM metadata documents four procedures and functions contained within this package body:

• CREATE_FACILITIES – A procedure that establishes multiple facility records in a single invocation, enabling batch setup of freight locations across organizations or business units.
• CREATE_FACILITY – A procedure that creates an individual facility record, capturing the location attributes needed for FTE freight processing.
• GET_FAC_INFO – A function that retrieves facility information, returning the configured attributes of a specified facility for downstream processing.
• GET_FAC_LAT_LONG_AND_TIMEZONE – A function that returns the geographic latitude, longitude, and time zone associated with a facility, which are essential for distance calculations, transit time estimation, and carrier rate determination.

These routines collectively provide the create and read operations that manage the facility parameter data consumed by FTE.

Tables Accessed

The package operates across a broad set of dictionary and transactional tables. It reads and writes FTE_LOCATION_PARAMETERS and its translation table FTE_LOCATION_PARAMETERS_S, which are the primary stores for FTE location configuration. It references FTE_PRC_PARAMETERS for FTE process parameters and HR_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION to associate facilities with inventory organizations and operating units.

Party and site data are sourced from HZ_PARTIES, HZ_PARTY_SITES, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, and HZ_RELATIONSHIPS, linking facilities to trading partners and addresses. Shipping and location details come from WSH_LOCATIONS, WSH_LOCATION_OWNERS, and WSH_CARRIERS_V. Inventory parameters are drawn from MTL_PARAMETERS and MTL_UNITS_OF_MEASURE_VL, while purchasing location links are read from PO_LOCATION_ASSOCIATIONS_ALL and PO_VENDORS. Spatial geometry for latitude and longitude is handled through the MDSYS schema using SDO_GEOMETRY. Utility structures such as STRINGARRAY, PLITBLM, and geocoding services from WSH_GEOCODING and WSH_DEBUG_SV support bulk processing and diagnostics.

Usage Notes

This package is typically invoked during FTE setup and configuration, either from Oracle Forms-based location maintenance screens, from concurrent programs that initialize or refresh freight location data, or from custom PL/SQL integrations that provision facilities programmatically. The CREATE_FACILITIES routine supports bulk loading scenarios, while the GET functions are called at runtime by transportation planning and rating engines to resolve facility geography and time zone. The presence of WSH debugging and geocoding dependencies indicates that the package participates in location validation and address geocoding workflows. As the package is not referenced by any other database object per the ETRM metadata, it functions as a top-level entry point for facility parameter management rather than an internal library. Because it is an "OTHER"-classified API, Oracle does not guarantee public API stability; customizations should be limited to invocations rather than modifications of the package body itself.