Search Results wsh_fte_enabled




Overview
Explore in AI Chat

Overview

The PL/SQL package body APPS.WSH_FTE_ENABLED is a shipped Oracle E-Business Suite database object owned by the APPS schema. Its API classification in the ETRM metadata is listed as OTHER, and the object is documented with a status of VALID in both the 12.1.1 and 12.2.2 releases. The name prefix WSH identifies the package as belonging to the Oracle Shipping (Warehouse Shipping) product family, while the FTE component indicates its association with the "Freight Tax Engine" or freight-related enablement logic used within the shipping execution architecture.

Conceptually, the package serves as a lightweight utility that exposes an enablement or status check for the shipping freight functionality. Rather than performing heavy transactional work, it functions in a supporting role: other Shipping modules, concurrent programs, and forms call into it to determine whether a given freight feature is currently active before executing downstream logic. This pattern is common in EBS, where configuration flags control whether specific shipping and freight-processing paths are exercised at runtime.

Key Procedures and Functions

The ETRM documentation records a single documented program unit within this package body: CHECK_STATUS.

  • CHECK_STATUS — This is the sole documented procedure or function exposed by WSH_FTE_ENABLED. As its name implies, it evaluates and returns the enablement/status state relevant to the freight feature governed by this package. The metadata does not publish a parameter list, so no argument signature is asserted here. In practice, callers consult CHECK_STATUS to branch their processing — for example, to decide whether to proceed with freight-related validation or to skip it when the feature is disabled.

No other procedures or functions are enumerated in the documentation for this object; the total documented unit count is one.

Tables Accessed

The ETRM metadata for APPS.WSH_FTE_ENABLED does not list any base tables referenced through APPS synonyms. This is consistent with the object's role as a status/enablement checker: rather than reading or writing application transaction tables directly, it likely derives its result from package-level constants or lightweight configuration. Where persistent state is consulted, it would be accessed through the Shipping product's own dependent objects rather than through direct table references recorded at the package level. Because no table dependencies are documented, integrators should not assume this package performs any DML against Shipping tables.

Usage Notes

The dependency section of the metadata shows that WSH_FTE_ENABLED references several supporting objects, notably FND_MSG_PUB (the standard Oracle Application Object Library message publication utility), WSH_DEBUG_INTERFACE, and WSH_DEBUG_SV (Shipping debug/logging facilities), along with STANDARD. The presence of FND_MSG_PUB and the WSH debug packages indicates that CHECK_STATUS follows Oracle's standard error-handling and diagnostics conventions, raising or logging messages through the shared message dictionary rather than hardcoding text.

  • The ETRM record states that WSH_FTE_ENABLED is not referenced by any database object, meaning no other stored PL/SQL object in the EBS data dictionary declares a dependency on it. This suggests it is invoked dynamically from client-side code such as Oracle Forms, OAF pages, or concurrent program logic rather than statically from other server packages.
  • The package is referenced by one other package according to the 12.2.2 documentation, confirming it participates in the Shipping dependency graph as a provider of status information rather than as a consumer of transactional APIs.
  • Because it is a seeded APPS object, customizations should not attempt to modify WSH_FTE_ENABLED directly; instead, custom code should call CHECK_STATUS to honor the same enablement decision used by standard Shipping flows.

In summary, APPS.WSH_FTE_ENABLED is a small, focused helper package whose single documented entry point, CHECK_STATUS, provides standardized freight-enablement evaluation for the Oracle Shipping module in EBS 12.1.1 and 12.2.2.