Search Results message_encoding




Overview
Explore in AI Chat

Overview

The JTF_XML_INV_SERVICES_VL view is a CRM Foundation (JTF) object in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores invocation information for XML-based services registered within the E-Business Suite integration framework. In the ETRM metadata, the object is described simply as a "View that stores invocation info." Functionally, it exposes the configuration attributes required to invoke an external or internal XML service — including the service name, owning application, message encoding, timeout, and authentication reference — alongside the translated descriptive text for each service.

The _VL suffix indicates a "view with language" (translated) construct. This pattern is standard in EBS: a base (_B) table holds language-independent columns, a translation (_TL) table holds the language-specific description, and the _VL view joins the two while filtering on the session language via USERENV('LANG'). The view therefore presents a single, session-appropriate row per invocation service, which is convenient for both runtime lookup and reporting.

Underlying Base Objects

The ETRM metadata lists no separately documented base objects, but the view text itself identifies the two tables it is defined over:

The join condition is B.INV_SERVICE_ID = T.INV_SERVICE_ID. The view selects B.ROWID as ROW_ID, which allows the view to be treated as updateable/identifiable for certain EBS framework purposes. Because the translation filter restricts rows to the session language, the visible row set depends on the value of USERENV('LANG'). Note that the ETRM record states "Not implemented in this database," meaning the object was documented in the reference repository but not materialized in the specific instance from which the metadata was captured.

Key Columns

  • ROW_ID — the ROWID of the base table row, used to uniquely identify a service record.
  • INV_SERVICE_ID — primary identifier linking the base and translated records.
  • INV_NAME — the internal name of the invocation service.
  • APPLICATION_ID — the owning Oracle application (FK to FND_APPLICATION).
  • SERVICE_GROUP_NAME and SERVICE_NAME — the grouping and logical name used to locate the service at runtime.
  • MESSAGE_ENCODING — the character encoding applied to the XML message payload. This is the column most relevant to the searched term "message_encoding"; it governs how the request/response payload is serialized (for example UTF-8 or similar), and misconfiguration can produce malformed XML or textual corruption in service calls.
  • TIMEOUT — the maximum wait interval for the invocation.
  • AUTH_ID — reference to the authentication credential used by the service.
  • END_DATE — effective end date of the record.
  • SECURITY_GROUP_ID — multi-tenant/security grouping identifier.
  • OBJECT_VERSION_NUMBER — optimistic locking version.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns.
  • DESCRIPTION — translated description sourced from the _TL table.

Common Use Cases and Queries

The view is typically queried to audit service registrations, verify encoding and timeout settings, and confirm the owning application. A representative query is:

  • SELECT INV_SERVICE_ID, INV_NAME, APPLICATION_ID, SERVICE_GROUP_NAME, SERVICE_NAME, MESSAGE_ENCODING, TIMEOUT FROM JTF_XML_INV_SERVICES_VL WHERE UPPER(INV_NAME) LIKE '%XML%';
  • SELECT INV_NAME, SERVICE_NAME, MESSAGE_ENCODING FROM JTF_XML_INV_SERVICES_VL ORDER BY INV_NAME; — useful for spotting inconsistent MESSAGE_ENCODING values.
  • SELECT SERVICE_GROUP_NAME, COUNT(*) FROM JTF_XML_INV_SERVICES_VL GROUP BY SERVICE_GROUP_NAME;

Because the view filters on USERENV('LANG'), queries executed from different session language settings may return differing DESCRIPTION text; joins to FND_APPLICATION on APPLICATION_ID are common to resolve the application short name.