Search Results ar_cmgt_scorable_data_points_v




Overview
Explore in AI Chat

Overview

AR_CMGT_SCORABLE_DATA_POINTS_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Receivables (AR) product family and specifically to the Credit Management (CMGT) subsystem, which supports customer credit scoring, risk assessment, and the collection of external credit data. The view exposes the complete set of "scorable" data points — that is, those attributes that may be fed into a scoring model or credit rule engine. Its role is to present a single, consolidated, read-only interface through which credit management scoring engines, concurrent programs, and external integrations can enumerate the data elements available for evaluation without needing to query the underlying multilingual base objects directly. Because it filters on the SCORABLE_FLAG and unions two distinct data sources, the view abstracts the distinction between internally derived scoring attributes and Dun & Bradstreet (D&B) supplied credit elements.

Underlying Base Objects

According to the documented ETRM metadata, the view is defined over two referenced base objects, both of which are themselves views in the APPS schema:

The view text is a UNION of two SELECT statements. The first selects from AR_CMGT_DATA_POINTS_VL where SCORABLE_FLAG = 'Y', while the second selects from AR_CMGT_DNB_ELEMENTS_VL where SCORABLE_FLAG = 'Y'. This design normalizes two structurally similar but semantically distinct sources into one uniform result set. The VL suffix on both base objects indicates multilingual support, meaning description columns (such as data point or element names) are resolved according to the session language.

Key Columns

The view exposes eight columns, aligned across both branches of the UNION:

  • DATA_POINT_ID — unique identifier for the data point or D&B element.
  • DATA_POINT_NAME — display name of the scorable attribute.
  • DATA_POINT_CATEGORY — category grouping; for rows sourced from the D&B branch this is hard-coded to the literal value 'DNB'.
  • APPLICATION_ID — owning application identifier, used to determine the source application context.
  • RETURN_DATA_TYPE — datatype returned when the data point is evaluated (for example, numeric, character, or date).
  • RETURN_DATE_FORMAT — format mask applied when the return type is a date.
  • DATA_POINT_CODE — internal code for the data point; NULL for D&B-sourced rows.
  • FUNCTION_NAME — the name of the PL/SQL function invoked to compute the value; NULL for D&B-sourced rows.

The asymmetry in the final two columns reflects the difference between internally computed data points (which require a function to derive their value) and externally supplied D&B elements (which are retrieved directly rather than calculated).

Common Use Cases and Queries

Typical uses include powering a credit scoring setup screen, validating which data points a scoring model can reference, and auditing the inventory of scorable attributes available to the Credit Management engine. A common query lists all scorable attributes grouped by category:

  • SELECT data_point_id, data_point_name, data_point_category, return_data_type FROM ar_cmgt_scorable_data_points_v ORDER BY data_point_category, data_point_name;
  • To isolate D&B-sourced elements only: SELECT data_point_id, data_point_name FROM ar_cmgt_scorable_data_points_v WHERE data_point_category = 'DNB';
  • To find function-backed data points: SELECT data_point_name, function_name FROM ar_cmgt_scorable_data_points_v WHERE function_name IS NOT NULL;

Because the view is read-only and pre-filtered on SCORABLE_FLAG = 'Y', consumers should not attempt DML against it; the underlying base views and their tables are the correct maintenance points. Queries should always constrain by DATA_POINT_CATEGORY or APPLICATION_ID when the intent is targeted, since the union returns the full scorable set across both internal and D&B sources. In summary, AR_CMGT_SCORABLE_DATA_POINTS_V provides a stable, language-aware, and scoring-oriented projection of Receivables credit management metadata suitable for both runtime scoring and administrative reporting.