Search Results get_results_for_rule

Overview

FTE_ACS_CACHE_PKG is an internal PL/SQL package in the APPS schema that supports the caching and retrieval layer of the Oracle E-Business Suite Advanced Catch-Weight and Shipment (ACS) rule-processing engine. In EBS 12.1.1 and 12.2.2 the FTE (Freight and Transportation Execution) module evaluates a set of user-defined matching rules against shipment and trip data to determine how goods should be consolidated, routed, or assigned to trips. Evaluating those rules repeatedly against the base configuration tables is expensive, so FTE_ACS_CACHE_PKG provides a cache abstraction: it holds rule definitions and evaluated results in memory during a session and returns them on demand to the higher-level rule and trip packages.

The package is classified as OTHER rather than as a public or private API, confirming that it is a supporting utility rather than a customer-callable interface. Its principal consumers are FTE_ACS_PKG (the core ACS engine), FTE_ACS_RULE_UTIL_PKG (rule evaluation utilities), and FTE_ACS_TRIP_PKG (trip building and consolidation). Because these three packages depend on it directly, FTE_ACS_CACHE_PKG is on the critical path for any ACS-enabled shipping or load-planning transaction.

Key Procedures and Functions

The ETRM metadata documents two entry points:

• GET_MATCHING_RULE — Returns the matching rule (or rule set) applicable to the current evaluation context. It resolves which selection rule should be applied for a given combination of selection group, selection group attributes, and rule restrictions, drawing on cached rule metadata rather than re-querying the underlying configuration tables on each call.
• GET_RESULTS_FOR_RULE — Returns the cached evaluation results associated with a previously matched rule. It supplies the result assignments and result attributes that the calling engine uses to act on the matched rule, such as how shipments or trips should be grouped or consolidated.

Because the metadata exposes only the procedure and function names, parameter signatures are not documented here; callers should reference the deployed package specification in the target instance for exact prototypes. The two routines are designed to be used in sequence: match the rule first, then retrieve its results.

Tables Accessed

The package reads (and in some paths populates cache structures derived from) the following tables through APPS synonyms:

• FTE_SEL_GROUPS and FTE_SEL_GROUP_ATTRIBUTES — define the selection groups and their attributes that scope rule matching.
• FTE_SEL_RULE_RESTRICTIONS — constrains which rules apply in a given context.
• FTE_SEL_RESULT_ASSIGNMENTS and FTE_SEL_RESULT_ATTRIBUTES — define the outcome data returned by GET_RESULTS_FOR_RULE.
• WSH_LOCATIONS — the Oracle Shipping location reference, used when rule matching or restriction evaluation depends on origin/destination geography.
• PLITBLM — the standard PL/SQL table of VARCHAR2 used by EBS for bulk parameter passing; its presence indicates set-based invocation of the cache routines.

Usage Notes

FTE_ACS_CACHE_PKG is not invoked directly from Oracle Forms or concurrent program definitions. It is called internally by FTE_ACS_PKG, FTE_ACS_RULE_UTIL_PKG, and FTE_ACS_TRIP_PKG whenever ACS rule evaluation is triggered — for example, during shipment consolidation, trip building, or load optimization initiated from the Shipping Transactions form or from ACS-related concurrent programs. Custom code should treat the package as private: depend on the documented ACS public APIs rather than calling GET_MATCHING_RULE or GET_RESULTS_FOR_RULE directly, since cache lifetime, invalidation, and signature behavior are implementation details subject to change across patch levels in both 12.1.1 and 12.2.2.