Results for “ams_dm_score_apply_v”

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

Overview

AMS_DM_SCORE_APPLY_V is a database view owned by the APPS schema within the Oracle E-Business Suite Release 12.1.1 and 12.2.2 environment. It belongs to the AMS (Marketing) product family, which is part of the Oracle Marketing and Advanced Marketing applications supporting campaign management, lead generation, customer segmentation, and predictive scoring. The view is documented with a VALID status in the E-Business Suite Technical Reference Manual (ETRM).

According to the documented ETRM metadata, this is explicitly classified as a "dummy view." Its purpose is not to expose business data for transactional or analytical reporting, but rather to grant access to the ODM schema. ODM refers to Oracle Data Mining, the schema and technology embedded within the Oracle Database that enables in-database predictive modeling and scoring. Oracle Marketing leverages Oracle Data Mining to perform customer scoring, propensity modeling, and segmentation directly within the database. The view acts as a controlled access bridge permitting the APPS schema, and by extension its responsibilities and users, to reference or interact with objects in the ODM mining environment without requiring direct grants on underlying mining tables.

Underlying Base Objects

The view is defined over a single documented base object: DUAL, accessed through a synonym. DUAL is the well-known Oracle built-in single-row, single-column pseudo-table used for syntactic completeness in SELECT statements. The view text is documented as:

SELECT 1 DUMMY FROM DUAL

This definition confirms the dummy nature of the view. It contains no join logic, no reference to marketing campaign tables, no scoring model tables, and no actual Data Mining views such as those in the ODM schema. Instead, it returns a single constant value. The design intent is that the view functions as a placeholder or grant target: a lightweight object within the APPS schema that can be privileged to expose the ODM mining schema's functionality, while the actual mining objects reside under the ODM schema itself.

Key Columns

The view exposes exactly one column, as documented in the ETRM metadata:

• DUMMY — A numeric constant with a literal value of 1. The column name mirrors the conventional column name used in the DUAL pseudo-table. Because the view always returns the constant 1 rather than any data drawn from business tables, the column carries no business semantics and cannot be used to retrieve scoring results, model identifiers, or customer attributes.

No other columns are documented. There are no foreign key relationships to marketing entities, no descriptive attributes, and no measurable facts. Any consumer expecting scoring output, model scores, or prediction values from this view would find none; the actual scoring data is produced by Oracle Data Mining routines operating through the ODM schema.

Common Use Cases and Queries

The view is not intended as an end-user reporting source. Its realistic uses are administrative and procedural:

• Verifying existence and validity of the grant-bridge object in the APPS schema during ETRM-based auditing or impact analysis.
• Establishing privileges that enable Oracle Marketing components to invoke Oracle Data Mining functionality.
• Confirming the "dummy" implementation as documented, so that developers do not mistakenly build reports against it.

Representative queries include a simple existence check:

SELECT * FROM APPS.AMS_DM_SCORE_APPLY_V;

This returns a single row with DUMMY = 1. A metadata inspection query such as SELECT TEXT FROM ALL_VIEWS WHERE VIEW_NAME = 'AMS_DM_SCORE_APPLY_V' confirms the documented definition. Practically, users seeking marketing scoring results should query the appropriate Oracle Data Mining mining model views or AMS scoring tables, not this dummy view. Its role is infrastructural: it supports schema access for Oracle Data Mining integration rather than delivering reportable business content.