Table of Contents
- Title and Copyright Information
- Preface
- 1 What's New in Release 4.0.0
- 2 Introduction to Oracle Visual Builder Add-in for Excel
- 3 Install Oracle Visual Builder Add-in for Excel
-
4
Create Layouts in an Excel Workbook
- Create a Table Layout
- Work with Service Path Parameters in a Table Layout
- Create a Form-over-Table Layout
- Manage Fields in a Form or Table
- Create Layouts for Attachment Business Objects
-
Use Polymorphic Business Objects and Fields
- About Polymorphic Business Objects
- Check the Cardinality of Child Polymorphic Business Objects
- Create a Layout Using Descriptive Flexfields
- Add Descriptive Flexfields to a Layout
- Show or Hide Context-Sensitive Columns in a Table Layout
- Refresh Polymorphic Business Object Metadata
- Polymorphic Support Limitations
- Manage Layout Capabilities
- Layout Limitations
-
5
Manage Catalogs and Business Objects
- Add Business Objects to an Existing Catalog
- Import a Business Object Catalog
- Create a Business Object Catalog from a Data Sample
- Configure Business Object Fields
- Set an Authentication Method for a REST Service
- Override a Business Object's Base Path
- Manage Metadata Path Information
- Configure Pagination for a Business Object
- Configure Row Finders for a Business Object
- Use Row Variables for a Business Object
- Configure GZIP Compression for Request Payloads
- Refresh a Business Object Catalog
- Configure the REST-Framework-Version
- 6 Configure Search Options for Download
- 7 Download Data
- 8 Custom Actions
-
9
Use Lists of Values in an Excel Workbook
- About Lists of Values
- Configure a List of Values with a Business Object
- Configure a Filter for a List of Values
- Use a Local Data Source for a List of Values
- List of Values for Descriptive Flexfields
- Clear Cache for a List of Values
- Refresh Parameter Definitions for a Lists of Values
- Notes and Limitations for Lists of Values
- 10 Use Key Flexfield Pickers
- 11 Appearance of an Integrated Excel Workbook
- 12 Data Validation
-
13
Upload Changes
- Upload Changes from a Table Layout
- Upload Changes from a Form-Over-Table Layout
- Invoke Custom Actions via Upload
- Upload Table Changes Using Separate Requests for Each Row
- Upload Changes Using Multi-Row Requests
- Upload Parent and Child Changes in the Same Payload
- Upload Changes Using Upsert Mode
- Omit Empty Values During Upload
- Send Only Changed Data During Upload
- Data Consistency
- Enable Parallel Requests During Upload
- 14 Use Multiple Layouts for Multi-level Business Objects
- 15 Use Macros in an Integrated Excel Workbook
- 16 Publish an Integrated Excel Workbook
-
17
REST Service Support
- Service Types
- Supported Data Types
- Business Objects Harvested from OpenAPI Metadata
- Required Fields
- REST Operations
- REST Request Headers
- Natural Language Support
- Object-typed Fields and Subfields
- REST Service Support Limitations
- 18 Internationalization
- 19 Security
- 20 Troubleshoot Excel Workbooks
- 21 Migrating an Excel Workbook to Version 4.0
- 22 Use Expressions in an Integrated Workbook
- 23 The Embedded Browser
- 24 Third Party Licenses