Change Item Position using jQuery

Denes Kubicek - Sun, 2016-02-28 07:51
See this example on how to change the item position. In APEX you can position the buttons after the action bar in an interactive report. However, you can't put the items there. Using jQuery this is easy to achieve.

Categories: Development

React on Tab Change

Denes Kubicek - Sun, 2016-02-28 07:47
See this example on how to react on tab change in APEX 5. The problem is to determine the right selector to trigger the corresponding dynamic action. Thanks Christian Rokitta for your help.

Categories: Development

First Steps with Oracle Application Builder Cloud Service

Shay Shmeltzer - Wed, 2016-02-24 19:22

Last week we released a new cloud service - the Oracle Application Builder Cloud Service.

(I'll refer to is as ABCS here to keep it short).

ABCS is built for the non-professional developer, what some call the citizen developer, giving them a solution to very quickly build and publish applications that can address immediate business needs. As you'll see in the demo below, a UI first approach makes development very simple.

I recorded a quick demo to show you just the basics of app development and wet your appetite.

As you'll see ABCS makes it dead simple to create Web apps, define business objects that you want to track (implemented as tables in an Oracle cloud database instance), and fine tune the UI creating multiple forms. The underlying UI technology of both ABCS and the apps that it creates is Oracle JET. 

Note that in this video I didn't cover the steps to actually stage and then publish your application so other users can access it - another thing that ABCS makes simple. On these and other capabilities in future blogs...

Categories: Development

Advanced SQL Webinar on February 23

Gerger Consulting - Mon, 2016-02-22 06:58
On February 23, Oracle ACE Kim Berg Hansen is hosting a free webinar about pattern matching with SQL in Oracle 12c. More than 140 developers have already signed up. Register at this link.

Categories: Development

ASR Summary Cheat sheet for Exadata and Enterprise Manager12c

Arun Bavera - Wed, 2016-02-17 11:19
What is ASR:

Phone Home feature for Engineered System View the ASR Demo Video.
ASR resolves problems faster by automatically opening service requests for Oracle's qualified server,  storage, and Engineered Systems when specific faults occur.

Note: From EM13c  onwards ASR is integrated directly.

How to use ASR 

1. ASR can be installed in External system Linux or Solaris. (Small RPM package) We can install it in our OMS box.
2. Requires communnication between ExaData Assets where ASR monitoring is valid.
     4.15.1 ASR Port Usage  
3. Requires Communication to
4. ASR can send same SR Creation info to Omnibus via SNMP Trap.
      4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:

ASR Manager systems require Oracle Java 7 - JDK 7 (JDK 1.7.0_13) or later JDK 7 updates or Oracle Java 8 (1.8.0_25 or later).
Oracle Linux 5.3 or later. Red Hat Enterprise Linux 6.3 or later.
For IPv6, the ASR Manager server needs to be enabled for dual stack IPv6/IPv4

Test from designated ASR Manager server below:
telnet 443
/usr/bin/wget (

1. Set-up firewall rules to allow bi-directional SNMP/UDP traffic to traverse between ASR Assets and the ASR Manager.
2. Ensure that ASR assets can send SNMP telemetry data out on port 162 to the ASR Manager. ( test using OneCommand)
3. Ensure that the ASR Manager can communicate with Service Tags on ASR asset, via http, using port 6481.
4. If your environment requires SNMP v3 to use the Oracle ASR service, you will need to configure both ASR Manager and any ASR Assets. See  
   Configuring ASR Manager for SNMP v3 and Optional ILOM Setup: SNMP v3 for ASR Assets for more information in Chapter 2.
5. Verify Telemetry on each component valid for ASR monitoring -
6. Verify MOS account: MOS accont and SupportIdentifier How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1):
7. Install ASR Manager -
          Install ASR Manager -
  Test connectivity:
  Register  ASR with Oracle Support:
                      asr> register
 asr> show_reg_status
 asr> test_connection ( /opt/asrmanager/bin/asr test_connection)
 asr> autoupdate
 asr> show_version

 service asrm stop
 tar -cvf /var/opt/asrmanager/db
 tar -cvf /var/opt/asrmanager/configuration
 service asrm start
 asr> send_deactivations -a
 asr> send_activations -a
 asr> list_asset
 asr> disable_asr_manager <1 48="" hours="" to="">
 asr> enable_asr_manager
 asr> disable_asset -i IP_address
 asr> enable_asset -i IP_address
 asr> send_test -i IP_address
 asr> send_test -h host name
 asr> deactivate_asset -i IP_address
 rpm -e asrmanager;rm -rf /var/opt/asrmanager/

 asr>  set_property snmp.receiver.port 1162
 asr>  get_property snmp.receiver.port
 service asrm restart

8. Configure ASR Assets -
Activate Exadata Assets.--

Check the Service Tag:  http://asr_system_hostname:6481/stv1/agent/

9. Pre-check Engineered Systems ASR Configuration Check via ASREXACHK (Doc ID 1450112.1) to verify the ASR deployment.
10. Approve ASR assets refer
How To Manage and Approve Pending ASR Assets In My Oracle Support (Doc ID 1329200.1)
11. Audit log at /var/opt/asrmanager/log/auditlog
12. Check ASR Email
13. Create Test Alert - ILOM - Refer
14. Check Ports: -4.15.1 ASR Port Usage
15. Configure ASR to send SNMP traps to Command center: 4.16.1 Managing SNMP Trap Destinations for Service Request Notifications:  
  asr> set_notification_trap [-i ipAddress -p port -c community] [-h hostname -p port -c community]
  asr> set_notification_trap -i -p 162 -c public
  asr> show_notification_trap
  asr> delete_notification_trap -i
  asr> send_test [-i ipAddress] [-h hostname]
  The SUN-ASR-NOTIFICATION-MIB file is located at:
16. Troubleshooting:

Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide 5.5.1

Oracle® Auto Service Request Exadata Database Machine Quick Installation Guide
Release 5.5

Categories: Development

How to Do Pattern Recognition with SQL in Oracle 12c

Gerger Consulting - Tue, 2016-02-16 08:03
More than 120 developers have signed up for Kim Berg Hansen's webinar about pattern recognition with SQL in Oracle 12c. Sign up for this free webinar if you want to improve your SQL skills and learn from the best.
Categories: Development

Taking backup of AIA Middleware Domains Excluding log files

Arun Bavera - Wed, 2016-02-10 15:24

tar -zcvf /opt/app/oracle/BACKUP/AIA_MSERVER.tar.gz --exclude='core.*'  --exclude='*.log*'  --exclude='*.out*'  --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/mserver/aia01_domain

tar -zcvf /opt/app/oracle/BACKUP/AIA_ASERVER.tar.gz --exclude='core.*'  --exclude='*.log*'  --exclude='*.out*'  --exclude='*ConsumeFaultMessage*.dat' /opt/app/oracle/fmw_domains/aia_domain/aserver/aia01_domain


Categories: Development

How to get nfs info on 1000 or many hosts using Oracle Enterprise Manager

Arun Bavera - Fri, 2016-02-05 11:27
There was a requirement to get nfs info on all the hosts.
Here is the way to get it:

Create a OS JOB in EM12c with following text and execute on all interested hosts. Assuming you have common shared mount on all these hosts.
Otherwise you can create Metric Extension to collect this info and query repository using Configuration Manger or directly to get this info.
 echo -e `echo '\n';hostname --l;echo '\n=====================================\n';nfsstat -m;echo '\n=====================================\n';exit 0` >> /nfs_software/nfs_info_PROD.txt

Categories: Development

Agile Development with Oracle Developer Cloud Service and JDeveloper 12.2.1

Shay Shmeltzer - Tue, 2016-02-02 18:49

I blogged in the past about using Oracle Developer Cloud Service (DevCS) together with JDeveloper/ADF to manage your code and automate your builds.

Since I wrote those blog entries, we released a new version of JDeveloper (12.2.1) that added deeper integration with the Developer Cloud Service functionality for tracking tasks/issues. In parallel Developer Cloud Service also added various features with one of the new areas being covered is managing sprints and an agile development processes

I thought it might be interesting to show some of the new features of both products working togethers.

In the video below you'll see how to:

  • Connect to DevCS and its projects from inside JDeveloper
  • Leverage the Team view in JDeveloper (tasks, builds, and code repositories)
  • Interact with Tasks/Issues in JDeveloper
  • Handle Git transactions
  • Associate code commits with specific tasks
  • Monitor team activity in the Team Dashboard
  • Create Agile boards and manage sprints in Developer Cloud Service

One other interesting feature I'm not showing above is the ability to do code reviews on your code by team members - before those are merged into your main code line.

If you want to try Developer Cloud Service out, just get a trial account of the Oracle Java Cloud Service - and you'll get an instance of the Developer Cloud Service that you can use to test this new way of working. 

Categories: Development

Free SQL Webinar by Oracle ACE Kim Berg Hansen

Gerger Consulting - Tue, 2016-01-26 06:55
Join us on February 23 at 14:00 CET (07:00 EST) with our guest host Oracle ACE Kim Berg Hansen presenting “Use Cases of Row Pattern Matching in Oracle 12c”

In this month’s free webinar, you’ll learn how you can use Oracle’s pattern recognition features to gain actionable insights from your organization’s or client’s data.

Let’s hear from Kim why you should attend this webinar:

In recent years, pattern recognition has been a very hot topic in business intelligence. Being able to use SQL for pattern recognition is one of the must-have skills if you are working in the BI field. At ProHuddle, we’ll continue to study pattern recognition with more webinars in the upcoming months.
Categories: Development

Highlight numbers in an APEX Report (SQL and Class)

Dimitri Gielis - Wed, 2016-01-20 09:31
Last year I blogged about highlighting negative numbers in an APEX Report, the CSS only way.
At that time I gave two alternative approaches; by using JQuery or SQL, but it looks like I didn't do those posts yet, till somebody reminded me. This post is about using SQL to highlight something in a report.

Let's say we want to highlight negative numbers in a report (as in the previous post):

We have some CSS defined inline in the Page:

.negative-number {

The negative-number class we will add to some values. All the logic to know if it's a negative number will be in SQL. Why SQL you might ask? This example is very simple, but you could call a function which has a lot of complexity to decide if you want to assign a class to a record or not, the principe of this example is more important, that you can use logic in SQL to work with CSS.

The SQL Query of the Report looks like this. Watch for the case statement where we say when to assign a value for the class:

   when amount < 0
   then 'negative-number'
   else ''
 end as class
from dimi_transaction
order by id

Finally we assign the class to the amount, by adding a span in the HTML Expression of the Amount column:

The Class column you can make Conditional = Never as it's something we just use behind the scenes.

That's how you make a bridge between SQL and CSS.

You can now play more with the case statement and even let the class or style e.g. color, come from a user defined table... unlimited possibilities :)

Categories: Development

APEX Dashboard Competition

Denes Kubicek - Sun, 2016-01-17 15:01
APEX Dashboard Competition initiated by Tobias Arnhold is now online. If you want to compete against your colleagues all you need to do is to create a nice looking dashboard based on the prepared set of data, crate a packaged application and send it to the jury. You can apply here: Submit your application and win some nice prices. Hurry up. The closing is on Friday the 1st of April 2016.

Categories: Development

Netflix for Webinars

Gerger Consulting - Tue, 2016-01-12 01:35
This February, we are launching ProHuddle, a website where you can find high quality webinars for every topic you are interested in.

Our core community consists of Oracle professionals, so we’ll start with Oracle related topics and branch off from there to other areas.

Benefits of ProHuddle for You
It’s free Attending conferences can be expensive. ProHuddle brings you high quality presentations for free.

Content DiscoveryYou miss a lot of content you might enjoy, simply because you never hear about it. ProHuddle curates presentations, surfaces the best ones and notifies you about them. You’ll have access to presentations from all over the world, connecting you to the experts from everywhere.

Easy to Attend Attending conferences can be time consuming. You can attend ProHuddle webinars from the comfort of your home or your office, on any device.

More Engaging Presentations have time constraints. At ProHuddle, there is no next presentation to catch or to clear the room for. The presenter has as much time as she needs to deliver her message, answer questions and interact with the audience (which is to me the best part of all).

If you are a curious, open minded person, with an interest in new people, ideas, products and technologies, sign up at We are launching in February 2016!
Categories: Development

Powerful Free Webinar Network for Oracle Developers

Gerger Consulting - Tue, 2016-01-05 07:15
In February 2016, we are launching ProHuddle, a community of curious, open minded people who love to learn about interesting people, ideas, technologies and products to help them improve their personal and professional lives.

Our community largely consists of Oracle Professionals. It is a great mix of developers, DBA’s, software designers, enterprise architects, consultants, managers and executives who in one way or the other are involved with Oracle Technologies.

We’ll host free webinars which will appeal to such an audience. We’ll start with Oracle related topics such as SQL, Java, the Oracle Database and other Oracle products.

If this sounds interesting to you, visit the ProHuddle web site and sign up for our email list to get notified about upcoming webinars. (Don’t worry, we will never spam you. We will never share your email with a third party and it takes only one click to unsubscribe.)

Looking forward to meeting you in our webinars!

Yalim K. Gerger

Categories: Development


Greg Pavlik - Thu, 2015-12-24 09:24
Shadows flicker against the wall
within the cave it is perpetually night
(I find my vision gets dimmer with age
- when we are alleged to see more sharply -
in the low light of a single candle flame
it is getting much harder to read
year by year)
there is a form I barely am able to perceive.
I wonder if it is better here than the open air
where my eyes would surely be closed against the sun
where all forms find their origin in the one.


Remove Blanks from Formated Date Column

Denes Kubicek - Tue, 2015-12-22 02:31
This small example is showing how powerful jQuery is and how easy it is to use it in APEX. In this case, I needed to correct the oracle formatting, which adds blanks to the name of the day prior to comma. Probably oracle RPAD's the day names to the longest (Wednesday). Those are showing in APEX as one blank - see the left column. The only good way to go around that annoying side effect is to use jquery and basically one line of code.

Categories: Development


Greg Pavlik - Sun, 2015-12-20 23:11
Blown away to get my purple belt in Brazilian Jiu Jitsu from 10th Planet black belt Alex Canders.

How to monitor Weblogic correct HEALTH STATE using EM12c Metric Extension

Arun Bavera - Fri, 2015-12-04 17:00
Requirement is to know failed status of Weblogic Servers.

For Weblogic 11g:

EM12c: How to Monitor WebLogic Server Health Status in Enterprise Manager 12c Cloud Control (Doc ID 1984804.1)

Categories: Development

APEX Feature Request

Denes Kubicek - Thu, 2015-12-03 01:41
Just created a new feature request for APEX at … Extend Interactive Report API - Get IR Query. The feature request is abut the following:

"This API should deliver a couple of different SQL statements for an interactive report. There are several possible requirements I can think of:

1. IR query including visible columns and filter values - actual SQL for the user session,
2. IR query including all columns and the original SQL,
3. get column names of an IR with or without column alias,...

Having this SQL we should be able to run it as EXECUTE IMMEDIATE, without having to replace any binds.

This feature could be included in the actions menu and available as a plugin for dynamic actions - new dynamic action feature (action)."

Please, feel free to go there and vote for it.

Categories: Development

How to fix Putty timeout issue

Arun Bavera - Tue, 2015-12-01 14:00

Set this in Putty/SuperPutty:


Categories: Development


Subscribe to Oracle FAQ aggregator - Development