Search Results sys_ixmlagg




Overview
Explore in AI Chat

Overview

MDSYS.SDO_OLS_LOCUTL is a database package body belonging to the MDSYS schema, the Oracle Spatial and Graph owner. In the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this package supplies location-oriented utility routines used by the OpenLS (Open Location Services) stack. Its name reflects its role: an OpenLS locator utility layer. It builds and formats OpenLS 1.0 request payloads and resolves single-address geocoding requests, bridging EBS location-aware functionality to the underlying Spatial geocoder and address services.

The package body is reported as VALID and is classified under the generic API classification OTHER, indicating it is an internal support utility rather than a published EBS application programming interface. It depends on sibling MDSYS components including SDO_OLS, SDO_GCDR, SDO_GEO_ADDR, SDO_KEYWORDARRAY and SDO_UTIL, confirming that it does not implement geospatial logic itself but orchestrates these lower-level services.

Key Procedures and Functions

Two program units are documented in the package body metadata:

  • GEOCODESINGLEADR — Resolves a single address to a geographic location. It encapsulates the single-address geocoding path, relying on the Spatial geocoder and address model objects (SDO_GCDR, SDO_GEO_ADDR, SDO_KEYWORDARRAY) to interpret the input address and return the matched location. It is the functional entry point for one-off address-to-coordinate resolution.
  • MAKEOPENLS10REQUEST — Constructs an OpenLS 1.0 compliant request document. It assembles the request structure, including XML serialization, so that geocoding or location requests conform to the OpenLS 1.0 specification before being dispatched to the OpenLS service layer (OPENLSSERVICES).

Parameter lists are intentionally omitted here because the ETRM metadata does not expose argument signatures; only the purpose of each unit is documented.

Tables Accessed

The documented table and object references are XMLTYPE, DUAL, XMLAGG and XMLSEQUENCE. These are not application business tables but rather SQL/XML constructs and pseudo-objects:

  • XMLTYPE — represents the OpenLS request and response payloads as XML documents.
  • XMLAGG — aggregates XML fragments, used to assemble repeated or composite elements within an OpenLS 1.0 request.
  • XMLSEQUENCE — expands an XMLType into a set of rows for iterative processing of request or response content.
  • DUAL — the standard single-row source used to evaluate expressions and function calls in a SELECT context.

No EBS application tables (such as those in APPS) are read or written by this package; all data interaction is confined to XML structures and Spatial services.

Usage Notes

SDO_OLS_LOCUTL is an internal MDSYS utility and is not typically invoked directly by EBS forms or concurrent programs. It is called indirectly through the OpenLS and Spatial geocoding APIs exposed to EBS, and it is referenced by one other database package. Custom extensions that require OpenLS 1.0 request construction or single-address geocoding may call these units, but doing so creates a dependency on undocumented MDSYS internals. Because the package is owned by MDSYS and is not referenced by any EBS application object directly, upgrades to Spatial or the database may alter it without notice. The presence of SYS_IXMLAGG among its references explains why searches for "sys_ixmlagg" surface this object: XMLAGG-based aggregation resolves through SYS_IXMLAGG, tying this locator utility to the XML aggregation machinery.