Thursday Apr 21, 2016

Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsql

Starting with the 12.1.3 Oracle HTTP Server (OHS), the mod_plsql feature has been deprecated.  

As outlined in the Oracle Fusion Middleware documentation, OHS - mod_plsql will not be included with the 12.2 version of the database or the 12.2 Oracle HTTP Server.

This deprecation notice only affects future product direction for the Oracle HTTP Server, and the mod_plsql will continue to be supported according to the dates defined in the Fusion Middleware Lifetime Support Policy document.

For the future, Oracle recommends moving to Oracle REST Data Services (formerly known as Oracle  APEX Listener) as an alternative to mod_plsql. Oracle REST Data Services is a J2EE-based servlet which offers increased functionality including enhanced security, and file caching.

Oracle REST Data Services (ORDS) is a free product provided under Oracle Technology Network License Terms
To run in a supported configuration, ORDS has to be installed into Oracle WebLogic Server (WLS), Oracle Glassfish or Apache Tomcat. 

Read more details about this topic in :
Note 1945619.1 - Future Direction for Application Express (APEX) and the Oracle HTTP Server (OHS) / Mod_plsql
Note 1576588.1 - Oracle Web Tier - Statement of Direction. 

Monday Mar 21, 2016

Application Express in the Cloud

Did you know?
Oracle Application Express can be used in the Cloud.

The Oracle Database Cloud Service is available in several different offerings. Database Schema Service (the schema-based APEX service) offering provides HTTPS access to the Oracle Database and is targeted at developers. Database as a Service and Virtual Image (the dedicated database instance service) are well suited for customers needing a full database or SQL*Net connectivity.

The following figure illustrates the architectural differences between these offerings:



Sign up for a trial account at: cloud.oracle.com

Read all about what Application Express offers in the Cloud in this FAQ

Monday Mar 07, 2016

ORDS 3.0.4 was released

A new ORDS version was released on March 3, 2016

Useful links:

Full download
Release notes and installation
Bugs fixed

Also, read more about the new features of this version in here

Tuesday Mar 01, 2016

New features overview for Oracle Forms 12c

A new features overview for Oracle Forms 12c has recently been released.

In this new white paper, detailed information can be found on several important topics:

Forms Runtime and Integration Features 

  • Oracle BI-Publisher Integration
  • System Events
  • Audio Playback
  • Single Sign-out
  • Client Deployment
  • Custom Text on Logon and Password Change Dialogs
  • Tab Labels with Images
  • Record Counter
  • Item Level Mouse Cursor (Pointer)
  • Setting Max Event Wait Programmatically
  • Client IP Address
  • Form Query-Only Mode
  • Oracle Diagnostic Logging and Forms MESSAGE Built-in
  • JVM Controller
  • Custom Color Schemes
  • New Applet Parameters
  • New Environment Variables

Forms Design Time and Utility Features

  • Builder Preferences
  • Module Converter
  • Product Documentation and Community
  • Java Developer API (JDAPI)
  • WebUtil without OLE

Read more about each feature in Oracle Forms 12c New Features White Paper.

Tuesday Jan 12, 2016

Just Released! Apex 5.0.3 - SQL Developer 4.1.3 - ORDS 3.0.3

Quite right in sync with the year change, we have a bunch of product updates.
New releases are in place

Find all details - new features, fix list, downloads - on the related product sites following the links above.

Tuesday Jan 05, 2016

Oracle Forms and Reports Builders in 12c

In Fusion Middleware 12c, Oracle Forms product introduces a new installation option named 'Forms Builder Only'.
This option offers the ability to install only the Forms Builder and its associated utilities. No runtime or related components will be installed.
This lighter weight installation option will be helpful when a runtime environment is not needed.

All the steps needed to configure Forms Builder Standalone 12c are presented in

Chapter 2.4.9 Configuring Form Builder Standalone 12c Using the Configuration Wizard

Apart from the 'Form Builder Only', Forms Builder can installed as part of 'Forms and Reports Deployment' option as shown below.


On the other side, Reports Builder can only be obtained as part of 'Forms and Reports Deployment' option illustrated above.

Read more about Oracle Forms and Reports 12c version in:

Oracle Forms and Reports 12c (12.2.1) Download and Readme
Oracle Forms and Reports 12c (12.2.1) - Overview
Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
Oracle® Fusion Middleware System Requirements and Specifications12c (12.2.1)


Tuesday Dec 22, 2015

Oracle RESTful Data Services

Representational State Transfer (REST) is a style of software architecture for distributed hypermedia systems such as the World Wide Web.
An API is described as RESTful when it conforms to the tenets of REST. Although a full discussion of REST is outside the scope of this document, a RESTful API has the following characteristics:
  •     Data is modelled as a set of resources. Resources are identified by URIs.
  •     A small, uniform set of operations are used to manipulate resources (for example, PUT, POST, GET, DELETE).
  •     A resource can have multiple representations (for example, a blog might have a HTML representation and a RSS representation).
  •     Services are stateless and since it is likely that the client will want to access related resources, these should be identified in the representation returned, typically by providing hypertext links.

Creating a RESTful Services can be achieved in two ways:

1. Using Oracle Application Express 4.2 SQL Workshop or above with ORDS 2.0.6 or above.
Detailed steps are presented in Doc ID 2085947.1.

2. Using SQL Developer 4.1 and above with ORDS 3.0.2 or above.  Oracle Application Express is not required with this combination.
Read more about this option in : Section E:Getting Started with RESTful Services

Check out the Oracle REST Data Services Installation, Configuration, and Development Guide and the Oracle RESTful Data Services FAQ ( Doc ID 2085904.1  ) for more details.

Thursday Dec 10, 2015

Oracle Lifetime Support Policy for Forms and Reports 12c

Oracle Forms and Reports 12c lifetime support dates are now defined.

At this point in time they are as follows:

Release  GA Date

 Premier

Support Ends

 Extended

Support Ends

Sustaining

Support Ends

Forms and Reports 11.1.2.x
Oct 2011
Dec 2016
Dec 2018
Indefinite
Forms and Reports 12.2.x
Oct 2015
Oct 2020
Oct 2023
Indefinite


For more specifics on Premier Support, Extended Support, and Sustaining Support, please refer to Oracle Lifetime Support Policy or visit us at oracle.com/support


Monday Oct 26, 2015

Forms and Reports 12c are here!

 We are proud to announce the release of Oracle Forms and Reports 12c.

This version provides a compelling platform for developing and deploying your next generation of applications and upgrading your existing applications.

Read more about this version in the links below:

Documentation 
Certification
System Requirements and Specifications

For download go here

Thursday Oct 22, 2015

Apex 5.0.2 was released

A new Apex version was released on October 20, 2015.


This is a cumulative patch set for Application Express 5.0.0 and Application Express 5.0.1.
Full download, release notes and installation notes are available here.

Read more about the new features of this version in here.

Oct 2015 Critical Patch Update



The latest Critical Patch Update (CPU) has been released for Oracle products.

Start your reading here:
Critical Patch Updates, Security Alerts and Third Party Bulletin

This is the home page containing links to all "Critical Patch Updates" released to date, along with sections detailing: Security Alerts, Third Party Bulletin, Public Vulnerabilities Fixed, Policies and Reporting Security Vulnerabilities.

On this page you will find the link to the: Oracle Critical Patch Update Advisory - October 2015

For Oracle Fusion Middleware Forms and Reports, go to section 3.3.20.3 Oracle Forms and Reports 11.1.2.2 in note: Patch Set Update and Critical Patch Update October 2015 Availability Document (MOS authentication neededNote 2037108.1)

Wednesday Jan 21, 2015

CPU Quarterly - January 2015 Security Advisor

Note this quarter's Oracle Critical Patch Update Advisory - January 2015.

The details for Oracle Forms and Oracle Reports environments - releases, patch numbers, configuration heads-ups, ... - are availabe via Master Note on Fusion Middleware Proactive Patching - Patch Set Updates (PSUs) and Bundle Patches (BPs) (MOS authentication neededNote 1494151.1)

Tuesday Aug 12, 2014

OTN Forum to Oracle Community

The Oracle technology Network (OTN) Discussion Forums is  a great place  to exchange, discuss, inform, ask questions, share, ... all around Oracle products. Nothing more to tell, as forums.oracle.com  is for sure a well known institution.

Just as small note, instead of "OTN Forums" it is now titled Oracle Communities (note also the change in URL http://community.oracle.com). Certainly it is not only a name change, it is basically the move to a new application platform introducing new look&feel, usability and functionality. Details about new features and best practices on OTNC welcome page.

MOSC By the way, it is the same platform as for MOS authentication neededMy Oracle Support Communities (MOSC).

Where to find the Developer Tools Communities?

OTNC

OTNC
Development Tools Application Development in PL/SQL Designer
Forms
Reports

Application Express


Wednesday Apr 09, 2014

Free Learning Sessions on Oracle Fusion Middleware

Free Learning Sessions on Oracle Fusion Middleware
Each session runs 2 hours and will provide an in-depth look into each topic. There will be demos, a question and answer session as well as a brief overview of next steps for those who require more detailed training.[Read More]

Tuesday Apr 01, 2014

MOSC Bits - Personalized Profile


 It is a good idea to have a unique profile in MOSC. Your activities there are better reminded and might even  become a well known brand! This leads to recognition and trust.

My Oracle Support Communities (MOSC)  is a well established platform where experiences are shared. Reputation and trust are the basis for the quality of all communication there.

A personalized  profile can help to build up a good reputation. Besides the experience counter, a good name, details about your location and business experience are valuable details. Although a little bit hidden, the profile's avatar can be customized, too. The profile's avatar is an eye catcher snd can act as an unique visual representation for  you. 

How to add / modify MOSC profile avatar (picture, icon)  ?   


  • Don't look in Edit Profile section.
  • After login, click on  your profile's name on top right.  

  • This lists all public information as part of the Bio section.
  • Select the Activity tab.

  • The Change Avatar link is on same level at far right.
  • A list of predefined symbolic pictures is populated.
  • Choose from the list of existing pictures or try Add Another to upload an image file from your local computer (JPG, PNG, GIF, or BMP only, maximum file size of 2.0 MB).
  • Note: New added images can be used only after running through a review process. Usually after one business day they can be selected for your personal avatar.


About


This is the official blog of the Proactive Support Team for Developer Tools: Oracle Forms, Oracle Reports, Apex, SQLDeveloper, ... . Find information about our activities, publications, product related information and more.

 

Follow @psdDevTools on Twitter

Search

Categories
Archives
« May 2016
SunMonTueWedThuFriSat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
    
       
Today