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:
- SERVICE_ID — the surrogate primary key, enforced by the JTF_XML_SERVICES_B_PK constraint. This is the value users reference when searching for "jtf_xml_services_b_pk".
- SERVICE_GROUP_ID — foreign key to JTF_XML_SVC_GROUPS_B, grouping individual services into logical collections.
- SERVICE_NAME — the internal identifier used to resolve the service at runtime.
- ENABLE_FLAG — controls whether the service is active or disabled.
- EXE_PERMISSION and VIEW_PERMISSION — permission tokens governing execution and visibility of the service.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, tying the row to EBS security-group scoping.
- END_DATE — effective-dating attribute marking service expiry.
- OBJECT_VERSION_NUMBER — optimistic locking column used by the OAF/BC4J framework.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns.
- ZD_EDITION_NAME — editioning column introduced in 12.2 for online patching support, forming part of the unique business-key index JTF_XML_SERVICES_B_U1 (SERVICE_ID, ZD_EDITION_NAME).
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.
-
Table that stores services.
-
Table that stores services.
-
View: JTF_XML_SERVICES_VL 12.2.2
View that stores services info.
Not implemented in this database·Explore JTF module →
-
Table: JTF_XML_SERVICES_TL 12.1.1
Table that stores services.
Not implemented in this database·Explore JTF module →
-
Table: JTF_XML_SERVICES_TL 12.2.2
Table that stores services.
Not implemented in this database·Explore JTF module →
-
View: JTF_XML_SERVICES_VL 12.1.1
View that stores services info.
Not implemented in this database·Explore JTF module →
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel