Results for “ams_iba_display_rules_pk”

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

Overview

AMS_IBA_DISPLAY_RULES is a table in the AMS (Marketing) schema of Oracle E-Business Suite, present and valid in both 12.1.1 and 12.2.2. According to the ETRM documentation, the table stores display rules content and context used for displaying advertisements in the store, and it is maintained by the i-marketing development team as part of the Oracle iStore / iMarketing advertising framework (the IBA prefix denotes Internet Business Advertising). The table functions as a configuration repository that governs how, where, and in what order advertising content is presented to end users browsing an online storefront.

The heuristic Data Vault classification mined from the foreign key structure is hub-leaning. This suggests that, from a modeling perspective, AMS_IBA_DISPLAY_RULES behaves primarily as a hub entity: it is identified by a single surrogate key, holds relatively stable descriptive attributes, and is referenced by multiple surrounding tables. Analysts building a dimensional or Data Vault layer may therefore treat it as a hub, with dependent attribute history and link relationships captured separately.

Key Information Stored

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

• DISPLAY_RULE_ID — the surrogate primary key, enforced by AMS_IBA_DISPLAY_RULES_PK and also covered by the unique index AMS_IBA_DISPLAY_RULES_U1. This is the column referenced by all downstream foreign keys.
• DISPLAY_CONTEXT — stores the context in which the display rule applies, determining the storefront location or rendering condition under which the associated advertising content is shown.
• RULESET_ID — associates the display rule with a parent rule set, grouping related display rules for coordinated evaluation.
• SORT_ORDER and SORT_BY_CODE — control sequencing of advertisements and the sort criterion applied when multiple items qualify for display.
• SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, providing multi-tenant or organizational data isolation consistent with Oracle EBS security group conventions.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates through the Oracle Application Framework.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS WHO columns capturing audit and provenance information.

The only documented unique business-key candidate is DISPLAY_RULE_ID itself; no alternate natural key is recorded in the ETRM metadata.

Common Use Cases and Queries

Typical uses include troubleshooting why a specific advertisement does or does not appear in a storefront region, auditing display rule configuration across security groups, and reporting on rule sets and their sequencing. A representative query joins the table to its security group parent:

• SELECT d.display_rule_id, d.display_context, d.sort_order, d.sort_by_code, d.ruleset_id FROM ams.ams_iba_display_rules d WHERE d.security_group_id = :p_security_group ORDER BY d.ruleset_id, d.sort_order;
• SELECT c.rule_id, d.display_rule_id, d.display_context FROM ams.ams_iba_campaign_rules c JOIN ams.ams_iba_display_rules d ON c.rule_id = d.display_rule_id WHERE c.campaign_id = :p_campaign;
• Reports listing posting attachments and their governing display rules by joining JTF_AMV_ATTACHMENTS on DISPLAY_RULE_ID.

Because the table is maintained by the i-marketing development team, customizations should be limited to read-only queries unless coordinated with Oracle Support.

Related Objects

• AMS_IBA_CAMPAIGN_RULES — references AMS_IBA_DISPLAY_RULES via AMS_IBA_CAMPAIGN_RULES.RULE_ID; links campaigns to display rules.
• JTF_AMV_ATTACHMENTS — references this table through DISPLAY_RULE_ID, tying media attachments to display rules.
• AMS_IBA_POSTINGS_B — references this table through DISPLAY_RULE_ID, connecting advertising postings to their display rules.
• FND_SECURITY_GROUPS — parent of SECURITY_GROUP_ID, providing the security grouping referenced by this table.
• AMS_IBA_DISPLAY_RULES_PK / AMS_IBA_DISPLAY_RULES_U1 — the primary key constraint and unique index enforcing identity on DISPLAY_RULE_ID.