Search Results ams_iba_ps_rl_st_params




Overview
Explore in AI Chat

Overview

AMS_IBA_PS_RL_ST_PARAMS is a Marketing (AMS) module table in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores the resolved parameter values associated with strategy rules used by the Interactive Business Analysis (IBA) Personalization and Segmentation engine. Each row represents a single named parameter and its assigned value for a given rule strategy, allowing the marketing rule engine to retrieve the operative configuration (thresholds, target values, codes, and similar attributes) that drive rule evaluation when segments or lists are processed.

The table is owned by the AMS schema and is documented as VALID in the ETRM object registry. Its physical model comprises eleven columns and two supporting indexes: the primary key index AMS_IBA_PS_RL_ST_PARAMS_PK on RULE_STRAT_PARAM_ID, and the unique business-key index AMS_IBA_PS_RL_ST_PARAMS_U1 on the composite of RULEGROUP_ID and RULE_STRAT_PARAM_ID. Under a heuristic Data Vault classification mined from the foreign-key structure, the table is satellite-leaning: it hangs off a parent rule group entity and records descriptive, time-stamped attribute values rather than acting as an independent hub or a pure associative link. This classification should be treated as a modeling suggestion rather than a defined architectural standard.

Key Information Stored

The table's most significant columns fall into three groups: identity, business association, and payload.

  • RULE_STRAT_PARAM_ID — the surrogate primary key, uniquely identifying each strategy parameter row. It is the column enforced by AMS_IBA_PS_RL_ST_PARAMS_PK.
  • RULEGROUP_ID — foreign key to AMS_IBA_PS_RULEGRPS_B, tying the parameter to its owning rule group or strategy definition. This column also participates in the unique business key AMS_IBA_PS_RL_ST_PARAMS_U1.
  • PARAMETER_NAME — the identifier of the parameter being set (for example, a strategy attribute or rule operand name).
  • PARAMETER_VALUE — the value assigned to that parameter, stored as the operative datum the rule engine consumes.
  • SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, enforcing multi-org and data-security partitioning of the parameter rows.
  • OBJECT_VERSION_NUMBER — the optimistic locking column used by the OAF/ADF framework to detect concurrent updates.
  • CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard WHO audit columns recording row provenance, creation, and most recent modification.

The composite unique index on RULEGROUP_ID and RULE_STRAT_PARAM_ID confirms that a parameter is scoped to a rule group, which is the practical business key for lookups.

Common Use Cases and Queries

Typical uses include auditing how a strategy is configured, diagnosing why a rule fired or failed to fire, and migrating parameter sets between environments.

  • Retrieving all parameters for a rule group: SELECT PARAMETER_NAME, PARAMETER_VALUE FROM AMS.AMS_IBA_PS_RL_ST_PARAMS WHERE RULEGROUP_ID = :rulegroup_id;
  • Locating a specific parameter value: SELECT RULE_STRAT_PARAM_ID, PARAMETER_VALUE FROM AMS.AMS_IBA_PS_RL_ST_PARAMS WHERE PARAMETER_NAME = :name AND RULEGROUP_ID = :rulegroup_id;
  • Joining to the parent rule group to report strategy names alongside parameter values, using RULEGROUP_ID as the join key.
  • Security-scoped reporting that restricts results by SECURITY_GROUP_ID when multi-org or group security is enabled.
  • Change auditing via CREATION_DATE and LAST_UPDATE_DATE to trace when parameter values were introduced or modified.

Related Objects

The following objects are directly related through documented keys and the surrounding IBA strategy model.

  • AMS_IBA_PS_RULEGRPS_B — parent rule group table; joined on AMS_IBA_PS_RL_ST_PARAMS.RULEGROUP_ID = AMS_IBA_PS_RULEGRPS_B.RULEGROUP_ID.
  • FND_SECURITY_GROUPS — security group reference; joined on SECURITY_GROUP_ID to enforce data partitioning.
  • AMS_IBA_PS_RL_ST_PARAMS_PK / _U1 — the primary key and unique indexes that enforce row identity and the (RULEGROUP_ID, RULE_STRAT_PARAM_ID) business key.
  • AMS_IBA_PS_RULEGRPS_TL — the translated rule group table, useful for reporting strategy names and descriptions alongside parameters.
  • AMS_IBA_PS_RULES_B and related rule definition tables — the parent rule entities whose strategies reference these parameter values.
  • FND_USER — referenced indirectly through CREATED_BY and LAST_UPDATED_BY for attribution in audit queries.