Oracle Cloud Compute – EBS 12.2.5 Vision Demo

During our trial, we’ve created multiple, publicly accessible, Oracle EBS 12.2.5 vision demo instances. This is, by far, the easiest way to install and configure an Oracle E Business Suite test instance.

Install ODI 12c Studio – Windows PC

Overview

1. Download Software – JDK 1.8.x and ODI 12c Studio Disk 1 & 2
2. Install & Source JDK
3. Install Oracle Data Integrator 12c Studio

Corente VPN Gateway Install – Oracle Cloud Compute

Select the Corente Gateway Image from the published Oracle Images

Tableau Desktop – Connecting to an Oracle 12c PDB Hosted in the Oracle Cloud

Launch Tableau Desktop

From the Connect menu, select Oracle.

Presentation Selected for OAUG Collaborate 2017

“Congratulations! The Oracle Applications Users Group (OAUG) is pleased to inform you that your presentation, “Advanced EBS R12 & Database Cloning: A Complete Test Refresh in 2 Hours or Less,” has been accepted as a session at COLLABORATE 17 – Technology and Applications Forum for the Oracle Community, OAUG Forum, at the Mandalay Bay Resort & Casino in Las Vegas, Nevada. We can only deliver an excellent conference if we have excellent content; thank you for your contribution!”

This will be my third year presenting at OAUG Collaborate in Las Vegas and my fourth session overall. It’s been an honor to have at least one proposal selected for Collaborate each year. I’m proud our team’s hard work and I look forward to sharing our solution with the community.

Please join me at Collaborate 2017 this April 2 – 6.

Install ODI 12c Studio – Ubuntu 16.04 or Elementary OS Loki

Download ODI 12c Studio Disks 1 & 2

 http://www.oracle.com/technetwork/middleware/data-integrator/downloads/index.html

Install SQL Developer on Ubuntu 16.04 or Elementary OS Loki

Install jdk

http://www.oracle.com/technetwork/java/javase/downloads/index.html

Download the necessary jdk for your flavor of linux 32 or 64 bit.  You can use alien to convert the rpm to a deb installer or just download the .tar.gz file and follow the steps below.

sudo tar -zxf jdk-8u111-linux-x64.tar.gz -C /opt/java

Paper Proposals Selected for OAUG Collaborate 2016

Taming Oracle EBS R12.x Accrual Reconciliation Load

Following our EBS R12.1.3 upgrade, we experienced inconsistent runtime and resource utilization with the Accrual Reconciliation Load program. During one month end close, a plant accountant could run accrual reconciliation for three years of data in under 10 hours. The next month, the same amount of data would take upwards of 30 hours to load. This behavior made it hard to plan for month end closure; successful accrual load being crucial to the finals for the month. Through multiple rounds of testing, we were able to complete the reconciliation process with nearly 15 years of data in just 1 hour and 45 minutes.

Taming Oracle EBS R12.x Accrual Reconciliation Load from Joshua Johnson, MIS

OAUG Pro Tips: Take Five – Performance Tuning During EBS 11i to 12.1.3 Upgrade

In addition to my upcoming article in the Winter issue of OAUG Insights magazine, I’m proud to share my OAUG Pro Tips video on memory tuning, currently available on the OAUG website.

Discussing the necessity for memory management and tuning for Oracle systems.

Finalist for the 2016 Oracle Excellence Award for Data Management Innovation!

Our team was nominated for the 2016 Oracle Excellence Award: Oracle Cloud Platform Innovation in both Data Management and Integration. Today, I received an update stating that we’re in the top 6 finalists out of a field of a few hundred nominees for Data Management Innovation.

“Congratulations! On behalf of our awards committee, I am pleased to inform you that Simmons has been selected as a Finalist for the 2016 Oracle Excellence Award for Data Management Innovation!   The Award Ceremony will take place at Oracle Open World on Tuesday, September 20, from 4:00-6:00 p.m. at which time Simmons will be presented with the Award.”