Fun with Bubbles!

I'm on a train up to Liverpool for the UK Oracle User Group Tech 14 conference, and decided it's about time for a post showing something I've been working on.  I don't post often these days, which I blame on work and family commitments, but is actually just down to pure laziness.  Anyhow, I'm feeling in the mood so I'll just get on with it in case the desire to catch some zzz's becomes overwhelming. (more...)

Good Blog Bad Blog

Just checked if the http://www.odtug.com/apex is available again and it is. It seems the people there are filtering blogs because I don't see my blog post from yesterday appearing there and I don't understand why. Is that just because I said that the old blog listing was much better? Or this is just another technical problem they have? Am I going to be removed from that blog listing forever if I continue saying (more...)

APEX, HTML und Jahresausklang…

Die letzten Wochen waren verdammt arbeitsintensiv und es wird bis Weihnachten nicht viel besser werden. Meetings, Telko's, PL/SQL, SQL, APEX alles verpackt in unterschiedlichsten Projekten.

Umso mehr waren die 3 Tage #DOAG2014 eine gute Erholungspause und eine Quelle für neue Motivation und Ideen.

Mein eigener Vortrag zum Thema "Dynamisches Arbeiten mit Grafiken in APEX" kam sehr gut an und zeigt einmal mehr das APEX Enthusiasten auch am letzten Tag 09:00 Uhr bereit sind sich weiterzuentwickeln. (more...)

You shouldn’t think this happens only to you

Since several hours I am getting this while trying to access all blogs at http://www.odtug.com/apex. It seems that this list has a lots of problems listing all the relevant APEX blogs. The previous version from Dimitri was so much better and user friendly.

From Zero to Hero….In About 2 Hours



This is an example of a real-world problem, an opportunistic one, being solved via a mobile application created with Oracle Application Express.

First, a brief bit of background.  Our son is 9 years old and is in the Cub Scouts.  Cub Scouts in the United States is an organization that is associated with Boy Scouts of America.  It's essentially a club that is geared towards younger boys, and teaches them many valuable skills - hiking, (more...)

Value Placeholder

Did you know that you can use Value Placeholder in your page items to display hints for the users? This is a quite neat feature you can implement without using different plugins for displaying hints. It will also work with the APEX ampersand substitution strings like

&P1_ITEM.

Here is how it looks like. Be carefull with this. It will work only for the browsers supporting HTML5.

APEX Worst Practices – Survey

As preparation for my Presentation about Worst Practices in Oracle APEX I set up a survey using the Survey Builder Packaged Application.

Please help out and fill in the survey: https://apex.oracle.com/pls/apex/f?p=80076:Q::AAAW

There will be a follow up post with details on worst practices and survey results.

 

Thanks for your time,

Peter

APEX 4.2 interactive report with row detail

Interactive report with the functionality to show a detail row per each row

APEX Tabular Forms Deep Dive at #ORCLAPEX NYC Meetup

Ever heard of APEX$ROW_NUM, APEX$ROW_SELECTOR and APEX$ROW_STATUS? Did you know you can reference tabular form columns using bind variable syntax in your page processes? Are you familiar with the execution scope of tabular form proecesses for modified vs submitted rows? Ever struggled using apex_application.g_fxx arrays with checkboxes? And do you really need to use the apex_item APIs? In APEX 4.0, 4.1 and 4.2 we've introduced lots of new tabular form features, (more...)

APEX Connect 8th and 9th of June 2015 in Duesseldorf Germany

APEX Connect is the first big APEX event in Germany and will be taking place in Duesseldorf on 8th and 9th of June 2015. You can still apply for a presentation using this link. I will be there with a presentation on APEX Plugins. As far as I know a couple of international guests are expected to be there as well. This event will for sure be interesting and informative so you should think about (more...)

MS Sharepoint and Oracle APEX integration

At Oracle Open World I gave a presentation about the integration of Microsoft Sharepoint and Oracle Application Express (APEX).

I see a lot of companies using Microsoft Sharepoint as portal for their intranet. For many people it’s the first place they go to when they start their day. But to do their job they make also use of other applications, some which are build in Oracle Application Express (APEX). This presentation will show the different (more...)

APEX and shuttle filter

How to create filter / search field for APEX shuttle item values using jQuery.

APEX 5.0 verschiebt sich

APEX 5.0 wird erst im Jahr 2015 erscheinen!

Alle Details findet Ihr hier: https://blogs.oracle.com/apexcommunity_deutsch/de/entry/openworld_update_application_express

Imho: Qualität hat seinen Preis! :)

APEX 5.0 New Features – Terminverschiebung

leider müssen wir den Termin für den bei uns gebuchten Kurs "Oracle APEX 5.0: New Features" (Termin: 08/09.12.2014) auf den Februar 2015 (09.02/10.02) aus gegebenem Anlass verschieben.

Wie Sie/Ihr bereits bestimmt erfahren haben, wird sich das Release von Oracle APEX 5.0 etwas verschieben: https://blogs.oracle.com/apexcommunity_deutsch/de/entry/openworld_update_application_express.

Sie können sich hier zum Kurs anmelden.

Is Oracle Application Express supported?


Time to clear up some confusion.

In the past 60 days, I have encountered the following:
  • Two different customers who said they were told by Oracle Support that "APEX isn't supported."
  • An industry analyst who asked "Is use of Oracle Application Express supported?  There is an argument internally that it cannot be used for production applications."
  • A customer who was told by an external non-Oracle consultant "Oracle Application Express is good for a (more...)

Oracle APEX 5 Update from OOW

The big news about Oracle APEX from OOW is not so much about what, but more about when.  Much to many people's disappointment, APEX 5.0 is still going to be a few months out.  The "official" release date has been updated from "calendar year 2014" to "fiscal year 2015".  For those not in the know, Oracle's fiscal year ends on May 31st, so that date represents the new high-water mark.

Despite this bit of (more...)

APEX 4.2.6 patch available

Oracle released APEX 4.2.6 yesterday, it's also available from My Oracle Support as a patch set 19595896.

Here's the table of bug fixes.

Table 6 Bugs Fixed in the Oracle Application Express 4.2.6.00.03 Patch Set
Bug NumberDescription
18393429
Importing pre-4.2 application with data loading results in runtime error
18609856
APEX_WEB_SERVICE.CLOBBASE642BLOB converts incorrectly
18658967
Corrupted HTML mail messages are created from APEX_MAIL.SEND
18719750
ORA-01858 during application (more...)

I am running for the ODTUG Board of Directors

After some thought, I decided I will be running for the ODTUG Board of Directors this year. I have been attending Kscope since 2008 (New Orleans). Presented at Kscope and APEXPosed since 2009. Did a few webinars. Was a member of the APEX Content Team for Kscope12 and 13. And now I am the Content Lead for the APEX track for KScope14 and Kscope15. So I like spending my free time for ODTUG, to keep (more...)

Extending EBS R12.1 and above using APEX White Paper Released

Extending Oracle E-Business Suite Release 12.1 and above using Oracle Application Express Revision 2 has just been released. 

This paper is a major revision which now includes certification for Oracle E-Business Suite Release 12.2 and also an alternate database architecture using Oracle Database links. You can download the paper from OTN: http://www.oracle.com/technetwork/developer-tools/apex/learnmore/apex-ebs-extension-white-paper-345780.pdf





SQL Developer Neue Version & Hidden Features

Es gibt eine neue Version vom Oracle SQL Developer 4.0.3:
http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index.html

Hier noch ein paar Links zu den Hidden Features im SQL Developer
Top 10 Voreinstellungen:
http://www.thatjeffsmith.com/archive/2011/12/top-10-preferences-to-tweak-when-using-sql-developer/

Automatisches öffnen einer Tabelle verhindern:
http://nuijten.blogspot.de/2012/10/sql-developer-tip-dont-open-table.html

Formatiere SQL Code in lower/UPPER:
http://www.apex-at-work.com/2014/07/format-lowerupper-with-sql-developer.html

Verbindung zu anderen Datenbanken herstellen:
http://www.thatjeffsmith.com/archive/2012/01/sql-developer-supports-db2-sybase-mysql-access-and-teradata/
http://kentgraziano.com/2013/01/14/tech-tip-connect-to-sql-server-using-oracle-sql-developer/

Wenn Ihr noch nicht allzu viel Erfahrung mit dem SQL Developer habt, dann solltet Ihr euch diese Seiten mal anschauen:
http://www.thatjeffsmith.com/sql-developer/
http://www.oracle.com/technetwork/articles/sql/exploring-sql-developer-1637307.html
http://www.oracle.com/technetwork/developer-tools/sql-developer/learnmore/index.html