Category: SQL

#odtug, Conferences, KScope14, Oracle, SQL

The Final Note – Kscope14

KScope14 was hosted in Seattle, the City of Music, and what an experience it was.  For six days, Oracle experts and professionals descended upon the City to share with and learn from each other.  We kicked off on Saturday with a Community Service event event with the Nature Consortium.  After being stuck and scratched by …

#odtug, BI, cloud, conference, cool stuff, Data Migration, Database, Databases, HCM, HFM, Hints and Tips, Hyperion, Implementation, kscope14, OBIA, OBIEE, Oracle, PLSQL, SQL, technology, virtualization

Let The Games Begin! – #Kscope14

We kicked off KScope 14 with a great Community Service event with the Nature Consortium.  If you saw my tweet earlier, we HANDLED that Himalayan Blackberry.  I’ve got some of that stuff or a very close relative growing in my back yard, so I felt really good pulling that stuff out.  Not to be beat …

ACE, ACEA, BI, BI Publisher, Database, Discoverer, E-Business Suite, EBS, EBS 11i, EBS XML, Oracle Report, Reporting, SQL, SQLDev, technology, XML, XML Publisher

XML/BI Publisher in Oracle EBS – Bye Bye Discoverer

All good things must come to an end.  It has been a long run with plenty of ups and downs.  Getting Discoverer rolled out was one of my first tasks as I embarked upon my +Oracle E-Business Suite journey.  Alas, we are saying our final goodbyes to Discoverer.  This however opens new doors to address our reporting …

E-Business Suite, EBS, HCM, Hints and Tip, HRMS, Oracle, PLSQL, SQL

Auto End Date Separated Employees

A little while back, there was some concern that employees were being terminated in #Oracle E-Business Suite, but there was no process to ensure that those former employees couldn’t log back into EBS.  This particular environment did not leverage any SSO technologies to manage user access, so each System Administrator was responsible for managing that …

12C, CDB, Containers, Database, Databases, DBA, Hints and Tips, ORA-01033, Oracle, PDB, Pluggable Databases, script, SQL, SQLDev, startup, Startup Script

Use Start-up Script to Modify State of your Pluggable Database to Open Read Write in SQL Developer 4.0 EA3 (ORA-01033)

I’m playing around with Oracle’s SQL Developer 4 EA3 and Database 12c.  Using SQL Dev, I quickly created a Pluggable Database (PDB). I try to open it, and I get this (ORA-01033). Then I remember reading that the Pluggable Databases don’t open automatically when the database services are started.  Well that sucks because now I …

Data Migration, Database Copy, Databases, DBA, dbcapoeira, Migration, MSSQL migration, Oracle, SQL, SQLDev, SQLDev Cart

Story by a non-DBA: Database Migration with SQLDev EA1 v4.0

It’s been a while, but this 20 minutes turned 8 hour project was a lot of fun.  It just kept getting better and better.  Today boy and girls, I’m gonna take you through my process of migrating a MSSQL database to Oracle.  Let get stated. So, before we had Oracle EBS 11i (2008), there was …

Discoverer, EBS, optimize, Oracle, SQL

How to Speed up Discoverer Reports

Finally getting back into the swing of things after an awesome #Kscope12 conference.  It was a great learning experience and networking wasn’t too bad either.  Met personalities such as oraclenerd, Kent Graziano, ODTUG Presidents Mike Riley (outgoing) and Monty Latiolais (incoming).  All great people with a wealth of knowledge. In case I didn’t mention it, …