Oracle Scripting Implementation Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

Introduction to Oracle Scripting

Overview of Oracle Scripting

Components

How Scripts Are Used

Dependencies and Integration Points

Conditional Dependencies

Survey Component Dependencies

Minimum Software Requirements

Minimum Hardware Requirements

Scalability and Performance Guidelines

Installing Oracle Scripting

Implementation Overview

Implementation Task Sequence

Implementation Tasks

Understanding Users Required for Implementation

SYSADMIN Versus Explicitly Created Administrator User Account

JTF Role Requirements

Administrator Super Users

Implementation Responsibility Matrix

Road Map to User Creation and Administration

Creating Administrators for Oracle Scripting

Performing Further Administration Setups

Assigning Scripting Administrative Responsibilities to Users

Assigning Survey-Related Administrative Responsibilities to Users

Creating Oracle Scripting Agents

Implementing the Scripting Engine Agent Interface

Assigning Scripting Engine-Related Responsibilities to a User

Establishing Profile Settings for the Agent Interface

Setting Session Idle Timeout Values for Apache JServ

Implementing the Scripting Engine Web Interface

Implementation Considerations

Assigning Web Interface Responsibilities to a User

Implementing Administrative Interfaces

Establishing Profile Settings

Setting Up the Scripting Administrative Interface

Setting Up the Survey Administrative Interface

Assigning Fulfillment Administrator Role to Survey Administrators

Assigning Survey Administrator User to a Fulfillment Group

Configuring the Oracle XML SQL Utility

Setting Display Server for UNIX Environments

Implementation Administration Tasks

Creating and Administering Users

Creating an Employee in the Enterprise Database

Creating a Resource Group

Importing a CRM Resource

Defining Oracle Applications Users

Setting Up Debugging and Message Logging in Oracle Scripting

Setting Up Applications Common Logging

Enabling Logging for the Guest User

Enabling the Oracle JInitiator Java Console

Bypassing the Sales Resource Group Membership Requirement

Granting JTF Roles

Setting System Profile Values

Finding Application and Responsibility ID Values

Finding Default Application from a Responsibility ID Value

Finding the FND User ID Value of a Defined User

Obtaining the FND USER_ID Value Using SQL

Obtaining the FND USER_ID Value from the Users Window

Removing the Quick Find Menu

Scripting Administration Tasks

Overview of Scripting Administration Tasks

Scripting Home

Launching the Script Author Java Applet

Administering Oracle Scripting Files

Viewing and Removing Deployed Scripts

Viewing and Administering Custom Java Archive Files

Viewing and Removing Uploaded Java Archive Files

Uploading New Java Archive Files

Overwriting Existing Java Archive Files with Updated Archives

Changing the Global Property of Uploaded Java Archive Files

Creating, Removing, and Viewing Java Archive Mapping Definitions

Specifying Load Order of Java Archives Files

Generating and Viewing Panel Footprint Reports

Survey Resource Administration Tasks

Administering Survey Resources

Creating Survey Resources

Creating Survey Resource Definitions

Viewing or Deleting Survey Resource Definitions

Uploading JSP Survey Resources

Survey Campaign Administration Tasks

Overview of Survey Campaign Administration

Setting Survey Administration Preferences

Survey Administration Console Tabs

Administering Survey Campaigns

Performing Survey Campaign and Survey Resource Searches

Survey Campaign and Survey Resource Search Overview

Performing Simple Searches

Performing Advanced Searches

Creating and Personalizing Views

Using Views

Creating Survey Campaigns and Cycles

Viewing or Modifying Survey Campaign and Cycle Details

Cancelling a Survey Campaign from the Survey Campaigns List

Deleting Survey Campaigns and Cycles

Adding or Modifying a Cycle for an Existing Survey Campaign

Defining Deployments

Viewing or Modifying Deployment Details

Deleting Deployments

Viewing Responses Received

Sending Reminders Manually to List Members

Setting Up Invitations and Reminders

Oracle One-to-One Fulfillment Terminology

Fulfillment Activities for Targeted Survey Deployments

Recommended Order of Steps

Invitations

Reminders

Sample Invitation Master Document

Sample Reminder Master Document

Seeded Survey List Query

Using the Master Document Editor

Verifying Status of a Fulfillment Request

Administering Concurrent Programs for Survey Execution

Scheduling or Executing Concurrent Programs

Checking Concurrent Program Logs

Campaign and List Administration Tasks

Introduction

Administering Campaigns in Oracle Marketing

Creating a Campaign

Creating a Campaign Schedule

Associating a Script to a Campaign Schedule

Associating a Script to a Campaign

Administering Campaigns in Oracle Sales Online

Assigning Agents to a Campaign Schedule

Assigning Campaign Schedules to Agents

Administering Lists in Oracle Marketing

List Creation Overview

Creating a List

Identifying Record Sources for a List

Importing Record Sources

Manually Selecting List Entries as Record Sources

Using Oracle Discoverer Workbook to Define Record Sources

Adding Records to a List

Generating a List

Marketing Campaigns as an Oracle Applications Dependency

Implementation Verification

Overview of Verification

Script Author Tasks

Creating a Hello World Graphical Test Script

Oracle Creating a Hello World Wizard Test Script

Using the Regression Test Script

Survey Administration Console Tasks

Scripting Engine Tasks

Apache Web Server Servlet Verification URLs

Scripting Engine Agent Interface Verification

Scripting Engine Web Interface Verification Tasks

Executing a Script in the Web Interface

Testing Display Server for UNIX Environments

Viewing Server Message Logs

Integrating Oracle Scripting

Introduction

Integration by Component

Script Author

Scripting Engine

Scripting Engine Agent Interface

Scripting Engine Web Interface

Scripting Administration Console

Survey Administration Console

Integration by Technology Stack

HTML-Based Integrated Applications

Oracle Self-Service Web Applications

Oracle One-to-One Fulfillment

Oracle Marketing

Forms-Based Integrated Applications

Prebuilt Integration with Oracle Applications

Integrating with Oracle TeleSales

Launching Any Deployed Script from Oracle TeleSales

Launching a Specific Script from Oracle TeleSales

Effects of OTS Profile Settings for Oracle Scripting

Parameters Passed to the Scripting Blackboard

Integrating with Oracle TeleService

Launching Any Deployed Script from Oracle TeleService

Launching a Specific Script from Oracle TeleService

Obtaining Values in a Script from Oracle TeleService

Creating Service Requests in Oracle TeleService from Oracle Scripting

Integrating with Oracle Marketing

Troubleshooting Oracle Scripting

Common Implementation Errors

Responsibility Names Can Differ

Survey Implementation Errors

General Implementation Errors

If You Cannot See the Survey Administration Console

Troubleshooting Fulfillment Administrator Role Assignment

Common Verification or Execution Errors

Script Author Errors

Script Author Deployment Errors

Script Author Script Verification

Scripting Engine Agent Interface Errors

Troubleshooting Applet Security and Signing

Load Balancing Environments with Multiple Apache JServ Instances

Session Timeout Issues

Panel Text Errors

Cascading Style Sheet Information Ignored at Runtime

JavaScript Imported into Panel Text Ignored or Displaying Incorrectly

Debug Statements Not Appearing from Custom Java Code

Survey Deployment and Fulfillment Troubleshooting

User Interface Discrepancies

Log Files and Error Messages

Oracle Scripting Execution Errors and Error Logging

Errors in the Scripting Engine Agent Interface

Errors in the Scripting Engine Web Interface

Unsupported Functions

Panel Layout Editor Formatting Limitations

Oracle Scripting Profile Options

Setting

Finding Responsibility ID Values

Oracle

Current IES Profile Options

Information, Error and Debug Logging Profile Options

Additional Required Profile Options

Oracle Discoverer Workbooks

Introduction

Implementing Survey Analysis Discoverer Workbooks

Staging Oracle Discoverer EEX Files for Import

Creating an End User Layer

Assigning End User Layer Implementation Privileges

Importing Oracle Discoverer Objects into an End User Layer

Assigning Responsibility and Business Area Privileges

Assigning Workbook Privileges

Verifying the End User Layer

Viewing Oracle Scripting Survey Reports

Survey Workbook Descriptions

Survey Question Frequency Workbook

Survey Question Detail Workbook

Survey Question Text Workbook

Survey Campaign Summary Workbook

Survey Deployment Detail Workbook

Survey Cross Tabulation Workbook

Glossary

Oracle Scripting Implementation Guide

Contents