Logical operators in RETURN clause of a function

Here is what I learnt today.

You can use logical operators in the RETURN clause of a function whose return type is BOOLEAN. So for example, you can write a function with the following structure:


create or replace function test_fn(p_param varchar2)
return boolean
as
l_value varchar2(10):= 'TEST';
begin
return false
or p_param = l_value
or length(p_param) = 5 ;
end;
/
show errors;

The logical truth table is used to evaluate the expression in the RETURN clause (more...)

Calling all Apps DBAs doing 11i to R12.x upgrades

At this time of the year during holidays, the Apps DBA community is busy doing upgrades as longer downtimes are possible.  In case you are facing any issues, please feel free to write to me at my email: oracleappstechnology@gmail.com .  I will be glad to hear from you and help you.

11i pre-upgrade data fix script ap_wrg_11i_chrg_alloc_fix.sql runs very slow

We are currently upgrading one of our ERP instances from 11.5.10.2 to R12.2.5.  One of the pre-upgrade steps is to execute the data fix script ap_wrg_11i_chrg_alloc_fix.sql.  However, this script has been running very very slow. After 4 weeks of monitoring, logging SRs with Oracle, escalating etc., we started a group chat today with our internal experts.  We had Ali, Germaine, Aditya, Mukhtiar, Martha Gomez and Zoltan.  I also (more...)

Oracle Forms 12c: Install

I can go explain the full installation, but to be honest, I followed the guides of ORACLE-BASE.  

 

These are the guides I followed to install Forms and reports:

More On Wearable Tech

I've been going through an amazing experience over the past month plus...purchased and began wearing an Apple iWatch.  Never really thought I would do so...kind of did it on the spur of the moment.  Plus a little push from my team lead at Oracle, who wears one and loves it.

Even after a month of wearing the iWatch, I can't really point at one particular feature that makes it worthwhile.  It's really more (more...)

Scripts “All Things Oracle” article on Oracle Live SQL

I've put the scripts of my All Things Oracle article "About functions, records and result cache" on Oracle Live SQL.  This makes it easier to test the code used in the article.  

I used the employees table from the HR demo schema for my examples which is already available in Live SQL, so you don't have to create anything but the functions used in the scripts.

I've created 4 scripts: 

The Times They Are A-Changin’

Come gather 'round people
Wherever you roam
And admit that the waters
Around you have grown
And accept it that soon
You'll be drenched to the bone
If your time to you
Is worth savin'
Then you better start swimmin'
Or you'll sink like a stone
For the times they are a-changin'.

                     -- From Bob Dylan's "The Times They Are A-Changin'"


Spent some time with (more...)

Be Quick, But Don’t Hurry

Over the month since I've joined Oracle, many people has asked about the work I'm doing here.  And, in all honesty, the work is so varied that I've had a difficult time describing it.

Yesterday, I was traveling from my home in Salt Lake to Oracle Corporate HQ in Redwood Shores.  Having landed in San Francisco, I was in a rush to get my rental car, make the drive to HQ, and get (more...)

sqlplus core dumps with segmentation fault error in OEL 6.6 when you connect to DB

We have used OEL 6.6 image in our latest build.  When we cloned an EBS R12.2 instance that was on OEL 5.7 to this new server that has OEL 6.6, During the clone, adcfgclone.pl was failing. On further checks, we discovered that sqlplus is crashing with segmentation fault error whenever we tried to connect to database:

sqlplus /nolog
conn apps/apps
Segmentation Fault

So, I suggested the DBAs to do strace (more...)

twm: unable to open fontset "-adobe-helvetica-bold-r-normal–*-120-*-*-*-*-*-*"

While launching twm, it gives this error and exits to unix prompt:

twm: unable to open fontset "-adobe-helvetica-bold-r-normal--*-120-*-*-*-*-*-*"

I found a solution on http://ubuntuforums.org/archive/index.php/t-1596636.html :

It was reported here for fedora: https://bugzilla.redhat.com/show_bug.cgi?id=509639. The workaround is to execute it with a specific shell variable:

$ LANG=C
$ export LANG
twm &

twm launches fine after this.

Oracle SSO Failure – Unable to process request Either the requested URL was not specified in terms of a fully-qualified host name or OHS single sign-on is incorrectly configured

Today, during a cutover when we were moving one of our ERP instance on Cisco UCS VMware VMs to Exalogic and Exadata, I got a call from Bimal.  The extranet iSupplier URL had been configured, but whenever any user logged in, they were seeing the following error instead of the iSupplier OAF Home page:

Oracle SSO Failure - Unable to process request Either the requested URL was not specified in terms of a fully-qualified host (more...)

JavaScript and PeopleCode Array Parameters

I have been experimenting with scripting PeopleCode using JavaScript. This is possible because Java includes Mozilla's Rhino JavaScript engine. I took one of my experiments to OpenWorld 2015 which shows creating a Microsoft Excel Spreadsheet using POI and JavaScript. Here we are, a couple of weeks later, and I see this in the PeopleSoft OTN Discussion Forum: Java Exception: java.lang.reflect.InvocationTargetException: during call of java.lang.reflect.Method .invoke. Perfect! That is (more...)

Western Canada Regional Users Group 2015

I will be in Calgary next week presenting PeopleTools topics at the Western Canada Regional Users Group meeting. My sessions are at 1 PM and 2:15 PM. See you there!

The SaaS Race

So I've been back at Oracle for about a month now.  I'd say the biggest change so far is my perspective on trends in SaaS and Cloud.  Prior to gaining that perspective from the inside, I really did not have a full appreciation for just how early in the game we are.  Not just Oracle, but everybody.

During my undergrad days, when remote learning was done with smoke signals (no Internet yet), (more...)

OpenWorld 2015 Presentations Available

OpenWorld 2015 presentations are now available in the content catalog. My PeopleTools Tips and Techniques session presentation is available here.

Limitations

I've noticed a trend lately.  In working with various organizations in the early stages of evaluating SaaS, I'm hearing vigorous defense of limitations. "We can't go to the cloud because our business is so unique."  "We can't consider cloud because our data is too complex to migrate." "We can't entrust our data to a 3rd party."  While there are plenty of additional reasons, I'm sure you've noticed the two important words forming (more...)

Oracle Forms 12c arrived!

It's here!  The latest version for Oracle Forms is now 12c!
Download can be found here.

A few months ago I wrote a blog post of possible new features.
I'm looking forward to explore the new version the next few days to see what's in it.

OpenWorld Session Teaser

As a teaser to the session that Mark Thomas and myself are presenting on Selective Adoption at OpenWorld next week, here’s a slide showing why Selective Adoption is important for so many clients:

teaser slide

By virtue of such a high proportion of clients upgrading to 9.2 already, Selective Adoption is impacting a huge number of customers.

Come to Mark’s and my session at 9:30am on Thursday to find out the adjustments that you need to (more...)

How To Install Latest Verisign G5 Root Certificates

Dhananjay pinged me today and told me that for their Paypal integration, they had to upgrade to Verisign G5 root certificate.  This was the message from Paypal:

Global security threats are constantly changing, and the security of our merchants continues to be our highest priority. To guard against current and future threats, we are encouraging our merchants to make the following upgrades to their integrations:
  1. Update your integration to support certificates using the SHA-256 algorithm. (more...)

EBS 12.2.7 AD & TXK Delta 7 Features Review

With 12.2.7 AD & TXK Delta 7 - EBS Customers on 12.2 should be seeing improvements and stability. It is time now to review them. Watch this blog for the detailed review.

Some of the key features of Delta 7 are

  • Middle-Tier and Database Technology Code Checkers
  • Online Patching Progress Monitoring Tool
  • Online Patching System Validation 
  • Single Step Cloning
  • Local Inventory Support
  • Improved Middle tier Startup & Shutdown performance
  • Automated scripts to change system passwords
  • Patched tables de-fragmentation