Skip navigation.

Feed aggregator

Quiet Release MySQL Plugin 12.1.0.1.2 — bug fixes

Alex Gorbachev - Tue, 2012-12-11 12:30
This is just a small bug fix release of the plugin. It was actually quietly released for a while now of if you have downloaded the plugin recently, you have the latest version. To be sure — check the version in the Console or you will see it in the file name. There are two [...]
Categories: APPS Blogs

Movember 2012: The ‘stache returns!

Dan Norris - Tue, 2012-10-30 07:16

In 2011, I joined many others in the Movember event for the first time. This is a fund-raising effort where participants grow a mustache for the month of November and collect donations to support men’s health, specifically prostate and testicular cancers. Individuals can participate on their own or as a team, but no matter what you donate, it all goes to the same place. In my first year, I managed to collect $754 from 15 donors! Hopefully, I’ll exceed my previous year’s fundraising this year…just not sure what mustache style will bring in the most money yet?!

To see photo updates of how my ‘stache is coming along and to make donations, go to my page on Movember. Thanks for any donation you can make!

IOUG Big Data SIG — Kick-off Meeting at OOW12

Alex Gorbachev - Thu, 2012-09-27 16:47
Announcing the IOUG Big Data Special Interest Group (SIG)! We have the SIG meeting at Oracle Open World — come join us with you morning coffee. Nothing better than starting your Big morning with Big Data talks! Yes — we actually managed to get the room at this busy times at OOW thanks to IOUG. [...]
Categories: APPS Blogs

IOUG Collaborate 2013 — Call for Speakers Informational Webinar

Alex Gorbachev - Tue, 2012-09-11 04:28
As I’ve become Director of Communities for IOUG recently, I’m intimately involved in many aspects of leading IOUG community. One of the area the user group is pursuing all the time is finding the new speakers and that takes some part of convincing the community members to actually start presenting. There are many of you [...]
Categories: APPS Blogs

Oracle OpenWorld 2012 – Bloggers Meetup

Alex Gorbachev - Thu, 2012-09-06 13:40
Oracle OpenWorld 2012 is just over a month away and yes we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of the OpenWorld. What: Oracle Bloggers Meetup 2012 When: Wed, 3-Oct-2012, 5:30pm Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103 (street view). [...]
Categories: APPS Blogs

Announcing MySQL Plugin 12.1.0.1.0 for Oracle Enterprise Manager 12c Cloud Control

Alex Gorbachev - Thu, 2012-08-30 12:00
MySQL management plugin for EM 12c has been long overdue. I’ve initially migrated the older plugin to EM 12c about 6 months ago and few dozen people received this as initial beta of the plugin. It worked OK but didn’t use any of the 12c new features and its home page was a bit of [...]
Categories: APPS Blogs

Advert: few Oracle Database Appliances at significant discount

Alex Gorbachev - Wed, 2012-08-29 16:19
This blog is a little bit self serving and I’d normally not post it but I think that it would be an awesome deal for those of you who are thinking of buying an Oracle Database Appliance now. We have several just two left brand new, unopened ODAs left in our inventory that we need [...]
Categories: APPS Blogs

How to Prevent Manual Entries to System Accounts

Marian Crkon - Tue, 2012-08-07 23:21
There is a new feature in Oracle General Ledger R12 (12.1.3), which lets you define an additional qualifier called Third Party Control on your natural account values. You can set the Third Party Control qualifier for your accounts to be only used by Payables (Supplier) or Receivables (Customer), or prevent any manual entries (Restrict manual … Continue Reading 0

How to Prevent Manual Entries to System Accounts

The Feature - Tue, 2012-08-07 23:21
There is a new feature in Oracle General Ledger R12 (12.1.3), which lets you define an additional qualifier called Third Party Control on your natural account values. You can set the Third Party Control qualifier for your accounts to be only used by Payables (Supplier) or Receivables (Customer), or prevent any manual entries (Restrict manual … Continue Reading
Categories: APPS Blogs

New Continuous Integration tutorial published

Lynn Munsinger - Mon, 2012-07-02 09:44
Hot off the press – a new continuous integration tutorial. It’s really not just about continuous integration, though! You’ll find it useful even if you aren’t using a continuous integration server like Hudson. It’s useful if you are doing any part of the scenario it documents: Setting up Team Productivity Center for your team and [...]

Advanced ADF eCourse, Part Deux

Lynn Munsinger - Tue, 2012-06-19 15:11
In February, we published the first in a series of FREE(!) online advanced ADF training: http://tinyurl.com/advadf-part1 The response to that course has been overwhelmingly positive as more and more people are moving past the evaluation/prototype stages with ADF and looking for more advanced topics. I’m pleased to relay the good news that the 2nd part [...]

Fun with Hudson, Part 1.1

Lynn Munsinger - Tue, 2012-06-05 09:19
Earlier I posted that I had used the following zip command in the ‘execute shell’ action for my Hudson build job: zip -r $WORKSPACE/builds/$JOB_NAME-$BUILD_NUMBER * -x ‘*/.svn/*’ -x ‘*builds/*’ This zips up the content of the exported source, so that I can send it on to team members who need the source of each build [...]

Hiring a Curriculum Developer

Lynn Munsinger - Tue, 2012-05-15 09:34
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

Hiring a Curriculum Developer

Lynn Munsinger - Tue, 2012-05-15 09:34
If you are an instructional designer with an eye for technologies like ADF, or if you are an ADF enthusiast and excel at creatively producing technical content, then ADF Product Management would like to hear from you. We’re looking for a curriculum developer to join our ADF Curriculum team, which is tasked with ensuring that [...]

Deinstalling Oracle Forms – Java RunTime Environment was not found at…

Rajender Singh - Sun, 2012-04-29 23:05

Today while deinstalling Oracle Forms 11g R2, I came across following error.

It says “Java RunTime Environment was not found at…”

I tried setting the local Java related variable but it didn’t help. The deinstaller keep taking the old location.

After going through Oracle Documentation I found that I can run deinstaller and pass JRE information to deinstaller as follows:

setup.exe -deinstall -jreLoc JRE_LOCATION

In my case JRE location was as follows:

So I ran as follows:

C:\Oracle\Middleware\oracle_common\oui\bin\setup.exe -deinstall -jreLoc C:\Java\jdk1.6.0_32\jre

After this, Deinstallation went smoothly :)

I hope this post will help somebody plus will act as a future reference to me.

Back to Upgrading to Oracle Forms 11g R2!

Rajender Singh - Sat, 2012-04-28 09:30

While thinking about Oracle forms..I came across a blog post “Lessons Learned From Upgrading to Oracle Forms 11g R2 on WebLogic !” by Mila Urman.

Now really inspired again, to get started on Oracle Forms 11g again… last time I did well but my heart :) couldn’t reach to actual production stage!

Thanks Mia for sharing your valuable experience with Oracle Forms Community!

How ROWNUM Pseudocolumn works?

Rajender Singh - Mon, 2012-04-23 05:09

I keep coming across guys confused about “How ROWNUM Pseudocolumn works?”

Even though ORACLE document clearly mentions “the ROWNUM pseudocolumn returns a number indicating the order in which ORACLE selects the row from a table or set of joined rows”, confusion still exists….may be we tend to google rather than going though ORACLE documents these days :)

As per above statement it is clear that ORACLE assigns ROWNUM after WHERE clause but before ORDER BY clause.

For example, if we run following query:

SELECT rownum, ename FROM emp WHERE ROWNUM < 10 ORDER BY ename;

If no index exist, ROWNUM be allocated by the ORACLE when it process WHERE condition i.e. “SELECT rownum, ename FROM emp WHERE ROWNUM < 10"

After it only ORACLE will process ORDER BY clause i.e. "ORDER BY ename",

so end result, ROWNUM may not follow the ORDER BY clause

Example as follows:

SQL> SELECT rownum, ename FROM emp WHERE ROWNUM < 10 ORDER BY ename;

ROWNUM ENAME
---------- ----------
2 ALLEN
6 BLAKE
7 CLARK
4 JONES
9 KING
5 MARTIN
8 SCOTT
1 SMITH
3 WARD

9 rows selected.

If we embed the ORDER BY clause in a subquery and place the ROWNUM in the main query, then we can force the ROWNUM to be assigned after ORDER BY.

Example as follows:

SQL> SELECT rownum, ename FROM ( SELECT ename FROM emp WHERE ROWNUM < 10 ORDER BY ename)

ROWNUM ENAME
---------- ----------
1 ALLEN
2 BLAKE
3 CLARK
4 JONES
5 KING
6 MARTIN
7 SCOTT
8 SMITH
9 WARD

9 rows selected.

Now in case the column which we are doing has a Index, then ORACLE will select the row using the INDEX, as a result, ROWNUM will follow the ORDER BY clause.

Example as follows:

SQL> SELECT rownum, empno FROM emp WHERE ROWNUM < 10 ORDER BY empno;

ROWNUM EMPNO
———- ———-
1 7369
2 7499
3 7521
4 7566
5 7654
6 7698
7 7782
8 7788
9 7839

9 rows selected.

I really don’t know how important you feel to understand this concept, but I did well by learning this in my early days itself :)

New ADF Insider on Layouts

Lynn Munsinger - Mon, 2012-03-26 13:22
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html

New ADF Insider on Layouts

Lynn Munsinger - Mon, 2012-03-26 13:22
I’ve published an ADF Insider session that helps de-mystify the ADF Faces components and how to work with them (and not against them), when building ADF applications. There’s also some great information on building ADF prototypes. Take a look here: http://download.oracle.com/otn_hosted_doc/jdeveloper/11gdemos/layouts/layouts.html

Looking for Technical Writer

Elena's Blog - Wed, 2012-02-15 00:23
We are looking for a talented technical writer, experienced in Linux and Virtualization. It is important that the candidate knows Docbook XML in depth. Basics requirements:
  • 3 or more years previous experience in writing software documentation (please provide URLs of your writings)
  • Experience with writing documentation for system level software and operating systems
  • Strong knowledge of the Linux operating system
  • Strong knowledge of XML, DocBook XML, and XSL style sheets (and motivation to help maintain and expand our tools and infrastructure)
  • Ability to administer own workstation and test environment
  • Good experience with distributed working environments and versioning systems such as SVN
The location where we are looking to hire is mainly Ireland, possibly considering also Scandinavian countries. Position Description