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 Jul 16, 2014

CPU Quarterly - July 2014 Security Advisor and Java SE Updates Released

It is good practice to review the security updates for your Oracle products regularly. They are updated quarterly with latest just published (July 2014).
The Oracle Critical Patch Update Advisory lists best practices and latest patches with scope making Oracle products more stable and robust.
TheMOS authentication needed PSU and CPU July 2014  Availability Document gives a comprehensive listing of recommended patching  for products and releases effected. Note that all effected components of a product are listed there.

For example for an 11.1.2.2.0 Forms/Reports environment follow this navigation path:

  • "Patch Availability for Oracle Products"
  • "Oracle Fusion Middleware"
  • "Oracle Fusion Middleware"
  • 3.3.17.4 Oracle Forms and Reports 11.1.2.2

 leading to Table 78. There are references for Java SE, JRockit, WebLogic Server, Database client, Oracle ADF,
OPMN, HTTP Server that are strongly recommended to review an implement. Even though Forms/Reports may not be effected directly, partner components need an update.

 An important part is always Java. With July 2014,  Java 8u11, 7u65, 6u81, and 5u71 are now in place (8u11 and 7u65 are publicly available through OTN).  The Information Center: Installation & Configuration for Oracle Java SE (MOS authentication neededDoc ID 1412103.2) will give more details on Java SE  download and installation.

as

Monday Jun 16, 2014

QR Codes in Oracle Reports

 QR codes are pretty popular, especially for paper based workflows and in logistics. "Quick Response Code" is a two dimensional (2D) visual representation of any alphanumeric string. Main purpose - same as with barcodes - is to integrate paper with computers, aka offer machine readability.

Depending on the use case, different variations of QR codes are established, like Micro-QR-Code, Secure-QR-Code (SQRC), iQR-Code. Typically their specifications differ in dimension and number of elements (which basically refers to the amount of data  that can be represented with it).

Also several (country specific) industrial standards (like JIS X 0510, GB/T 18284, ISO/IEC 18004) as well as de-facto standards (like OpenSource XZing) are in place, and so do many programs generating them (QR Code Generator).

QR Code Sample

Oracle Reports has the ability to integrate external Java programs while the report is executed. Existing reports can be modernized that way and additional functionality can be added. A nice use case is demonstrated for the Barcode Bean. The barcode is generated on the fly and added for any destination format. Find details about the concept, implementation and coding in

Chptr. 43 Building a Report with a Barcode

of the main reference manual Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports 11g Release 2 (11.1.2).

For QR Codes integration into Oracle Reports, the same concept comes into place:

How to Generate 2D Barcode / QR Code in Oracle Reports (Doc ID 1678110.1)

This brand new sample code comes with demo RDF, Java coding required and setup instructions. It is based on OpenSource QR code generators.

Give it a try and let us know your experience!

Thursday Apr 24, 2014

Java Headlines and Security Advisor April 2014

Java is the key technology for Fusion Middleware product stack and very relevant for Developer Tools, specifically Oracle Forms and Reports. Looking after the security updates and new features of JDK and JRE has impact on behavior of your application and thus effecting end users.

New Java versions have been released as part of the standard Critical Patch Update (CPU) cycle.  The latest versions are now:

  • 8U5
  • 7U55
  • 6U75
  • 5U65

Does your product allow to take advantage of these updates? Review carefully the Fusion Middleware Certification Guides before attempting to install them! Talking about Oracle Forms and Reports, the server side JDK and the client side JRE is to be checked - relevant are the branches 6 and 7.

Java downloads are available on OTNMy Oracle Support, and on java.com

Oracle Forms  and Reports are not directly effected by the latest Oracle Critical Patch Update Advisory - April 2014, nevertheless worth to review with scope partner FMW components and Java.

Details on the new support timelines are available on the Oracle Java SE Support Roadmap page and are included in the updated Lifetime Support Policy: Oracle Fusion Middleware Products.

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.


Friday Feb 21, 2014

Top 5 Solution Documents for Oracle Forms/Reports and APEX - Feb 2014

The following are the top 5 Solution Documents found useful in Support for  Oracle Forms, Reports and APEX in last 2 months :[Read More]

Friday Feb 07, 2014

New My Oracle Support Community (MOSC) Platform

The My Oracle Support Community (MOSC) recently migrated to a new platform with a completely new look and feel and navigation.

There is a series of 5 short videos to help learn the basic features and get you started.  Please see My Oracle Support Community - New Platform Overview to start out with the first video.  Once done with that video, click on the [ Watch the Next in this series ] at the bottom left and it will automatically take you to the next video in the series.  Each video page has the [ Watch the Next in this series ] link to advance to the next video.

[Read More]

Thursday Feb 06, 2014

Oracle Application Express (APEX) 5.0 Early Adopter 1

Oracle Application Express 5.0 Early Adopter 1 is available now :

http://apexea.oracle.com

Major Enhancements include :

  • A new "Page Designer": a completely new IDE designed to greatly improve developer's productivity, allowing you to very quickly enhance and maintain pages within Application Express.
...
[Read More]

Wednesday Jan 29, 2014

IMPORTANT: My Oracle Support Community and OTN Profiles Merge January 31, 2014

For My Oracle Support Community Users...

On January 31, 2014, we plan to migrate the My Oracle Support Community (MOSC) to the same platform used for the Oracle Technology Network (OTN) forums.
[Read More]

Oracle Forms - A Closer Look at the JRE Security Warning(s) Related to JAR Signing and Manifests

Latest versions of JREs demand some new security requirements on JAR files used by applets. Because of these new requirements, Oracle  Forms users started to see several different Security Warnings lately, which didn't popup in the past. With a careless glance at these Security Warnings, one may not realize any difference between them. But for careful eyes, there are important distinctions between each. And of course each of them has its own specific solution. This article shows the current set of security warnings and explains how to deal with them.[Read More]

Wednesday Jan 22, 2014

Oracle Critical Patch Update January 2014 - Availability and Relevance

Oracle constantly reviews its products to harden against security threatening. Regularly an "Oracle Critical Patch Update Advisory" is published to inform about new patches and other actions to take. Oracle users are highly recommended to carefully review and to consider these advices.

With the January 2014 advisory, Oracle Forms and Oracle Reports for releases 11gR1 and 11gR2 are not effected by a new patch directly. Nevertheless, there are two items to take into account:

  • Corresponding Oracle Fusion Middleware components like database client, JDK, HTTP Server, ... may need patching. Find the details in Master Note on Fusion Middleware Proactive Patching - Patch Set Updates (PSUs) and Bundle Patches (BPs) MOS authentication neededDoc ID 1494151.1)
  • The January 2014 Risk Matrices - Oracle Fusion Middleware lists one item for Oracle Reports: CVE-2013-5785 dedicated to versions 11.1.1.6, 11.1.1.7 & 11.1.2.1 and gives best practices how to use the existing feature "Enable File System Access Control". Check out "Enable File System Access Control" - Fine Grained File System Access Control for the Reports Server MOS authentication neededDoc ID 1608683.1 for more details.

Security Alert Tickler Tip:
Keep updated on latest security announcements from Critical Patch Updates, Security Alerts and Third Party Bulletin and activate the Security Alert Tickler (RSS Feed)!

 





Tuesday Jan 07, 2014

Just Released - Fusion Middleware Forms & Reports 11gR2 Patchset 2 (11.1.2.2.0)

Oracle Fusion Middleware Forms and Reports 11G Release2 (11gR2) is now on patchset 2 with version number 11.1.2.2.0.

This release can be applied as a patch on top of 11.1.2.x installation or as a new installation. Be sure to review the product Certification Guide for the latest updates on certified configurations and the latest updates to the Documentation Library.

You can download it from :

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

Archives
« February 2015
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
       
       
Today