Search Results script_actual_answer_id

Overview

The AS_SCRIPT_ACTUAL_ANSWERS table is a core data repository within the Oracle E-Business Suite Sales Foundation module (AS). Its primary function is to persistently store the specific answers provided by users during script execution in the Oracle Sales application. This table is essential for capturing the transactional outcome of scripted interactions, such as sales calls or customer surveys, enabling historical analysis, reporting, and process tracking. It serves as the definitive record linking a script question, a provided answer, and the relevant business context (customer, contact, address). The table is owned by the OSM schema and is valid for both Oracle EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to establish relationships with key master data and transactional entities. Its primary key is the unique SCRIPT_ACTUAL_ANSWER_ID. The most critical foreign key columns define the core relationships: QUESTION_ID links to AS_SCRIPT_QUESTIONS to identify the specific script question posed, and PRE_DEF_ANSWER_ID links to AS_SCRIPT_PRE_DEFINED_ANSWERS, which holds the valid, predefined answer choices for that question. This ensures data integrity by validating responses against a controlled list. Furthermore, the table includes foreign keys to central customer and site entities: CUSTOMER_ID references RA_CUSTOMERS, CONTACT_ID references the AS_SCRIPT_ACTUAL_ANSWERS table itself (likely for contact hierarchy), and ADDRESS_ID references RA_SITE_USES_ALL, providing the full business context for the interaction.

Common Use Cases and Queries

This table is central to reporting on script performance and customer engagement. Common use cases include analyzing answer distributions for specific questions to gauge customer sentiment, tracking script completion rates for sales representatives, and auditing the history of interactions with a particular customer. A typical analytical query would join this table to its related master data tables to produce a readable report.

• Retrieve All Answers for a Customer: SELECT q.question_text, a.pre_def_answer_id, c.customer_name FROM as_script_actual_answers a, as_script_questions q, ra_customers c WHERE a.question_id = q.question_id AND a.customer_id = c.customer_id AND a.customer_id = :p_cust_id ORDER BY a.creation_date;
• Report on Answer Frequency for a Survey Script: SELECT p.answer_text, COUNT(*) FROM as_script_actual_answers a, as_script_predefined_answers p WHERE a.pre_def_answer_id = p.pre_def_answer_id AND a.question_id = :p_question_id GROUP BY p.answer_text;

Related Objects

AS_SCRIPT_ACTUAL_ANSWERS is a central child table within a well-defined schema. It has direct foreign key dependencies on several key tables: AS_SCRIPT_QUESTIONS (to identify the question) and AS_SCRIPT_PRE_DEFINED_ANSWERS (to validate the answer). It also links to fundamental Oracle EBS entities like RA_CUSTOMERS and RA_SITE_USES_ALL to provide customer and site context. The table AS_SCRIPT_ACTUAL_ANSWERS is also listed as a foreign key parent to itself on the CONTACT_ID column, suggesting a hierarchical relationship for contact data. This network of relationships positions the table as a critical junction for data flowing from script execution into the broader customer relationship management framework.