Results for “parent_select_all”

46 results




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

Overview

The AMS_PROD_TEMPLATE_ATTR table is an Oracle Marketing (AMS) application table that stores the Oracle Inventory attributes which can be configured through the Oracle Marketing Online (OMO) user interface. It belongs to the AMS schema and is classified as VALID in the EBS 12.1.1 / 12.2.2 data dictionary. Functionally, it acts as a configuration metadata repository: rather than storing transactional marketing or inventory data, it defines which item attributes are exposed, editable, or suppressed when a user works with a product template in OMO. This makes it central to the template-driven attribute model used to control item setup behaviour in Oracle Inventory integration scenarios.

From a Data Vault modeling perspective, the mined heuristic classification for this object is standalone. No parent hubs or link relationships were detected beyond the security group reference, which suggests the table behaves as an independent reference/configuration set. A modeler would therefore treat it as a satellite-like attribute store keyed on its own surrogate identifier, with the security group reference handled as a secondary descriptive relationship rather than a true business link.

Key Information Stored

The table contains 16 documented columns. The most significant are:

The distinction between the surrogate key (TEMPLATE_ATTRIBUTE_ID) and the unique business key (TEMPLATE_ATTRIBUTE_ID plus ZD_EDITION_NAME) reflects 12.2 editioning requirements; in 12.1.1 the editioning column does not exist.

Common Use Cases and Queries

Typical reporting retrieves the configured attributes for a given template, or audits which attributes are editable or hidden.

  • Attributes for a template: SELECT ATTRIBUTE_CODE, DEFAULT_FLAG, EDITABLE_FLAG, HIDE_FLAG FROM AMS.AMS_PROD_TEMPLATE_ATTR WHERE TEMPLATE_ID = :p_template_id AND SECURITY_GROUP_ID = :p_security_group;
  • Locating a specific configuration row: SELECT * FROM AMS.AMS_PROD_TEMPLATE_ATTR WHERE TEMPLATE_ATTRIBUTE_ID = :p_id;
  • Editable attribute inventory: filter on EDITABLE_FLAG = 'Y' grouped by TEMPLATE_ID.
  • Security-group scoped extracts joined to FND_SECURITY_GROUPS for multi-org validation.

Diagnostic queries commonly verify the editioning column, since missing ZD_EDITION_NAME predicates cause incorrect results post-upgrade to 12.2.

Related Objects

  • FND_SECURITY_GROUPS — referenced by SECURITY_GROUP_ID; the only documented foreign key.
  • AMS_PROD_TEMPLATE (implied parent) — joined on TEMPLATE_ID to resolve template names.
  • AMS_PROD_TEMPLATE_ATTR_PK and AMS_PROD_TEMPLATE_ATTR_U1 — the primary key and unique index constraints.
  • Oracle Inventory item attribute views/APIs (OMO) that consume the flag settings.
  • FND audit/WHO standard references for LAST_UPDATED_BY and CREATED_BY.