Monday, April 1, 2013

Oracle Scripting

Posted by at 2:26 AM Read our previous post

Oracle Scripting is a set of tools to facilitate the process of gathering or exchanging information for the benefit of the enterprise.
          Used by call center agents to provide scripting and desktop flow and integration
          Used to provide Web scripts to agents or customers using self-service Web  applications
          Used to provide survey capabilities
     Via web sites to public
      In combination with Oracle Marketing and Oracle One-to-One Fulfillment to invite list members via email to respond to a Web-based survey

What Oracle Scripting offers to enterprises:
          Reduce agent training time
          Ensure that agents deliver consistent messages to customers
          Streamline the desktop environment
          Integrate with other ERP, CRM, and legacy applications
          Increase productivity through automated alerts, cross-sell, and up-sell  capabilities
          Assist with rapid creation and deployment of scripts, call guides, and surveys

Components of Oracle Scripting

          The Script Author is used to build scripts for use as call guides, desktop flow aids, self-service Web scripts and survey questionnaires. This component is required for all implementations.
          The Scripting Engine executes scripts in two interfaces (the agent interface, which is an Oracle Forms client, and the Web interface, which allows scripts to be executed within a Web browser). This component (at least one of these two interfaces) is required for all implementations.
          The Scripting Administration console is used to access Script Author, manage scripts and custom Java archives used in support of scripts. This component is required for all implementations.
          The Survey Administration console is used to manage survey resources and administer survey campaigns and deployments, which is required to execute any script in a Web browser. This component is implemented optionally, if such requirements exist for the enterprise.

Script Author

Component used to build, modify, and deploy scripts to the Oracle Applications database
               Script Author is a Java applet
               Launched from an authenticated Oracle Applications session only
               Accessible from the Scripting Administration console
               Requires Scripting Administrator responsibility

Key Components
          Graphical Script: Script created using the Script Author's graphical editing tools. These can include custom code and complex features specific to the agent interface.
          Wizard Script: Script created using the Script Wizard, a feature that allows non-technical users to provide information in a series of windows called a Wizard that results in saved, deployed, syntactically correct scripts.
          Canvas: The visual layout area in the Script Author where objects are placed, connected and configured to drive the flow of a script in the Scripting Engine or Survey component.
          Explorer: The left-most region in the Script Author which shows different views of the script components.
          Properties Pane: Located under the Explorer, this pane shows the properties associated with the selected object on the canvas.

Script Author Objects

A script is represented as one or more graphs. A graph is made up of configurable and non-configurable objects connected by branches. Objects are processing units that tell the script what to do. Branches are processing units that tell the script where to go.

          Configurable Objects: An object that has properties that you can modify. Script Author contains the following three configurable objects:
-       Panel: A panel object contains the information that is displayed at runtime. Answer controls defined in the panel are used to accept information from the user at runtime and advance the flow of the script.
-       Group: A group object is a container for other objects and branches. It may contain any type of objects, including other groups. Groups can be nested as many levels as desired. A group represents a child graph and can be used to logically group a section of the script flow. A group can also be the destination of the “jump command” using a shortcut.
-       Block: When used to query, update, or insert information in a database, the Block definition is always associated with one or more database tables and contains connection information associated with that database. When used as a container for an Application Program Interface (API), it contains a command that references the API. A block can also be a container for panel objects. The answer controls in the panel objects can be used in block processing.

           Non Configurable Objects: An object that does not have properties that can be modified.
-       Start Node: Every time a graph is created in the Script Author, it contains a Start Node. Start Nodes cannot be created or deleted and contain no viewable properties. Start Nodes visually represent the starting point in a graph. They can be moved about the canvas but must be attached using a branch to the first explicitly created object in the script.
-       Termination Node: Termination Nodes represent the end of the flow of that level of the script runtime. A graph may contain two or more Termination Nodes, each depicting the end of the flow of a particular path.

           Branches: A branch is used to connect objects. The type of branch used determines the next object in the script flow. There are four types of branches:
-       Default: The destination is the designated object. If there is more than one branch, this type of branch must be defined as the last-case default if no other branch is valid. Requires no properties to be associated with it in the Script Author.
-       Distinct: The destination is based on the answer selected in a panel at runtime. This branch type requires lookup values to be defined in the Panel, and requires values to be assigned to each distinct branch from the branch properties in the Script Author.
-       Conditional: The destination is based on the evaluation of a Boolean expression. This branch type requires the definition of a Boolean expression to be associated with the branch in the Script Author and corresponding Java code to provide the expression to be evaluated at runtime.
-       Indeterminate: The destination is based on information obtained at runtime. This branch type requires the definition of a command to be associated with the branch in the Script Author and corresponding Java code (to provide the expression and destination objects) to be evaluated at runtime. The script can then flow to any sibling object (Panel, Block or Group on the same canvas) or a destination group (using the Shortcut property) on any level of the script.

Scripting Engine
The Scripting Engine is the component of Oracle Scripting which processes a script in runtime.
               Displays any included panel text and images.
               Displays questions with answer controls.
               Interprets the script end user's response to prompts, executes custom code, and determines flow based on business rules set up in the script.

Two Interfaces
Scripts developed with Script Author can be executed in one of two Scripting Engine interfaces:
  1. Agent interface: a Java application running in an Oracle form.
  2. Web interface: a sequential interpretation of a script executed in a Web browser, with each panel represented by one JSP page.
Scripting Administration Console
          The Scripting Administration console is an HTML user interface.
          Trusted users with access to this console can launch scripts, administer deployed scripts, upload and administer Java archives, map deployed scripts to Java archives, and view panel footprint reports.
          This console is accessed by logging into Oracle HTML-based applications using a user account with the Scripting Administrator responsibility.

Survey Administration Console
Use this HTML user interface to administer all  requirements for executing scripts in a Web browser.

Integration with Other Applications
          Survey campaigns to be executed to targeted lists can take advantage of Oracle Marketing's list management features from the Audience tab of the Survey Administration console.
          Access to Oracle One-to-One Fulfillment's master documents, queries, and templates are accessible from the Invitations tab of the Survey Administration console.

Survey Campaign Administration
To administer survey campaigns, cycles, or deployments, use the Survey Administration console
         The Survey Administration console is an HTML user interface.
         This console is accessed by logging into Oracle HTML-based applications using a user account with the Survey Administrator responsibility.



  1. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer
    LinkedIn profile -
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at | +91 - 9581017828.

  2. Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check


© Oracle Apps CRM is powered by Blogger - Template designed by Stramaxon - Best SEO Template