Search Results xdp_adapter_type_attrs_b




Overview
Explore in AI Chat

Overview

The XDP_ADAPTER_TYPE_ATTRS_B table is a core data definition table within the Oracle E-Business Suite Provisioning (XDP) module. It functions as the master repository for defining the configurable attributes associated with both seeded and custom adapter types. An adapter in XDP is a software component responsible for executing specific provisioning tasks, such as interfacing with an external system or performing a data transformation. This table stores the metadata that defines the characteristics and default values for each attribute an adapter type can possess, enabling the flexible configuration and parameterization of provisioning workflows. Its role is foundational to the extensibility of the XDP framework.

Key Information Stored

The table's primary purpose is to store attribute definitions linked to specific adapter types. While the full column list is not detailed in the provided metadata, its structure is defined by a primary key and critical foreign keys. The ADAPTER_TYPE_ATTRS_ID column serves as the unique primary key identifier for each attribute record. The ADAPTER_TYPE column is a foreign key linking the attribute to its parent adapter type definition in the XDP_ADAPTER_TYPES_B table. Other columns would typically store the attribute's internal name, data type, whether it is mandatory, and its default value. This design allows administrators to define a set of required and optional parameters that must be supplied when an instance of an adapter is configured within a provisioning process.

Common Use Cases and Queries

A primary use case is the administration and audit of adapter configurations. System administrators or implementers query this table to understand what parameters are available for a given adapter, which is essential for setting up or troubleshooting provisioning services. Common reporting needs include listing all attributes for a specific adapter type or identifying attributes that lack default values. Sample query patterns include joining to the adapter types table for descriptive information:

  • Attribute Listing: SELECT a.ADAPTER_TYPE, b.ATTR_NAME, b.DATA_TYPE, b.DEFAULT_VALUE FROM XDP_ADAPTER_TYPE_ATTRS_B a, XDP_ADAPTER_TYPES_TL b WHERE a.ADAPTER_TYPE = b.ADAPTER_TYPE AND b.LANGUAGE = USERENV('LANG');
  • Adapter Configuration Audit: SELECT ADAPTER_TYPE, COUNT(*) AS ATTRIBUTE_COUNT FROM XDP_ADAPTER_TYPE_ATTRS_B GROUP BY ADAPTER_TYPE ORDER BY ADAPTER_TYPE;

Related Objects

The table exists within a well-defined hierarchy in the XDP schema. Its relationships, as documented, are as follows:

  • References (Foreign Key): The table references XDP_ADAPTER_TYPES_B via the ADAPTER_TYPE column. This ensures every attribute is associated with a valid, defined adapter type.
  • Referenced By (Primary Key): The table's primary key (ADAPTER_TYPE_ATTRS_ID) is referenced by the translation table XDP_ADAPTER_TYPE_ATTRS_TL. This related table stores the translated, user-facing names and descriptions for the attributes in multiple languages.

Therefore, a complete view of an adapter attribute's metadata requires joining the base table (XDP_ADAPTER_TYPE_ATTRS_B) with its translation table (XDP_ADAPTER_TYPE_ATTRS_TL) and the parent adapter type tables.