Results for “default_uom_code”

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

Overview

AMS_METRICS_INFO_V is a reportable and queryable view owned by the APPS schema within the Oracle E-Business Suite Marketing (AMS) product family. It exposes configuration and definitional metadata about marketing metrics — the measurable business indicators (for example response rates, revenue, campaign costs) that Oracle Marketing uses to evaluate campaigns, marketing activities, and related objects. Rather than a transactional entity, the view is a presentation layer that denormalizes metric definitions and resolves several foreign-key references into human-readable meanings, making it well suited for reporting, integration extracts, and ad hoc analysis.

The view combines data from the metric base tables with descriptive category and lookup information so that consumers do not need to join to ancillary reference objects themselves. Its definition status is VALID and the object is available in both EBS 12.1.1 and 12.2.2 under the same APPS schema namespace.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, AMS_METRICS_INFO_V is defined over the following referenced base objects:

• AMS_METRICS_ALL_B (SYNONYM) — the base table holding the core metric records; supplies most columns such as METRIC_ID, METRICS_NAME, SENSITIVE_DATA_FLAG, FORMULA, AC varied, and so on.
• AMS_METRICS_ALL_TL (SYNONYM) — the translated table supplying language-dependent attributes, notably the DESCRIPTION.
• AMS_CATEGORIES_VL (VIEW) — a category view joined twice (aliases C1 and C2) to resolve METRIC_CATEGORY and METRIC_SUB_CATEGORY into displayable category names.
• AMS_LOOKUPS (VIEW) — a lookup view joined on LOOKUP_TYPE = 'AMS_METRIC_VALUE_TYPE' to translate VALUE_TYPE into its meaning.

The base view text selects from AMS_METRICS_VL (the combined base/translation view) as B, with outer and inner joins to the category and lookup sources. The ROW_ID column is generated from B.ROWID to provide a stable row identifier for tooling such as Oracle Forms or integration adapters.

Key Columns

• METRIC_ID — primary identifier of the metric; used as the join key to other AMS metric-related objects.
• METRICS_NAME — the user-facing name of the metric.
• SENSITIVE_DATA_FLAG — indicates whether the metric is classified as sensitive; consumers should honor this flag when surfacing data.
• METRIC_CATEGORY_MEANING / METRIC_SUB_CATEGORY_MEANING — resolved category names for the metric's category and sub-category.
• VALUE_TYPE_MEANING — the decoded value type from the AMS_METRIC_VALUE_TYPE lookup.
• FORMULA, FUNCTION_NAME, ACCRUAL_TYPE, DEFAULT_UOM_CODE, UOM_TYPE — calculation and unit-of-measure definitions.
• ENABLED_FLAG — whether the metric is active.
• OBJECT_VERSION_NUMBER — optimistic locking/versioning column.
• Standard audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

A frequent requirement is to enumerate available metrics with their decoded categories and value types for reporting or integration mapping:

• SELECT METRIC_ID, METRICS_NAME, METRIC_CATEGORY_MEANING, VALUE_TYPE_MEANING FROM AMS_METRICS_INFO_V WHERE ENABLED_FLAG = 'Y';
• Filtering by sensitivity: ... WHERE SENSITIVE_DATA_FLAG = 'Y'; to audit which metrics are flagged sensitive.
• Driving pick-lists or validation sets in custom concurrent programs and OAF pages.