Thursday Jan 28, 2016

Tracing in Oracle Reports 12c

Just in case tracing is needed, here is a summary of steps needed to enable Reports Server Engine/Server/Servlet trace in Oracle Reports 12c:

Open the Enterprise Manager console.  
From the WebLogic Domain menu, select "System MBean Browser".

Depending on the type of trace needed, choose the corresponding section below:

In-process Reports Server engines Go to "Application Defined MBeans"
Expand "oracle.logging --> Server: WLS_REPORTS --> Application: reports --> LogConfig":
  • Click on "LogConfig" and go to the "Operations" TAB.
  • Click on row #11 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.engine". 
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,         ERROR:1, WARNING:1, NOTIFICATION:1 (This is the default value), NOTIFICATION:16,        TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.
In-process Reports Server and Servlet

Go to "Configuration MBeans"
Expand "oracle.logging --> Server: WLS_REPORTS --> LogRuntime" :

  • Click on "WLS_REPORTS" and go to the "Operations" TAB
  • Click on row #6 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.server" for Reports Server trace or "oracle.reports.servlet" for Reports Servlet trace.
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,  ERROR:1, WARNING:1, NOTIFICATION:1 (This is the default value), NOTIFICATION:16, TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.
Stand-alone Reports Server and Engine

Go to "Configuration MBeans"
Expand "oracle.logging --> LogConfig" :

  • Click on "[Reports Server Name]" and go to the "Operations" TAB.
  • Click on row #11 "setLoggerLevel" operation.
  • For "loggerName", enter in the Value field "oracle.reports.server" for Reports Server trace or "oracle.reports.engine" for Reports Server Engine trace.
  • For "levelName", enter in the Value field any of the following values: INCIDENT_ERROR:1,  ERROR:1, WARNING:1, NOTIFICATION:1 (This is the default value), NOTIFICATION:16, TRACE:1, TRACE:16, TRACE:32
  • Click on the "Invoke" button.

Re-start the Reports Server.

 Log Files Location:

    Reports Servlet trace file: DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwservlet_diagnostic.log
    In-process Reports Server trace file:  DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwserver_diagnostic.log
    In-process Reports Server Engine file: DOMAIN_HOME/servers/WLS_REPORTS/logs/reports/rwEng-X_diagnostic.log
    Stand-alone Reports Server trace file: DOMAIN_HOME/servers/[Reports Server Name]/logs/reports/rwserver_diagnostic.log
    Stand-alone Reports Server Engine file: DOMAIN_HOME/servers/[Reports Server Name]/logs/reports/rwEng-X_diagnostic.log

More information on this topic can be found in:  Note 2070743.1

Thursday Jan 21, 2016

WebUtil Overview

WebUtil main purpose is to provide a simple way to achieve client side integration while running Oracle Forms on the web.
It also simplifies the upgrade of existing applications to the web and enhances the capabilities of web based Oracle Forms applications.

WebUtil has an overriding goal to produce a utility that any Forms developer could use to carry out the complex tasks on the client browser machines by simply coding PL/SQL. With WebUtil, everything the programmer needs to do is exposed through a PL/SQL library.

WebUtil main features are:

  • Text_IO - Read and write text files on the client machine.
  • Tool_Env - Read client side variables
  • C API on the client - Interface with client side C.
  • Host - Run Host commands on the client machine
  • OLE2 - Integrate with client side OLE (e.g. Word and Excel)
  • Enhanced Host commands - Host command call back into Forms
  • Browser functions - Integrate with the browser.
  • File transfer - Move from between the client, application server and database
  • File Manipulation - Manipulate client side files.
  • Client machine information - Read information from the client machine
  • READ/WRITE_IMAGE_FILE - Read and write client side images
  • Get_File_Name - Use a file selection dialog on the client machine
  • D2KWUtil features - Client side interface into the D2KWUtil package.


General information about WebUtil like:

Where can I download WebUtil?
What is WebUtil?
The Goals of WebUtil?
Webutil Demo

can be found on OTN

While configuring WebUtil, jacob.jar can be included or not.

The configuration requires jacob.jar when Microsoft OLE functionality is needed.  
Microsoft OLE functions are used primarily in Forms by Forms Developers who wish to interact with Microsoft applications such as Word or Excel from Forms.  
If OLE functions are not needed, following note can be used: Note 1644754.1 WebUtil Demo with No Jacob Dependency/ No OLE Features.

Otherwise, depending on the Forms version used, WebUtil configuration can be completed using:
Note 1093985.1 : How to Configure WebUtil in Forms 11g  or Note 2070183.1 : How to Configure WebUtil in Forms 12c

Monday Dec 07, 2015

Creating and Starting a Standalone Reports Server in 12c

Due to its properties, a Standalone Reports Server provides better control outside the rwservlet process with the ability to separate the server process from the WebLogic Server instance.

As stated in Oracle® Fusion Middleware Administering Oracle Fusion Middleware, starting with 12c version, OPMN is no longer used in Oracle Fusion Middleware. Instead, system components are managed by the WebLogic Management Framework, which includes WLST and Node Manager.

Therefore, managing reports component process has been adapted as well.

With no further ado, here are the instructions to create and start a standalone reports server in the latest 12c version.


A. Create the components

The first step after running the Configuration Wizard in a new environment with Oracle Reports 12c is, to run the WLST command createReportsToolsInstance().
This command will create all the components at the file system level needed for Oracle Reports:

Example

1- Execute wlst.cmd/wlst.sh from ORACLE_HOME/oracle_common/common/bin

2- Connect to AdminServer.

    connect("weblogic","weblogic_password","hostname:7001")

3- Run the following wlst command.

    createReportsToolsInstance(instanceName='reptools1',machine='AdminServerMachine')


B. Create the standalone reports server

Example

1- Execute wlst.cmd/wlst.sh from ORACLE_HOME/oracle_common/common/bin

2- Connect to the AdminServer.

    connect("weblogic","weblogic_password","hostname:7001")

3- Run the following WLST command.

    createReportsServerInstance(instanceName='rep_server1',machine='AdminServerMachine')

* this will create a new standalone Reports Server named 'rep_server1'

4- Start the Reports Server.

Note: The examples use default credentials and ports.


C. Start / Stop the standalone reports server

Go to the DOMAIN_HOME/bin folder and issue any of the following commands:

startComponent.cmd or startComponent.sh [Reports Server Name]
or
stopComponent.cmd or stopComponent.sh [Reports Server Name]


Read more about Reports 12c in the official documentation:

Oracle® Fusion Middleware Publishing Reports to the Web with Oracle Reports Services
and
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports


Tuesday Nov 24, 2015

JNLP embedded in HTML with Forms 12c


Last but not least in the list of new client deployment options available in Oracle Forms 12c is JNLP embedded in HTML.

By definition, Java Network Launch Protocol (JNLP) enables an application to be launched on a client desktop by using resources that are hosted on a remote web server.
Java Plug-in software and Java Web Start software are considered JNLP clients because they can launch remotely hosted applets and applications on a client desktop.

Starting with 12c version, Oracle Forms can be called through JNLP embedded in HTML.

This method requires Java Plugin and a browser and offers full support for SSO, SSO logout and Java Script Integration.
Also, Base64 encodes JNLP code in client side html source.

As with the other options, an example of how to use this type of configuration can be found in the Forms web configuration, formsweb.cfg.

For more details, consult Oracle Forms 12c Documentation and Oracle Forms Java Plugin FAQ

Thursday Nov 05, 2015

Browser-less access to Forms 12c


Oracle Forms 12c version can now be used without a browser while still keeping the native appearance of the application.

Either JDK or Java Plugin (JRE) has to be installed on the client PC.

An example of how to use this type of configuration can be found in the Forms web configuration file (formsweb.cfg), present in Forms 12c environment.

Keep in mind that, due to its standalone properties, there will be no support for SSO, SSO Logout, or Java Script Integration in this configuration.  The Java Web Start option is different from Standalone in that Java Web Start can still use SSO (using Oracle Access Manager).  Neither Standalone or Java Web Start can do SSO logout or Java script integration. 

For more details, check out the Oracle Forms 12c Documentation and Oracle Forms Java Plugin FAQ

Thursday Oct 29, 2015

Forms 12c and Webstart

Did you know?

Oracle Forms 12c offers support for Java Web Start.

Newer Oracle Forms versions (starting with 12c) are planned to support Java Web Start using a new configuration option.

Java Web Start applications should be called from a certified browser. A list of certified browsers that can optionally be used with Oracle Forms when configured for using Java Web
Start is provided in the Product Certification Guide

Because Java Web Start is not tightly dependent on a browser, the list of certified browsers is expected to be larger than the list of browsers supporting the Java Plugin.

Check out the Oracle Forms 12c Documentation  and this recently posted FAQ for more details: Oracle Forms Java Plugin FAQ

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 Jan 29, 2014

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]

Monday Dec 09, 2013

SQL Developer Data Modeler 4.0 (full release)

Just to forward the announcement:

SQL Developer Data Modeler 4.0 is now available. Thanks attending the Early Adopter initiative and providing comments and feedback!

Let's get you started.

Wednesday Oct 16, 2013

APEX Listener Release 2.0.5 is now available on OTN (Oracle Technology Network).

Oracle Application Express (APEX) Listener 2.0.5 is now available on OTN (Oracle Technology Network) 

Oracle APEX Listener 2.0.5 Download 

Friday Sep 27, 2013

A Case Study - Setting Up Oracle Forms 11g with OAM (Oracle Access Manager)

Article by Falilou Waidi, Principal Support Engineer, Oracle Corporation, France

Oracle Forms Services applications can be executed in a Single Sign-on environment using Oracle Access Manager 11g (OAM) and Oracle Internet Directory (OID) to eliminate the need for additional or different logins to access many applications during the same user session.

Oracle Forms Services applications in Oracle FMW 11g Release 2 can be protected by one of the following authentication servers:

  • Oracle Access Manager (OAM) 11g
  • Oracle Single Sign-On Server (OSSO) 10g
[Read More]

Monday Sep 16, 2013

Share your findings! - Oracle SQL Developer 4.0 Early Adopter 2 is now available

Oracle SQL Developer 4.0 Early Adopter 2 is now available. Besides JDK 7 support, this release includes Database Performance Monitoring features to manage snapshots, baselines and enhanced reporting options (ADDM  & ASH).
Anyone is welcome to raise findings, issues and comments - please log them on the OTN Forum marked with an "EA2" prefix in  the subject line.

Here are a few links to get you started :

Monday Aug 12, 2013

Available Now ! Oracle SQL Developer Data Modeler 4.0 Early Adopter

 The Early Adopter release of Oracle SQL Developer Data Modeler 4.0  is now available on OTN (Oracle Technology It completes as important add-on release 4.0 of SQL Developer. It comes with an interesting set of new features.

More details:

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