Results for “editable_flag”
50+ 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:
- TEMPLATE_ATTRIBUTE_ID — the surrogate primary key, enforced by the
AMS_PROD_TEMPLATE_ATTR_PKconstraint. This is the column users most often search for. - TEMPLATE_ID — identifies the parent product template to which the attribute configuration belongs; the principal grouping column for reporting.
- ATTRIBUTE_CODE — the inventory attribute being configured (for example, an item descriptive or control attribute).
- PARENT_ATTRIBUTE_CODE and PARENT_SELECT_ALL — support hierarchical or dependent attribute selection, allowing child attributes to be governed by a parent selection.
- DEFAULT_FLAG — indicates whether the attribute defaults into the template configuration.
- EDITABLE_FLAG — controls whether the attribute can be modified by the end user in OMO.
- HIDE_FLAG — suppresses the attribute from display.
- SECURITY_GROUP_ID — references
FND_SECURITY_GROUPS, enforcing multi-org/security-group data isolation. - ZD_EDITION_NAME — the editioning column introduced in 12.2 online patching; it participates with TEMPLATE_ATTRIBUTE_ID in the unique index
AMS_PROD_TEMPLATE_ATTR_U1, the business-key candidate. - Standard WHO/audit columns: LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.
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 byTEMPLATE_ID. - Security-group scoped extracts joined to
FND_SECURITY_GROUPSfor 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_IDto 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_BYandCREATED_BY.
-
This table stores the Oracle Inventory attributes which can be configured using OMO UI.
-
This table stores the Oracle Inventory attributes which can be configured using OMO UI.
-
Stores schedule information for each lane. This is the main catalog entity for schedules
-
Stores schedule information for each lane. This is the main catalog entity for schedules
-
Stores services catalog lane descriptions.
-
Stores services catalog lane descriptions.
-
VIEW: FTE.FTE_LANES# 12.2.2
-
VIEW: FTE.FTE_SCHEDULES# 12.2.2
-
VIEW: FTE.FTE_SCHEDULES# 12.2.2
-
VIEW: FTE.FTE_LANES# 12.2.2
-
TABLE: FTE.FTE_SCHEDULES 12.2.2
-
TABLE: FTE.FTE_SCHEDULES 12.1.1
-
TABLE: FTE.FTE_LANES 12.2.2
-
TABLE: MSC.MSC_HZ_UI_LINES 12.1.1
-
TABLE: MSC.MSC_HZ_UI_LINES 12.2.2
-
TABLE: FTE.FTE_LANES 12.1.1
-
PACKAGE: APPS.FTE_LANE_PKG 12.2.2
-
PACKAGE: APPS.FTE_LANE_PKG 12.1.1
-
PACKAGE: APPS.FTE_TL_LOADER 12.1.1