Feed aggregator

Oracle Buys goBalto

Oracle Press Releases - Wed, 2018-10-17 07:00
Press Release
Oracle Buys goBalto Adds Leading Solution for Accelerating Clinical Trial Site Selection and Activation to Oracle Health Sciences Cloud

Redwood Shores, Calif.—Oct 17, 2018

Oracle today announced that it has entered into an agreement to acquire goBalto, which delivers leading cloud solutions to accelerate clinical trials by streamlining and automating the selection and set up of the best performing clinical research sites to conduct trials.

goBalto’s study startup solutions are activated at over 90,000 research sites across 2,000+ studies in over 80 countries to deliver significant savings to customers with over 30 percent quantifiable reduction in study startup cycle times.

Today, Oracle Health Sciences offers customers the industry's most advanced cloud solution for clinical trial planning, data collection, trial execution and safety management. goBalto adds the leading industry cloud solution that significantly reduces clinical trial startup time.  Together, Oracle and goBalto will provide the most complete end-to-end cloud platform dedicated to unifying action and accelerating results for the Life Sciences industry. 

“Clinical trial site selection and activation is one of the most manual and time-consuming processes for our customers,” said Steve Rosenberg, Senior Vice President and General Manager of Oracle Health Sciences Global Business Unit. “Oracle Health Sciences is designed to provide the industry with the best end-to-end clinical trial experience and the addition of goBalto will further allow our customers to remove another barrier from delivering treatments to patients faster.”

“We set out on a mission to streamline the clinical trial study startup process ten years ago because we saw how untenable it was for pharmaceutical companies and contract research organizations to track 1,000+ sites by 1,000+ specialists on spreadsheets,” said Jae Chung, Founder and President of goBalto.  

“We are delighted to join forces with Oracle as the benefits offered to both our customers and employees as a broader clinical trial continuum are unparalleled in the industry,” said Sujay Jadhav, CEO of goBalto.

More information about this announcement is available at www.oracle.com/gobalto.

Contact Info
Deborah Hellinger
Oracle Corporate Communications
+1.212.508.7935
deborah.hellinger@oracle.com
Ken Bond
Oracle Investor Relations
+1.650.607.0349
ken.bond@oracle.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Safe Harbor

Oracle is currently reviewing the existing goBalto product roadmap and will be providing guidance to customers in accordance with Oracle’s standard product communication policies. Any resulting features and timing of release of such features as determined by Oracle’s review of goBalto’s product roadmap are at the sole discretion of Oracle. All product roadmap information, whether communicated by goBalto or by Oracle, does not represent a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. It is intended for information purposes only, and may not be incorporated into any contract.

Cautionary Statement Regarding Forward-Looking Statements
This document contains certain forward-looking statements about Oracle and goBalto, including statements that involve risks and uncertainties concerning Oracle’s proposed acquisition of goBalto, anticipated customer benefits and general business outlook. When used in this document, the words “anticipates”, “can”, “will”, “look forward to”, “expected” and similar expressions and any other statements that are not historical facts are intended to identify those assertions as forward-looking statements. Any such statement may be influenced by a variety of factors, many of which are beyond the control of Oracle or goBalto, that could cause actual outcomes and results to be materially different from those projected, described, expressed or implied in this document due to a number of risks and uncertainties. Potential risks and uncertainties include, among others, the possibility that the transaction will not close or that the closing may be delayed, the anticipated synergies of the combined companies may not be achieved after closing, the combined operations may not be successfully integrated in a timely manner, if at all, general economic conditions in regions in which either company does business may deteriorate and/or Oracle or goBalto may be adversely affected by other economic, business, and/or competitive factors. Accordingly, no assurances can be given that any of the events anticipated by the forward-looking statements will transpire or occur, or if any of them do so, what impact they will have on the results of operations or financial condition of Oracle or goBalto. You are cautioned to not place undue reliance on forward-looking statements, which speak only as of the date of this document. Neither Oracle nor goBalto is under any duty to update any of the information in this document.

Talk to a Press Contact

Deborah Hellinger

  • +1.212.508.7935

Ken Bond

  • +1.650.607.0349

[BLOG] Oracle Critical Patch Update October 2018 Now Available

Online Apps DBA - Wed, 2018-10-17 06:32

Do you know that Oracle has released Critical Patch Update (CPU) for October 2018 with wide-ranging security update? Visit: https://k21academy.com/appsdba36 to check: ✔Affected Products and Patch Information ✔Doc to Refer to Apply CPU October patches & much more… Do you know that Oracle has released Critical Patch Update (CPU) for October 2018 with wide-ranging security […]

The post [BLOG] Oracle Critical Patch Update October 2018 Now Available appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Connect to DV Datasets and explore many more new features in OAC / OAAC 18.3.3.0

Tim Dexter - Wed, 2018-10-17 05:26

Greetings !

Oracle Analytics Cloud (OAC) and Oracle Autonomous Analytics Cloud (OAAC) version 18.3.3.0 (also known as V5) got released last month. A rich set of new features have been introduced in this release across different products (with product version 12.2.5.0.0) in the suite. You can check all the new features of OAC / OAAC in the video here.

The focus for BI Publisher on OAC / OAAC in this release has been to compliment Data Visualization for pixel perfect reporting, performance optimizations and adding self service abilities. Here is a list of new features added this release:

BI Publisher New Features in OAC V5.0

New Feature Description 1. DV Datasets

Now you can leverage a variety of data sources covered by Data Visualization data sets, including Cloud based data sources such as Amazon Redshift, Autonomous Data Warehouse Cloud; Big Data sources such as Spark, Impala, Hive; and Application data sources such as Salesforce, Oracle Applications etc. BI Publisher is here to compliment DV to create pixel perfect reports using DV datasets.

Check the documentation for additional details. Also, check this video to see how this feature works.

2. Upload Center

Now upload all files for custom configuration such as fonts, ICC Profile, Private Keys, Digital Signature etc.from the Upload Center as a self service feature available in the Administration page.

Additional details can be found in the documentation here.

3. Validate Data Model

Report Authors can now validate a data model before deploying the report in a production environment. This will help during a custom data model creation where data sets, LOVs and Bursting Queries can be validated against standard guidelines to avoid any undesired performance impact to the report server. 

Details available here.

4. Skip unused data sets

When a data model contains multiple data sets for different layouts, each layout might not use all the data sets defined in the data model. Now Report Authors can select data model property to skip the execution of the unused data sets in a layout. Setting this property reduces the data extraction time, memory usage and improves overall report performance.

Additional details can be found here.

5. Apply Digital Signature to PDF Documents

Digital Signature is widely used feature in on-prem deployments and now this has been added in OAC too, where in Digital Signature can be applied to a PDF output. Digital Signatures can be uploaded from the Upload Center, required signature can be selected under security center, and then applied to PDF outputs by configuring attributes under report properties or run-time properties. 

You can find the documentation here. Also check this video for a quick demonstration.

6. Password protect MS Office Outputs - DocX, PPTX, XLSX

Now protect your MS Office output files with a password defined at report or server level.

Check the PPTX output properties, DocX output properties, Excel 2007 output properties

7. Deliver reports in compressed format

You can select this option to compress the output by including the file in a zip file before delivery via email, FTP, etc.

Additional details can be found here.

8. Request read-receipt and delivery confirmation notification 

You can opt to get delivery and read-receipt notification for scheduled job delivery via email.

Check documentation for additional details. 

9. Add scalability mode for Excel Template to handle large data size

Now you can set up scalability mode for an excel template. This can be done at system level, report level or at template level. By setting this attribute to true, the engine will flush memory after a threshold value and when the data exceeds 65K rows it will rollover data into multiple sheets.

You can find the documentation here.

 

Stay tuned to hear more updates on features and functionalities ! Happy BIP'ing ...

 

Categories: BI & Warehousing

Fixing* Baseline Validation Tool** Using Network Sniffer

Rittman Mead Consulting - Wed, 2018-10-17 05:22

* Sort of
** Not exactly

In the past, Robin Moffatt wrote a number of blogs showing how to use various Linux tools for diagnosing OBIEE and getting insights into how it works (one, two, three, ...). Some time ago I faced a task which allowed me to continue Robin's cycle of posts and show you how to use Wireshark to understand how a certain Oracle tool works and how to search for the solution of a problem more effectively.

To be clear, this blog is not about the issue itself. I could simply write a tweet like "If you faced issue A then patch B solves it". The idea of this blog is to demonstrate how you can use somewhat unexpected tools and get things done.

Obviously, my way of doing things is not the only one. If you are good in searching at My Oracle Support, you possibly can do it even faster, but what is good about my way (except for it is mine, which is enough for me) is that it doesn't involve uneducated guessing. I do an observation and get a clarified answer.

Most of my blogs have disclaimers. This one is not an exception, while its disclaimer is rather small. There is still no silver bullet. This won't work for every single problem in OBIEE. I didn't say this.

Now, let's get started.

The Task

The problem was the following: a client was upgrading its OBIEE system from 11g to 12c and obviously wanted to test for regression, making sure that the upgraded system worked exactly the same as the old one. Manual comparison wasn't an option since they have hundreds or even thousands of analyses and dashboards, so Oracle Baseline Validation Tool (usually called just BVT) was the first candidate as a solution to automate the checks.

Using BVT is quite simple:

  • Create a baseline for the old system.
  • Upgrade
  • Create a new baseline
  • Compare them
  • ???
  • Profit! Congratulations. You are ready to go live.

Right? Well, almost. The problem that we faced was that BVT Dashboards plugin for 11g (a very old 11.1.1.7.something) gave exactly what was expected. But for 12c (12.2.1.something) we got all numbers with a decimal point even while all analyses had "no decimal point" format. So the first feeling we got at this point was that BVT doesn't work well for 12c and that was somewhat disappointing.

SPOILER That wasn't true.

I made a simple dashboard demonstrating the issue.

OBIEE 11g

11g-dash-vs-bvt
Measure values in the XML produced by BVT are exactly as on the dashboard. Looks good.

OBIEE 12c

12c-dash-vs-bvt-1
Dashboard looks good, but values in the XML have decimal digits.

failed

As you can see, the analyses are the same or at least they look very similar but the XMLs produced by BVT aren't. From regression point of view this dashboard must get "DASHBOARDS PASSED" result, but it got "DASHBOARDS DIFFERENT".

Reading the documentation gave us no clear explanation for this behaviour. We had to go deeper and understand what actually caused it. Is it BVT screwing up the data it gets from 12c? Well, that is a highly improbable theory. Decimals were not simply present in the result but they were correct. Correct as in "the same as stored in the database", we had to reject this theory.
Or maybe the problem is that BVT works differently with 11g and 12c? Well, this looks more plausible. A few years have passed since 11.1.1.7 was released and it would not be too surprising if the old version and the modern one had different APIs used by BVT and causing this problem. Or maybe the problem is that 12c itself ignores formatting settings. Let's find out.

The Tool

Neither BVT, nor OBIEE logs gave us any insights. From every point of view, everything was working fine. Except that we were getting 100% mismatch between the source and the target. My hypothesis was that BVT worked differently with OBIEE 11g and 12c. How can I check this? Decompiling the tool and reading its code would possibly give me the answer, but it is not legal. And even if it was legal, the latest BVT size is more than 160 megabytes which would give an insane amount of code to read, especially considering the fact I don't actually know what I'm looking for. Not an option. But BVT talks to OBIEE via the network, right? Therefore we can intercept the network traffic and read it. Shall we?

There are a lot of ways to do it. I work with OBIEE quite a lot and Windows is the obvious choice for my platform. And hence the obvious tool for me was Wireshark.

Wireshark is the world’s foremost and widely-used network protocol analyzer. It lets you see what’s happening on your network at a microscopic level and is the de facto (and often de jure) standard across many commercial and non-profit enterprises, government agencies, and educational institutions. Wireshark development thrives thanks to the volunteer contributions of networking experts around the globe and is the continuation of a project started by Gerald Combs in 1998.

What this "About" doesn't say is that Wireshark is open-source and free. Which is quite nice I think.

Installation Details

I'm not going to go into too many details about the installation process. It is quite simple and straightforward. Keep all the defaults unless you know what you are doing, reboot if asked and you are fine.

If you've never used Wireshark or analogues, the main question would be "Where to install it?". The answer is pretty simple - install it on your workstation, the same workstation where BVT is installed. We're going to intercept our own traffic, not someone else's.

A Bit of Wireshark

Before going to the task we want to solve let's spend some time familiarizing with Wireshark. Its starting screen shows all the network adapters I have on my machine. The one I'm using to connect to the OBIEE servers is "WiFi 2".

Screenshot-2018-10-09-13.50.44

I double-click it and immediately see a constant flow of network packets flying back and forth between my computer and local network machines and the Internet. It's a bit hard to see any particular server in this stream. And "a bit hard" is quite an understatement, to be honest, it is impossible.

wireshark

I need a filter. For example, I know that my OBIEE 12c instance IP is 192.168.1.226. So I add ip.addr==192.168.1.226 filter saying that I only want to see traffic to or from this machine. Nothing to see right now, but if I open the login page in a browser, for example, I can see traffic between my machine (192.168.1.25) and the server. It is much better now but still not perfect.

Screenshot-2018-10-09-14.08.52

If I add http to the filter like this http and ip.addr==192.168.1.226, I definitely can get a much more clear view.

For example, here I opened http://192.168.1.226:9502/analytics page just like any other user would do. There are quite a lot of requests and responses. The browser asked for /analytics URL, the server after a few redirects replied what the actual address for this URL is login.jsp page, then browser requested /bi-security-login/login.jsp page using GET method and got the with HTTP code 200. Code 200 shows that there were no issues with the request.

startpage

Let's try to log in.

login

The top window is a normal browser and the bottom one is Wireshark. Note that my credentials been sent via clear text and I think that is a very good argument in defence of using HTTPS everywhere.

That is a very basic use of Wireshark: start monitoring, do something, see what was captured. I barely scratched the surface of what Wireshark can do, but that is enough for my task.

Wireshark and BVT 12c

The idea is quite simple. I should start capturing my traffic then use BVT as usual and see how it works with 12c and then how it works with 11g. This should give me the answer I need.

Let's see how it works with 12c first. To make things more simple I created a catalogue folder with just one analysis placed on a dashboard.

bvt-dashboard-1

It's time to run BVT and see what happens.

Screenshot-2018-10-11-17.49.59

Here is the dataset I got from OBIEE 12c. I slightly edited and formatted it to make easier to read, but didn't change anything important.

dataset12--1

What did BVT do to get this result? What API did it use? Let's look at Wireshark.

Screenshot-2018-10-11-19.09.27

First three lines are the same as with a browser. I don't know why it is needed for BVT, but I don't mind. Then BVT gets WSDL from OBIEE (GET /analytics-ws/saw.dll/wsdl/v6/private). There are multiple pairs of similar query-response flying back and forth because WSDL is big enough and downloaded in chunks. A purely technical thing, nothing strange or important here.
But now we know what API BVT uses to get data from OBIEE. I don't think anyone is surprised that it is Web Services API. Let's take a look at Web Services calls.

First logon method from nQSessionService. It logs into OBIEE and starts a session.

Screenshot-2018-10-11-19.36.59

Next requests get catalogue items descriptions for objects in my /shared/BVT folder. We can see a set of calls to webCatalogServce methods. These calls are reading my web catalogue structure: all folders, subfolders, dashboard and analysis. Pretty simple, nothing really interesting or unexpected here.

ws01

Then we can see how BVT uses generateReportSQLResult from reportService to get logical SQL for the analysis.

Screenshot-2018-10-11-19.42.07

And gets analysis' logical SQL as the response.

Screenshot-2018-10-11-19.45.10

And the final step - BVT executes this SQL and gets the data. Unfortunately, it is hard to show the data on a screenshot, but the line starting with [truncated] is the XML I showed before.

Screenshot-2018-10-12-12.19.58

And that's all. That's is how BVT gets data from OBIEE.

I did the same for 11g and saw absolutely the same procedure.

Screenshot-2018-10-11-21.01.35

My initial theory that BVT may have been using different APIs for 11g and 12c was busted.

From my experiment, I found out that BVT used xmlViewService to actually get the data. And also I know now that it uses logical SQL for getting the data. Looking at the documentation I can see that xmlViewService has no options related to any formatting. It is a purely data-retrieval service. It can't preserve any formatting and supposed to give only the data. But hey, I've started with the statement "11g preserves formatting", how is that possible? Well, that was a simple coincidence. It doesn't.

In the beginning, I had very little understanding of what keywords to use on MoS to solve the issue. "BVT for 12c doesn't preserve formatting"? "BVT decimal part settings"? "BVT works differently for 11g and 12c"? Now I have something much better - "executeSQLQuery decimal". 30 seconds of searching and I know the answer.

mos-1

This was fixed in 11.1.1.9, but there is a patch for 11.1.1.7.some_of_them. The patch fixes an 11g issue which prevents BVT from getting decimal parts of numbers.

pass

As you may have noticed I had no chance of finding this using my initial problem description. Nether BVT, nor 12g or 11.1.1.7 were mentioned. This thread looks completely unrelated to the issue, I had zero chances to find it.

Conlusion

OBIEE is a complex software and solving issues is not always easy. Unfortunately, no single method is enough for solving all problems. Usually, log files will help you. But when something works but not the way you expect, log files can be useless. In my case BVT was working fine, 11g was working fine, 12c was working fine too. Nothing special to write to logs was happening. That is why sometimes you may need unexpected tools. Just like this. Thanks for reading!

Categories: BI & Warehousing

Error while opening Database

Tom Kyte - Wed, 2018-10-17 03:26
HI,THERE I HAVE A SITUATION HERE,DUE TO POWER OUTAGE, DATABASE KEEP GIVING ERROR <code> <code> select name,open_mode from v$database; NAME OPEN_MODE --------- -----------------...
Categories: DBA Blogs

Automatic Memory Management or manual SGA & PGA setup?

Tom Kyte - Wed, 2018-10-17 03:26
Hi Tom, I need some clarification regarding the pros & cons of Oracle's AMM compare to us manually configuring SGA_TARGET & PGA_Aggregate. I read from quite a number of blogs & posts that doesn't recommend Oracle AMM on mission critical product...
Categories: DBA Blogs

Meaning of object_id and data_object_id in dba_objects.

Tom Kyte - Wed, 2018-10-17 03:26
Hi Tom, For some objects in dba_objects, I see object_id is not matching with data_object_id even when that object is not part of the cluster. 21:35:49 SQL> select count(*) from dba_objects where data_object_id is not null and object_name not...
Categories: DBA Blogs

Podcast: On Microservices Design and Implementation

OTN TechBlog - Tue, 2018-10-16 23:00

"Like buying a Ferrari and towing it around with a horse."

That's how Java Champion and Microservices Patterns (Manning Publications) author Chris Richardson describes the approach some organizations take to implementing microservices. It's often a matter of faulty motivation. 

In helping organizations around the world get started with microservices, the first question Chris asks his clients is, "Why do you want microservices?" The responses are often surprising. "I've talked to people who viewed microservices as magic pixie dust. You sprinkle it on things and everything will be better," Chris reports.

Another problem is the mistaken belief that the goal is microservices. "Microservices is a means to an end," Chris says. From a DevOps perspective, "there are two really good metrics," Chris explains. "One of them is deployment frequency, how often you're deploying into production. The other one is lead time, the time from commit to deploy. To me, those are the two metrics that you should be optimizing. Microservices is the way to get there."

Oracle Developer Champion Lucas Jellema, CTO and consulting IT architect with AMIS Services, also advises against diving blindly into microservices. "First step back and consider why you are thinking about microservices in the first place," Lucas says. "You choose microservices because there are issues you want to overcome, challenges you want to deal with. In the end, the only thing that really matters is that IT provides business value, and you can only provide business value if you have properly running applications that provide you with the right business functionality. The typical challenge that we try to address using microservices is to evolve that functionality in an agile fashion without much effort and without too much cost. If microservices can help with that then we want to have them. But we don't want to have them because everyone is talking about them."

Fellow Developer Champion Luis Weir, CTO of the Oracle Practice at Capgemini sees the human factor as the greatest challenge in microservice adoption and development. One of his customers has "a very clear need to implement this style of architecture," Luis says. "But it's been a nightmare to align the teams and make them work in a way that's aligned with the this architecture style, as opposed to operating in a very traditional ITL style where you need to handoff between three different teams and and do everything in a waterfall way."

Luis finds that many organizations are stuck in the past. "Not all organizations are into the DevOps way of doing things," Luis explains. Some departments may be adopting agile practices and the like. "But the IT side of the organization, in many cases, is not. They're trying to digitalize a lot of legacy. So it's a little more complicated. You're dealing with people, educating them on how to become more agile or how to think about breaking an elephant into smaller pieces." Luis admits that it's not easy.

What makes the transition so challenging, according to Oracle ACE Sven Bernhardt, a solution architect with OPITZ Consulting, is the need for "total cultural change" within the organization. "They must embrace the adaptability, the changeability. They must have a different fault tolerance, a different culture for dealing with software failures and also with failures on decisions with respect to technologies which are used for implementing a specific business functionality as a microservice," Sven explains. Too many organizations underestimate the necessary cultural change, and find that switching to a DevOps mindset is tough slog. 

But that's just a fraction of what you'll learn in this podcast, as the panel addresses ways to meet the various challenges found in getting to microservices. Listen!

BTW: Each of the panelists will present sessions are Oracle Code One and Oracle OpenWorld 2018. See the list of sessions, below. 

The Panelists

Listed alphabetically

Sven Bernhardt
Oracle ACE
Solution Architect, OPITZ Consulting
Twitter LinkedIn

Code One Sessions
  • Integration Reloaded: Integration Solutions Based on Reactive Principles [DEV5306]
    With Arturo Viveros, Principal Consultant, Sysco AS
    Thursday, Oct 25, 11:00 a.m. - 11:45 a.m. | Moscone West - Room 2008
  • Implementing a Low TCO Poly-Cloud Microservices Solution with Oracle Cloud [BUS2272]
    With Lucas Jellema, CTO, AMIS Services BV
    José Rodrigues, BPM And Webcenter Business Manager, Link Consulting
    Monday, Oct 22, 5:45 p.m. - 6:30 p.m. | Marriott Marquis (Golden Gate Level) - Golden Gate C2
Lucas Jellema
Oracle Developer Champion
Oracle ACE Director
CTO, Consulting IT Architect, AMIS Services
Twitter LinkedIn  

Code One Sessions
  • A Cloud- and Container-Based Approach to Microservices-Powered Workflows [BOF4977]
    Tuesday, Oct 23, 7:30 p.m. - 8:15 p.m. | Moscone West - Room 2006
  • 50 Shades of Data: How, When, Why—Big, Relational, NoSQL, Elastic, Graph, Event [DEV4976]
    Monday, Oct 22, 10:30 a.m. - 11:15 a.m. | Moscone West - Room 2007
  • Implementing Microservices on Oracle Cloud: Open, Manageable, Polyglot, and Scalable [BOF4978]
    Monday, Oct 22, 7:30 p.m. - 8:15 p.m. | Moscone West - Room 2012
  • Oracle Cloud Soaring: Live Demo of a Poly-Cloud Microservices Implementation [DEV4979]
    With Guido Schmutz, Principal Consultant - Technology Mangager, Trivadis AG
    Luis Weir, CTO - Oracle Practice, Capgemini UK Plc
    Wednesday, Oct 24, 2:30 p.m. - 3:15 p.m. | Moscone West - Room 2018
  • Implementing a Low TCO Poly-Cloud Microservices Solution with Oracle Cloud [BUS2272]
    With Sven Bernhardt, Solution Architect, OPITZ Consulting
    José Rodrigues, BPM And Webcenter Business Manager, Link Consulting
    Monday, Oct 22, 5:45 p.m. - 6:30 p.m. | Marriott Marquis (Golden Gate Level) - Golden Gate C2
Chris Richardson
Java Champion
Founder, Eventuate, Inc.
Twitter LinkedIn  

Code One Session
  • Developing Asynchronous, Message-Driven Microservices [DEV5252]
    Wednesday, Oct 24, 11:30 a.m. - 12:15 p.m. | Moscone West - Room 2001
Luis Weir
Oracle Developer Champion
Oracle ACE Director
CTO, Oracle Practice, Capgemini
Twitter LinkedIn  

Code One Sessions
  • The Seven Deadly Sins of API Design [DEV4921]
    Tuesday, Oct 23, 4:00 p.m. - 4:45 p.m. | Moscone West - Room 2020
  • Oracle Cloud Soaring: Live Demo of a Poly-Cloud Microservices Implementation [DEV4979]
    With Lucas Jellema, CTO, AMIS Services BV
    Guido Schmutz, Principal Consultant - Technology Mangager, Trivadis AG
    Wednesday, Oct 24, 2:30 p.m. - 3:15 p.m. | Moscone West - Room 2018
Additional Resources Coming Soon

Groundbreakers Neha Narkhede, Charles Nutter, Graeme Rocher, Guido van Rossum Guido van Rossum, and Doug Cutting examine the forces shaping IT in this special panel discussion recorded at Oracle Code One.

Subscribe

Never miss an episode! The Oracle Developer Community Podcast is available via:

Latest News, Updates, and Roadmaps--Oracle Premier Support at Oracle OpenWorld

Chris Warticki - Tue, 2018-10-16 15:57

Our conference sessions give you security, and how-to information that you can apply when you are back on the job. Hear directly from Oracle Support experts and Oracle Support customers and learn how you can maximize the value Oracle Premier Support provides your company.

Bookmark the Focus on Oracle Premier Support document for quick reference on your cell phone and you will have all the Premier Support sessions and activities available at your fingertips. Click on the + button for a session to pre-register and add the session to your Oracle OpenWorld schedule.

Oracle Premier Support—Hear from Customers

Oracle Support customers tell the story best—why they rely on Oracle Premier Support and how to get more from your Oracle products—from best practices for security, compliance, and governance to moving Oracle Applications Unlimited products to Oracle Cloud Infrastructure. Whether your Oracle Applications Unlimited run on premises or in the cloud, Oracle Premier Support is there with you.

 

See all the Oracle Premier Support customer sessions.

 

Oracle Premier Support Security—Hear from Security Experts

Oracle Premier Support provides customers with an enhanced security posture. Presented by security experts with operational security experience, these sessions will give you with insight into current security trends, common causes of security breaches, and with specific recommendations to help you secure your environment.

 

See all Oracle Premier Support Security Sessions

 

Oracle Applications Unlimited—Through at Least 2030

Get the latest details on Oracle Applications Unlimited products and their availability—whether you run Applications Unlimited products on premises or in Oracle Cloud Infrastructure. See all the Applications Unlimited sessions.

See all Oracle Applications Unlimited sessions

 

Oracle Platinum Services

See how Oracle Platinum Services helps maximize availability and reduce support complexity through remote fault monitoring, decreased response times, and patching performed by Oracle experts—at no additional cost.

See all the Oracle Platinum Services sessions

 

Find all the Oracle Support sessions, activities, and events on the Support and Services Oracle OpenWorld page.

October 2018 Critical Patch Update Released

Oracle Security Team - Tue, 2018-10-16 14:59

Oracle today released the October 2018 Critical Patch Update

This Critical Patch Update provides security updates for a wide range of product families, including: Oracle Database Server, Oracle Golden Gate, Oracle Big Data Graph, Oracle Fusion Middleware, Oracle Enterprise Manager, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Siebel CRM, Oracle Industry Applications (Construction, Communications, Financial Services, Hospitality, Insurance, Retail), Oracle Java SE, Oracle Virtualization, Oracle MySQL, and Oracle Sun Systems Products Suite.

As with previous Critical Patch Update releases, a significant proportion of the patches is for third-party components (non-Oracle CVEs, including open source components). 

For more information about this Critical Patch Update, customers should refer to the Critical Patch Update Advisory located at https://www.oracle.com/technetwork/security-advisory/cpuoct2018-4428296.html and the executive summary published on My Oracle Support (Doc ID 2456979.1).  

October 2018 Critical Patch Update Released

Oracle Security Team - Tue, 2018-10-16 14:59

Oracle today released the October 2018 Critical Patch Update

This Critical Patch Update provides security updates for a wide range of product families, including: Oracle Database Server, Oracle Golden Gate, Oracle Big Data Graph, Oracle Fusion Middleware, Oracle Enterprise Manager, Oracle E-Business Suite, Oracle PeopleSoft, Oracle Siebel CRM, Oracle Industry Applications (Construction, Communications, Financial Services, Hospitality, Insurance, Retail), Oracle Java SE, Oracle Virtualization, Oracle MySQL, and Oracle Sun Systems Products Suite.

As with previous Critical Patch Update releases, a significant proportion of the patches is for third-party components (non-Oracle CVEs, including open source components). 

For more information about this Critical Patch Update, customers should refer to the Critical Patch Update Advisory located at https://www.oracle.com/technetwork/security-advisory/cpuoct2018-4428296.html and the executive summary published on My Oracle Support (Doc ID 2456979.1).  

New OA Framework 12.2.6 Update 15 Now Available

Steven Chan - Tue, 2018-10-16 12:41

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure.

We periodically release updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 15 (Patch 28739010:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch. Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • When Rich Table Interaction is set to off, data binding for user-customizable properties does not take effect for classic tables.

  • A script error occurs on clicking the Go button in the Web ADI LOV window when selecting the Web ADI template.

  • An enhancement that allows developers to set an accessibility role attribute to a table HTML element.

  • Claim line level descriptive flexfields are not saved on page update.

Related Articles

Categories: APPS Blogs

Oracle Code One Expands Support for Developers

Oracle Press Releases - Tue, 2018-10-16 11:00
Press Release
Oracle Code One Expands Support for Developers Oracle Code One now covers more technologies and reaches new communities

Redwood Shores, Calif.—Oct 16, 2018

Code One

Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card.

To support and empower the developer community, Oracle Code One will take place alongside Oracle OpenWorld on October 22 to 25 at Moscone West in San Francisco. Oracle’s premier event for developers has expanded to include more languages, technologies and developer communities. Oracle Code One will cover a wide range of topics from AI, blockchain, digital assistants and containers to Java and more languages such as Go, Rust and Python. Registration is still open to all developers and available at oracle.com/code-one.

Oracle Code One features daily keynotes at 5:00 PM in Moscone North’s Hall D. In the Java technical keynote on Monday, October 22, Georges Saab, Vice President of Development at Oracle, will share Java SE updates from the last twelve months including recent enhancements made in the latest Java 11 release. They will also share a glimpse into future projects aimed at accelerating user productivity such as Java in container environments and exploration of new code review options for the JDK. This year’s Duke’s Choice Award winners will also be announced during the keynote.

The Oracle Code One keynote on Tuesday, October 23, will explore topics ranging from managed Kubernetes and serverless functions to blockchain and intelligent digital assistants powered by chatbot technology. The keynote will be presented by Matt Thompson, Vice President of Developer Engagement and Evangelism at Oracle; Amit Zavery, Executive, Vice President of Fusion Middleware and PaaS Development at Oracle; and Siddhartha Agarwal, Group Vice President of Product Management and Strategy for Oracle Cloud Platform. The Code One Meetup at 5:00 PM lets developers not registered for Oracle Code attend the keynote, join a fireside chat with iconic leaders who have made groundbreaking developer innovations and explore evening sessions.

The Java Community Keynote will take place October 24 and feature special guest, James Gosling, creator of Java, together with Stephen Chin, Director of Developer Marketing and Heather VanCura, Director at Oracle and Chair of the Java Community Process, the keynote will also include developer groundbreakers from Canoo Engineering AG, Gluon, IT-Beratung, Snyk.

“As developers look to build increasingly complex cloud native applications, Oracle continues to provide new, innovative capabilities like AI and Machine Learning, blockchain and Kubernetes support for developers to leverage,” said Siddhartha Agarwal, Group Vice President of Product Management and Strategy at Oracle. “Oracle Code One is where developers can engage with Oracle’s technical experts and the larger developer ecosystem to learn how to build the next generation of these applications and services. The event features an unrivalled variety of technical sessions and a community of peers with expertise in the tools, tricks and technologies relevant to building for the cloud. Oracle is engaging with developers wherever they are located around the world to enable innovation via learning resources, developer-focused events, hands on hackfests and free Oracle Cloud Trials to help them get started.”

Throughout Oracle Code One, developers will find more of the Java content they expect with extended workshops, talks, sessions and Hands-on-Labs to explore technologies from Oracle and the broader developer ecosystem, including GraalVM, Oracle JET, the Fn Project, OpenJFX and GraphPipe. Developers at Oracle Code One can also expect unexpected demos based on the latest emerging technologies, from AI to blockchain.

Among this year’s exciting demos, sessions and keynotes, attendees will get to experience:

  • The Code Card – With Wi-Fi, buttons and an e-link screen, developers can design their own Code Card IoT device. Visitors to the Groundbreaker Hub at Oracle Code One will be able to get their hands on the Code Card and join a workshop to learn how to program it using Oracle Cloud Functions, serverless technology powered by the Fn Project.

  • Demo: Alpha Zero AI Algorithm Connect Four – The Meet the Experts Lounge on Monday, October 22 at 4:00 PM will feature an interactive demonstration of a neural network trained to play Connect Four using the AlphaZero algorithm and deployed using Oracle’s open source GraphPipe.

  • Demo: Blockchain Beer – An exclusive demo of how a micro-brewery outcompetes big brands with the blockchain.

  • Panel: Groundbreaker Icons – A discussion by thought leaders in software development and open source, including Doug Cutting, (Hadoop), Neha Narkhede (Kafka), Graeme Rocher (Grails), Guido Van Rossum (Python) and Charles Nutter (JRuby).

  • AR Scavenger Hunt Game – Guests in the Developer Lounge can win money for charity by searching for chess pieces with their phone cameras, by downloading a special app. Find the scavenger hunt image and a 3D Java Duke appears on the screen with a quiz on the JavaFX 11 platform. For each correct answer on the scavenger hunt, Oracle will donate money to Iridescent, a science, engineering and technology education nonprofit organization that empowers underrepresented young people to become self-motivated learners, inventors and leaders. A leaderboard in the Oracle Code One Developer Lounge will show the number of players, the number of correct answers and how much money has been raised for Iridescent.

Oracle Code One is also an opportunity for developers to learn about the wide range of open source and open standards which Oracle champions. Since joining the Cloud Native Computing Foundation last year, Oracle has continued to advance key serverless and container projects, including announcing new open serverless standard support on its open source Fn Project and critical new features for Oracle Container Engine for Kubernetes to address key Kubernetes issues. Oracle  also contributed many of its Kubernetes projects to the open source community, including JenkinsX Supported Cloud Provider for OKE, Flexvolume DriverVolume ProvisionerCloud Controller Manager and Terraform Kubernetes Installer. These announcements follow last year’s announcement that Oracle open sourced several container utilities. For developers working on machine learning, Oracle recently announced that it open sourced GraphPipe, to simplify how enterprises deploy and query machine learning models from any framework. Earlier this year, Oracle also released GraalVM, a polyglot virtual machine to run Java and JVM languages with full support for JavaScript and Node.JS, plus early support for Ruby, Python, R and LLVM bitcode.

In 2019, Oracle will host over 300 events around the world to connect with and educate developers with workshops, sessions and keynotes featuring prominent experts. To learn more about Oracle Developer Events, please visit: https://developer.oracle.com/events

Oracle Cloud Platform Momentum

At last year’s OpenWorld, Oracle announced new integrated cloud offerings that made it easier for developers to leverage transformative technologies and create modern applications. These included the launch of the Oracle Container Native Application Development Platform and the Oracle Blockchain Cloud Service, as well as the expansion of the Oracle Mobile Cloud portfolio to include artificial intelligence-powered chatbots.

To accelerate mobile and web application development and deployment, Oracle announced the availability of Oracle Visual Builder Cloud, which enables both business users and developers to build applications with little to no coding. Oracle API Platform Cloud provides full lifecycle API management services. Finally, Oracle Integration Cloud now brings pre-built application integration and process automation to the Oracle Cloud Platform, making the deployment and integration of these applications more seamless than ever.

Contact Info
Alex Shapiro
Oracle
+1 405.608.5044
alex.shapiro@oracle.com
Quentin Nolibois
Burson Cohn & Wolfe
+1.415.591.4097
quentin.nolibois@bm.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

About Oracle Code One

Oracle Code One is the industry’s most inclusive developer conference, featuring a collection of international and local experts and speakers to explore the latest in developer technologies, languages, practices and leading-edge topics. Expanded from Oracle’s JavaOne, Oracle Code One brings together extensive technical Java content and numerous keynotes, sessions and workshops across 11 tracks covering a wide range of topics from chatbots, microservices, AI, and blockchain to languages such as Go, Rust, Python, JavaScript, SQL, and R. For more information, to register or to watch Oracle Code One keynotes, sessions and more, visit www.oracle.com/code-one. Join the Oracle Code One discussion on Twitter.

About Oracle OpenWorld

Oracle OpenWorld, the industry’s most important business and technology conference for the past 20 years, hosts tens of thousands of in-person attendees as well as millions online. Dedicated to helping businesses leverage Cloud for their innovation and growth, the conference delivers deep insight into industry trends and breakthroughs driven by technology. With hundreds of demos and hands-on labs, plus exhibitions from more than 400 partners and customers from around the world, Oracle OpenWorld has become a showcase for leading cloud technologies, from Cloud Applications to Cloud Platform and Infrastructure. For more information; to register; or to watch Oracle OpenWorld keynotes, sessions, and more, visit www.oracle.com/openworld. Join the Oracle OpenWorld discussion on Twitter.

Future Product Disclaimer

The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, timing, and pricing of any features or functionality described for Oracle’s products may change and remains at the sole discretion of Oracle Corporation.

Forward-Looking Statements Disclaimer

Statements in this article relating to Oracle’s future plans, expectations, beliefs, and intentions are “forward-looking statements” and are subject to material risks and uncertainties. Such statements are based on Oracle’s current expectations and assumptions, some of which are beyond Oracle’s control. All information in this article is current as of October 16, 2018 and Oracle undertakes no duty to update any statement in light of new information or future events.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Talk to a Press Contact

Alex Shapiro

  • +1 405.608.5044

Quentin Nolibois

  • +1.415.591.4097

[BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1]

Online Apps DBA - Tue, 2018-10-16 10:38

This blog is the first part of 3 part blog series on How we can connect to Social Media using ICS Integration. Visit: http://bit.ly/2AdKw4F to move ahead to: 1) Learn With a Use Case for the practical implementations 2) To know about the Implementation and Testing Phases. 3) Learn, How to create a connector from […]

The post [BLOG] Oracle Integration Cloud Service(ICS): Using ICS to connect to Social Media [Part 1] appeared first on Oracle Trainings for Apps & Fusion DBA.

Categories: APPS Blogs

Inheriting super user privileges over a role automatically in PostgreSQL

Yann Neuhaus - Tue, 2018-10-16 09:18

In a recent project at a customer where we synchronize the users and group out of Active Directory we hit a little issue I was not aware of before. Suppose you have created a role in PostgreSQL, you made that role a superuser and then granted that role to another role. What happens when you login using the other role? Will you have the super user privileges by default? Sounds confusing, I know, so lets do a test.

To start with we create a simple role and make that role a super user:

postgres=# create role my_admin;
CREATE ROLE
postgres=# alter role my_admin superuser;
ALTER ROLE

Of course you could also do that in one step:

postgres=# create role my_admin superuser;
CREATE ROLE

As a second step lets create a new user that is a member of the admin group and inherits the permissions of that role automatically:

postgres=# create user my_dba login password 'admin' in role my_admin inherit;
CREATE ROLE
postgres=# \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

The questions now is: When we login using the my_dba user are we superuser automatically?

postgres@pgbox:/home/postgres/ [PGDEV] psql -X -U my_dba postgres
psql (12devel)
Type "help" for help.

postgres=> \du
                                    List of roles
 Role name |                         Attributes                         | Member of  
-----------+------------------------------------------------------------+------------
 my_admin  | Superuser, Cannot login                                    | {}
 my_dba    |                                                            | {my_admin}
 postgres  | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=> create database db1;
ERROR:  permission denied to create database
postgres=> 

… and we are not. What we can do is:

postgres=> set role my_admin;
SET
postgres=# create database db1;
CREATE DATABASE

The reason for that is that some privileges are not inherited automatically and these are: LOGIN, SUPERUSER, CREATEDB, and CREATEROLE.

What you can do is put something like that into “.psqlrc”:

set role my_admin

… or do it like that:

postgres=# alter user my_dba set role my_admin;
ALTER ROLE

This will explicitly set the role with each login and the super user privileges will be there. When you have a bit more complicated scenario where roles are assigned based on patterns in the username you could do something like this and add it to .psqlrc as well (or put that into a file and then execute that file in .psqlrc):

DO $$
DECLARE
  lv_username pg_roles.rolname%TYPE := current_user;
BEGIN
  if ( substr(lv_username,1,2) = 'xx'
       and
       position ('yy' in lv_username) > 0
     )
  then
    execute 'set role my_admin';
  end if;
  perform 1;
END $$;

… or whatever checks you need to identify the correct user names. Hope that helps …

 

Cet article Inheriting super user privileges over a role automatically in PostgreSQL est apparu en premier sur Blog dbi services.

Query the table in Oracle 12c In-Memory still have physical reads

Tom Kyte - Tue, 2018-10-16 09:06
1. I cached a table in Oracle12C inmemory as following. <code>SQL> SELECT A.SEGMENT_NAME, 2 SUM(A.INMEMORY_SIZE) / 1024 / 1024 / 1024, 3 SUM(BYTES) / 1024 / 0124 / 1024, 4 SUM(A.BYTES_NOT_POPULATED) 5 FROM V$...
Categories: DBA Blogs

Salary increment by using cursor

Tom Kyte - Tue, 2018-10-16 09:06
<code>declare i number; j varchar2(30); cursor raise is select name, salary from emp; begin open raise; loop fetch raise into j,i; i :=i+15; dbms_output.put_line(i||' '||j); exit when raise%notfound; end loop; end; /</code> I am try...
Categories: DBA Blogs

Filter in Interactive Report with morethen 1000 values against one field

Tom Kyte - Tue, 2018-10-16 09:06
Hello, Is there any way I can apply a filter with more than 1000 values i.e. 5000 in single filed while working on the interactive report. I just want to copy paste my values separated by ','
Categories: DBA Blogs

World’s First AI Smart Hives Network Helps Conserve Declining Global Honey Bee Populations

Oracle Press Releases - Tue, 2018-10-16 07:13
Press Release
World’s First AI Smart Hives Network Helps Conserve Declining Global Honey Bee Populations The World Bee Project and Oracle collaborate in extraordinary marriage between nature and technology

Data to be collected from an international network of connected smart hives, monitored and analysed with Oracle Cloud technology

London, UK—Oct 16, 2018

Oracle and The World Bee Project have announced a world-first approach to understanding the declines of honey bee populations and helping protect them. The new programme uses cloud technology to better understand honey bees, the world’s most important single species of pollinator in agricultural ecosystems. ‘The World Bee Project Hive Network’ will remotely collect data using a network of connected beehives. The data will then be fed into Oracle’s Cloud, which will use analytics tools including artificial intelligence (AI) and data visualisation, to give researchers new insights into the relationships between honey bees and their environments.

The World Bee Project Hive Network will allow researchers to ‘listen’ to the honey bees—analysing intricate acoustic data captured inside the smart hives, including the movement of bees’ wings and feet. Combined with other precision measurements—including temperature, humidity and honey yield—researchers will be able to closely monitor bee colonies, detecting patterns and predicting behaviours. This will enable conservationists and bee keepers to take action to protect colonies, such as preventing swarming at the wrong time of year or removing predators like the invasive Asian Hornet. The value of the data is in informing beekeepers of various different states of the colony throughout the year to aid colony management.

“Our lives are intrinsically connected to the bees,” said Sabiha Rumani Malik, Founder and Executive President at The World Bee Project CIC. “By protecting bees and other pollinators we can help solve problems with global food supply and poverty and reduce further loss of biodiversity and damage of ecosystems. Our partnership with Oracle Cloud is an extraordinary marriage between nature and technology. It will engage the public into caring more and more for pollinators, it will enable advanced research and, crucially, action on a scale previously impossible to achieve. The more we understand the relationships between pollination, food and human wellbeing, the more we can do to protect bees and pollinators—and help protect our planet and ourselves.”

The data and insights gained by using Oracle Cloud will be made available to research and conservation projects working to protect bees around the world. By sharing resources and fostering collaboration, The World Bee Project Hive Network initiative aims to multiply its impact and enable greater action to save bees.

“Technology is changing the game for conservation efforts,” said John Abel, Project Director, Oracle Cloud. “Using cloud-based technology, the World Bee Project is going to have a truly global, real-time view of bee population health for the first time. This will arm researchers with the information needed to work with governments and beekeepers to help reduce the decline in honey bee populations.”

The World Bee Project CIC partners with the University of Reading School of Agriculture, Policy and Development, one of the top 10 agriculture schools in the world. In future the partners hope to add the vision of bringing novel IT and knowledge to support ecological intensification.

Contact Info
James Drake
Oracle Corporate Communications
07917584801
james.w.drake@oracle.com
About Bees

Pollinators are declining at an alarming rate; a serious concern given their importance to global food security:

  • Bees are responsible for pollinating one third of the global food supply
  • Of the 100 crop species that feed 90% of the world’s population, bees pollinate 70
  • England’s honey bees are vanishing faster than anywhere else in Europe, with a 54% decline between 1985 and 2005.

Research is showing that increasingly inhospitable conditions for bees is to blame for their decline—driven by loss of flower habitats, intensified farming methods, climate change and increased use of pesticides.

About the World Bee Project

The World Bee Project CIC is a global initiative addressing biodiversity loss, food insecurity, and poverty, through ecological intensification and pollinator restoration programs.

The aim of the World Bee Project Hive Network is to help inform and implement global actions to improve pollinator habitats, create more sustainable ecosystems, and improve food security, nutrition and livelihoods by establishing a globally-coordinated monitoring programme for honey bees and eventually for key pollinator groups.

http://worldbeeproject.org

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.

Talk to a Press Contact

James Drake

  • 07917584801

Oracle Answers the Call to Help Cities Improve Citizen Services

Oracle Press Releases - Tue, 2018-10-16 07:00
Press Release
Oracle Answers the Call to Help Cities Improve Citizen Services San Jose and other cities turn to Oracle to transform non-emergency services

Redwood Shores, Calif.—Oct 16, 2018

embedBrightcove('responsive', false, 'single', '5848145879001');

The City of San Jose selected Oracle Service Cloud to launch a new 311 service that could help make it safer, more inclusive, sustainable and user-friendly.

Cities across the country have selected Oracle Service Cloud to rethink traditional 311 services and provide the best possible citizen experience. With Oracle Service Cloud, cities including The City of San Jose, The City of Albuquerque, Sacramento County and The City of Fort Wayne have been able to transform the way they engage with citizens for all non-emergency inquiries and services.   

The City of San Jose is the nation’s 10th largest city, with approximately one million residents. To support its goal of becoming America’s most innovative city by 2020, The City of San Jose selected Oracle Service Cloud to launch a new 311 service that could help make it safer, more inclusive, sustainable and user-friendly.

“The Oracle Service Cloud platform has enabled the City to more effectively respond to resident’s service requests,” says Desiree Jafferies, San Jose’s customer contact center manager. “It has transformed our customer experience, shifting away from a reactive response to a more proactive, real-time, data-driven service environment.”

The City of Albuquerque supports more than 900,000 citizens. To improve efficiency and provide its citizens with the best possible service, The City of Albuquerque selected Oracle Service Cloud to support its 311 service. With Oracle Service Cloud, The City of Albuquerque has been able implement a new conversational interface that allows residents to ask the Alexa voice-activated system to help with a range of requests from finding a lost pet to scheduling a large package pickup, removing graffiti, getting rid of litter or reporting an abandoned car.

“This service allows us to offer residents innovative channels to engage with their city government,” stated Mayor Tim Keller. “Alexa’s conversational user interface is convenient for the community and will help us make the most effective and efficient use of 311 resources. We’re integrating emerging technologies with government to ensure that people from all walks of life in Albuquerque have easy ways to participate with their City and utilize City services.”

Sacramento County supports more than 1.5 million citizens. To provide the best possible service and support to internal agencies and other public constituents, Sacramento County selected Oracle Service Cloud to integrate data from different sources and optimize how residents interact with its 311 service across channels. With Oracle Service Cloud, Sacramento County has been able to automate previously manual processes to free up its communications center staff to focus more on customer service, collaboration and public engagement.  

The City of Fort Wayne, Indiana is home to more than 250,000 citizens. To capture the voice of its citizens and publicly hold city departments and officials accountable, The City of Fort Wayne selected Oracle Service Cloud to modernize its 311 service. With Oracle Service Cloud, The City of Fort Wayne has been able to reduce costs by increasing self-service channels and enabling citizens to engage on their preferred channels, while also reducing average wait times by approximately 60 percent.

“With Oracle, we have been able to connect seven Divisions with 16 different departments and change the game by unifying the entire city’s metrics into one performance scorecard. This not only holds departments accountable for their service performance, but it has also enabled us to move from a reactive to a proactive organization,” said Eric Harris 311 Call Center Manager, The City of Fort Wayne. “Now through our unified system, citizens are able to take a picture of a pothole with their smartphone and we are able to fill it within four hours. The city has also been able to reduce agent training time from three months to three weeks.”

Oracle Service Cloud is part of Oracle Customer Experience (CX) Cloud Suite, which empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. 

Contact Info
Danielle Cormier-Smith
Oracle
+1.914.441.4896
danielle@positive-comms.com
About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at oracle.com.

Trademarks

Oracle and Java are registered trademarks of Oracle and/or its affiliates.

Talk to a Press Contact

Danielle Cormier-Smith

  • +1.914.441.4896

Pages

Subscribe to Oracle FAQ aggregator