Search Results trail_slash

Overview

APPS.FND_WEB_CONFIG is an Oracle E-Business Suite PL/SQL configuration package that centralizes the resolution of web-tier connectivity parameters used throughout the EBS application. Its principal responsibility is to translate the value of the APPS_WEB_AGENT profile option, together with its HELP-mode and JSP-mode counterparts, into discrete URL components such as protocol, host, port, and Database Access Descriptor (DAD). The package is declared AUTHID CURRENT_USER and carries a header revision of 115.12, reflecting its long-standing role as a foundational utility rather than a business-process API. In practice, FND_WEB_CONFIG functions as an indirection layer: forms, concurrent programs, servlet bridges, and framework resources call it instead of hard-coding the deployment web agent string, so that administrators can relocate or reconfigure the middle tier through profile maintenance alone. The package is classified under ETRM as OTHER, and it is referenced by 69 other packages within the EBS schema—an indicator of how broadly its accessor functions are consumed across the technology stack, including the FND framework, Help system, and generic web-enabled components. The user-search term apps_web_agent corresponds directly to the profile option this package reads and parses.

Key Procedures and Functions

The documented package exposes nine callable units, each returning a single VARCHAR2 value or status:

• PLSQL_AGENT — Returns the name (URL) of the PL/SQL web agent, derived from the APPS_WEB_AGENT profile, guaranteeing a trailing slash. Accepts a help_mode argument that determines whether the HELP web agent override is consulted.
• WEB_SERVER — Extracts and returns the web server machine portion of the URL, that is, protocol, host, and port, with a guaranteed trailing slash.
• DAD — Returns just the Database Access Descriptor component of the configured web agent URL, again with a guaranteed trailing slash.
• GFM_AGENT — Resolves the agent string associated with the Generic File Manager (GFM) mechanism.
• PROTOCOL — Returns the protocol component (for example, http or https) parsed from the web agent configuration.
• TRAIL_SLASH — A normalization helper that ensures a supplied or derived string terminates in a single forward slash.
• DATABASE_ID — Reports the identifier of the database instance, used to disambiguate connectivity context.
• JSP_AGENT — Returns the Java Server Page (JSP) agent URL, the counterpart to the PL/SQL agent for Java-based content.
• CHECK_ENABLED — Verifies whether the relevant web configuration mechanism is enabled, allowing callers to branch safely before attempting URL construction.

Per the package comments, all accessor functions return NULL and post an error message to the message stack upon failure; the caller is explicitly responsible for displaying or clearing that message.

Tables Accessed

Three documented objects are referenced via APPS synonyms. FND_ENABLED_PLSQL is consulted to determine whether PL/SQL web agent functionality is enabled, supporting CHECK_ENABLED. OWA_UTIL is the Oracle Web Agent utility package, used for HTTP-environment inspection and URL-related processing. V$INSTANCE supplies the database instance identity backing DATABASE_ID. Primary configuration values are drawn from profile options rather than tables, so this package is predominantly a read-only resolver.

Usage Notes

FND_WEB_CONFIG is invoked from Oracle Forms through the FND framework, from concurrent programs and PL/SQL libraries, and from custom code requiring a deployment-correct web URL. Typical calls include fnd_web_config.web_server for building hyperlinks and fnd_web_config.plsql_agent or jsp_agent for agent-specific URLs. Because results depend on profile option state, callers should check CHECK_ENABLED and handle NULL returns and message-stack errors appropriately.