Skip navigation.

Feed aggregator

Dynamic Actions in APEX

Patrick Barel - Fri, 2011-07-08 05:07

After visiting the OPP/APEXPosed conference in Brussels I decided to write a post on how to create a relatively simple dynamic action in APEX. When you are working with password fields your only visual check to see if the entered text in both fields match may be the number of characters entered. Of course you can check for equality on submit but that may be a bit too late for the user.

For this post I will work with a textfield instead of a password field, but both will work the same.

First of all we create a page.

A simple blank page will do.

Give it a title.

Add a simple HTML region to hold the items.

Don’t use tabs (for this demo ;-))

Review what you just chose:  and press Finish.

The page should be created succesfully:

The page rendering part should look something like this:

When you open the context menu on the region you can choose to create a Page Item:

For the demonstration we will choose Text Field (that way what we enter will be visible)

Give the item a name:

Give the item a label:

Review the chosen options:

The item doesn’t have to be conditionally displayed so you can just press ‘Create Item’ here:

Repeat these steps for the second page item:

 

 

 

Now the page rendering portion will look something like this:

Using the context menu we can Create a Dynamic Action.

Give it a name and possibly a sequence.

Choose the event to use for this Dynamic Action to fire. In this case I think On Key Release will be the best choice. Choose the Selection Type, this action will rely on changes of items. Choose the items you want to fire this action.  In condition choose the kind of condition you want to use. Choose JavaScript Expression and type in your Javascript expression.

document.getElementById(’P100_TEXTFIELDA’).value ==

document.getElementById(’P100_TEXTFIELDB’).value


 

Then select the kind of Dynamic Action you wish to create. We will be creating an Advanced Action

 
Select what you will be doing when the condition evaluates to TRUE:

In this case we want to change the background color of the textbox, so we choose to Set the Style. We also want to execute this action when the page is loaded.

When the condition evaluates to FALSE we want to do the same action, but with a different color

Then select the kind of page elements you want to be affected by this dynamic action.

Next we choose on which fields this dynamic action will fire:

  

The Dynamic action now shows up in the Page Rendering section of our page.

Running the page shows our Dynamic Action in action:

 

I hope this helps in your understanding of the process of building Dynamic Actions in APEX. Of course this is a pretty simple example and you can probably come up with better ideas for the use of Dynamic Action, but as you can see, this is done with next to no coding (just the Javascript for the condition took some coding).

KScope 11

Patrick Barel - Wed, 2011-06-01 02:31

About 4 weeks from now KScope11 will be well underway. I am really looking forward to attending this conference. I think it is more ‘developer-centric’ than for instance Oracle Open World is. I still have to create my schedule for the days, but I know of at least one session where I will be present.

That will be my own session on Pipelined Table Functions. It will be on Tuesday, June 28th. Here’s the abstract of my presentation:

“If you can do it in SQL, use SQL.” But sometimes even the very powerful version of SQL that Oracle provides is not enough and you need more, like loops, conditions, etc. If you can make the output of a function like it’s a table, then you can use it in SQL and have access to all the power PL/SQL provides. After this session, you will know how to create functions that can be used as tables in SQL.

Before that I will do a preview session (or test run if you will) on Tuesday, June 14th at AMIS in the Netherlands. If you are not attending KScope11 in Long Beach and you live in or near the Netherlands then you are invited to join us. If you are attending KScope11 then you are of course invited to join me there.

Hope to meet you either in Nieuwegein or in Long Beach.

EBS Technology Stack Blog in transition

Steven Chan - Wed, 2011-03-16 10:17
I started this blog in 2006 as a personal experiment. Since then, this blog has morphed into a combination of a breaking news source and a wide-ranging reference library. Over the years, I've deliberately established an editorial policy of ensuring that we break EBS techstack news to you in real-time, free of hype and unvarnished by marketing considerations. It now includes contributions from almost thirty guest authors. We've collectively published about 800 articles, fielded over 5,200 comments, and handled countless emails from readers. We get millions of pageviews per year, and there are over a million incoming links to our published articles. This blog's success has been an object lesson in how a small, personal experiment can take on a life of its own. I still manage this blog in my free time, mostly, but it now lives in an odd grey area somewhere between my official job responsibilities and a personal project. Things are about to change I fully understand the importance of this site to you. Unfortunately, there are major changes underway that will dramatically affect this blog. I am working with our executive management team to investigate options for preserving both our ability to get breaking news to you as well as preserving the reference library functions that you've come to rely upon. In the meantime, I'm saddened to report that this blog is on hiatus. We won't be publishing new articles or announcements. Comments have been frozen. This is temporary, but I don't have a date yet when we'll get back into our normal swing of things. Stay tuned. I'll post more updates here as soon as possible. Regards, Steven Chan Chief Editor Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Be-Ice Consulting is now open in Belgium

Borkur Steingrimsson - Sat, 2011-03-12 09:29

First-class services for Oracle Business Intelligence in Belgium

Oracle E-Business Suite Plug-in 4.0 Released for OEM 11g (11.1.0.1)

Steven Chan - Fri, 2011-02-25 11:01
We're very pleased to announce the release of Oracle E-Business Suite Plug-in 4.0, an integral part of Application Management Suite for Oracle E-Business Suite. ams-ebs.png The management suite combines features in the standalone Application Management Pack (AMP) for Oracle E-Business Suite and Application Change Management Pack (ACMP) for Oracle E-Business Suite with Oracle's real user monitoring and configuration management capabilities. The features that were available in the standalone management packs are now packaged into the Oracle E-Business Suite Plug-in 4.0, which is now fully certified with Oracle Enterprise Manager 11g Grid Control. This latest plug-in extends Grid Control with E-Business Suite specific management capabilities and features enhanced change management support. The Oracle E-Business Suite Plug-in is released via patch 8333939. For the AMP and ACMP installation guide, see: * Getting Started with Oracle E-Business Suite Plug-in Release 4.0 (Note 1224313.1) Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

New Oracle E-Business Suite R12 OS and Tools Requirements on IBM AIX on Power Systems

Steven Chan - Thu, 2011-02-24 13:08
IBM has announced May 1st, 2011 as the end of Support for Version 8 of the IBM XL C/C++ compiler currently used for Release 12 builds and patching. The target date of the switchover -- May 1st 2011 -- corresponds to when this older compiler will no longer be supported by IBM. Beginning on May 1st 2011, Oracle E-Business Suite patches for Release 12 (12.0, 12.1) on the IBM AIX on Power Systems platform will be built with Version 9 of the IBM XL C/C++ compiler. Customers who plan to patch or upgrade their E-Business Suite R12 environments after May 1st, 2011 must meet all the new requirements prior to applying new patches or upgrades. John Abraham
Categories: APPS Blogs

Windows 7 Service Pack 1 Certified with E-Business Suite

Steven Chan - Wed, 2011-02-23 12:25
There are three possible configurations for Windows 7 desktop clients: 1. 32-bit Windows 7, 32-bit browsers, 32-bit JRE 2. 64-bit Windows 7, 32-bit browsers, 32-bit JRE 3. 64-bit Windows 7, 64-bit browsers, 64-bit JRE We certified the first configuration in December 2009: E-Business Suite with 32-bit Windows 7 desktop clients running 32-bit versions of Internet Explorer (IE) and Firefox with the 32-bit JRE. We certified the second configuration in September 2010: E-Business Suite with 64-bit Windows 7 desktop clients running 32-bit versions of IE and Firefox with the 32-bit JRE. I'm pleased to announce that Microsoft Windows 7 Service Pack 1 (SP1) is now certified with both of those configurations for Oracle E-Business Suite 11i and Oracle E-Business Suite R12 with the following minimum requirements: Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Reminder: ATG Live Webcast Feb. 24th: Using the R12 EBS Adapter

Steven Chan - Tue, 2011-02-22 13:58
Reminder: Our next ATG Live Webcast is happening on 24-Feb. The event is titled: * E-Business Suite R12.x SOA Using the E-Business Suite Adapter This live one-hour webcast will offer a review of the Service Oriented Architecture (SOA) capabilities within E-Business Suite R12 focusing on the E-Business Suite Adapter. While primarily focused on integrators and developers, understanding SOA capabilities is important for all E-Business Suite technologists and superusers. Bill Sawyer http://www.oracle.com/technology/products/applications/ebs/index.html
Categories: APPS Blogs

Choosing the Right JDeveloper Release for Your EBS Environment

Steven Chan - Mon, 2011-02-21 16:24
For customers and developers who are building OA Framework components and extensions to Oracle E-Business Suite, one of the first questions is "How do I find the right version of JDeveloper?" Sara Woodhull http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Discoverer 11.1.1.4 Certified with E-Business Suite

Steven Chan - Fri, 2011-02-18 16:48
Discoverer 11g (11.1.1.4) is now certified with Oracle E-Business Suite Release. Discoverer 11.1.1.4 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.4.0, also known as FMW 11g Patchset 3. Certified E-Business Suite releases are: * EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher * EBS Release 12.0.6 and higher * EBS Release 12.1.1 and higher Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Oracle Internet Directory 11.1.1.4 Certified with E-Business Suite

Steven Chan - Fri, 2011-02-18 16:31
Oracle Internet Directory 11.1.1.4 is now certified with Oracle E-Business Suite Release 11i, 12.0 and 12.1. OID 11.1.1.4 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.4.0, also known as FMW 11g Patchset 3. Certified E-Business Suite releases are: * EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher * EBS Release 12.0.6 and higher * EBS Release 12.1.1 and higher Oracle Internet Directory 11.1.1.3.0 can be integrated with two single sign-on solutions for EBS environments: * With Oracle Single Sign-On Server 10g (10.1.4.3.0) with an existing Oracle E-Business Suite system (Release 11i, 12.0.x or 12.1.1) * With Oracle Access Manager 10g (10.1.4.3) with an existing Oracle E-Business Suite system (Release 11i or 12.1.x) Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Portal 11.1.1.4 Certified with E-Business Suite

Steven Chan - Fri, 2011-02-18 16:09
Portal 11g (11.1.1.4) is now certified with Oracle E-Business Suite Release. Portal 11.1.1.4 is part of Oracle Fusion Middleware 11g Release 1 Version 11.1.1.4.0, also known as FMW 11g Patchset 3. Certified E-Business Suite releases are: * EBS Release 11i 11.5.10.2 + ATG RUP 7 and higher * EBS Release 12.0.6 and higher * EBS Release 12.1.1 and higher Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases

Steven Chan - Thu, 2011-02-17 12:11
The EBS 12.1.3 Release Content Document (RCD, Note 561580.1) summarizes the latest functional and technology stack-related updates in a specific release. The E-Business Suite Electronic Technical Reference Manual (eTRM) summarizes the database objects in a specific EBS release. Those are useful references, but sometimes you need to find out which database objects have changed between one EBS release and another. This kind of information about the differences or deltas between two releases is useful if you have customized or extended your EBS instance and plan to upgrade to EBS 12.1.3. Where can you find that information? Answering that question has just gotten a lot easier. You can now use a new EBS Data Model Comparison Report tool: * EBS Data Model Comparison Report Overview (Note 1290886.1) This new tool lists the database object definition changes between the following source and target EBS releases: 1. EBS 11.5.10.2 and EBS 12.1.3 2. EBS 12.0.4 and EBS 12.1.3 3. EBS 12.1.1 and EBS 12.1.3 4. EBS 12.1.2 and EBS 12.1.3 Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Sun JRE 1.6.0_24 Certified with Oracle E-Business Suite

Steven Chan - Tue, 2011-02-15 14:13
The mismanaged session cookie issue (now fixed) may have made you a little nervous about automatically applying new JRE updates. To reassure you on that front: * Sun Java Runtime Environment 1.6.0_24 (a.k.a. JRE 6u24) is certified with E-Business Suite Release 11i and 12. * JRE 1.6.0_24 contains the fixes for the mismanaged session cookie issue that were originally released as part of JRE 1.6.0_23. All JRE releases are certified with EBS upon release Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops from JRE 1.6.0_03 and higher. We test all new JRE releases in parallel with the JRE development process, so all JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. In other words, you do not need to wait for a certification announcement before applying new JRE releases to your EBS users' desktops. If you wish, your desktop administrators can enable the Java "Automatic updates" option on your end-users' desktops. Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

EBS 12.0 Minimum Requirements for Extended Support Finalized

Steven Chan - Tue, 2011-02-15 13:53
Oracle E-Business Suite Release 12.0 will transition from Premier Support to Extended Support on February 1, 2012. New EBS 12.0 patches will be created and tested during Extended Support against the minimum patching baseline documented in our E-Business Suite Error Correction Support Policy (Note 1195034.1). These new technical requirements have now been finalized. To be eligible for Extended Support, all EBS 12.0 customers must apply the EBS 12.0.6 Release Update Pack and a set of technology stack infrastructure updates and updates for EBS products if they're shared or fully-installed. The complete set of minimum EBS 12.0 baseline requirements are listed in: * E-Business Suite Error Correction Support Policy (Note 1195034.1) Steven Chan http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

ATG Live Webcast Feb. 24th: Using the EBS 12 SOA Adapter

Steven Chan - Mon, 2011-02-14 14:42
Our next ATG Live Webcast is now open for registration. The event is titled: * E-Business Suite R12.x SOA Using the E-Business Suite Adapter This live one-hour webcast will offer a review of the Service Oriented Architecture (SOA) capabilities within E-Business Suite R12 focusing on the E-Business Suite Adapter. While primarily focused on integrators and developers, understanding SOA capabilities is important for all E-Business Suite technologists and superusers. Bill Sawyer http://www.oracle.com/technology/products/applications/ebs/index.html
Categories: APPS Blogs

ATG Live Webcast Replay Available: EBS 12 OAF Rich UI Enhancements

Steven Chan - Thu, 2011-02-10 11:50
The E-Business Suite Applications Technology Group is thrilled at the response to our first ATG Live Webcast. Following up to that event, I am pleased to provide the links to replay the event and download the presentation file. The Latest E-Business Suite R12.x OA Framework Rich User Interface Enhancements Original Recording Date: Thursday, January 27, 2011 Replay Link (Note: You will need an Oracle.com account to view the replay.) Presentation Download Link Bill Sawyer http://www.oracle.com/technology/products/applications/ebs/index.html
Categories: APPS Blogs

New Whitepaper: Upgrading EBS 11i Forms + OA Framework Personalizations to EBS 12

Steven Chan - Wed, 2011-02-09 12:25
Personalizations are -- and have always been -- one of the safest and most upgradable ways to "customize" your Oracle E-Business Suite screens, both for Oracle Forms-based screens and for Oracle Application Framework-based pages. However, the upgrade from Release 11i to Release 12.1 spans many years of EBS evolution, during which time Oracle has actively been building many new features and modules. A lot has changed in Oracle E-Business Suite that may affect upgrading your personalizations from 11i to 12.1. We have published a new note on My Oracle Support that discusses ways to evaluate your existing personalizations: * Upgrading Form Personalizations and OA Framework Personalizations from Oracle E-Business Suite Release 11i to 12.1 (Note 1292611.1) Sara Woodhull http://blogs.oracle.com/stevenChan/about.html
Categories: APPS Blogs

Safari 5 certified with EBS Release 12 on Apple Mac OS X 10.5 and 10.6

Steven Chan - Sun, 2011-02-06 15:52
Oracle E-Business Suite Release 12 (12.0.4 or higher, and 12.1.2 or higher) is now certified with the Safari 5 browser on the following Apple Mac OS X desktop configurations: Mac OS X 10.5 ("Leopard") * Mac OS X 10.5 ("Leopard" version 10.5.6 or higher) along with any other security and Java updates listed in the 'Software Update' program on the Mac * Safari version 5 (5.0.2 or higher) * Apple Java/JRE plugin 5 (1.5.0_13 or higher) Mac OS X 10.6 ("Snow Leopard") * Mac OS X 10.6 ("Snow Leopard" version 10.6.3 or higher) along with any other security and Java updates listed in the 'Software Update' program on the Mac. * Safari version 5 (5.0.2 or higher) * Apple Java/JRE plugin 6 (1.6.0_20 or higher) John Abraham
Categories: APPS Blogs

Oracle Discoverer (10.1.2.3) certified with EBS R12 on IBM: Linux on System z

Steven Chan - Mon, 2011-01-31 12:50
Oracle Discoverer 10g (10.1.2.3) is now certified with E-Business Suite Release 12 (12.1.2 or higher) on the IBM: Linux on System z platform. With this certification, Oracle Application Server 10g (10.1.2.3) is now fully certified with E-Business Suite on Linux on System z. Specifically, the following OracleAS 10.1.2.3 components are now certified for external integration with E-Business Suite R12 environments: * Single Sign-On 10.1.2.3 * Oracle Internet Directory 10.1.2.3 * Discoverer 10.1.2.3 * Portal 10.1.4.2 (as included in OracleAS 10.1.2.3) * Web Cache 10.1.2.3 John Abraham
Categories: APPS Blogs