1/18
Contents
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
About these Tutorials
What this Book Is Not
Tutorial Topics
About Loading Sample Objects
Downloading OEHR Sample Objects
Importing and Installing OEHR Sample Objects
Viewing Database Objects
About Application Authentication
2
How to Create a Tabular Form
Creating an Application
Creating a Tabular Form Using a Wizard
Changing an Updatable Column to a Select List
Create a Named List of Values
Edit the Column to Display as a Select List
3
How to Create a Parameterized Report
Sample Report Utilizing a Form Input
Creating an Application
Creating Regions
Create a Search Region
Create a Query Region
Adding Form Items
Create a Search Employee Text Field
Create a Hidden Text Field
Create Department and Manager Select Lists
Adding a Button to Submit the Page
Adding an Onload Process
Running the Page
4
How to Create a Drill Down Report
Creating a New Application
Creating Reports for OEHR_ORDERS and OEHR_ORDER_ITEMS
Create a Report for OEHR_ORDERS
Create a Report for OEHR_ORDER_ITEMS
Customizing the ORDER_ITEMS Report
Add an Item to Hold the Value of ORDER_ID
Add a Where Clause to Restrict the Report
Modify the Region Title
Linking the ORDERS Report to the ORDER_ITEMS Report
5
How to Control Form Layout
Creating a Table and Data Input Form
Create the HT_EMP Table
Create a New Application
Create a New Page Containing an Input Form
Run the Page
Changing the Appearance of a Page by Altering Region Attributes
Edit the Region Title
Change the Display Point and Template
Change the Region Attributes Back to the Original Selections
Understanding How Item Attributes Affect Page Layout
Edit Item Attributes
Fix Item Alignment
Change a Region to Display-only
Adding a Region Header and Footer
Making a Region Conditional
Adding a Region to Contain Hint Text
Changing Item Types
Change an Item to a Radio Group
Change an Item to a Select List
Change an Item to a Check Box
About Label Templates
Changing Buttons
Running the Page for Update
Making Data Bold
6
How to Work with Check Boxes
Creating an Application
Run the Application
Editing the Update Form
Hide the Warranty Period Field
Add a New Checkbox
Change the Report Display
Create Multi Value Check Boxes to Filter Content
Change the Search Field to a Multi Value Check Box
Edit the Report Region Definition
Change the Default Check Box Behavior
Change the Check Boxes to Display in Bold
Adding Check Boxes to Each Row in the Report
Call APEX_ITEM.CHECKBOX
Add a Button to Submit Check Box Array Values
Add a Process
7
How to Implement a Web Service
About Creating Web Service References
Creating a New Application
Specifying an Application Proxy Server Address
Searching a UDDI Registry
Create a Form and Report
Creating a Web Reference Manually
Create a Web Reference Manually
Test the Web Service
Create a Page to Call the Manual Web Service
Create a Submit Button
Create Items for ZIP Code and Radius
Create a Process to Call the Manually Created Web Reference
Create a Report on the Web Service Result
8
How to Create a Stacked Bar Chart
About the Syntax for Creating Chart Queries
Creating an Application
Creating a New Page
Adding Additional Series
Updating the Sample Data
Viewing the Chart
Editing Chart Attributes
9
How to Upload and Download Files in an Application
Creating an Application
Creating an Upload Form
Create an HTML Region
Create an Upload Item
Create a Button
Creating a Report with Download Links
Create a Report on APEX_APPLICATION_FILES
Add Link to Download Documents
Storing Additional Attributes About the Document
Create a Table to Store Document Attributes
Create an Item to Capture the Document Subject
Create a Process to Insert Information
Show Additional Attributes in the Report Region
Storing the Document in a Custom Table
Downloading Documents from the Custom Table
Create a Procedure to Download Documents
Edit the Uploaded Files Region
Change the Download Link to Use the New Procedure
Security Issues to Consider
10
How to Incorporate JavaScript into an Application
Understanding How to Incorporate JavaScript Functions
Incorporating JavaScript in the HTML Header Attribute
Including JavaScript in a .js File Referenced by the Page Template
About Referencing Items Using JavaScript
Calling JavaScript from a Button
Changing the Value of Form Elements
Creating a Client Side JavaScript Validation
Create an Application on the OEHR_EMPLOYEES Table
Add a Function to the HTML Header Attribute
Edit an Item to Call the Function
Test the Validation by Running the Page
Enabling and Disabling Form Elements
Add a Function to the HTML Header Attribute
Edit an Item to Call the Function
Change the Item to a Select List
Create a Call to the disFormItems Function
11
How to Build an Access Control Page
How Access Control Administration Works
Creating an Application
Download Spreadsheet Data
Create an Application Based on Spreadsheet Data
Run the Application
Creating an Access Control Administration Page
Create an Access Control Page
View the Page
Add Users to the Access Control List
Creating an Authentication Function
Updating the Current Authentication Scheme
Applying Authorization Schemes to Components
Associate an Authorization Scheme with the Application
Associate Edit Privileges with the ID Column
Associate Edit Privileges with the Create Button
Associate Edit Privileges with Page 2
Restrict Access to Page 8
Testing the Application
Log In with View Privileges
Log In with Edit Privileges
Log In with Administrator Privileges
12
How to Review a Packaged Application
What Is a Packaged Application?
About the Supporting Object Utility
Accessing the Supporting Objects Page
About Supporting Objects Installation
Welcome Message
Prerequisites
License Acceptance
Application Substitution Strings
Build Options
Pre-Installation Validations
Pre-Installation Confirmation Message
Installation Scripts
Success Message
About Supporting Objects Deinstallation
View the Deinstallation Confirmation Message
Review the Deinstallation Script
View the Deinstallation Success Message
About Supporting Objects Export
Review the Supporting Objects Export Setting
Where the Export Default Appears When Exporting
About Creating Upgrade Scripts
Utilizing Upgrade Messages
About Refining Your Installation Scripts
Downloading Public Packaged Applications and Sample Code
13
How to Create a Master Detail PDF Report
About Oracle BI Publisher Licensing Requirements
Viewing a Hosted Version of the Application
Loading the Required Objects
Download the Packaged Application
Import and Install the Packaged Application
Creating a Master Detail Form
View the Report
Creating the Report Query
Creating the RTF Template
Download Oracle BI Publisher Desktop
Load the XML Details
Insert the Fields
Include Line Items
Creating the Report Layout
Create a Report Layout
Associate the Report Layout and Report Query
Linking the PDF Report to the Application
Create a Button
Create a Branch
Run the Page
About Creating One PDF Containing All Orders
14
How to Build and Deploy an Issue Tracking Application
Planning and Project Analysis
Planning and Project Analysis
Designing the Database Objects
About the Projects Table
About the People Table
About the Issues Table
Implementing Database Objects
About Building Database Objects
Create and Run a Script
View the Created Database Objects
Loading Demonstration Data
Load Projects Data
Load People Data
Load Issues Data
Building a Basic User Interface
Create the Application
Add Pages to Maintain Projects
Add Pages to Track People
Add Pages to Track Issues
Create Summary Reports
Add Content to the Home Page
Add a Breadcrumb Menu
Adding Advanced Features
Add Support for Email Notification
Add Application Security
Deploying Your Application
Move the Application Definition
Alternate Authentication Mechanisms to Consider
Create Users
Publish the URL
A
DDLs and Scripts
Creating Application Database Objects DDL
Creating Issues Script
Scripting on this page enhances content navigation, but does not change the content in any way.