Search Results fte_acs_pkg




Overview
Explore in AI Chat

Overview

FTE_ACS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the Oracle Transportation Management and Global Trade Management integration layer within the Fulfillment Transaction Engine (FTE). Its designation in the ETRM metadata as an "OTHER" classification API indicates that it is an internal engine package rather than a public, customer-facing API. The package is responsible for executing Automated Classification Services (ACS) logic, which assigns transportation and trade classification values to order and shipment lines based on preconfigured selection rules. In the context of Oracle EBS 12.1.1 and 12.2.2, ACS processing supports downstream transportation planning, carrier selection, compliance screening, and landed cost determination by ensuring that each transaction line carries a valid classification code before planning or documentation activities proceed.

Key Procedures and Functions

The documented package exposes three procedures and functions:

  • START_ACS — Serves as the primary entry point that initiates the automated classification process. It orchestrates the evaluation of active selection rules against the input transaction data and drives the classification run from beginning to end.
  • LOG_CS_MESSAGES — Handles message logging during classification processing. It records diagnostic, informational, or error messages generated during an ACS run, supporting troubleshooting and audit of classification outcomes.
  • GET_ROUTING_RESULTS — Returns the routing or classification results produced by the ACS evaluation, allowing calling programs to retrieve the outcome of the classification for further processing or persistence.

No parameter signatures are documented in the ETRM metadata; parameter lists are intentionally omitted here to avoid speculation.

Tables Accessed

The package accesses the following tables through APPS synonyms:

  • FTE_SEL_RULES — Stores the selection rule definitions that govern how classification values are determined. START_ACS reads these rules to drive the classification logic.
  • FTE_SEL_RULE_RESTRICTIONS — Holds restriction criteria attached to selection rules, narrowing rule applicability to specific conditions, such as organization, item, or transaction attributes.
  • FTE_SEL_SEARCH_ENTITIES_TMP — A temporary staging table used to hold the entities being searched or evaluated during rule execution.
  • PLITBLM — A standard PL/SQL table (index-by table) type, referenced for internal collection handling rather than as a physical database table.

Usage Notes

FTE_ACS_PKG is invoked indirectly through the FTE processing framework rather than being called directly by end users. Its documented callers include FTE_ACS_RULE_UTIL_PKG, FTE_PROCESS_REQUESTS, and WSH_FTE_INTEGRATION. This dependency chain indicates that ACS logic is triggered when fulfillment or shipping requests are processed — for example, during order release to the warehouse or shipment confirmation flows handled by WSH. Customizations that require classification behavior should call START_ACS through the supported FTE processing interfaces rather than modifying the package body, since the package is internal and protected by Oracle proprietary and confidential licensing. Because the metadata lists only three documented units, implementers should treat any additional internal units as unsupported and subject to change across 12.1.1 and 12.2.2 patch levels. Auditing classification behavior is best performed through LOG_CS_MESSAGES output, while integrations requiring classification values should obtain them from GET_ROUTING_RESULTS or the persisted transaction records rather than invoking internal rule tables directly.