Results for “jtf_xml_services_vl”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_XML_SERVICES_VL is a CRM Foundation (JTF) view in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores and exposes XML service registration information. It is a "_VL" (view with translation) object, meaning it joins the base table holding service definition attributes with the corresponding translation table that supplies language-specific descriptive text. The view presents one row per registered XML service for the session's current language, returned by the USERENV('LANG') predicate. In the context of Oracle EBS reporting and integration, this view acts as the read interface for the service registry used by the JTF XML Services framework, which supports web services and XML message routing across CRM modules.

Note that the ETRM metadata records this view as "Not implemented in this database." This indicates the object exists in the ETRM definition set but is not physically present in the specific environment catalogued. In an actual EBS instance the underlying tables JTF_XML_SERVICES_B and JTF_XML_SERVICES_TL would normally be seeded by the CRM Foundation installation.

Underlying Base Objects

The view is defined over two base tables:

  • JTF_XML_SERVICES_B — the base (non-translated) table storing service operational attributes such as SERVICE_ID, SERVICE_GROUP_ID, SERVICE_NAME, ENABLE_FLAG, permission flags, and the standard WHO columns.
  • JTF_XML_SERVICES_TL — the translation table supplying the DESCRIPTION column matched to the user's language.

These are joined on SERVICE_ID, with the additional language filter T.LANGUAGE = USERENV('LANG'). Alias B denotes the base table and T the translation table. All columns prefixed with B come from the base table; DESCRIPTION is the only column sourced from the translation table.

Key Columns

  • SERVICE_ID — primary identifier for the XML service; the join key between the two underlying tables.
  • SERVICE_NAME — the internal name of the registered service, used for programmatic lookup.
  • SERVICE_GROUP_ID — groups related services into logical categories for administration and routing.
  • ENABLE_FLAG — indicates whether the service is active and available for invocation.
  • EXE_PERMISSION / VIEW_PERMISSION — permission attributes governing execution and visibility of the service.
  • DESCRIPTION — language-specific descriptive text from the TL table.
  • END_DATE — effective end date of the service registration.
  • SECURITY_GROUP_ID — the security group (operating unit) context for multi-org security.
  • OBJECT_VERSION_NUMBER — optimistic locking column used by the underlying entity.
  • ROW_ID — the physical ROWID of the base table row, exposed for direct reference.
  • WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN for audit.

Common Use Cases and Queries

A frequent requirement is listing all currently enabled XML services along with their translated descriptions for a given language:

  • SELECT SERVICE_ID, SERVICE_NAME, DESCRIPTION, ENABLE_FLAG FROM JTF_XML_SERVICES_VL WHERE ENABLE_FLAG = 'Y';
  • Filtering by service group for administrative reporting: ... WHERE SERVICE_GROUP_ID = :p_group_id;
  • Auditing recent changes: SELECT SERVICE_NAME, LAST_UPDATE_DATE, LAST_UPDATED_BY FROM JTF_XML_SERVICES_VL ORDER BY LAST_UPDATE_DATE DESC;

Because the view already applies the language filter, callers do not need to add a language predicate themselves; the returned DESCRIPTION matches the session language. This makes it suitable for concurrent program reports, CRM integration diagnostics, and lookup queries within custom XML service tooling.

Users searching for "Trommler Service" may encounter this view while investigating custom or third-party service registrations, since externally named services are typically catalogued in this registry.