Search Results ar_cmgt_dnb_elements_b_u1




Overview
Explore in AI Chat

Overview

The AR.AR_CMGT_DNB_ELEMENTS_B table is a Credit Management configuration and metadata object within the Oracle Receivables (AR) schema. It defines the intersection between where Dun & Bradstreet (D&B) Global Data Product report data is physically stored and how that data is retrieved for presentation in Oracle Credit Management. Each D&B report contains numerous data points that are rendered in the case folder of a customer under credit review. The table establishes the mapping contract between a Credit Management DATA_ELEMENT_ID and the physical D&B source location, expressed through SOURCE_TABLE_NAME and SOURCE_COLUMN_NAME. In this sense it functions as a registry of resolvable data elements, enabling the Credit Management engine to locate, format, and display third-party credit attributes without hardcoding source references.

The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10 and is owned by the AR schema. Heuristic Data Vault classification mined from the foreign key structure is satellite-leaning, which suggests the object is best modeled as a descriptive satellite attached to a hub or link (for example, a D&B data element hub), rather than as an independent business key container. The ZD_EDITION_NAME column further indicates edition-based redefinition (EBR) support in Oracle EBS 12.2.2, allowing online patching of the object across editions.

Key Information Stored

The primary key of the table is AR_CMGT_DNB_ELEMENTS_B_PK, defined on DATA_ELEMENT_ID. A unique index, AR_CMGT_DNB_ELEMENTS_B_U1, is defined on the composite of DATA_ELEMENT_ID and ZD_EDITION_NAME. Because the edition column is appended to the unique key, the true business-key candidate under EBR is the pair, while DATA_ELEMENT_ID alone serves as the logical surrogate identifier.

  • DATA_ELEMENT_ID – Numeric (15) identifier of the D&B data element; primary key and principal join key.
  • SCORABLE_FLAG – Indicates whether the data point can participate in credit scoring rules.
  • SOURCE_TABLE_NAME – Name of the D&B table that stores the source key (60 characters).
  • SOURCE_COLUMN_NAME – Column within the source table that contains the source key (240 characters), enabling dynamic lookup.
  • RETURN_DATE_FORMAT – Format mask applied when the data element returns a date value.
  • RETURN_DATA_TYPE – Declares the datatype expected for the returned value, driving presentation logic.
  • APPLICATION_ID – Foreign key to FND_APPLICATION, identifying the owning application context.
  • ZD_EDITION_NAME – EBR edition discriminator for online patching.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO audit columns tracking row provenance and change history.

Common Use Cases and Queries

Typical usage involves resolving a Credit Management case folder data element to its D&B source location, or reporting on which D&B attributes are configured as scorable. Analysts frequently query the unique index columns when troubleshooting AR_CMGT_DNB_ELEMENTS_B_U1 uniqueness violations during upgrades or data loads.

Resolve a data element to its source:

  • SELECT data_element_id, source_table_name, source_column_name, return_data_type, return_date_format FROM ar.ar_cmgt_dnb_elements_b WHERE data_element_id = :p_element_id;

List scorable elements for scoring-rule configuration:

  • SELECT data_element_id, scorable_flag FROM ar.ar_cmgt_dnb_elements_b WHERE scorable_flag = 'Y';

Join to the application for reporting context:

  • SELECT e.data_element_id, a.application_name FROM ar.ar_cmgt_dnb_elements_b e, fnd_application a WHERE e.application_id = a.application_id;

These queries support case-folder rendering diagnostics, credit score model audits, and D&B attribute inventory reporting.

Related Objects

The following objects are most significant in relation to AR_CMGT_DNB_ELEMENTS_B:

  • FND_APPLICATION – Referenced via APPLICATION_ID; supplies the owning application name.
  • AR_CMGT_DNB_ELEMENTS_TL – The translated (language) companion table, joined by DATA_ELEMENT_ID, supplying display names and descriptions.
  • AR_CMGT_DNB_ELEMENTS_B_PK – Primary key constraint on DATA_ELEMENT_ID.
  • AR_CMGT_DNB_ELEMENTS_B_U1 – Unique index on DATA_ELEMENT_ID and ZD_EDITION_NAME.
  • FND_USER – Referenced indirectly through the CREATED_BY and LAST_UPDATED_BY WHO columns.
  • FND_LOGINS – Referenced through LAST_UPDATE_LOGIN.
  • D&B source tables – Dynamically referenced at runtime by the values held in SOURCE_TABLE_NAME and SOURCE_COLUMN_NAME.
  • Oracle Credit Management case folder APIs – Consume the element metadata to render data points for a customer under credit review.