Results for “display_sequence_no”

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

Overview

AMS_CPAG_ANSWERS_B is the base (language-independent) table within the Oracle E-Business Suite Marketing (AMS) module that stores the set of possible or predefined answers associated with marketing questionnaire questions. It sits underneath the campaign and dialog management feature set, where questionnaires are presented to respondents and their selections are captured for later analysis, segmentation, and lead qualification.

In Oracle EBS 12.1.1 and 12.2.2 the object is owned by the AMS schema and is reported as VALID. It holds possible answers for marketing questionnaire questions, meaning each row defines one selectable response option belonging to a parent question. Because the table separates the answer definition from the answer text, it follows the standard Oracle EBS multilingual pattern: the transactional or definitional rows live in the _B table, while translated, user-facing text lives in the corresponding _TL table (AMS_CPAG_ANSWERS_TL).

From a data-modeling perspective, the ETRM metadata classifies this table heuristically as hub-leaning in a Data Vault sense. That classification reflects its role as a durable, relatively stable catalog of business entities (answers) identified by a surrogate key, rather than a high-velocity transactional link. Treating AMS_CPAG_ANSWERS_B as a hub candidate is a reasonable modeling suggestion where the answer definitions act as reference entities referenced by response capture tables.

Key Information Stored

The table is documented with 15 physical columns. The following are the most significant for understanding and querying the data:

• ANSWER_ID — the surrogate primary key of the table (AMS_CPAG_ANSWERS_B_PK) and also the column for the unique index AMS_CPAG_ANSWERS_B_U1. It uniquely identifies each possible answer.
• QUESTION_ID — a foreign key to AMS_CPAG_QUESTIONS_B, linking each answer to its parent questionnaire question.
• TYPE — indicates the answer type or classification, governing how the answer is presented or interpreted.
• DISPLAY_SEQUENCE_NO — controls the ordering in which answers appear relative to one another for a given question.
• HTML_PARAM_NAME — the HTML form parameter name used when the answer is rendered and submitted through a web-based questionnaire.
• LOOKUP_CODE — a reference into the Oracle EBS lookup mechanism, enabling standardized coding of answers.
• WEIGHT — a numeric weighting applied to the answer, commonly used for scoring or assessment logic.
• WEIGHT_DIM_ID — identifies the weighting dimension associated with the answer, allowing weighted scoring across different dimensions.
• SECURITY_GROUP_ID — a foreign key to FND_SECURITY_GROUPS, supporting multi-organization / security-group access partitioning.
• OBJECT_VERSION_NUMBER — the standard EBS optimistic locking column used to detect concurrent updates.

The audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN — follow the standard EBS WHO-column convention and are present but not otherwise distinctive. Notably, ANSWER_ID serves simultaneously as the surrogate primary key and as the unique business-key candidate documented through AMS_CPAG_ANSWERS_B_U1.

Common Use Cases and Queries

The primary practical use of AMS_CPAG_ANSWERS_B is resolving the list of selectable answers for a questionnaire question and joining those answers to respondent selections. A typical listing query orders answers by display sequence for a specific question:

SELECT a.answer_id, a.question_id, a.type,
       a.display_sequence_no, a.weight
  FROM ams.ams_cpag_answers_b a
 WHERE a.question_id = :p_question_id
 ORDER BY a.display_sequence_no;

To retrieve the human-readable answer label, join to the translation table:

SELECT a.answer_id, t.answer_text
  FROM ams.ams_cpag_answers_b a,
       ams.ams_cpag_answers_tl t
 WHERE a.answer_id = t.answer_id
   AND t.language = USERENV('LANG')
   AND a.question_id = :p_question_id;

Reporting scenarios include analyzing weighted responses, measuring answer frequency across respondents by joining AMS_CPAG_DLG_RESPONS_B on ANSWER_ID, and exporting questionnaire catalogs for campaign design. Because SECURITY_GROUP_ID participates in access control, queries executed under a specific security context may need to filter accordingly.

Related Objects

• AMS_CPAG_QUESTIONS_B — parent table of questions; joined via AMS_CPAG_ANSWERS_B.QUESTION_ID = AMS_CPAG_QUESTIONS_B.QUESTION_ID.
• AMS_CPAG_ANSWERS_TL — translation table holding language-specific answer text; references this table via AMS_CPAG_ANSWERS_TL.ANSWER_ID = AMS_CPAG_ANSWERS_B.ANSWER_ID.
• AMS_CPAG_DLG_RESPONS_B — response capture table recording respondent selections; references this table via AMS_CPAG_DLG_RESPONS_B.ANSWER_ID = AMS_CPAG_ANSWERS_B.ANSWER_ID.
• FND_SECURITY_GROUPS — referenced by AMS_CPAG_ANSWERS_B.SECURITY_GROUP_ID, providing the security-group partitioning context.

Together these objects form the questionnaire definition and response-capture chain within the AMS Marketing module: questions define the prompt, AMS_CPAG_ANSWERS_B and its translation table define the selectable options, and AMS_CPAG_DLG_RESPONS_B records which options respondents actually chose.