Results for “ams_web_plce_ctype_assoc”

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

Overview

AMS_WEB_PLCE_CTYPE_ASSOC is a Marketing (AMS) module table within the Oracle E-Business Suite, documented as VALID in the AMS schema across releases 12.1.1 and 12.2.2. The table stores the association between web placements and their default content types, functioning as a configuration bridge that determines which content type is served by default for a given placement in web marketing and iStore-facing placement scenarios. Placements in AMS define where marketing content may appear; the content type association determines the rendering default applied to that placement.

Heuristically, the mined foreign key structure suggests a satellite-leaning Data Vault classification. The table carries its own surrogate key and descriptive attributes while referencing several parent entities, so it is best modeled as a satellite attached to the placement hub, with dependent references to stylesheet and security group dimensions. This classification is a modeling suggestion derived from the FK topology rather than a documented Data Vault design.

Key Information Stored

The documented physical schema contains 28 columns. The most significant are:

• PLACEMENT_CTYPE_ID — the surrogate primary key (constraint AWC_PK) and also the single-column unique index AMS_WEB_PLCE_CTYPE_ASSOC_U1, making it the primary business-key candidate for row identification.
• PLACEMENT_ID — foreign key to AMS_WEB_PLACEMENTS_B, identifying the placement to which the content type association applies.
• CONTENT_TYPE_CODE — the content type code assigned as the default for the placement.
• STYLESHEET_ID and STYLESHEET_VER_ID — foreign key and version reference to AMS_IBA_PL_STYLESHTS_B, defining the stylesheet applied when the content is rendered.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org and security-group scoping of the association.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the underlying AOL/ADF framework during concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard WHO columns providing audit lineage.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard Oracle EBS descriptive flexfield (DFF) column set for extensibility.

Common Use Cases and Queries

Typical usage centers on resolving the default content type and stylesheet for a placement. A common join pattern is:

• Join to AMS_WEB_PLACEMENTS_B on PLACEMENT_ID = PLACEMENT_ID to retrieve placement names and context.
• Join to AMS_IBA_PL_STYLESHTS_B on STYLESHEET_ID to retrieve stylesheet metadata for rendering diagnostics.
• Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to filter associations visible to a given security context.

A representative query retrieves the default content type for each placement:

SELECT a.PLACEMENT_CTYPE_ID, a.PLACEMENT_ID, a.CONTENT_TYPE_CODE, a.STYLESHEET_ID
FROM AMS.AMS_WEB_PLCE_CTYPE_ASSOC a, AMS.AMS_WEB_PLACEMENTS_B p
WHERE a.PLACEMENT_ID = p.PLACEMENT_ID;

Reporting use cases include auditing which content types are configured per placement, identifying placements lacking a default content type, validating stylesheet assignments, and troubleshooting rendering mismatches in web marketing campaigns. Because the table is satellite-leaning, change history and audit reporting should also consult the WHO columns and OBJECT_VERSION_NUMBER.

Related Objects

The following objects reference or are referenced by AMS_WEB_PLCE_CTYPE_ASSOC through documented foreign keys:

• AMS_WEB_PLACEMENTS_B — parent placement entity via PLACEMENT_ID.
• AMS_IBA_PL_STYLESHTS_B — stylesheet definition via STYLESHEET_ID.
• FND_SECURITY_GROUPS — security grouping via SECURITY_GROUP_ID.
• AMS_WEB_PLACEMENTS_TL — translated placement names, commonly joined through the placement base table.
• FND_OBJECTS / FND_APPLICATION — framework metadata that governs the AMS schema objects and concurrent programs that maintain this table.
• AMS_WEB_PLCE_CTYPE_ASSOC_U1 — the unique index enforcing business-key uniqueness on PLACEMENT_CTYPE_ID.

Because the AMS web marketing placement model is closely tied to iStore rendering, integration and extension work should treat this table as the authoritative mapping between placement and default content type, and should preserve the surrogate key relationship when replicating or migrating placement configuration across environments.