Results for “strategy_description”

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

Overview

AMS_IBA_PS_STRATS_VL is a seeded, valid database view owned by the APPS schema and delivered as part of the Oracle Marketing (AMS) product family. Its documented purpose is to display pre-defined and custom strategies maintained within the Oracle Marketing application. The view presents strategy definition records in a language-aware format, resolving translatable name and description text against the runtime language of the session, and is therefore the principal read-only interface for reporting on and integrating with the strategy registry.

The "_VL" suffix follows standard Oracle EBS naming conventions, indicating a "view with translation joined" — the view combines the base (non-translatable) attributes of a strategy with its language-specific translation rows. In EBS 12.1.1 and 12.2.2, this object is catalogued in the ETRM (E-Business Suite Technical Reference Manual) as a VIEW with status VALID and is referenced in reporting, extracts, and integrations requiring strategy metadata. Because the translation join filters on USERENV('LANG'), the view returns exactly one row per strategy, in the language of the querying session, rather than one row per installed language.

Underlying Base Objects

The view is defined over two documented base objects, both exposed as synonyms in the APPS schema:

• AMS_IBA_PS_STRATS_B — the base table holding non-translatable strategy attributes such as identifiers, type codes, and DBA-level audit and concurrency columns.
• AMS_IBA_PS_STRATS_TL — the translation table holding STRATEGY_NAME and STRATEGY_DESCRIPTION per language.

The join condition is B.STRATEGY_ID = T.STRATEGY_ID AND T.LANGUAGE = USERENV('LANG'), which enforces a one-to-one relationship between the current-language translation row and its owning base record. This is the mechanism through which the view delivers a translated, single-row-per-strategy result set.

Key Columns

• ROW_ID — the ROWID of the base strategy row, exposing a stable physical address for the underlying record.
• STRATEGY_ID — primary identifier for the strategy; the join key between base and translation tables.
• STRATEGY_NAME — translatable display name, sourced from AMS_IBA_PS_STRATS_TL.
• STRATEGY_DESCRIPTION — the user-searched column; the translatable, long-text description of the strategy, sourced from the translation table.
• STRATEGY_TYPE, CONTENT_TYPE — classification codes identifying the strategy category and content behaviour.
• STRATEGY_REF_CODE, SELECTOR_CLASS — the reference code and the Java/implementation selector class that drive strategy execution logic.
• MAX_RETURNED — maximum number of results the strategy may return when executed.
• SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER — multi-org security and optimistic locking (Oll) columns.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns inherited from the base table.

Common Use Cases and Queries

The view is typically used to enumerate strategies, drive configuration reports, verify selector-class wiring, and feed external campaign or targeting toolkits.

Listing all strategies with their descriptions:

SELECT STRATEGY_ID,
       STRATEGY_NAME,
       STRATEGY_TYPE,
       STRATEGY_DESCRIPTION
FROM   APPS.AMS_IBA_PS_STRATS_VL
ORDER  BY STRATEGY_NAME;

Searching by the user-queried column:

SELECT STRATEGY_ID, STRATEGY_NAME, STRATEGY_DESCRIPTION
FROM   APPS.AMS_IBA_PS_STRATS_VL
WHERE  UPPER(STRATEGY_DESCRIPTION) LIKE UPPER('%&keyword%');

Auditing recently modified strategy definitions:

SELECT STRATEGY_ID, STRATEGY_NAME, LAST_UPDATED_BY, LAST_UPDATE_DATE
FROM   APPS.AMS_IBA_PS_STRATS_VL
WHERE  LAST_UPDATE_DATE >= SYSDATE - 30;

Because the view is language-filtered through USERENV('LANG'), callers cannot retrieve multiple translations in a single query; per-language reporting must query AMS_IBA_PS_STRATS_TL directly, joining to the base table for the non-translatable attributes.