Oracle E-Business Suite 12.2 is now covered by Premier Support to September 30, 2023. This is documented here:
Premier Support includes new EBS 12.2 patches for:
- Individual product families (e.g. Oracle Financials)
- Quarterly security updates released via the Critical Patch Update process
- New technology stack certifications with server-based components
- New certifications for end-user desktops and mobile devices
What are the minimum patching baselines for EBS (more...)
Here's an overview of CSS tools in NetBeans that I've found to be quite useful. Below, in the first example, the value of "class" is set to "foo", which does not exist in any of the available CSS stylesheets. NetBeans offers to create the rule in a stylesheet of my choosing and to import that stylesheet into my HTML file:
Below, the value of "id" is "foo", which doesn't exist in any of the stylesheets. NetBeans (more...)
Create an Integration on ICS to expose a REST API for a SOAP Connection for an external web service by Lucas Jellema
In this article, I will show a little bit more of ICS – the Integration Cloud Service. In a previous article, I have introduced some concepts – such as Connection, Integration, Business Identifier. I have shown how to create an integration connecting two connections – an inbound and an outbound one (both of type SOAP).
In picture, that looks like this:
In this article, I will create a new connection (REST API style) and (more...)
We had an interesting AskTom question recently, about why certain TRUNC commands would generate an error when applied to a TIMESTAMP value. At first glance, TRUNC seems fine.
SQL> select trunc(localtimestamp,'MM') to_the_month from dual; TO_THE_MO --------- 01-OCT-16 1 row selected. SQL> select trunc(localtimestamp,'YYYY') to_the_year from dual; TO_THE_YE --------- 01-JAN-16 1 row selected. SQL> select trunc(localtimestamp,'DD') to_the_day from dual; TO_THE_DA --------- 20-OCT-16 1 row selected.
But the moment you try apply a TRUNC down to (more...)
I think we’ve just about all heard enough about voting this election year, but I want to discuss a slightly different angle and that’s when it comes to user groups. As most people know, I’m pretty passionate about everyone contributing time to your local and national user groups. I also think it’s important to take pride in and be responsible for the promises you make.
I was sent (more...)
When you need to monitor web services, you can use EM beacons. A beacon is a target that allows the EM Agent to remotely monitor services. You can add beacons to any EM agent using “Add Non-Host Targets by Specifying Target Monitoring Properties” option in the Add Targets Manually page. After adding a beacon, you can configure it to fetch a web page and test the status of the service according to the result of (more...)
A few days ago, a new version of StreamSets Data Collector v184.108.40.206 has been announced. It contains a couple of new interesting features.
This blog article shows how to use the new Package Manager to install only the stage libraries in StreamSets Data Collector (origins, processors and destinations) you actually need.
The new StreamSets version provides two distributions:
We bumped a Linux 220.127.116.11 database up to a 12 gigabyte SGA and the login time went up to about 2.5 seconds. Then a Linux admin configured 12 gigabytes of HugePages to fit the SGA and login time went down to .13 seconds. Here is how I tested the login time. E.sql just has the exit command in it so this logs in as SYSDBA and immediately exits:
$ time sqlplus / (more...)
I’ll be attending my very first Pass Summit next week and I’m really psyched! Its an amazing event and for those of you who are my Oracle peeps, wondering what Summit is, think Oracle Open World for the Microsoft SQL Server expert folks.
I was a strong proponent of immersing in different database and technology platforms early on. You never know when the knowledge you gain in an (more...)
As a “born again UX/UI” enthusiast I was quite interested when some of my Google services started telling me about the new UI they were introducing. As part of the “do you want to see more” links they pushed me across to Google’s Material design pages.
I had a bit of mixed reaction to a lot of it. Some of the stuff was straight from the ministry of the bleedin’ obvious, while other stuff was more (more...)
The other day I was running an upgrade for a client that is using ACLs ( Access Control Lists) from 18.104.22.168 to 22.214.171.124. If you have been doing upgrades to 12c, you know that when running the catctl.pl -n 4 catupgrd.sql it entails 73 steps. So this upgrade failed in step 65 with the following error (I have trimmed the output for reading purposes) :
Serial Phase (more...)
My previous post contained a brief description of Data Visualization Desktop (DVD) new features in 126.96.36.199, in terms of sources, visualisations and components. In this post we're going to simulate a typical analyst use case and understand how DVD can support the process.
Data Visualisation Desktop is a tool aimed at departmental analysis, with data coming from different sources and results that need to be delivered quickly. Given the ad-hoc nature of (more...)
I recently tweeted about a comment I’d picked up at the Trivadis performance days regarding tablescans and performance.
“If you can write your SQL in conjunctive normal form it can help the optimizer to offload more predicates”
Inevitably someone asked me if I had an example to demonstrate this – I didn’t, and still don’t really, but here’s an interesting demo based on an example from the Oracle In-Memory blog showing how the optimizer will (more...)
DBA_HISTtables for subsequent analysis and graphing using things like Excel. This post is to summarise where I got to on this, and provide links back to the main posts for future reference.
A guiding principle of my approach was that I wanted to avoid the (more...)
Back in August I asked for your vote in The UKOUG Partner Awards. I always say how important these are because they are voted for by end users.
It is a hard process for me, I am not allowed to do anything for PYA by UKOUG because I am a partner and there has to be a total separation. Most people understand that but my boss rang me 3 times on the day asking (more...)
This is part 2 of my blog post series about the Ambient Visualization hardware (part 1). Also, please read John’s post on details about the creation of the actual visualization, from concept to build. In the first part, I focused on the hardware, a sonar sensor connected to a NodeMCU. In this second part, the focal point will be the software.
When I started working with ESPs a few years ago I was all (more...)