Search Results jtf_xml_inv_services_b_pk

Overview

JTF_XML_INV_SERVICES_B is a core configuration and metadata table within the JTF — CRM Foundation product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It resides in the JTF schema and stores the definitions of XML-based invocation services consumed by the CRM Foundation integration framework. Each row represents a single invocation service, capturing the application it belongs to, its service and group naming, message encoding expectations, timeout thresholds, and authorization context. As the base (B) table in a translated pair, it holds language-independent attributes while JTF_XML_INV_SERVICES_TL supplies the translatable descriptions.

From a Data Vault modeling perspective, the ETRM metadata classifies this table as hub-leaning. This reflects its role as a stable, uniquely-keyed registry of business entities (invocation services) referenced by multiple dependent tables. The surrogate primary key is enforced by JTF_XML_INV_SERVICES_B_PK on INV_SERVICE_ID, and a business-key candidate is provided by the unique index JTF_XML_INV_SERVICES_B_U1 on (INV_SERVICE_ID, ZD_EDITION_NAME), which also confirms the table's participation in the Online Patching edition-based redefinition model introduced in 12.2.

Key Information Stored

The table contains seventeen documented columns. The most operationally significant are:

• INV_SERVICE_ID — surrogate primary key (JTF_XML_INV_SERVICES_B_PK) uniquely identifying each invocation service; also the join key for all dependent tables.
• INV_NAME — business name of the invocation service.
• APPLICATION_ID — foreign key to FND_APPLICATION, identifying the owning product/application.
• SERVICE_GROUP_NAME — logical grouping used to organize related services.
• SERVICE_NAME — technical service identifier invoked by the framework.
• MESSAGE_ENCODING — expected character/transport encoding for message payloads.
• TIMEOUT — maximum wait threshold for the invocation.
• AUTH_ID — foreign key to JTF_XML_INV_AUTHS, linking the service to its authorization definition.
• END_DATE — effective end date supporting soft retirement of a service.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS for multi-tenant data isolation.
• OBJECT_VERSION_NUMBER — optimistic locking control.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns.
• ZD_EDITION_NAME — edition identifier supporting 12.2 Online Patching; part of the unique business-key index.

The surrogate key (INV_SERVICE_ID) should be distinguished from the composite business-key candidate defined by JTF_XML_INV_SERVICES_B_U1, which combines INV_SERVICE_ID with ZD_EDITION_NAME.

Common Use Cases and Queries

Typical uses include auditing active invocation services per application, diagnosing timeout or encoding mismatches, and driving integration reporting. A representative query joining the owning application and authorization definition:

• SELECT s.INV_SERVICE_ID, s.INV_NAME, s.SERVICE_NAME, s.TIMEOUT, a.APPLICATION_SHORT_NAME FROM JTF.JTF_XML_INV_SERVICES_B s JOIN FND_APPLICATION a ON a.APPLICATION_ID = s.APPLICATION_ID WHERE s.ZD_EDITION_NAME = 'SET1' AND (s.END_DATE IS NULL OR s.END_DATE > SYSDATE);
• Parameter inventory: join JTF_XML_INV_PARAMS on INV_SERVICE_ID to list arguments per service.
• Translation reporting: join JTF_XML_INV_SERVICES_TL on INV_SERVICE_ID for localized descriptions.
• Authorization review: join JTF_XML_INV_AUTHS on AUTH_ID to inspect security context.

Related Objects

• JTF_XML_INV_SERVICES_TL — translated (language-dependent) attributes; join on INV_SERVICE_ID.
• JTF_XML_INV_PARAMS — invocation parameters; join on INV_SERVICE_ID.
• JTF_XML_EVENT_MAPPINGS — event-to-service mappings; join on INV_SERVICE_ID.
• JTF_XML_INV_TMAPPINGS — team/type mappings; join on INV_SERVICE_ID.
• JTF_XML_INV_AUTHS — authorization definitions referenced via AUTH_ID.
• FND_APPLICATION — owning application referenced via APPLICATION_ID.
• FND_SECURITY_GROUPS — security grouping referenced via SECURITY_GROUP_ID.