Designing Foreign Keys, PT II

I say designing, because I’m going to be talking about how to do this in SQL Developer Data Modeler. And I say Part Two, because in a previous post I showed how to draw a foreign key in your relational design. Animated GIF showing how to draw a foreign key in Oracle SQL Developer Data Modeler. This post discusses... [Read More]

PeopleSoft Security User Authorization Audits

When performing a PeopleSoft security audit, reviewing what rights and privileges individual users have been granted for system and application security privileges (authorization) is one of the key deliverables. The following are several of the topics that Integrigy investigates during our PeopleSoft security configuration assessments - take a look today at your settings:

Review users with access to

  • PeopleTools
  • The SQR folder
  • Process scheduler
  • Security and other sensitive administration menus
  • Security and other sensitive administration (more...)

What’s new in Oracle BPM and Process Cloud Service? SOA & BPM Partner Community Webcast – July 26th 2016

imageAttend our July edition of the SOA & BPM Partner Community Webcast live on July 26th 2016 at 16:00 CET.

What’s new in Oracle BPM and Process Cloud Service? Digital Process Apps made Simple

During this session, we will be joined by Sujan Balachandran, Product Manager for Oracle BPM and Process Cloud Service (PCS). The session will cover

· Empower Business User using BPM Composer

· What is Business Architecture? How can it help (more...)

Spreadsheet-like Totals and Subtotals

We very often make spreadsheets with subtotals for each row and for each column. Someone on the OTN forum asked how to produce data in this format. I answered using the cool CUBE function.

Apt-get error: E: The method driver /usr/lib/apt/methods/https could not be found

I’ve been getting the following error when using apt-get update with Debian Wheezy recently. [crayon-578cc50f4f2f7166336499/] It seems that apt-get only supports HTTP connections by default, and throws an error with any HTTPS URLs.  You’ll likely see this error message if you add a new apt source URL that starts with https. What’s most annoying is that apt doesn’t simply ignore

Connecting Oracle Data Visualization Desktop to OBIEE

Recently at Rittman Mead we have been asked a lot of questions surrounding Oracle’s new Data Visualization Desktop tool and how it integrates with OBIEE. Rather than referring people to the Oracle docs on DVD, I decided to share with you my experience connecting to an OBIEE 12c instance and take you through some of the things I learned through the process.

In a previous blog, I went though database connections with Data Visualization (more...)

Blast from the Past: Gesture-Controlled Robot Arm

Hard to believe it’s been nearly three years since we debuted the Leap Motion-controlled robot arm. Since then, it’s been a mainstay demo for us, combining a bit of fun with the still-emergent interaction mechanism, gesture.

Anthony (@anthonyslai) remains the master of the robot arm, and since we lost access to the original video, Noel (@noelportugal) shot a new one in the Gadget Lab at HQ where the robot arm continues (more...)

Quote of the Day: Mark Twain

It is better to deserve honors and not have them         than to have them and not deserve them. — Mark TwainFiled under: Quotes Tagged: Mark Twain, quote of the day, quotes

2016 Kscope – What Did I Learn?


Oops! This has taken me two weeks to write, I got back to UK and was just so busy. I thought perhaps it was too late but I still have the same nail polish on I had done at the end of Kscope so I guess it is OK.

As a user group leader you miss out on a lot of the great education delivered by your own group, especially when you want to cover (more...)

Workaround for ADF BC REST Custom Method Configuration

This post is based on JDEV 12.2.1.1, it seems like there is issue with ADF BC REST custom method definition in this release. I'm glad it is not runtime issue, but related to design time JDEV wizard incorrect functionality. I will explain how to bypass it, when you want to expose custom REST method in 12.2.1.1.

Sample application (ADFBCRestApp_v8.zip) implements custom method, exposed through ADF BC (more...)

Video Tutorial: XPLAN_ASH Active Session History – Part 8

The next part of the video tutorial explaining the XPLAN_ASH Active Session History functionality continuing the actual walk-through of the script output.

More parts to follow.


Maximize the Value of Your CX Investments with Oracle Cloud Platform

With Oracle CX Cloud, companies not only get the most comprehensive CX offering, but also an innovative and powerful cloud platform to extend, analyze and integrate these applications with the rest of the enterprise resources, as well as to optimize them for every user.  

This session outlines the Cloud Platform (PaaS & IaaS) solutions that Oracle provides to streamline cloud development and empowers you to deliver enterprise-grade solutions rapidly and cost effectively. Join this event if you are interested in the most advanced way to extend, analyze and integrate the Oracle CX solutions. In subsequent webinars, we will drive you through further Integration Solutions’ details.

Agenda:

§ Oracle Cloud Platform Overview

§ Practical use case to extend, analyze and integrate Oracle CX Cloud

§ CX extension & integration demo

§ Partner resources

Schedule:

December 17th 2015 10:00 am CET

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

How To Configure Exadata Database Machine in Enterprise Manager Cloud Control 13c (OEM13c)

I have followed the steps in Oracle Documentation link: https://docs.oracle.com/cd/E63000_01/EMXIG/ch2_deployment.htm#EMXIG215 to configure Exadata Database Machine in OEM13c. If you want to configure your Exadata in OEM13c you have to follow the above mentioned link. In this post I will share the mandatory steps for configuration, and some of the issues which I faced while configuring the Exadata…

BPM 12c Subprocesses (Part 3 of 3): Event Subprocess by Antonis Antoniou

clip_image001

In this third and last part of a three part series on subprocesses we will explore a special type of subprocess referred to as an “Event” subprocess.
This type of subprocess is triggered by an event that can occur anytime during the execution of a process flow that allows you to interrupt the normal flow of an instance.
Such capability can be applicable in various use cases. For example, an error might occur in the (more...)

GoldenGate and Netwworking

I have never delved into networking for GoldenGate since things just work. Due to security tightening, telnet is no longer available to verify opened port.

What’s to follow is a demo for ports being listened by GoldenGate when manager started and ports listened and when PUMP Extract is started as part using DYNAMICPORTLIST.

Also, how to test opened port using (nc – arbitrary TCP and UDP connections and listens)

Both source and target are running on the (more...)

FRIDAY SPOTLIGHT: New VirtualBox 5.1 and Private Cloud Appliance Refresh

This week had been a busy one for us. We had several exciting announcements that we would like to inform you about.

Oracle VM VirtualBox 5.1

To enable organizations and developers to more easily and flexibly create and deploy on premises and cloud applications, we are pleased to announce the general availability of Oracle VM VirtualBox 5.1, the latest release of the world’s most popular free and open source, cross-platform virtualization software. The (more...)

Oracle Database INTERVAL Partitioning and Virtual Columns

I bumped into this issue recently which prevents you INSERTING a date of 31-12-9999 into an INTERVAL partitioned table due to the fact that the LESS THAN partition value would be larger than an Oracle Date. After speaking with Jeff Moss he mentioned that we might be able to get round the problem by using a virtual

Truncates and Sequences Replication in Oracle GoldenGate

We use the terms DDL and DML in our DBA life with Oracle all the time. The first stands for Data Definition Language and it is about Data Definition changes. The latter is about manipulation with your data itself, and stands for Data Manipulation Language. When we speak about replication of our data by replication tools between Oracle databases, we generally either enable DDL, work only replicating DML, or do it for both together. In (more...)

Oracle Database Interval Partition Set Up Script

This script is used to set up the test table for the following blog posts: Oracle Database INTERVAL Partitioning Date Error With 31-12-9999 Oracle Database INTERVAL Partitioning and Virtual Columns [crayon-578913d2a047f830082062/]  

Oracle Database INTERVAL Partitioning Date Error With 31-12-9999

You may have seen the below error when using dates at the extremes with an Oracle Database. This post focuses on the scenario where you’re inserting a high date, such as 31-12-9999 into an INTERVAL partitioned table. High dates such as this are often used in warehouse environments where from and to dates are specified