Search Results get_formated_regions




Overview
Explore in AI Chat

Overview

FTE_ACS_RULE_UTIL_PKG is a utility package within the Oracle E-Business Suite Freight and Transportation Execution (FTE) module, specifically supporting the Advanced Carrier Selection (ACS) engine. Its principal role is to provide shared helper logic that the ACS rule engine and related search components invoke when evaluating carrier selection rules, formatting candidate entities, and resolving shipment attributes. The package encapsulates both a numeric conversion utility and a set of procedures that manipulate selection groups, geographic regions, postal data, and shipping method mappings. It is classified as an "OTHER" API in the ETRM repository for releases 12.1.1 and 12.2.2.

The package bridges the ACS configuration tables (selection groups, rules, restrictions) with the underlying Oracle Shipping execution tables (carriers, services, locations), thereby enabling the rules engine to translate abstract rule criteria into concrete, carrier-specific shipping method codes and geographic region identifiers. Several procedures were introduced or enhanced during the R12 development cycle, as indicated by the inline "R12 Enhancements" comment in the package specification header.

Key Procedures and Functions

  • CONV_TO_BASE_UOM — A function that converts a supplied numeric value from one unit of measure to another base unit of measure. It is used to normalize quantities and weights so that rule comparisons operate on consistent UOM values.
  • GET_FORMATED_REGIONS — Retrieves the formatted region, all-region, and postal zone identifiers associated with a given location. It returns collection types defined in WSH_UTIL_CORE, supporting geographic rule evaluation.
  • GET_POSTAL_CODE — Returns the postal code for a specified location identifier, supplying the postal data required by zone-based selection rules.
  • SET_RANGE_OVERLAP_FLAG — Evaluates and sets the range overlap flag for a given selection group, detecting overlapping value ranges that could produce ambiguous rule matches.
  • INSERT_INTO_GTT — Inserts candidate entity data into a global temporary table used to stage records during a search operation.
  • FORMAT_ENTITY_INFO — Formats and normalizes the entity information collection that is carried through the selection process, applying entity-specific formatting rules.
  • GET_SHIP_METHOD_CODE — Resolves a shipping method code from a carrier, service level, mode of transport, and organization combination. This is the procedure most commonly sought by developers working with shipping method resolution in ACS.
  • GET_CANDIDATE_RECORDS — Retrieves the candidate entity records that match a given search level and query criteria, optionally using a single-record template, producing the output collection consumed by the selection engine.

Tables Accessed

The package reads and writes several ACS and Shipping tables through APPS synonyms:

Three other packages reference this utility package, indicating it is a shared dependency within the ACS framework.

Usage Notes

FTE_ACS_RULE_UTIL_PKG is typically invoked indirectly by the ACS rule engine and by the higher-level FTE_ACS_PKG package rather than being called directly from end-user forms. It is most commonly encountered in the context of carrier selection processing, where the engine evaluates configured selection rules against shipment and order attributes. Developers extending ACS functionality, building custom carrier selection logic, or troubleshooting shipping method resolution may call GET_SHIP_METHOD_CODE or GET_CANDIDATE_RECORDS directly from custom PL/SQL. Because the procedures rely on NOCOPY OUT parameters and application collection types, callers should initialize output parameters and handle the returned status and message values appropriately. The GET_SHIP_METHOD_CODE procedure is the standard entry point when a carrier, service level, mode of transport, and organization must be translated into a valid shipping method code for downstream order or delivery processing.