Feed aggregator

ORA-02089: COMMIT is not allowed in a subordinate session

Tom Kyte - Wed, 2017-02-15 05:06
Hello Tom, I got an issue above. I have some stored procedure which enables/disables some Oracle queue, procedure is being called from java, java method is wrapped by '@Transactional' annotation. It opens the main transaction, where my db procedu...
Categories: DBA Blogs

Servers for Pratice

Tom Kyte - Wed, 2017-02-15 05:06
Hi, Just visited the site livesql.oracle.com, look like it is very good environment for developers to improve their skills in Coding. I am learning RAC & Apps DBA concepts.Is there any environment to implement Apps DBA & RAC concepts like liv...
Categories: DBA Blogs

Facing error while fetching partition_position from all_tab_partitions

Tom Kyte - Wed, 2017-02-15 05:06
Hi Tom Am facing trouble with a simple query. Basically, my ultimate goal here is to purge the data older than 2 years for few tables(which I have mentioned in purge_table_list table). I have renamed all the partitions to the format of last 7 ch...
Categories: DBA Blogs

Dropping all objects under a schema

Tom Kyte - Wed, 2017-02-15 05:06
Hi Connor, The below query will drop all the table which are present in the current user A's schema (normal scenario login using user 'A'). <code> select 'drop '||object_type||' '|| object_name || ';' from user_objects where object_type in...
Categories: DBA Blogs

Subtract 2 timestamps to find the difference in hours

Tom Kyte - Wed, 2017-02-15 05:06
Hi, How can I find out the time difference in hours between 2 timestamp with timezone I tried below one <code> select extract(HOUR FROM diff) from ( select '2/14/2017 3:39:15.097484 PM +00:00' - '2/14/2017 1:39:15.097484 PM +00:00' as dif...
Categories: DBA Blogs

ORA-00936: missing expression Solution

Complete IT Professional - Wed, 2017-02-15 05:00
Did you get an ORA-00936: missing expression error? Learn what it means and how to resolve it in this article. ORA-00936 Cause The error you’ve gotten is this: ORA_00936: missing expression Oracle’s official “cause and action” that appears along with the error is: Cause: A required part of a clause or expression has been omitted. […]
Categories: Development

Webcast: "Planning Your Upgrade to Oracle E-Business Suite 12.2"

Steven Chan - Wed, 2017-02-15 02:04

EBS 12.2 upgrade webcastOracle University has a wealth of free webcasts for Oracle E-Business Suite.  If you're looking for help with planning your upgrade to EBS 12.2, see:

Anne Carlson, Senior Director Applications Technology, discusses key upgrade planning considerations, combining lessons learned from customers with practical advice from Oracle’s Development, Consulting, and Support organizations. Understand how to build the business case, identify needed time and resources, prepare business and IT staff for changes, plan for required system changes, create an effective test strategy, and more. This material was presented at Oracle OpenWorld 2016.

Categories: APPS Blogs

Links for 2017-02-14 [del.icio.us]

Categories: DBA Blogs

Financial Reports - which tool to use? Part 1

Rittman Mead Consulting - Wed, 2017-02-15 01:00
Financial Reports - which tool to use? Part 1

One of the treats of working in the Business Intelligence world is that we are asked to analyze different aspects of a business. In fact, we are asked to analyze many different types of businesses, too. Most of us using BI tools have come from some previous background. Be it Marketing, Finance, Supply Chain or any other, we most likely had work experience before we got here. Maybe one of our jobs even led to Business Intelligence. The fact is, we are not experts in all areas. It would take several lives to make such a claim, because each area can be very complex and take years to master. The truth, for most of us, is that we have our favorite areas. They are often related to what we are most familiar with.

Financial Reports - which tool to use? Part 1

Over time, I came to really appreciate how simple numbers can be, and developed this - hard to understand - favoritism towards financial reports. While some business areas can be artistic and even vague, numbers are never vague. I have a great appreciation for that. Working with numbers is always precise. In the end, they have to match. No matter how great your report looks, if the numbers don’t add up the report is always wrong. Plus, financial layouts are generally very defined going in, so there is little room for error.

Financials in OBIEE

So, the endeavor begins when you are a BI consultant and everything is supposed to add up properly and look very nice. OBIEE is an extremely powerful tool, and this gives users the impression that it can solve all problems. While it can solve most problems, it falls short on some key features needed for easy financial reporting. That is not to say that Financials can’t be handled in OBIEE - but it is definitely to say that it is not easy.

So, if financial reports are not easy to create in OBIEE, than we are left with two very simple options:

  1. Struggle through it and make it happen

  2. Choose another tool

I have made the mistake of choosing option 1 some times, but quickly realized that option 2 couldn’t be as bad. Countless times, I have been asked to create financial reports in OBIEE. Of course, they needed to tie up and match a specific format: they needed to have blank lines inserted between one section and another, and the alignment of the categories was very important. They often required very detailed variance calculations, so that a company could see where they stood as far as change overtime. Variance percentages are key on these types of reports, and if you have dealt with them in OBIEE, you know that different types of variances and their grand totals can often pose challenges for report writers.

So, in order to accomplish the formatting needed, you end up adding extra code here and there, in essence trying to make OBIEE do something that it’s not supposed to do. Soon, you are experiencing performance issues and a new array of considerations are in place. You start removing your “special code”, then you loose your formatting. The numbers on your financial statement are still correct, but your report looks something like this:

Financial Reports - which tool to use? Part 1

While, in reality, you were trying to get here:

Financial Reports - which tool to use? Part 1

** The Balance Sheet above was created using HFR for illustration of formatting only.

Looking at a different OBIEE financial report (below), you will see that a lot of formatting can be done in these reports, but they will always look like OBIEE reports, if you know what I mean.

Financial Reports - which tool to use? Part 1

In this example, the first column is out of order - as far as Income Statements go. This was left alone on purpose to display one of the issues with creating these statements in OBIEE. The tool does not easily allow you to choose which items will go in each row. So, in the criteria tab, in Answers, you choose the order of the columns, but if you need the rows in order, you will need to either:

  1. Use a hidden column created just for sorting purposes

  2. Leverage selection steps, or

  3. Create a measure column for each row that you will need, use a pivot table, and add the Measure Labels as rows on your pivot

I will illustrate the third option, as it is my preferred way of ordering rows. Suppose that you have a very simple criteria tab such as this:

Financial Reports - which tool to use? Part 1

Naturally, your results would default like this on a table:

Financial Reports - which tool to use? Part 1

If you use a Pivot table instead, you can drag your Measure Labels onto the Rows:

Financial Reports - which tool to use? Part 1

And now, you will be able to see your measures as rows. You can easily reorder them as needed by just moving the order of the columns in the Measures section of your Layout editor.

Financial Reports - which tool to use? Part 1

This seems like a simple solution if you know precisely what all your rows should be, and even better, if you don’t have a huge amount of measures on the report. In real life, this type of row ordering is high maintenance:

  1. You must label each measure to match the account category name for each row

  2. You must filter each measure by its account category (or account number)

  3. If the account category name changes in your DB, you must manually rename your columns to match the new naming convention

  4. If you add or delete account categories, you must manually add and delete columns from your report

OBIEE 12c offers a great improvement in this area: the ability to “save columns” is described very well by Jason Baer on this blog: https://www.rittmanmead.com/blog/2016/01/my-favorite-obiee-12c-feature-that-almost-no-one-is-talking-about/

With the new release of the product you can save as many financial columns as you would like in the web catalog, which allows you to reuse them. As a consequence, you will streamline report maintenance by updating the columns’ format and formula directly from the catalog (instead of inside every report). In fact, if you are spending too much time maintaining your existing reports out of OBIEE 11g, you will automatically benefit from an upgrade to 12c just based on this single feature. Check here for more info: https://www.rittmanmead.com/obiee-12c-upgrade/

This is a great improvement, but you will still need to deal with an overall lack of flexibility for dynamically adding and deleting columns, setting orders, adding blank space, indenting and calculating variances along with proper grand totals.

After spending more time than you should in order to create a simple report, you really start considering other tools. If you are already working in the Oracle stack, the obvious choices will be BI Publisher and Hyperion Financial Reporting (HFR).

Financials in Essbase/HFR

Hyperion Financial Reporting (HFR) brings a powerful solution to financial statements, because it allows you to create pixel perfect reports that are pre-aggregated in an Essbase cube. Just with that, two big problems were just solved: formatting and performance.

In the example below, you see that HFR allows you to place metrics on both sides of the Account Category (butterfly layout - difficult to accomplish in OBIEE):

Financial Reports - which tool to use? Part 1

In addition to formatting and performance, there are some definite pros to consider when choosing HFR:

  1. The calculations in HFR dynamically reference cells, as in excel. So, if a cell changes, the cells that are referencing the original cell will automatically be updated

  2. HFR has the ability to create financial books and batches, and also has a powerful bursting feature

HFR is a great solution for Income Statements, Balance Sheets and other reports that come from Essbase cubes. In a simplistic way, an Essbase cube is a combination of tables that have been joined and pre-aggregated. Since most tables coming out of a financial module in a system can often be joined, you should be able to create Essbase cubes to use as a source for your HFR reports. You will rarely have a requirement that cannot be handled by HFR and Essbase, but some situations may be problematic, for example, if your report requires a measure to be entered at run-time, if results from multiple cubes need to be added, or if your layout is very complex. This is why :

In an HFR report, you start by inserting a grid onto your report and then you associate that grid with a specific Essbase cube. If you need data from two cubes on the report, you can insert another grid and associate that with the second cube. You can also create a report that leverages calculations between existing grids (for the purpose of doing math with two or more separate cubes):

Financial Reports - which tool to use? Part 1

Many thanks to my collegue, Mark Cann https://www.rittmanmead.com/blog/author/mark-cann/, for working through this solution with me

The challenge here is that you may end up with multiple layout grids on your HFR report, which will complicate the report creation and maintenance going forward. It is important to know that if your requirements call for strange off-setting of cells and multiple different looking blocks, then HFR may not be the best tool for the job. If you choose HFR for this purpose, you will spend too much time trying to make things right.

Financial Reports - which tool to use? Part 1

*This is a simple Essbase implementation with 2 cubes (or databases): a Balance Sheet and an Income Statement cube.

The fact is, some financial reports are very tricky and do not come solely from a Financial module. For example, if your company is evaluated monthly for a line of credit, your bank may require to look at several components of your business in order to determine the amount that you can borrow. They will base their decision not only on your monthly revenue, but also your liabilities, such as accounts payables, and some of your assets, such as inventory. What they ask for really depends on their internal lending requirements, and also on the type of business that you have. These are, therefore, highly customized reports that never come out-of-the box anywhere. For this reason, most companies spend a lot of man hours creating these reports as a huge excel report, after the employees have managed to pull information from many different modules together.

These excel “monsters” do the job. They are accepted by the banks, and will get you that loan. On the downside, they need to be redone every month and will drag resource hours out of profitable projects. The flat excel files are also prone to mistakes, as the values are manually keyed in each time. If you make a mistake favorable to the company, your bank will look at it as a very negative issue. If you make an unfavorable mistake, you will not be able to borrow as much as you qualify for. This is a no win situation, so the reports must be accurate every time.

Financial Reports - which tool to use? Part 1 To check for accuracy, there is nothing like testing overtime. But, since you must rework the report each month, you don’t have that opportunity.

The solution is to create a template that will pull from all of these different modules, calculate the numbers, add the results automatically to a pixel perfect formatted report. Over the development cycle, these mappings and calculations will be thoroughly tested, and then they will only be reused going forward.

While you may spend some time pulling this logic together, you will only have to click a few buttons after you are done, for months or years to come. In fact, I have clients that have been running reports such as this one for years. They have been saving a couple of weeks in report creation every month.

Let’s look at an example of what I am talking about:

Financial Reports - which tool to use? Part 1

On this report, each number (disguised as $1234) has been mapped to a calculation that will be pulled dynamically, according to the date entered on the prompt. The inventory amounts are adjusted according to banking requirements, and a rate is allocated depending on the row. This amount is later added/subtracted from receivables and existing contracts. Most of these numbers were created as separate OBIEE analyses. Some amounts could even be tied into web services to get the daily futures prices to estimate the value of contracts when the report runs. All lines are considered in the final equation before the total borrowing amount can be calculated. Per this bank’s requirement, this form needed to be printed and signed, then submitted monthly.

Lending/financing reports may be the most tricky, and the most time consuming for companies to generate every month. The reports may be required by the bank, or by a company that is leasing or financing valuable equipment to your company. These reports need to show your prospective lender everything about your business. They will often need to be done in a format that is specified by your lender. These formats are not negotiable, in fact, some lenders still use old forms that used to be read by a machine.

Here is another small snippet of a financing report that I had to create recently. Now, which tool would you use for 10 different pages of something like this, which required some of the amounts to be entered in the prompt? *Note: the report had to look “exactly” like this:

Financial Reports - which tool to use? Part 1

Well, as I mentioned in the beginning of this article, OBIEE would not be your partner in this type of endeavor. I can guarantee that this relationship would fail: strange formatting with black boxes, line numbers, need for Headers (footers too, not shown here), indenting, etc.

You may consider Essbase/HFR combo, for formatting and performance, but you will soon realize that:

  1. Performance does not tend to be an issue with these reports, as they are generally submitted to lenders on a monthly basis, and therefore can be scheduled to run automatically in the middle of the night.

  2. As mentioned earlier, HFR requires a layout grid to be inserted before the report can be designed. Here, you would end up with multiple grids to handle the calculation of different cells from multiple cubes - which can be cumbersome to create and maintain.

  3. The measures in an HFR report should come from the pre-aggregated cube. In this example, some of the measures were entered as part of the prompt and are calculated at run time. At this point, you must scratch the Essbase/HFR option for this one!

So, now you are still stuck with your monster excel spreadsheet, then retyping the numbers onto the required form.
Financial Reports - which tool to use? Part 1

Before you marry this solution, let me present you with the tool that can do everything: BI Publisher.

Stay tuned for the second part of this blog, when I will share why I believe that BIP can solve the most challenging reporting requirements out there!

Categories: BI & Warehousing

Data Pump or Data Pain Part03 – user/db object

Michael Dinh - Tue, 2017-02-14 22:48

You might be thinking, why is it necessary to specify schemas versus perform full import or why create SQL file?

$ cat impdp_full02_user.par

directory=DATA_PUMP_DIR
userid="/ as sysdba"
metrics=Y
dumpfile=full.dmp
logfile=impdp_full_user.log
schemas=GGS_ADMIN,DEMO
include=USER
sqlfile=user.sql

There are 5 users imported which correspond to EXU8USR view.
If users already exists in the new database, wouldn’t create user just fail?

From demo below #schemas=GGS_ADMIN,DEMO (commented) which will
import SYS/SYSTEM/OUTLN

$ impdp parfile=impdp_full02_user.par

Import: Release 11.2.0.4.0 - Production on Tue Feb 14 19:04:05 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
Startup took 0 seconds
Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_01":  /******** AS SYSDBA parfile=impdp_full02_user.par
Processing object type DATABASE_EXPORT/SYS_USER/USER
     Completed 1 USER objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/USER
     Completed 4 USER objects in 0 seconds
Job "SYS"."SYS_SQL_FILE_FULL_01" successfully completed at Tue Feb 14 19:04:07 2017 elapsed 0 00:00:01

One good reason to create SQL file is to know what changes will be made to DB ahead of time.

$ cat /u01/app/oracle/product/11.2.0.4/db_1/rdbms/log/user.sql

-- new object type path: DATABASE_EXPORT/SYS_USER/USER
-- CONNECT SYSTEM
 ALTER USER "SYS" IDENTIFIED BY VALUES 'S:A1856CFD100792EB56F0432B20D3C4AAD57A48DD2C89A94E055FE37B2DD0;8A8F025737A9097A'
      TEMPORARY TABLESPACE "TEMP";
-- new object type path: DATABASE_EXPORT/SCHEMA/USER
 ALTER USER "SYSTEM" IDENTIFIED BY VALUES 'S:0966E912AE33B8963B86F44E9731A9D0126DF07B0A8EADF85E248BBC18D5;2D594E86F93B17A1'
      TEMPORARY TABLESPACE "TEMP";
 CREATE USER "OUTLN" IDENTIFIED BY VALUES 'S:14BB7D86CDE99B2AF179EA19879DCB4A7DA651430A671FE8453ADB858B35;4A3BA55E08595C81'
      TEMPORARY TABLESPACE "TEMP"
      PASSWORD EXPIRE
      ACCOUNT LOCK;
 CREATE USER "GGS_ADMIN" IDENTIFIED BY VALUES 'S:2AD4199BA9BF38A158B1181515FA385823EABDD9945B84F9698037BF319A;2E16F5C363B2AFF8'
      DEFAULT TABLESPACE "GGS_DATA"
      TEMPORARY TABLESPACE "TEMP";
 CREATE USER "DEMO" IDENTIFIED BY VALUES 'S:63BE233139FAE11FA97490DC8D7CABDAED282C89A7D343CE4D45972C8087;4646116A123897CF'
      DEFAULT TABLESPACE "USERS"
      TEMPORARY TABLESPACE "TEMP";

$ grep DATABASE_EXPORT /u01/app/oracle/product/11.2.0.4/db_1/rdbms/log/expdp_full.log
|grep -v SCHEMA|sort

Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/AUDIT
Processing object type DATABASE_EXPORT/CONTEXT
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION
Processing object type DATABASE_EXPORT/PROFILE
Processing object type DATABASE_EXPORT/RESOURCE_COST
Processing object type DATABASE_EXPORT/ROLE
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYS_USER/USER
Processing object type DATABASE_EXPORT/TABLESPACE
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK

SYS_USER excluded; otherwise, SYS password will be changed via ALTER USER.

$ cat impdp_full03_dbobj.par

directory=DATA_PUMP_DIR
userid="/ as sysdba"
metrics=Y
dumpfile=full.dmp
logfile=impdp_full_dbobj.log
include=AUDIT
include=CONTEXT
include=DB_LINK
include=DIRECTORY
include=GRANT
include=PASSWORD_VERIFY_FUNCTION
include=PROFILE
include=PUBLIC_SYNONYM/SYNONYM
include=RESOURCE_COST
include=ROLE
include=TRUSTED_DB_LINK
include=SYSTEM_PROCOBJACT
sqlfile=dbobj.sql

Next, import objects from DATABASE_EXPORT.

$ impdp parfile=impdp_full03_dbobj.par

Import: Release 11.2.0.4.0 - Production on Tue Feb 14 20:34:31 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning and Real Application Testing options
Startup took 0 seconds
Master table "SYS"."SYS_SQL_FILE_FULL_01" successfully loaded/unloaded
Starting "SYS"."SYS_SQL_FILE_FULL_01":  /******** AS SYSDBA parfile=impdp_full03_dbobj.par
Processing object type DATABASE_EXPORT/PASSWORD_VERIFY_FUNCTION
     Completed 1 PASSWORD_VERIFY_FUNCTION objects in 0 seconds
Processing object type DATABASE_EXPORT/PROFILE
     Completed 1 PROFILE objects in 0 seconds
Processing object type DATABASE_EXPORT/ROLE
     Completed 16 ROLE objects in 0 seconds
Processing object type DATABASE_EXPORT/GRANT/SYSTEM_GRANT/PROC_SYSTEM_GRANT
     Completed 4 PROC_SYSTEM_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/GRANT/SYSTEM_GRANT
     Completed 48 SYSTEM_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/RESOURCE_COST
     Completed 1 RESOURCE_COST objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/DB_LINK
     Completed 2 DB_LINK objects in 0 seconds
Processing object type DATABASE_EXPORT/TRUSTED_DB_LINK
     Completed 1 TRUSTED_DB_LINK objects in 0 seconds
Processing object type DATABASE_EXPORT/DIRECTORY/DIRECTORY
     Completed 2 DIRECTORY objects in 0 seconds
Processing object type DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
     Completed 6 OBJECT_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/CONTEXT
     Completed 3 CONTEXT objects in 1 seconds
Processing object type DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
     Completed 6 SYNONYM objects in 0 seconds
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
     Completed 3 PROCACT_SYSTEM objects in 0 seconds
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
     Completed 17 PROCOBJ objects in 0 seconds
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
     Completed 4 PROCACT_SYSTEM objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
     Completed 24 OBJECT_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/GRANT/OWNER_GRANT/OBJECT_GRANT
     Completed 4 OBJECT_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/SCHEMA/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT
     Completed 3 OBJECT_GRANT objects in 0 seconds
Processing object type DATABASE_EXPORT/AUDIT
     Completed 29 AUDIT objects in 0 seconds
Job "SYS"."SYS_SQL_FILE_FULL_01" successfully completed at Tue Feb 14 20:34:33 2017 elapsed 0 00:00:02

$ egrep ‘LINK|SYNONYM|DIRECTORY’ /u01/app/oracle/product/11.2.0.4/db_1/rdbms/log/dbobj.sql

-- new object type path: DATABASE_EXPORT/SCHEMA/DB_LINK
CREATE DATABASE LINK "PRIVATE_DBLINK.LOCALDOMAIN"
CREATE PUBLIC DATABASE LINK "PUBLIC_DB_LINK.LOCALDOMAIN"
-- new object type path: DATABASE_EXPORT/TRUSTED_DB_LINK
-- new object type path: DATABASE_EXPORT/DIRECTORY/DIRECTORY
 CREATE DIRECTORY "DATA_PUMP_DIR" AS '/u01/app/oracle/product/11.2.0.4/db_1/rdbms/log/';
 CREATE DIRECTORY "TEST" AS '/tmp/';
-- new object type path: DATABASE_EXPORT/DIRECTORY/GRANT/OWNER_GRANT/OBJECT_GRANT
GRANT WRITE ON DIRECTORY "DATA_PUMP_DIR" TO "DEMO";
GRANT WRITE ON DIRECTORY "DATA_PUMP_DIR" TO "EXP_FULL_DATABASE";
GRANT WRITE ON DIRECTORY "DATA_PUMP_DIR" TO "IMP_FULL_DATABASE";
GRANT READ ON DIRECTORY "DATA_PUMP_DIR" TO "EXP_FULL_DATABASE";
GRANT READ ON DIRECTORY "DATA_PUMP_DIR" TO "IMP_FULL_DATABASE";
GRANT WRITE ON DIRECTORY "TEST" TO "GGS_ADMIN";
-- new object type path: DATABASE_EXPORT/SCHEMA/PUBLIC_SYNONYM/SYNONYM
CREATE  PUBLIC SYNONYM "OL$" FOR "SYSTEM"."OL$";
CREATE  PUBLIC SYNONYM "OL$HINTS" FOR "SYSTEM"."OL$HINTS";
CREATE  PUBLIC SYNONYM "OL$NODES" FOR "SYSTEM"."OL$NODES";
CREATE  PUBLIC SYNONYM "PRODUCT_PROFILE" FOR "SYSTEM"."PRODUCT_PRIVS";
CREATE  PUBLIC SYNONYM "PRODUCT_USER_PROFILE" FOR "SYSTEM"."PRODUCT_PRIVS";
CREATE  PUBLIC SYNONYM "PUBLIC_HAWK" FOR "GGS_ADMIN"."OGG$Q_TAB_E_HAWK";
oracle@arrow1:HAWKA:/media/sf_working/datapump
$

++++++++++

-- CONNECT DEMO
CREATE DATABASE LINK "PRIVATE_DBLINK.LOCALDOMAIN"
   CONNECT TO CURRENT_USER
   USING 'sales';
-- CONNECT SYS
CREATE PUBLIC DATABASE LINK "PUBLIC_DB_LINK.LOCALDOMAIN"
   CONNECT TO "REMOTE_USERNAME" IDENTIFIED BY VALUES ':1'
   USING 'test';

Cablenet Selects Oracle Communications to Modernize Infrastructure

Oracle Press Releases - Tue, 2017-02-14 21:14
Press Release
Cablenet Selects Oracle Communications to Modernize Infrastructure Cablenet will deploy Oracle Communications’ full suite of IMS and VoLTE capabilities to dramatically simplify network design, deployment and operations

Redwood Shores, Calif.—Feb 15, 2017

Cablenet Communications Systems, an alternative telecommunications provider that offers broadband services, fixed telephony and television, will use Oracle Communications technologies to modernize and future-proof its IMS network with Oracle Communications Unified Session Manager (OCUSM) and Oracle Communications Evolved Communications Application Server (OCECAS). OCUSM’s next-generation converged core supports a variety of value-added services, such as a virtualized NFV-capable network architecture. With Oracle, Cablenet will be able to improve service agility, accelerate time-to-market and streamline ongoing operations to gain a competitive advantage and boost business results.

“Oracle’s NFV-ready IMS solution will provide Cablenet true service agility with out-of-the-box service creation for VoLTE and VoWiFi,” explains Yiannos Michaelides, Management Information Systems Manager for Cablenet. “Our Oracle solutions will reduce our OPEX significantly and provide an excellent return on investment.”

Oracle Communications Unified Session Manager will provide Cablenet with a complete set of standard-compliant 3GPP IMS functions and interfaces in a single solution. As such, Cablenet will be able to accelerate its IMS rollout and converge its disparate fixed and mobile access networks, laying the foundation for advanced services that span devices and locations. The NFV-capable solution will also allow Cablenet to minimize upfront investments while closely aligning ongoing capital expenditures with evolving business demands.

In tandem, Oracle Communications Evolved Communications Application Server will enable Cablenet to accelerate its VoLTE rollout and will simplify the implementation of future services like VoWiFi and VoLTE. OCECAS simplifies application lifecycle management and provides carrier-grade performance and reliability for revenue-critical services.

“In today’s increasingly competitive marketplace, our customers are constantly seeking solutions that will help improve their agility, streamline operations and accelerate time-to-market,” said Doug Suriano, senior vice president and general manager, Oracle Communications. “Oracle NFV enabled IMS solutions provide simplicity in design and operation, enabling a low cost of ownership and a faster and easier rollout of services such as VoLTE and VoWiFi. We’re pleased that Cablenet will be able to enjoy such positive return-on-investment with our OCUSM and OCECAS solutions.”

Contact Info
Katie Barron
Oracle
+1 202-904-1138
katie.barron@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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

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, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Katie Barron

  • +1 202-904-1138

Kristin Reeves

  • +1.415.856.5145

Log Buffer #504: A Carnival of the Vanities for DBAs

Pythian Group - Tue, 2017-02-14 19:15

This edition of Log Buffer covers Oracle, Microsoft SQL Server, and MySQL.

Oracle:

Data Pump or Data Pain Part02 – tablespace/user

Monday Spotlight: It’s About Security – Oracle Exadata SL6

0001_specify_date_format_mask.md copy

OGG Custom Adapters: How to include a unique identifier for every record in custom adapter?

One of the optimizer enhancements that appeared in 12.2 for SQL is the “band join” that makes certain types of merge join much more efficient.

Microsoft SQL Server:

How to import data to Azure SQL Data Warehouse using SSIS

Using Index-Organized Tables in Oracle

Query Performance Tuning – A Methodical Approach

SQL Server Temporal Tables: How-To Recipes

Fix Commvault Backup Failures After an Upgrade

MySQL:

MySQL may return results in non-deterministic order with ‘order by’

Shinguz: MySQL and MariaDB authentication against pam_unix

MySQL in the Cloud – Pros and Cons of Amazon RDS

With 500+ VividCortex Users, Shopify Eliminates High Latency Queries From Redis and MySQL

An Introduction to MariaDB’s Data at Rest Encryption (DARE)

Categories: DBA Blogs

node-oracledb Session at DeveloperWeek, San Francisco 2017

Christopher Jones - Tue, 2017-02-14 17:54

I just finished my session on node-oracledb at DeveloperWeek on Pier 27 insunny, fantastic San Francisco. I'm in my old neighborhood, enjoyinga familar view of the Bay Bridge from the speaker room window. Thereis a big hum around me from sessions and demo booths as developers arenetworking and learning.

If you missed my session you can check out the slides. (They should be available fora month or so). I've added some slides that didn't fit into the 40minute session, but you'll just have to imagine all the cool, extratips I verbalized during the presentation! Make sure to come and listen tome speak at a future conference.

PS Thanks to the Oracle Apps UX crew for the photographs (and forlunch afterwards). I'm looking forward to visiting their Oracle HQlab to see all the cool stuff they do.

Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017

node-oracledb Session at DeveloperWeek, San Francisco 2017

Christopher Jones - Tue, 2017-02-14 17:54

I just finished my session on node-oracledb at DeveloperWeek on Pier 27 in sunny, fantastic San Francisco. I'm in my old neighborhood, enjoying a familar view of the Bay Bridge from the speaker room window. There is a big hum around me from sessions and demo booths as developers are networking and learning.

If you missed my session you can check out the slides. (They should be available for a month or so). I've added some slides that didn't fit into the 40 minute session, but you'll just have to imagine all the cool, extra tips I verbalized during the presentation! Make sure to come and listen to me speak at a future conference.

PS Thanks to the Oracle Apps UX crew for the photographs (and for lunch afterwards). I'm looking forward to visiting their Oracle HQ lab to see all the cool stuff they do.

Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017 Christopher Jones presenting on node-oracledb at Developer Week in San Francisco on 14 February 2017

Oracle to Help Businesses Better Support Global Operations with Seamless Tax Reporting

Oracle Press Releases - Tue, 2017-02-14 17:00
Press Release
Oracle to Help Businesses Better Support Global Operations with Seamless Tax Reporting New cloud tax and reporting solution helps tax professionals, CFOs, and controllers manage complex country-specific tax reporting requirements through automation

Redwood Shores, Calif.—Feb 14, 2017

Oracle today announced a new finance cloud solution that helps companies, operating in multiple countries, meet complex taxation requirements and regulatory reporting standards imposed by each country. In our globalized economy, compliance with sophisticated tax and statutory laws around the world continues to be a constant challenge for finance professionals. Now these professionals can rely on Oracle Tax Reporting Cloud Service (TRCS), which streamlines tax reporting processes and manages complexity to ultimately enable compliance with new and existing tax regulations.

Oracle TRCS delivers an out-of-the-box cloud solution to help organizations automate their tax provision and country-by-country reporting (CbCR). TRCS enables seamless transparency between tax and finance to reduce risk and brings tax and finance functions together in a unified, secure, and scalable cloud platform. It also streamlines tax reporting processes, including data collection, workflow, data automation, and pre-built KPIs for audit flags.

“Tax reporting is a complicated process, especially for businesses operating in multiple countries, which needs automation to help keep up with the increasing demands,” said Hari Sankar, group vice president of enterprise performance management (EPM) at Oracle. “Oracle TRCS enables organizations to transparently unify tax and finance data in the cloud, with pre-built best practice tax reporting, and provides a platform to significantly improve the broader tax function.”

With a strong tax framework that includes workflow, dashboards, segregation of duties, and transparent calculations, Oracle TRCS allows tax departments to spend more time on analysis and planning instead of on data reconciliation, which can be a complex and time-consuming task in the ledger or stand-alone tax provision system. Oracle TRCS was built for the cloud with the business user in mind and introduces new capabilities and innovations built on best practices from Oracle’s on-premises offering—Oracle Hyperion Tax Provision. By efficiently planning, reporting, and automating tax—with transparency and auditability, regardless of country of operation—TRCS also enhances CbCR, US GAAP, IFRS, and statutory tax reporting.

Additional features include:

  • Task management and calendaring framework that is configurable and integrated with finance systems; businesses can automate the whole tax calendar including tax filing dates, tax provision, and audit management tasks
  • Supplemental data management tool that is configurable and provides a centralized repository for manual input
  • Pre-built dashboards and reports that deliver simple self-service reporting
  • Configurable dashboards that provide analysis across total tax, including direct, sales & VAT, fixed assets, property tax, and more
  • Oracle Smart View for Microsoft Office provides powerful ad hoc analysis for all tax reporting data
  • Direct data integration with source finance systems, including both cloud and on-premises applications

Oracle TRCS easily integrates with multiple Enterprise Resource Planning (ERP) systems, as well as Oracle Enterprise Performance Management (EPM) Cloud and on-premises offerings, and specifically enables the sharing of data, metadata, and processes with the finance function during the financial close cycle.

“Many companies have still managed their global tax reporting processes through Excel and struggle to make the step into applying technology,” said Bart Janssen, Partner, Deloitte Tax Lawyers. “I am certain that with TRCS, the threshold for making that leap for many clients will become lower.”

Oracle TRCS is available now for existing and new customers. Businesses can choose flexible deployment options to best fit their needs. For additional information, visit Oracle Cloud and connect with Oracle EPM Cloud on Twitter.

Contact Info
Joann Wardrip
Oracle
+1.650.607.1343
joann.wardrip@oracle.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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

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, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Joann Wardrip

  • +1.650.607.1343

IP Telecom Implements Oracle’s Zero Data Loss Recovery Appliance to Boost Growth of its Data Protection & Recovery as a Service Business

Oracle Press Releases - Tue, 2017-02-14 12:56
Press Release
IP Telecom Implements Oracle’s Zero Data Loss Recovery Appliance to Boost Growth of its Data Protection & Recovery as a Service Business IP Telecom and Oracle worked together to implement this Cloud Business solution to ensure 100% data protection

Redwood Shores, Calif.—Feb 14, 2017

Oracle Portugal today announces that the telecommunications leader IP Telecom has selected Oracle’s Zero Data Loss Recovery Appliance (Recovery Appliance), the industry’s only solution to offer end-to-end data protection for Oracle databases, eliminate data loss exposure and maintain business availability, to ensure their national market customers have access to Data Protection & Recovery as a Service as a Cloud Solution.

IP Telecom is a company held by Infraestruturas de Portugal specialized in telecommunications, Corporate Cloud and Information Security solutions. Oracle’s Zero Data Loss Recovery Appliance was implemented jointly by Oracle Portugal and by IP Telecom and will be available in its Cloud Solutions portfolio.

Oracle’s Zero Data Loss Recovery Appliance is the first appliance ever to eliminate data loss exposure for critical Oracle Databases. When using traditional solutions to restore a database, businesses typically lose all data generated since the last backup—often hours to days of critical data. The Recovery Appliance also dramatically reduces the impact of backups on production servers and networks, virtually eliminating the need for lengthy backup windows. The cloud-scale architecture enables a single Recovery Appliance to manage the data protection requirements of thousands of databases, avoiding the cost and complexity of disparate backup systems.

The solution now available is a result of the partnership agreement signed in June 2016 between Oracle and IP Telecom, aiming to assure the availability of a proper and innovative offer, with customized scaling, based on Oracle’s recognized high-service levels offered by Infrastructure as a Service, which has competitive advantages of real value added.

According to Rui Ribeiro, General Manager of IP Telecom, "This first joint offer with Oracle means that we provide an unparalleled level of data protection to our Cloud national market customers. For us, the information of all our customers is critical, so we seek to create value-added and reliable offerings, ensuring that our customers focus only on their business, because they know that their data is safe and available with our Solutions.“.

Hugo Abreu, Country Manager at Oracle Portugal, said:

“Existing data protection solutions fail to meet the demands of critical databases because they treat databases as simply files to copy rather than as transactional systems with specific data integrity, performance, and availability requirements. With traditional backup solutions, business data is lost, end users and customers are impacted, and deployment and management are complex and fragmented. Oracle's Zero Data Loss Recovery Appliance tightly integrates advanced data protection technologies with Oracle Database to address these challenges head-on, enabling IP Telecom to offer its clients an efficient and effective protection and recovery service for one of their greatest asset: data."

Contact Info
Sarah Fraser
Oracle PR
+1.650.743.0660
sarah.fraser@oracle.com
About IP Telecom

IP Telecom is a telecommunications company and a specialized services operator in the areas of telecommunications, information systems and technologies.

Recognized as a benchmark in this area, the company has a qualified team able to design valuable solutions tailored to the needs of each client and which guarantees its "turnkey" implementation.

Operating in Portugal since 2000, it is led by the management of the Portuguese highway and railway infrastructure - Infraestruturas de Portugal, part of the IP Group.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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

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, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Sarah Fraser

  • +1.650.743.0660

Customers Across Industries Adopt Oracle Management Cloud to Improve User Experience and Application Delivery

Oracle Press Releases - Tue, 2017-02-14 12:56
Press Release
Customers Across Industries Adopt Oracle Management Cloud to Improve User Experience and Application Delivery Customers use Oracle Management Cloud to increase performance and decrease cost of traditional systems-of-record and DevOps-oriented systems of innovation

Redwood Shores, Calif.—Feb 14, 2017

Oracle today announced that Oracle Management Cloud is experiencing exceptional growth with nearly 950 new customers and partners across the globe within its first year of availability.  FORS, IDEA Cellular, and Safexpress are among the many organizations around the world choosing Oracle Management Cloud to help improve IT resource utilization, increase DevOps productivity, and ensure that critical applications are up and running.

Part of the Oracle Cloud Platform, Oracle Management Cloud is a suite of next-generation integrated monitoring, management, and analytics cloud services that leverage machine learning and big data techniques against the full breadth of customers’ operational data. Oracle Management Cloud’s unified platform helps customers improve IT stability, prevent application outages, and increase DevOps agility, as well as assists in hardening security across their entire application and infrastructure portfolio.

“Across the globe, companies have embraced the new agility of cloud computing,” said Prakash Ramamurthy, senior vice president, Systems Management and Security, Oracle. “While this new environment is great for rapid innovation, it is extremely difficult for development and operations management and staff to keep pace with constant change. Oracle Management Cloud was developed to allow developers to focus more on coding and less on infrastructure while it helps operations staff to efficiently manage fast changing applications and infrastructure – whether customers bought the underlying technology from Oracle or any other vendor; without restrictions upon where it’s running.”

Oracle Management Cloud Revolutionizes Systems Management for Customers Around the World and Across Many Public and Private-Sector Verticals

Telecom:  “Idea is the third-largest telecom service provider in India,” said Prakash Paranjape, CIO, IDEA Cellular. “Given the digital revolution India is going through, we felt that business transformation needed a new management approach. Oracle Management Cloud has allowed us to use contemporary technologies to predict reasons behind a cause through its machine learning capabilities. It has helped us correlate sources of data and logs from multiple components which previously were not looked into.” 

Logistics: “With Oracle Management Cloud, we have been able to manage our IT more efficiently and detect problems before they impact users,” said Sanjay Bakshi, senior manager, IT, Safexpress. “For example, we are able to detect issues like slow transactions and resolve them proactively and faster, which is making a difference in our customer experience.” 

Value-Added Distributor:  “Using Oracle Management Cloud raises quality and expands the range of services available to our partners in their projects,” said Andrey Tambovsky, director of Technology, FORS Distribution. “Administrators use the next-generation analytical tools to improve the quality of services available in the hybrid cloud. We strongly recommend that our partners and their customers use Oracle Management Cloud for in-depth analysis and monitoring of infrastructure and equipment in their own data centers and are ready to assist them in the implementation of these projects.”

Recent Releases Demonstrate Commitment to Customer-Focused Innovation

Oracle Management Cloud’s frequent releases provide an ongoing stream of exciting new customer-centric features that are automatically available in the cloud service’s Software-as-a-Service management platform.  Top features released in the last few months include:

  • Better application performance monitoring through new synthetic end-user monitoring, native mobile application monitoring and APDEX end-user experience rating
  • More efficient log analytics with automatic outlier identification and trend correlation using machine learning-based clustering
  • Smarter IT analytics using improved visualizations and host resource instrumentation, as well as a new database performance tuning application
  • Deeper infrastructure monitoring for popular network devices, public cloud IaaS on Amazon and Oracle as well as monitoring for Oracle PaaS
  • Seamless cross-service navigation with topology-aware exploration for monitored applications that is shared across all Oracle Management Cloud services

Oracle Cloud

Oracle Cloud is the industry’s broadest and most integrated public cloud, offering a complete range of services across SaaS, PaaS, and IaaS. It supports new cloud environments, existing ones, and hybrid, and all workloads, developers, and data.  The Oracle Cloud delivers nearly 1,000 SaaS applications and 50 enterprise-class PaaS and IaaS services to customers in more than 195 countries around the world and supports 55 billion transactions each day.

For more information, please visit us at http://cloud.oracle.com.

Contact Info
Nicole Maloney
Oracle
+1.650.506.0806
nicole.maloney@oracle.com
Kristin Reeves
Blanc & Otus
+1.415.856.5145
kristin.reeves@blancandotus.com
About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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

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, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

Talk to a Press Contact

Nicole Maloney

  • +1.650.506.0806

Kristin Reeves

  • +1.415.856.5145

Announcing eSignatures for WebCenter Content

WebCenter Team - Tue, 2017-02-14 11:21
Authored by: Sarah Gabot, Demand Generation Manager, HelloSign 

HelloSign, the innovative product leader in the eSignature space, has joined forces with TEAM Informatics to provide Oracle WebCenter Content (WCC) customers the ability to integrate the HelloSign API directly into the WCC interface

This means users can now start using eSignatures in WCC, making it easier to send, track, and manage documents that require signature such as contracts or agreements. Users can streamline their content management workflows, resulting in more accurate documents, improved tracking, better security, and faster document turnaround times. 

Users can quickly prepare documents for signature using an easy-to-use interface. This eliminates the time consuming, tiresome manual process of printing, signing, and scanning agreements or business contracts. 

“At TEAM we are always striving to provide our existing and potential customers with new and innovative products that solve everyday business needs,” said Doug Thompson, CEO of TEAM. “Our partnership with HelloSign allows us to integrate an electronic signing process into WebCenter Content, enabling enterprise customers to send, sign, and manage documents at any time from any device.

How does it work? 
In the WebCenter Content interface, users can start the signing process by clicking on the “action” menu. 


Then you’re able to prepare a document to send for eSignatures to the signer. Once it’s sent, you can track the status of the document at any time directly in WCC. 

As the sender, you also get email updates when a signer completes the document–you’ll always be in-the-know with your document statuses!  

Once the document is signed, you’ll be able to see the status in WCC. You’ll have full access to retrieve the document to store or download it to the repository. 

Benefits
When you start using HelloSign for WCC, you get to reap the following benefits: 
  • Easy-to-use integration into WebCenter Content UI
  • Bank-level security for legally binding agreements
  • Ease of use experience for signer and sender reduces turnaround time
  • Removes the need for signers to print, scan, and sign documents 
How to get started
To learn more about this integration, reach out to the TEAM Informatics sales team for a demo sales@teaminformatics.com. To learn more about HelloSign and our services, reach out to us oracle-sales@hellosign.com

Oracle Hospitality Research Identifies Drivers for Consumer Loyalty and Impact of Technology on Hotel and Restaurant Guest Experience

Oracle Press Releases - Tue, 2017-02-14 11:00
Press Release
Oracle Hospitality Research Identifies Drivers for Consumer Loyalty and Impact of Technology on Hotel and Restaurant Guest Experience Global Insights Offer Guidance for Global Food and Beverage and Hotel Industries as they Aim to Capture Repeat Business in 2017

Redwood Shores, Calif.—Feb 14, 2017

Today Oracle announced the findings of two research initiatives aimed at identifying the consumer drivers for loyalty in the food and beverage and hotel industries and the impact of technology in curating a unique hotel guest experience. Insights from both studies highlight a global demand for loyalty programs in the hospitality industry and the critical role of technology to inspire hotel staff to create memorable guest experiences.

Identifying Consumer Drivers for Loyalty

Loyalty programs are a critical driver of repeat business for both the food and beverage and hotel industries with their ability to identify consumer habits, demographics and personalization opportunities. With these insights the hospitality industry can more effectively create frictionless experiences that encourage repeat engagement. To better understand what makes loyalty programs most effective Oracle Hospitality recently conducted a survey of 6,500 global food and beverage consumers and 8,000 hotel travelers represented by the U.S., Brazil, Mexico, Australia, U.K., Germany, France and Japan.

Recipe for Engagement: Essential Ingredients for a Restaurant Loyalty Program

Key insights from the research for the food and beverage industry include:

  • Consumers around the world want to join loyalty programs. In the U.S., 65 percent of consumers are already members of one or more food and beverage programs. Even in Japan, where the lowest percentage of consumers were already members of a program from our survey, nearly one-third belonged to a loyalty program.
  • Plastic loyalty cards remain the preferred loyalty tool with mobile applications gaining popularity. At 62 percent overall, plastic swipe cards were the most preferred method across all generations. At a 56 percent preference, Millennials wanted to use apps for loyalty programs and 50 percent of Gen Xers also agreed that apps are a preferable method.
  • Perceived personal savings drive loyalty. Money off of every purchase (71 percent) and free products (63 percent) were the top two most attractive rewards to consumers.

“Loyalty programs provide restaurant operators with the opportunity to reward guests for repeat business, to create a marketing database for personalized promotions, and to guide the strategy for future programs ensuring their relevancy,” said Mike Webster, senior vice president and general manager, Oracle Hospitality and Oracle Retail. “Oracle Hospitality has a differentiated offering that leverages best-in-class, cloud POS with an integrated gift and loyalty solution and cloud analytics suite that minimizes the creation of disparate data silos which can create false perspectives of guest engagement.”

What Do Consumers Want from a Hotel Loyalty Program?

Key insights from the research for the hotel industry include:

  • Hoteliers still have a chance to create long-term relationships. Among all survey participants, 58.7 percent reported that they do not belong to a hotel loyalty program. A mere 3.2 percent stated that they belong to 5 or more.
  • Loyalty initiatives are “sticky” and encourage repeat stays. Globally a pattern of repeat business was evident among respondents, ranging from 33.6 percent of Australians to 53.8 percent of Mexicans who said they often stay in hotels that offer loyalty programs.
  • Consumers want control over how they redeem rewards. Globally a majority of consumers identified that they are interested in being able to choose how they redeem their rewards (61 percent) and 57 percent are interested or very interested in being able to customize their hotel guest experience (room choice, newspaper, late check out, etc.).
Creating the Coveted Hotel Guest Experience

Oracle Hospitality also polled more than 2,700 travelers from the U.S., U.K., France and Germany to better understand technology’s impact on the hotel-guest experience and gain insight into how technology investments can be a differentiator for winning consumer business. The study also adds perspectives of hoteliers, both chains and independents, to shed light on their technological pursuits and gauge alignment with consumer expectations.

Key insights from the study highlight opportunities to engage guests prior to and during their hotel stay:

  • Nearly two-thirds of U.S. guests said it was “very or extremely important” for hotels to continue investing in technology to enhance the guest experience.
  • Ninety-four percent of business travelers and 80 percent of leisure travelers value the ability to use their smartphones to request service and message hotel staff.
  • Guests are comfortable sharing with hoteliers a fair amount of personal information: 71 percent would share information about food preferences/allergies and 64 percent would share their entertainment preferences.
  • Sixty-two percent of guests used non-hotel sources such as the Internet for dinner reservations and activity recommendations, bypassing the concierge from whom guests say they would prefer to get such assistance.

The full findings of the report can be accessed here and point to a critical opportunity for hoteliers. Once travelers arrive in the lobby, their notion of a memorable experience can be shaped entirely by the deeds and words of hotel staff which can be informed and augmented by technology investments.

“Rather than worry that greater reliance on technology will erode the human aspect of hospitality, hoteliers need to embrace it for what it can be – an invaluable tool to better understand their guests and orchestrate stays that they will long remember,” said Mike Webster, senior vice president and general manager, Oracle Hospitality and Oracle Retail. “Technology can address the industry’s dual challenge of operating efficiently at scale and simultaneously providing individualized service.”

Join Oracle Hospitality at Oracle Industry Connect

Oracle Hospitality will be presenting new product releases, market insights and customer case studies at Oracle Industry Connect in Orlando, FL from March 20-22, 2017. For more information on attendance please visit http://www.oracleindustryconnect.com to register.

About Oracle

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit 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

The following 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, and timing of any features or functionality described for Oracle's products remains at the sole discretion of Oracle Corporation. 

How to add years to a timestamp without losing fractions

Tom Kyte - Tue, 2017-02-14 10:46
Hi, I have a column of type <code>TIMESTAMP</code> t in which I safe timestamps with 6 digit precision e.g. 03-FEB-17 04.45.01.909000 PM Due to the way they have ben added to the table they are missing two things: 1. The time zone information ...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator