Search Results script_pre_def_answer_id




Overview
Explore in AI Chat

Overview

The OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Oracle Scripting module (part of Oracle TeleSales). It serves as the master definition table for all possible answer choices associated with questions in a telemarketing or survey script. Its primary role is to define the answer options presented to a script user (e.g., a sales agent) during an interaction, enabling structured data capture and controlling the logical flow to subsequent questions based on the selected answer.

Key Information Stored

The table stores both the definition and control logic for script answers. The most critical columns include the primary key, SCRIPT_PRE_DEF_ANSWER_ID, which uniquely identifies each predefined answer record. The QUESTION_ID links the answer to its parent question in the AS_SCRIPT_QUESTIONS table, while SCRIPT_ID ties it to the overarching promotion or script in AS_PROMOTIONS_ALL. The LABEL and ANSWER columns hold the text of the answer option displayed to the user. Control logic is managed via ENABLED_FLAG (to activate/deactivate the answer), QUESTION_SEQ (the sequence of the question), and NEXT_QUESTION_SEQ (which dictates the next question sequence to present, enabling branching). The table also includes standard EBS WHO columns (CREATED_BY, LAST_UPDATE_DATE, etc.) and 15 descriptive flexfield attribute columns for custom extensions.

Common Use Cases and Queries

This table is central to script execution, reporting on answer popularity, and troubleshooting script flow. A common operational query retrieves all active answers for a specific script to validate configuration:

  • SELECT LABEL, ANSWER, QUESTION_SEQ, NEXT_QUESTION_SEQ FROM OSM.AS_SCRIPT_PRE_DEFINED_ANSWERS WHERE SCRIPT_ID = :script_id AND ENABLED_FLAG = 'Y' ORDER BY QUESTION_SEQ;

For auditing or analyzing answer usage, a join with the actual answers table is typical:

Technical support often queries this table to diagnose missing or incorrect answer options by verifying the foreign key relationships to questions and scripts.

Related Objects

The table maintains integral relationships with other Scripting module objects, as defined by its foreign key constraints. It references two key parent tables:

  • AS_SCRIPT_QUESTIONS via the QUESTION_ID column. This defines the question to which this answer belongs.
  • AS_PROMOTIONS_ALL via the SCRIPT_ID column. This links the answer to the master script definition.

Furthermore, it is referenced as a parent table by two critical transactional tables:

  • AS_SCRIPT_ACTUAL_ANSWERS.PRE_DEF_ANSWER_ID references this table. This stores the specific instance of an answer chosen during a live script interaction.
  • AS_SCRIPT_ANSWER_ACTIONS_ALL.PRE_DEF_ANSWER_ID references this table. This links predefined answers to subsequent business actions or tasks that are triggered upon selection.