Search Results ra_site_uses_all

Overview

AS_SCRIPT_ACTUAL_ANSWERS is a transactional table in the Oracle E-Business Suite Sales Foundation (AS) product, owned by the OSM schema. It stores the answers captured against scripted questions during a sales interaction. In the Oracle EBS 12.1.1 and 12.2.2 releases, this table supports the Scripting framework used by call center, telesales, and field sales personnel, where guided scripts present questions to an agent and the agent records responses. Each row represents a single recorded answer for a specific question within a specific interaction.

The table carries a documented status of VALID and exposes 38 columns in the 12.2.2 physical schema. Its role is to persist the outcome of a script execution so that responses can be audited, reported on, and reused for follow-up activities, campaign analysis, and customer profiling. From a Data Vault modeling perspective, the mined classification is link. This is a reasonable modeling suggestion because the table's grain is a captured event that resolves relationships among an interaction, a question, a pre-defined answer, a customer, an address, and a contact, rather than serving purely as a descriptive hub or a slowly changing satellite.

Key Information Stored

The table is anchored by the surrogate primary key SCRIPT_ACTUAL_ANSWER_ID, enforced through the AS_SCR_ACT_ANSWERS_PK constraint and mirrored in the unique index AS_SCRIPT_ACTUAL_ANSWERS_U1. A second unique index, AS_SCRIPT_ACTUAL_ANSWERS_U2, defines the business-key candidate (INTERACTION_ID, PRE_DEF_ANSWER_ID). The most significant non-key columns are:

• INTERACTION_ID — identifies the sales interaction in which the answer was captured; part of the business-key candidate.
• PRE_DEF_ANSWER_ID — identifies the selected pre-defined answer; part of the business-key candidate and an FK to AS_SCRIPT_PRE_DEFINED_ANSWERS.
• QUESTION_ID — the script question being answered; FK to AS_SCRIPT_QUESTIONS.
• SCRIPT_ID — the script executed; FK to JTF_IH_SCRIPTS.
• CUSTOMER_ID — the customer associated with the answer; FK to RA_CUSTOMERS.
• ADDRESS_ID — the site associated with the answer; FK to RA_SITE_USES_ALL.
• CONTACT_ID — the contact recording or associated with the answer.
• COMMENTS — free-text notes captured alongside the answer.
• STATUS_CODE — processing state of the recorded answer.
• EVENT_OFFERING_ID, CALL_PROMOTION_ID, MAIL_PROMOTION_ID — links to offerings and promotions that drove the script.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard who-audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the DFF/descriptive flexfield segment set for extensibility.

Common Use Cases and Queries

Typical scenarios include measuring script completion and answer distribution, tying responses back to a customer or site, and analyzing promotion effectiveness. A representative join retrieves answers with their questions and customers:

SELECT a.SCRIPT_ACTUAL_ANSWER_ID, a.INTERACTION_ID, q.QUESTION_TEXT, a.PRE_DEF_ANSWER_ID, c.CUSTOMER_NAME FROM OSM.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;

The user search term ra_site_uses_all reflects a common pattern: joining ADDRESS_ID to RA_SITE_USES_ALL to report answers by site or location. Because AS_SCRIPT_ACTUAL_ANSWERS.U2 enforces uniqueness on (INTERACTION_ID, PRE_DEF_ANSWER_ID), one interaction can hold multiple answers but not duplicate selections for the same pre-defined answer, which is useful when de-duplicating or aggregating results.

Related Objects

• RA_SITE_USES_ALL — joined via ADDRESS_ID to identify the site associated with a recorded answer.
• RA_CUSTOMERS — joined via CUSTOMER_ID to associate answers with the customer.
• AS_SCRIPT_PRE_DEFINED_ANSWERS — joined via PRE_DEF_ANSWER_ID to obtain the selected answer text.
• AS_SCRIPT_QUESTIONS — joined via QUESTION_ID to retrieve the question detail.
• JTF_IH_SCRIPTS — joined via SCRIPT_ID to identify the executed script.

These relationships position AS_SCRIPT_ACTUAL_ANSWERS as the central link between scripted content and the customer, contact, and site dimensions captured during the interaction.