Results for “xdp_adapter_types_b”

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

Overview

XDP_ADAPTER_TYPES_B is a core configuration table within the XDP (Provisioning) module of Oracle E-Business Suite, valid in both 12.1.1 and 12.2.2. It stores all seeded and user-defined Adapter Types used by the provisioning framework to define how the application communicates with external systems, gateways, and network elements. Each row describes the behavioral characteristics and constraints of an adapter — for example, whether it requires a connection, whether inbound messaging is mandatory, and how command-line execution should be handled. In ETRM terms, the table acts as the master definition list for adapter technology, and downstream registration and audit tables reference it by adapter type.

From a Data Vault modeling perspective, the metadata's heuristic classification places this object as hub-leaning. This suggests it functions naturally as a hub of unique adapter-type business keys, with descriptive and flag-based attributes behaving like satellite content. This classification is a modeling suggestion and not an enforced physical construct in EBS.

Key Information Stored

The table contains 17 documented columns. The most significant are:

• ADAPTER_TYPE — The primary key (XDP_ADAPTER_TYPES_PK), a business-meaningful identifier for each adapter (e.g., a specific gateway or protocol).
• BASE_ADAPTER_TYPE — Self-referencing foreign key enabling inheritance from a parent adapter type.
• ADAPTER_CLASS — The implementation class that carries out the adapter's runtime behavior.
• APPLICATION_MODE — Defines how the adapter integrates (e.g., inbound, outbound, or bidirectional).
• INBOUND_REQUIRED_FLAG — Indicates whether inbound processing is mandatory for the adapter.
• CONNECTION_REQUIRED_FLAG — Indicates whether an active connection is required at runtime.
• MAX_BUFFER_SIZE — Buffer capacity used in message or stream handling.
• CMD_LINE_OPTIONS / CMD_LINE_ARGS — Command-line configuration for externally invoked adapters.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling multi-tenant visibility.
• OBJECT_VERSION_NUMBER — Optimistic locking column for concurrent updates.
• ZD_EDITION_NAME — Editioning column supporting online patching (12.2.x).

The unique index XDP_ADAPTER_TYPES_U1 on (ADAPTER_TYPE, ZD_EDITION_NAME) is the business-key candidate, distinguishing it from the surrogate primary key. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) track change history.

Common Use Cases and Queries

Typical usage includes reviewing which adapters require a live connection, tracing adapter inheritance hierarchies, and auditing registered versus seeded adapters.

• List connection-required adapters:
  SELECT ADAPTER_TYPE, ADAPTER_CLASS FROM XDP_ADAPTER_TYPES_B WHERE CONNECTION_REQUIRED_FLAG = 'Y';
• Find child adapters by base type:
  SELECT ADAPTER_TYPE, BASE_ADAPTER_TYPE FROM XDP_ADAPTER_TYPES_B WHERE BASE_ADAPTER_TYPE IS NOT NULL;
• Join translations for multilingual reporting using XDP_ADAPTER_TYPES_TL on ADAPTER_TYPE.
• Cross-reference registrations via XDP_ADAPTER_REG.ADAPTER_TYPE for deployment reporting.

Related Objects

• XDP_ADAPTER_REG — Registers adapters; joins on ADAPTER_TYPE.
• XDP_ADAPTER_AUDIT — Audit trail of adapter activity; joins on ADAPTER_TYPE.
• XDP_ADAPTER_TYPES_TL — Translated names/descriptions; joins on ADAPTER_TYPE.
• XDP_ADAPTER_TYPE_ATTRS_B — Attribute definitions per adapter type; joins on ADAPTER_TYPE.
• XDP_FE_SW_GEN_LOOKUP — Lookup values that reference adapter types; joins on ADAPTER_TYPE.
• XDP_ADAPTER_TYPES_B (self-reference) — Parent/child inheritance via BASE_ADAPTER_TYPE.
• FND_SECURITY_GROUPS — Security group definition referenced by SECURITY_GROUP_ID.