Results for “fte_acs_pkg”
46 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FTE_ACS_PKG is the core PL/SQL package body supporting the Carrier Selection (ACS) module within Oracle E-Business Suite's Transportation Execution and Freight Foundation (FTE) product family. Carrier selection is the process by which Oracle Transportation Management's EBS integration layer evaluates shipment or delivery candidates against configured selection rules and determines the most appropriate carrier and routing. The package encapsulates the procedural logic that drives this evaluation, including rule matching, entity (delivery/trip) resolution, and the logging of selection messages that are surfaced back to the calling application or user interface.
The package is owned by APPS and is classified as an OTHER API, meaning it is not part of Oracle's published, externally supported open interface set but is instead an internal implementation package invoked by other EBS components. It is referenced by three other packages, confirming its role as a shared service within the carrier selection flow. The header comment identifies it as containing "core procedures for carrier selection module," and the embedded R12 enhancement structures — such as FTE_CS_ENTITY_RULE_REC and FTE_CS_TEMP_ENTITY_TAB — indicate that the package was extended in Release 12 to handle entity-level rule evaluation for deliveries and trips.
Key Procedures and Functions
- START_ACS — The primary entry point for the carrier selection process. It initiates evaluation of selection rules against the shipment, delivery, or trip context supplied by the caller and orchestrates the downstream logic that produces routing results. This is the procedure other packages call to begin an ACS run.
- LOG_CS_MESSAGES — Persists and manages the output messages generated during carrier selection. The package defines a global variable, g_message_tab, of type FTE_CS_OUTPUT_MESSAGE_TAB, which accumulates messages as the selection process executes; LOG_CS_MESSAGES writes these to the messaging infrastructure so that they can be retrieved and displayed.
- GET_ROUTING_RESULTS — Returns the carrier and routing outcomes produced by a completed or in-progress carrier selection run, allowing callers to consume the selected carrier, service level, and associated routing data.
Tables Accessed
The package interacts with four documented tables via APPS synonyms. FTE_SEL_RULES stores the carrier selection rule definitions, while FTE_SEL_RULE_RESTRICTIONS holds the restriction criteria that qualify when each rule applies. FTE_SEL_SEARCH_ENTITIES_TMP is a temporary working table populated with the entities (deliveries or trips) to be evaluated; the package's temporary entity record and table types mirror the structure of this staging table. PLITBLM is the standard Oracle PL/SQL temporary table used for passing PL/SQL index-by tables to and from SQL, and is typically employed here to move arrays of IDs and messages between procedural and SQL layers.
Usage Notes
FTE_ACS_PKG is ordinarily invoked indirectly rather than called directly by end users. In a standard EBS 12.1.1 or 12.2.2 environment, it is driven by the transportation execution flows that determine carrier assignment for outbound and inbound shipments, and by any forms or concurrent programs that trigger or refresh carrier selection. Because it is classified as OTHER and is referenced by three other packages, customizations should avoid modifying it in place; instead, developers should call its documented procedures (START_ACS, LOG_CS_MESSAGES, GET_ROUTING_RESULTS) or wrap them from custom code. Note that the package name uses the FTE_ACS prefix, which is sometimes colloquially associated with the "gplp entities" search term referring to global trade and entity-level rule evaluation; there is no separate GPLP entity object here — entity processing is handled through the temporary entity structures and FTE_SEL_SEARCH_ENTITIES_TMP documented above.
-
PACKAGE: APPS.FTE_ACS_PKG 12.2.2
-
PACKAGE: APPS.FTE_ACS_PKG 12.1.1
-
SYNONYM: APPS.FTE_SEL_RULES 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: APPS.FTE_SEL_RULES 12.1.1
-
PACKAGE: APPS.FTE_ACS_PKG 12.1.1
-
PACKAGE: APPS.FTE_ACS_PKG 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.2.2
-
12.2.2 DBA Data 12.2.2
-
SYNONYM: PUBLIC.PLITBLM 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1