Search Results ams_prod_template_attr_pk

Overview

The AMS_PROD_TEMPLATE_ATTR table is a core data object within the Oracle E-Business Suite (EBS) Marketing (AMS) module, specifically in versions 12.1.1 and 12.2.2. It functions as a repository for configurable Oracle Inventory item attributes. Its primary role is to support the Oracle Marketing Online (OMO) user interface, enabling marketers to define and manage product-related attribute templates. These templates are essential for structuring and standardizing product information used in marketing campaigns, promotions, and collateral, ensuring data consistency between inventory management and marketing operations.

Key Information Stored

The table's central purpose is to map and store attribute definitions for marketing product templates. While the full column list is proprietary, the documented primary key, TEMPLATE_ATTRIBUTE_ID, is the unique identifier for each configurable attribute record. Based on its description, the table likely contains columns that define the relationship between a marketing template and specific Inventory item attributes, such as:

• TEMPLATE_ATTRIBUTE_ID: The primary key, a unique sequence number for each attribute entry.
• TEMPLATE_ID: A foreign key linking to the parent product template definition.
• INVENTORY_ATTRIBUTE: The code or identifier of the specific Inventory item attribute being configured (e.g., descriptive flexfield context, item category).
• Columns controlling attribute behavior in the OMO UI, such as display order, mandatory flag, and default values.
• Standard Oracle EBS audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN).

Common Use Cases and Queries

This table is primarily accessed during the setup and rendering of product templates within OMO. Common operational and reporting scenarios include auditing template configurations and troubleshooting UI behavior. A typical query would involve joining to the parent template table to list all attributes for a specific template.

Sample Query: Retrieving the configured attributes for a known template.

SELECT template_attribute_id, inventory_attribute
FROM ams_prod_template_attr
WHERE template_id = :p_template_id
ORDER BY display_sequence; -- Assuming a column like DISPLAY_SEQUENCE exists

Use Case: Identifying which Inventory attributes are mandatory for marketers to complete when creating a new promotional item via an OMO template, ensuring critical product data is captured.

Related Objects

AMS_PROD_TEMPLATE_ATTR is part of a larger data model for marketing product templates. Key related objects include:

• Primary Key Constraint: AMS_PROD_TEMPLATE_ATTR_PK on TEMPLATE_ATTRIBUTE_ID.
• Parent Template Table: A table named similarly to AMS_PROD_TEMPLATE_B (likely the base table), which holds the master definition of the product template. The TEMPLATE_ID in this table is a foreign key to that parent.
• OMO UI Application Modules: The Oracle Forms or OA Framework pages that provide the interface for configuring these attributes, which query and update this table.
• Oracle Inventory (INV) Tables: Tables such as MTL_SYSTEM_ITEMS_B or descriptive flexfield definitions, which hold the master definitions of the attributes referenced in this table.