Oracle Scripting


Oracle ScriptingDeveloper's GuideRelease 12.1Part No. E14599-03August 2010

Oracle Scripting Developer's Guide, Release 12.1Part No. E14599-03Copyright 2005, 2010, Oracle and/or its affiliates. All rights reserved.Primary Author:Rinku MohapatraOracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarksof their respective owners.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalfof the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSPrograms, software, databases, and related documentation and technical data delivered to U.S. Governmentcustomers are "commercial computer software" or "commercial technical data" pursuant to the applicableFederal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication,disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in theapplicable Government contract, and, to the extent applicable by the terms of the Government contract, theadditional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). OracleUSA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is notdeveloped or intended for use in any inherently dangerous applications, including applications which maycreate a risk of personal injury. If you use this software in dangerous applications, then you shall beresponsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use ofthis software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware in dangerous applications.This software and documentation may provide access to or information on content, products and servicesfrom third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim allwarranties of any kind with respect to third party content, products and services. Oracle Corporation and itsaffiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of thirdparty content, products or services.

ContentsSend Us Your CommentsPreface1Understanding Script Author CommandsAction Types and Commands. 1-1Where Commands are Defined in the Script Author. 1-1Action Types. 1-2Command Types. 1-5Java Commands. 1-5Referencing Java Methods in Script Author. 1-6Referencing Best Practice Java Methods in Script Author. 1-6Passing the Proxy Bean as a Parameter to a Java Command. 1-8Standard Java Naming and Usage Conventions. 1-9Importing Scripting Classes into Java Source Files.1-10PL/SQL Commands. 1-10Blackboard Commands. 1-11Providing Values to the Blackboard. 1-11Uses of the Blackboard Command. 1-12Maintaining State in the Scripting Blackboard. 1-12How Long Is Blackboard Information Retained?. 1-13Using Scripting APIs. 1-14Forms Commands. 1-15Oracle Scripting Forms APIs. 1-17Getting a Value from Forms-Based Oracle Applications. 1-19Setting a Value in Forms-Based Applications.1-23Defining a Shortcut Button to Launch a Form. 1-25iii

Launching a Web Browser as a Script Action. 1-28Calling APIs Customized for Use with Oracle Scripting. 1-29Constant Commands. 1-34Delete Actions. 1-342Customizing Oracle ScriptingCustomization and Support. 2-1Skill Sets and Experience Required for Oracle Scripting. 2-2Using Best Practices and Building Blocks. 2-4Determining Where to Define a Command.2-5Best Practice Java Methods. 2-9Overview of Best Practice Java Methods.2-9Deciding Between Best Practice and Custom Java. 2-11ScriptUtil Java Methods. 2-11NodeDefault Java Methods. 2-16NodeValidation Java Methods. 2-17Referencing Best Practice Java in a Command. 2-20Passing Parameters to the Web Interface. 2-22Performing Advanced Graphical Script Tasks. 2-23Defining a Shortcut Button. 2-23Defining Shortcuts. 2-27Enabling the Agent Interface Disconnect Button. 2-28Enabling or Disabling a Shortcut Button.2-32Defining the Script Information Area. 2-33Defining a Constant Command. 2-36Using the Indeterminate Branch. 2-37Using Iterating Parameters. 2-40Querying the Database and Displaying Results.2-41Displaying Returned Values as Panel Text. 2-41Displaying Returned Values as Panel Answer Lookup Values. 2-42Understanding the Scripting Cursor. 2-49Scripting Engine Cursor APIs. 2-49Replacing a Panel with a Java Bean. 2-513Seeded Script Author CommandsOverview of Seeded Script Author Commands. 3-1Support Statement. 3-3Seeded Command Detail. 3-4Create Lead. 3-4Create Lead Opportunity. 3-8iv

Send Collateral. 3-12Register for an Event. 3-14Register Interest for Organization. 3-17Register Interest for Contact. 3-19Create Organization Contact.3-22Create Party Organization Type. 3-25Create Party Site. 3-26Create Person Party. 3-28Create Location. 3-30Update Organization Contact. 3-32Update Party Site. 3-344Oracle Scripting Building BlocksOverview of Building Blocks. 4-1How to Use Building Blocks. 4-3Summary Information on the Building Block Scripts.4-4The Retrieve Customer Building Block Script. 4-55Best Practice SurveysBest Practice Survey Script Considerations. 5-1Location of Best Practice Survey Scripts. 5-2Description of Best Practice Survey Scripts.5-26Customizing Panel LayoutsOverview of Customizing Panel Layouts. 6-1Purpose and Limitations of the Panel Layout Editor. 6-2HTML Restrictions in the Scripting Engine. 6-2Restrictions for Web and Agent Interfaces. 6-2Web Interface Restrictions. 6-2Agent Interface Restrictions. 6-4Oracle Scripting Custom HTML Syntax. 6-5Panel-Level HTML Requirements and Syntax. 6-6Answer UI-Level HTML Requirements and Syntax. 6-6Radio Button Answer UI Panel Syntax. 6-6Check box Group Answer UI Panel Syntax. 6-7Button Answer UI Panel Syntax. 6-8Continue Button Panel Syntax.

E-Business Suite DBA. Oracle E-Business Suite Maintenance Procedures provides a description of the strategies, related tasks, and troubleshooting activities that will help ensure the continued smooth running of an Oracle E-Business Suite system. Oracle E-Business Suite Maintenance Utilities describes the Oracle E-Business Suite utilities that