Search Results ams_iba_ps_rules




Overview
Explore in AI Chat

Overview

AMS_IBA_PS_RULES is a transactional configuration table in the Oracle E-Business Suite Marketing (AMS) module. It stores the individual rule conditions that belong to a rule group defined in AMS_IBA_PS_RULEGRPS_B. In the Oracle Marketing Intelligence/Business Assistant (IBA) framework, rule groups aggregate one or more rules, and each rule is bound to a posting and a strategy. This table therefore acts as the junction that ties a rule condition to the campaign strategy and the posting (placement or offer) against which the rule is evaluated at runtime. The object resides in the AMS schema and is marked VALID in the ETRM 12.2.2 registry.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying AMS_IBA_PS_RULES as a link. Its three foreign keys (RULEGROUP_ID, POSTING_ID, STRATEGY_ID) connect independent business entities, which is characteristic of a link table rather than a pure hub or satellite. The CLAUSEVALUE1 through CLAUSEVALUE10 columns carry descriptive rule-condition payload, giving the row some satellite-like attributes as well.

Key Information Stored

The table is documented with 29 columns in ETRM 12.2.2. The most operationally significant columns are:

The unique index AMS_IBA_PS_RULES_U1 is defined on (POSTING_ID, RULEGROUP_ID, RULE_ID) and represents the business-key candidate: within a given posting and rule group, RULE_ID is unique. The surrogate RULE_ID alone is not the business key in this composite sense.

Common Use Cases and Queries

Typical usage is to resolve which rule conditions apply to a posting/strategy combination, and to report on rule priority and clause configuration.

  • Retrieving all rules for a rule group: 
    SELECT r.rule_id, r.posting_id, r.strategy_id,
       r.exec_priority, r.bus_priority_code
FROM   ams.ams_iba_ps_rules r
WHERE  r.rulegroup_id = :p_rulegroup_id
ORDER  BY r.exec_priority;
  • Joining to the parent rule group and posting to build a rule-condition report: 
    SELECT g.rulegroup_name, p.posting_name,
       r.clausevalue1, r.clausevalue2
FROM   ams.ams_iba_ps_rules r,
       ams.ams_iba_ps_rulegrps_b g,
       ams.ams_iba_ps_postings_b p
WHERE  r.rulegroup_id = g.rulegroup_id
AND    r.posting_id   = p.posting_id;
  • Locating active clause values only (respecting the USE_CLAUSE flags) for a strategy evaluation.
  • Reconciliation reports verifying that every rule group has at least one rule and that EXEC_PRIORITY sequences are contiguous.

Related Objects

The following objects are directly related through documented foreign keys or primary-key relationships:

  • AMS_IBA_PS_RULEGRPS_B — referenced via AMS_IBA_PS_RULES.RULEGROUP_ID; the parent rule group header.
  • AMS_IBA_PS_POSTINGS_B — referenced via AMS_IBA_PS_RULES.POSTING_ID; defines the posting context.
  • AMS_IBA_PS_STRATS_B — referenced via AMS_IBA_PS_RULES.STRATEGY_ID; defines the strategy context.
  • FND_SECURITY_GROUPS — referenced via AMS_IBA_PS_RULES.SECURITY_GROUP_ID; enforces security partitioning.
  • AMS_IBA_PS_RULES_PK — the primary key constraint/index on RULE_ID.
  • AMS_IBA_PS_RULES_U1 — the unique index on (POSTING_ID, RULEGROUP_ID, RULE_ID), the business-key candidate.

Together these objects form the rule-condition layer of the AMS Marketing IBA configuration model, linking strategies and postings to rule groups through prioritized, clause-driven conditions.