Search Results xdo_ds_elements_b

Overview

The XDO_DS_DEFINITIONS_B table is a core repository object within the XML Publisher (XDO) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It serves as the master definition table for registered data sources, which are fundamental to the XML Publisher reporting engine. A data source in this context is formally defined by an XML Schema Definition (XSD), which describes the structure and data types of the XML data that will be populated into report templates. This table acts as the central registry, storing the metadata for each data source, enabling XML Publisher to validate, process, and merge data with RTF, PDF, Excel, or eText templates during report generation.

Key Information Stored

The table stores the essential metadata that uniquely identifies and describes a data source within the EBS instance. While the full column list is proprietary, the documented primary key structure reveals the most critical fields. The composite primary key (XDO_DS_DEFINITIONS_B_PK) consists of APPLICATION_SHORT_NAME and DATA_SOURCE_CODE. The APPLICATION_SHORT_NAME ties the data source to a specific EBS product or module (e.g., AR, PO, GL), enforcing modularity and security. The DATA_SOURCE_CODE is the unique identifier for the data source definition within that application. Other columns typically store the associated XSD schema itself, display names, descriptions, and creation metadata (created by, creation date, last updated by).

Common Use Cases and Queries

This table is primarily queried for diagnostic, administrative, and integration purposes. Common scenarios include identifying all data sources registered for a specific application, troubleshooting missing data source errors during report submission, or auditing custom data source deployments. A fundamental query retrieves the list of defined data sources:

• SELECT APPLICATION_SHORT_NAME, DATA_SOURCE_CODE FROM XDO.XDO_DS_DEFINITIONS_B WHERE APPLICATION_SHORT_NAME = 'PO' ORDER BY DATA_SOURCE_CODE;

Another critical use case involves joining with the related XDO_DS_ELEMENTS_B table to analyze the full structure of a data source, verifying that all expected elements and parameters are defined. Developers and DBAs may also query this table to understand dependencies before patching or migrating XML Publisher objects between environments.

Related Objects

The XDO_DS_DEFINITIONS_B table has a direct and essential relationship with the XDO_DS_ELEMENTS_B table, as indicated in the documentation. While XDO_DS_DEFINITIONS_B stores the header definition, XDO_DS_ELEMENTS_B stores the detailed element and attribute definitions (columns, parameters, groups) that constitute the data source's XSD structure. This table is also a parent to other XML Publisher repository tables, such as XDO_DS_DEFINITIONS_TL for translated names and likely XDO_TEMPLATES_B and XDO_LOBS, which link templates to a specific data source. Access is typically managed through public XML Publisher administrative APIs rather than direct DML operations.