Results for “jtf_xml_services_b”

37 results




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

Overview

JTF_XML_SERVICES_B is a base table in the JTF (CRM Foundation) schema of Oracle E-Business Suite, present and valid in both release 12.1.1 and 12.2.2. It stores the definition of XML-based services exposed by the CRM Foundation layer, forming the registry from which the application resolves callable service endpoints and their associated access permissions. The table follows the standard EBS "_B" convention: it holds language-independent, translatable data, while descriptive text resides in the companion translation table JTF_XML_SERVICES_TL.

From a heuristic Data Vault modeling perspective, the mined foreign-key structure classifies this object as satellite-leaning. It is anchored by a single-column surrogate primary key and carries descriptive and state attributes (name, flags, permissions, dates) that describe a business entity rather than merely resolving many-to-many relationships, which supports treating it as a satellite surrounding a service hub.

Key Information Stored

The table documents 15 columns. The most operationally significant are:

The unique index JTF_XML_SERVICES_B_U1 is the documented business-key candidate; SERVICE_ID alone serves as the surrogate primary key.

Common Use Cases and Queries

Typical scenarios include auditing which services are enabled, resolving permission assignments, and tracing service membership within groups. A representative lookup by primary key:

  • SELECT SERVICE_ID, SERVICE_NAME, ENABLE_FLAG FROM JTF.JTF_XML_SERVICES_B WHERE SERVICE_ID = :p_service_id;
  • Listing active services joined to their translations: SELECT b.SERVICE_ID, t.SERVICE_NAME FROM JTF_XML_SERVICES_B b, JTF_XML_SERVICES_TL t WHERE b.SERVICE_ID = t.SERVICE_ID AND b.ENABLE_FLAG = 'Y';
  • Grouping services by category: SELECT g.GROUP_NAME, COUNT(*) FROM JTF_XML_SERVICES_B b, JTF_XML_SVC_GROUPS_B g WHERE b.SERVICE_GROUP_ID = g.SERVICE_GROUP_ID GROUP BY g.GROUP_NAME;

These queries support security reviews, patch impact analysis, and configuration reporting.

Related Objects

  • JTF_XML_SERVICES_TL — translation table joined on SERVICE_ID, holding language-specific service names and descriptions.
  • JTF_XML_SVC_GROUPS_B — parent group table referenced through SERVICE_GROUP_ID.
  • FND_SECURITY_GROUPS — security group reference via SECURITY_GROUP_ID.
  • JTF_XML_SERVICES_B_PK — the primary key constraint on SERVICE_ID.
  • JTF_XML_SERVICES_B_U1 — the unique index on (SERVICE_ID, ZD_EDITION_NAME) used for editioning.

Together these objects define the service registry and its dependent relationships within CRM Foundation.