Author Archives: Daniel Kampf

Oracle Reports and the Alternatives

“Oracle Reports released with Oracle Fusion Middleware’s 12.2.1.3.0 will be its terminal release. Oracle Reports will be supported in accordance with the Oracle Fusion Middleware Lifetime Support Policy. Customers are advised to use Oracle BI Publisher for their reporting needs.” … Continue reading

Posted in 12.2.1.2, 12c, BI Publisher, Developer, Development, Forms & Reports, Forms12c, Java, Oracle Forms 12c, Oracle Reports, Uncategorized | Tagged , , , , , , , , , , | Leave a comment

Mozilla Firefox 52 ESR for extended NPAPI-support

Interesting post from my colleagues from the US regarding Oracle Forms & Firefox 52: As of March 7, 2017, Mozilla has released the newest release of Firefox, version 52. Similar to what Google Chrome did about a year or so ago, Mozilla has now disabled the NPAPI plug-in which is required to run anything with … Continue reading Mozilla Firefox 52 ESR for extended NPAPI-support Continue reading

Posted in 11g, 52, Browser, ESR, Firefox, Firefox 52, General, Java, Oracle, oracle forms, Plugin, Plugins, Webstart | Comments Off on Mozilla Firefox 52 ESR for extended NPAPI-support

Oracle Forms 12c: Error 801 while compiling

If you’ve already upgrated to the latest Forms version (currently 12.2.1.2) you’ve maybe encountered following problem: If you use a cursor, that is specified in a package specification within your forms and define a rowtype based on that cursor that is fetched into the rowtype in a different other part of the form (in my … Continue reading Oracle Forms 12c: Error 801 while compiling Continue reading

Posted in 12.2.1.2, 12c, Compilation, Development, error, Error 801, Forms12c, FORMS_PLSQL_BHVR_COMMON_SQL, internal error, Metalink, Modernization, Oracle, oracle forms, OTN, unexpected fragile external reference, Upgrade | Comments Off on Oracle Forms 12c: Error 801 while compiling

Oracle Forms & Database Wallet

During my work as an Consultant I’ve seen some Forms applications, where developers made their lifes easier by using the Oracle connect string to directly connect to the database when starting Forms application. The problem is that the password in most cases is entered in plain text as part of the formsweb.cfg. In this blog … Continue reading Oracle Forms & Database Wallet Continue reading

Posted in formsweb.cfg, General, Oracle, oracle forms, security, userid | Comments Off on Oracle Forms & Database Wallet

Configure Webstart for custom Jar-Files

The following text is from a knowledgebase entry from my colleagues from the US. It describes how you have to configure Forms & Reports to be able to use PITSS.CON with webstart. Since adding your jar-files to the extensions.jnlp is a general task when you want to use webstart in 12c, I thought that this could […] Continue reading

Posted in 12c, General, Java, Java Webstart, JP2LAUNCHER, oracle forms, Webstart | Comments Off on Configure Webstart for custom Jar-Files

Running Forms 12c with SSL and Java Web Start Uses HTTP Instead of HTTPS

There is a known SSL-related issue when you run Oracle Forms 12c using the Java Web Start functionality. What happens is when you launch your Forms application using Java Web Start using HTTPS, you will notice that the URL will change to using HTTP instead of HTTPS. In some cases, you may encounter the following […] Continue reading

Posted in 12c, General, Java Webstart, JP2LAUNCHER, Oracle, oracle forms, Oracle Forms 12c, SSL, Webstart | Comments Off on Running Forms 12c with SSL and Java Web Start Uses HTTP Instead of HTTPS

ADF: Handling deletion in TreeTables

For the current project that I am working for, we had the requirement to display information in a table that should consist of Master and Detail rows. I knew that there is a component in ADF to solve this requirement quite easily: af:TreeTable. af:treeTable So I added my master as a TreeTable component and added […] Continue reading

Posted in 12c, ADF, af:OutputText, af:TreeTable, Delete, Development, Oracle, RowIterator | Comments Off on ADF: Handling deletion in TreeTables

JDeveloper Plugin for Forms2ADF Migration

I’ve migrated my first Oracle Forms module last week. It is the first time for me to be part of a migration project. The colleagues that I am working with instead have a high experience when it comes to ADF and migrating Forms to this technology, while my focus the last couple of years was […] Continue reading

Posted in ADF, Allgemein, Development, Java, JDev, JDeveloper, Migration, Modernization, Oracle, oracle forms, Pitss.Con, Plugin, Upgrade | Comments Off on JDeveloper Plugin for Forms2ADF Migration

ADF Tip: Custom Excel Export Performance

I’ve been working on my first ADF-project the last couple of months and its time for a first blog post regarding ADF-development. We had the requirement to export data from the new developed ADF-Application to Excel. The standard Excel Export functionality was not sufficient, since also the chosen search criteria and other values should be […] Continue reading

Posted in ADF, Development, docx4j, Excel Export, Oracle, Performance | Comments Off on ADF Tip: Custom Excel Export Performance

Update: jp2launcher.exe workaround

So, first post in the year 2016 – its gonna be a short one 🙂 In a previous post in this blog I mentioned a problem for using the webstart in Oracle Forms 11g: That the jp2launcher.exe process will not be terminated automatically when the webstart window is closed (view post). I ran a few […] Continue reading

Posted in 12c, Development, Java Webstart, JP2LAUNCHER, Oracle, oracle forms, Webstart | Comments Off on Update: jp2launcher.exe workaround