Search Results as_script_questions




Overview
Explore in AI Chat

Overview

The AS_SCRIPT_QUESTIONS table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation (AS) module. It serves as the master repository for defining individual questions that constitute a sales or marketing script. These scripts are typically managed within the Oracle Sales application to guide sales representatives through structured customer interactions, such as telemarketing campaigns or sales presentations. The table's primary role is to store the definitional metadata for each question, including its sequence, text, and relationship to a parent script. This enables the systematic presentation of questions and the subsequent capture of answers during a sales call or activity.

Key Information Stored

The table's structure is designed to manage the hierarchical and sequential nature of scripted questionnaires. The most critical columns include the SCRIPT_QUESTION_ID, which serves as the unique primary key identifier for each question record. The SCRIPT_ID is a foreign key that links the question to its parent script definition, typically housed in the AS_PROMOTIONS_ALL table. The QUESTION_SEQ column is vital for enforcing the correct order in which questions are presented to the user. While the exact column list is not fully detailed in the provided metadata, based on its purpose, the table would also be expected to store the QUESTION_TEXT itself, data type indicators for the expected answer (e.g., text, number, date), and flags controlling question behavior, such as whether an answer is mandatory.

Common Use Cases and Queries

A primary use case involves generating or auditing the complete list of questions for a specific sales script. For instance, an administrator may need to review the sequence and content of questions in a campaign. A typical query would join AS_SCRIPT_QUESTIONS to AS_PROMOTIONS_ALL to retrieve the script name and its associated questions in the correct order.

  • Retrieve all questions for a script: SELECT question_seq, question_text FROM osm.as_script_questions WHERE script_id = :script_id ORDER BY question_seq;
  • Audit script structure: SELECT p.name, q.question_seq, q.question_text FROM osm.as_promotions_all p, osm.as_script_questions q WHERE p.script_id = q.script_id ORDER BY p.name, q.question_seq;

This table is also fundamental to the runtime operation of the Sales application, as it provides the question framework for the user interface where sales representatives input customer responses, which are then stored in related tables like AS_SCRIPT_ACTUAL_ANSWERS.

Related Objects

The AS_SCRIPT_QUESTIONS table is centrally connected to several other key objects in the Sales Foundation schema, as documented by its foreign key relationships.

  • AS_PROMOTIONS_ALL: This table is referenced by AS_SCRIPT_QUESTIONS.SCRIPT_ID. It is the master table for promotion and script headers, establishing the parent-child relationship where a script contains many questions.
  • AS_SCRIPT_ACTUAL_ANSWERS: This table references AS_SCRIPT_QUESTIONS via AS_SCRIPT_ACTUAL_ANSWERS.QUESTION_ID. It stores the actual responses provided by sales representatives or customers for each specific question instance during a sales interaction.
  • AS_SCRIPT_PRE_DEFINED_ANSWERS: This table references AS_SCRIPT_QUESTIONS via AS_SCRIPT_PRE_DEFINED_ANSWERS.QUESTION_ID. It holds a list of valid, pre-defined answer choices (e.g., from a drop-down list) for questions that require a selection from a set list, enforcing data integrity and consistency in responses.