Results for “xdp_adapter_type_attrs_b”

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

Overview

XDP_ADAPTER_TYPE_ATTRS_B is a provisioning-layer table in the Oracle E-Business Suite XDP (Provisioning) product. It stores the attribute definitions and their default values that belong to seeded and custom adapter types. Each row represents a single named attribute of a given adapter type, together with the initial value used when that attribute is applied during provisioning. Because adapter types describe the configurable behavior of integration endpoints, this table functions as the metadata backbone for adapter configuration: it defines which attributes exist for an adapter type and what their out-of-the-box defaults are.

The ETRM relationship data classifies this object heuristically as satellite-leaning. In Data Vault terms, it is best modeled as a descriptive satellite attached to a parent hub/link represented by XDP_ADAPTER_TYPES_B, since its rows carry attribute-level descriptive detail rather than independent business entities. This classification is a modeling suggestion only and does not reflect physical implementation in EBS.

Key Information Stored

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

• ADAPTER_TYPE_ATTRS_ID — surrogate primary key, enforced by XDP_ADAPTER_TYPE_ATTRS_B_PK. It uniquely identifies each attribute record and is the column referenced by the translation table.
• ADAPTER_TYPE — foreign key to XDP_ADAPTER_TYPES_B; identifies the adapter type to which the attribute belongs.
• ATTRIBUTE_NAME — the business name of the configurable attribute.
• DEFAULT_VALUE — the default value supplied for the attribute when it is applied.
• ZD_EDITION_NAME — editioning column supporting EBS online patching (12.2.x), participating in both unique indexes.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-tenant data segregation.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OA Framework and concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns, plus the login that performed the most recent change.

Two unique indexes are documented as business-key candidates. XDP_ADAPTER_TYPE_ATTRS_B_U1 covers ADAPTER_TYPE_ATTRS_ID and ZD_EDITION_NAME, effectively reinforcing the surrogate key under editioning. XDP_ADAPTER_TYPE_ATTRS_B_U2 covers ADAPTER_TYPE, ATTRIBUTE_NAME and ZD_EDITION_NAME, confirming that an adapter type may not repeat an attribute name within an edition — this composite is the true natural or business key.

Common Use Cases and Queries

Typical usage centers on discovering adapter types and their configurable attributes. A common query lists all attributes and defaults for a given adapter type:

• SELECT attribute_name, default_value FROM xdp_adapter_type_attrs_b WHERE adapter_type = :type AND zd_edition_name = :edition;
• Joining to XDP_ADAPTER_TYPES_B to resolve adapter type descriptions.
• Joining to XDP_ADAPTER_TYPE_ATTRS_TL to retrieve translated or displayed attribute prompts.
• Comparing seeded versus custom adapter configurations by counting attributes per adapter type.
• Reporting to identify attributes with null DEFAULT_VALUE, which require operator input at provisioning time.

Because the table is configuration metadata rather than transactional data, queries are predominantly read-only and are often executed during implementation, cloning validation, and troubleshooting of provisioning failures.

Related Objects

• XDP_ADAPTER_TYPES_B — parent table joined on ADAPTER_TYPE; supplies the adapter type definition.
• XDP_ADAPTER_TYPE_ATTRS_TL — translation table joined on ADAPTER_TYPE_ATTRS_ID; holds language-specific attribute text.
• FND_SECURITY_GROUPS — joined on SECURITY_GROUP_ID for multi-tenant security resolution.
• FND_APPLICATION / FND_LOOKUP_VALUES — frequently consulted to interpret adapter and attribute metadata.
• XDP provisioning APIs and OA Framework pages — consume these rows to render adapter configuration and to populate defaults during runtime.

Together these relationships make XDP_ADAPTER_TYPE_ATTRS_B the central definition point for adapter attributes and their defaults across seeded and custom adapter types.