Feed aggregator

Microsoft Azure: Adding user requires more work as expected

Dietrich Schroff - 11 hours 33 min ago
Just to try some things in Microsoft Azure i wanted to add an additional user to my test account. But this was not so easy:

Go to "Azure Active Directory" and "Users":

 

 But then:

I thought this is not really a problem, because openesb.eu is my domain, so let's try to verify this one:


The problem is, that i am not able to change this settings. So i tried, if i am lucky, but:
So only way to add users in such a minimal setup, is to add accounts from live.com etc..

Migration of a very large warehouse database

Tom Kyte - Fri, 2019-03-22 13:46
This question is more of a solicitation for advice than an actual question. I've been tasked with migrating a large warehouse database from one set of hardware in one datacenter to a new set of hardware in a different datacenter. Excluding temp, ...
Categories: DBA Blogs

How to show special/unseen characters from a column in a plsql ?

Tom Kyte - Fri, 2019-03-22 13:46
Hi Tom, I have a table with special characters in a column. The column values are like this with the plsql below. <code>set serveroutput on; declare c varchar2 (100); a number; begin for i in ( select ekd0756_cur...
Categories: DBA Blogs

how to copy chrome bookmarks from one computer to another

Matt Penny - Fri, 2019-03-22 12:20

copy "C:\Users\matty\AppData\Local\Google\Chrome\User Data\Default\Bookmarks"
"\sh00001\c$\Users\matty\AppData\Local\Google\Chrome\User Data\Default" -verbose

Categories: DBA Blogs

Stats advisor

Jonathan Lewis - Fri, 2019-03-22 08:10

This is just a little shout-out about the Stats Advisor – if you decide to give it a go, what sort of things is it likely to tell you. The answer is in a dynamic performance view called v$stats_advisor_rules – which I’ve list below from an instance running 18.3.0.0.


SQL> set linesize 180
SQL> set trimspool on
SQL> set pagesize 40
SQL> column description format a75
SQL> column name format a32
SQL> break on rule_type duplicate skip 1
SQL> select * from v$stats_advisor_rules;

  RULE_ID NAME                             RULE_TYPE DESCRIPTION                                                                     CON_ID
---------- -------------------------------- --------- --------------------------------------------------------------------------- ----------
         0                                  SYSTEM                                                                                         0
         1 UseAutoJob                       SYSTEM    Use Auto Job for Statistics Collection                                               0
         2 CompleteAutoJob                  SYSTEM    Auto Statistics Gather Job should complete successfully                              0
         3 MaintainStatsHistory             SYSTEM    Maintain Statistics History                                                          0
         4 UseConcurrent                    SYSTEM    Use Concurrent preference for Statistics Collection                                  0
         5 UseDefaultPreference             SYSTEM    Use Default Preference for Stats Collection                                          0
         6 TurnOnSQLPlanDirective           SYSTEM    SQL Plan Directives should not be disabled                                           0

         7 AvoidSetProcedures               OPERATION Avoid Set Statistics Procedures                                                      0
         8 UseDefaultParams                 OPERATION Use Default Parameters in Statistics Collection Procedures                           0
         9 UseGatherSchemaStats             OPERATION Use gather_schema_stats procedure                                                    0
        10 AvoidInefficientStatsOprSeq      OPERATION Avoid inefficient statistics operation sequences                                     0

        11 AvoidUnnecessaryStatsCollection  OBJECT    Avoid unnecessary statistics collection                                              0
        12 AvoidStaleStats                  OBJECT    Avoid objects with stale or no statistics                                            0
        13 GatherStatsAfterBulkDML          OBJECT    Do not gather statistics right before bulk DML                                       0
        14 LockVolatileTable                OBJECT    Statistics for objects with volatile data should be locked                           0
        15 UnlockNonVolatileTable           OBJECT    Statistics for objects with non-volatile should not be locked                        0
        16 MaintainStatsConsistency         OBJECT    Statistics of dependent objects should be consistent                                 0
        17 AvoidDropRecreate                OBJECT    Avoid drop and recreate object seqauences                                            0
        18 UseIncremental                   OBJECT    Statistics should be maintained incrementally when it is beneficial                  0
        19 NotUseIncremental                OBJECT    Statistics should not be maintained incrementally when it is not beneficial          0
        20 AvoidOutOfRange                  OBJECT    Avoid Out of Range Histogram endpoints                                               0
        21 UseAutoDegree                    OBJECT    Use Auto Degree for statistics collection                                            0
        22 UseDefaultObjectPreference       OBJECT    Use Default Object Preference for statistics collection                              0
        23 AvoidAnalyzeTable                OBJECT    Avoid using analyze table commands for statistics collection                         0

24 rows selected.

As you can see the rules fall into three groups: system, operation, and object – and you can’t help noticing at all three levels how commonly the theme is: “just stick with the defaults!”.

As so often happens when I start writing a catch-up or “remind myself” not I found that Tim Hall has already written all about it.

When AWS SCT Unable to Connect to MySQL in RDS or EC2

Pakistan's First Oracle Blog - Fri, 2019-03-22 05:27
AWS Schema Conversion Tool (SCT) is one of the must tool for a successful migration of databases to AWS RDS.

If you are trying to connect to MySQL hosted on EC2 instance or RDS and unable to make the connection despite of setting the security groups correctly and making sure that port, hostname, username and password are right, then first check the log of SCT.




2019-03-22 19:40:16.866 [   1]     GENERAL INFO    global_settings:
    app_folder=AWS Schema Conversion Tool
    bucket-name=sct-cloud9-test
    console_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    convert_without_statistic_reminder=false
    data_migration_settings=
    db2luw_driver_file=
    debug_mode=false
    ext_pack_version_alert=true
    facade_log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    file-system-thread-count=1
    forget-state=false
    greenplum_driver_file=
    install_dir=C:\Users\mirza
    log.max_file_size_mb=100
    log.max_files_count=20
    log_folder=C:\Users\mirza\AWS Schema Conversion Tool\Log
    log_folder_extractors=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log
    log_folder_extractors_ask_before_load=false
    log_folder_extractors_cassandra=C:\Users\mirza\AWS Schema Conversion Tool\Extractor Log\Cassandra
    maria_driver_file=
    message_level.CLONE_DATACENTER=INFO
    message_level.COMPARE_SCHEMA=INFO
    message_level.CONTROLLER=INFO
    message_level.GENERAL=INFO
    message_level.LOADER=INFO
    message_level.PARSER=INFO
    message_level.PRINTER=INFO
    message_level.RESOLVER=INFO
    message_level.TELEMETRY=INFO
    message_level.TRANSFORMER=INFO
    message_level.TYPEMAPPING=INFO
Caused by: com.amazon.sct.dbloader.DbLoaderHandledException: Connection wasn't established. Check connection properties.
at com.amazon.sct.dbloader.DbLoader.checkConnection(DbLoader.java:512)
at com.amazon.sct.dbloader.DbLoader.connect(DbLoader.java:349)
at com.amazon.sct.dbloader.DbLoaderContainer.checkAccessibility(DbLoaderContainer.java:25)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:26)
at com.amazon.sct.task.TestConnectionTask.call(TestConnectionTask.java:12)
at javafx.concurrent.Task$TaskCallable.call(Task.java:1423)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
... 1 more

In this case, there are no errors about time out which commonly refers to security group configuration or any about the credential issue. Here the issue is not with SCT or any of AWS component, rather its about the user which you are using to connect to MySQL.

Create user MySQL as follows and try and it should work:

CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypass';
CREATE USER 'myuser'@'%' IDENTIFIED BY 'mypass';

GRANT ALL ON *.* TO 'myuser'@'localhost';
GRANT ALL ON *.* TO 'myuser'@'%';

Then first test connection using MySQL workbench and then try with SCT.

Hope it helps.

Categories: DBA Blogs

Intro: Initial Thoughts On Oracle Autonomous Database Cloud Services (Automatic For The People)

Richard Foote - Thu, 2019-03-21 22:37
I’m currently writing up a few blog pieces on indexing in the Oracle Autonomous Database environments, but I thought I’ll begin by introducing what exactly are Oracle Autonomous Database Cloud Services and some of my initial thoughts, as there’s still some confusion on all this. Introduced by Uncle Larry at Oracle OpenWorld 2017, Oracle Autonomous […]
Categories: DBA Blogs

ORA-02396: exceeded maximum idle time, please connect again

Tom Kyte - Thu, 2019-03-21 19:26
Dear Mr. Tom, i have an issue according the IDLE_TIME parameter.. I used to open more than one session to the database (different scheam's on same Database)... and our dba set IDLE_TIME as 15 minutes, and even if the session is not idle (i'm ...
Categories: DBA Blogs

truncating empty table generate ORA-02266:

Tom Kyte - Thu, 2019-03-21 19:26
Tom , why truncating empty table generates the error ORA-02266 ? SQL> select count(*) from t_data; COUNT(*) ---------- 0 SQL> truncate table t_data * ERROR at line 1: ORA-02266: unique/primary keys in t...
Categories: DBA Blogs

SQL query to find FK IDs with a series of values

Tom Kyte - Thu, 2019-03-21 19:26
we have below tables <code>create table bca(id number(2)); insert into bca(10); insert into bca(11); insert into bca(7); create TABLE abc( di NUMBER(2), fk_id NUMBER(3), yek VARCHAR2(20), elv VARCHAR(15...
Categories: DBA Blogs

JD Edwards EnterpriseOne 9.2—Why You Should Upgrade Now

Chris Warticki - Thu, 2019-03-21 12:29
Make This Your Last JD Edwards EnterpriseOne Upgrade 

If you’ve been considering an upgrade to JDE EnterpriseOne 9.2, but haven’t done so yet, you should plan to upgrade now.  There are a lot of exciting changes and new features that you can take advantage of once you upgrade.

  • Full Premier Support through at least 2030—rest assured that Oracle will protect your investment well into the next decade, and beyond.
  • Continuous AdoptionJDE EnterpriseOne 9.2 will be your last upgrade—but you will continue to receive new features and functionality that don't require more budgeting for expensive and time-consuming upgrades.
  • Continuous Delivery—choose only the features you want, when you want them.
  • JDE EnterpriseOne 9.2 is Cloud-ready—Optimize EnterpriseOne with Oracle’s IaaS, extend your solution via PaaS, or complement your solution with a SaaS offering.
  • Dynamic new product features—such as UX One, Personalization, Orchestrator, Citizen Developer Frameworks, and Mobility.

In June 2018, Oracle announced that Premier Support for EnterpriseOne 9.2 will be provided through at least 2030.  EnterpriseOne 9.2 will be the go-forward solution as Premier Support for World A9.4 ends in April 2022.  In preparation for this, Oracle has provided a direct migration path from JD Edwards World to JD Edwards EnterpriseOne.

For Oracle Support customers, Premier Support provides you with ongoing benefits:
  • Software updates
  • Security alerts and updates
  • Critical Patch Updates
  • Tax, Legal, and Regulatory Updates
  • Access to the My Oracle Support Knowledge Base
  • 24x7 assistance with service requests, and much more
Committed Through at Least 2030

Listen Lyle Ekdahl, SVP for JD Edwards, on JD Edwards’ Continuous Delivery Model.


Committed to Customers | Committed to Innovation | Committed to Products

 

Learn More

Hands-On Lab at Collaborate 2019

Steven Chan - Thu, 2019-03-21 11:15

If you are attending Collaborate 2019, don’t miss the opportunity to attend the latest of our popular hands-on lab sessions. This year's hands-on lab is titled Oracle E-Business Suite Cloud Manager: Deployment, Configuration and Review of EBS Lifecycle Management Capabilities and its key points are outlined in this article.

The hands-on lab serves as a practical introduction to Oracle E-Business Suite Cloud Manager. You will use a trial account to deploy Cloud Manager from an Oracle Cloud Infrastructure (OCI) Marketplace image; configure Cloud Manager; and use the One-Click Provisioning and Cloning features to create new environments.

In addition, the instructors will demonstrate the steps involved in performing a lift and shift of an on-premises EBS environment to OCI.

The hands-on lab will be held in the CC RIVER FL 007D room, and is scheduled to run for approximately two hours on the following dates and times:

Sunday, April 7, 1:45 PM – 4:00 PM

  • To register: 11382 (https://app.attendcollaborate.com/event/member/554040)

Monday, April 8, 3:15 PM – 5:30 PM

  • To register: 11383 (https://app.attendcollaborate.com/event/member/554041)

Note: As places at each session are strictly limited, we highly recommend that you register ahead of time at the indicated links to reserve your spot, and arrive at least 10 minutes early to claim your seat  - any unclaimed places will be released when the session begins.

Prerequisites and Skills

You will need:

  • Your own Windows laptop or Mac, with:
    • A modern browser such as Firefox, Google Chrome, or Safari
    • PuTTY (or equivalent)
  • Knowledge of:
    • Standard UNIX commands
    • PuTTY (or equivalent) usage

We look forward to seeing you at Collaborate 2019!

Related Articles References
Categories: APPS Blogs

Lost time

Jonathan Lewis - Thu, 2019-03-21 07:51

Here’s a little puzzle that came up in the ODC database forum yesterday – I’ve got a query that has been captured by SQL Monitor, and it’s taking much longer to run than it should but the monitoring report isn’t telling me what I need to know about the time.

Here’s a little model to demonstrate the problem – I’m going to join a table to itself (the self join isn’t a necessary feature of the demonstration, I’ve just been a bit lazy in preparing data). Here’s a (competely truthful) description of the table:

SQL> desc t1
 Name                          Null?    Type
 ----------------------------- -------- --------------------
 ID                                     NUMBER
 MOD_1000                               NUMBER
 V1                                     VARCHAR2(40)
 V2                                     VARCHAR2(40)
 PADDING                                VARCHAR2(100)

SQL> select num_rows, blocks from user_tables where table_name = 'T1';

  NUM_ROWS     BLOCKS
---------- ----------
    400000       7798

1 row selected.


And here’s the output I get from dbms_monitor.report_sql_monitor() for the query running on 18.3.0.0


Global Information
------------------------------
 Status              :  DONE (ALL ROWS)
 Instance ID         :  1
 Session             :  TEST_USER (261:36685)
 SQL ID              :  g6j671u7zc9mn
 SQL Execution ID    :  16777218
 Execution Started   :  03/21/2019 08:54:56
 First Refresh Time  :  03/21/2019 08:54:56
 Last Refresh Time   :  03/21/2019 08:55:17
 Duration            :  21s
 Module/Action       :  MyModule/MyAction
 Service             :  SYS$USERS
 Program             :  sqlplus@linux183.localdomain (TNS V1-V3)
 Fetch Calls         :  2

Global Stats
==========================================================================
| Elapsed |   Cpu   |    IO    | PL/SQL  | Fetch | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) | Time(s) | Calls |  Gets  | Reqs | Bytes |
==========================================================================
|      21 |      21 |     0.04 |    0.07 |     2 |     3M |  215 | 180MB |
==========================================================================

SQL Plan Monitoring Details (Plan Hash Value=83896840)
==================================================================================================================================================
| Id |       Operation       | Name |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  |  Mem  | Activity | Activity Detail |
|    |                       |      | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes | (Max) |   (%)    |   (# samples)   |
==================================================================================================================================================
|  0 | SELECT STATEMENT      |      |         |      |        21 |     +1 |     1 |        1 |      |       |     . |          |                 |
|  1 |   FILTER              |      |         |      |        21 |     +1 |     1 |        1 |      |       |     . |          |                 |
|  2 |    HASH JOIN OUTER    |      |     400 | 2014 |        21 |     +1 |     1 |      400 |      |       |   2MB |          |                 |
|  3 |     TABLE ACCESS FULL | T1   |     400 | 1005 |         1 |     +1 |     1 |      400 |   62 |  60MB |     . |          |                 |
|  4 |     TABLE ACCESS FULL | T1   |    400K | 1001 |        21 |     +1 |     1 |     400K |      |       |     . |          |                 |
==================================================================================================================================================

As you can see the total elapsed time 21 seconds of which the CPU time is the whole 21 seconds.

This seems a little large for a simple hash join so we should look at the “Activity Detail” section of the plan because that will report any ASH samples that can be found for this execution of this query. And that’s where the problem lies: despite using 21 CPU seconds in 21 seconds there are no ASH samples for the execution! Moreover – looking for other numerical oddities – the plan says we read 60MB in 62 read requests (that’s the first tablescan of of the 7,798 blocks of t1), but the summary says we read 180MB – where did we lose (or gain) 120MB ?

It might help to see the query (which is why I didn’t show it in the output above) and it might help to see the predicate section (which SQL Monitor doesn’t report). So here’s the query and its plan, with the resulting predicate section, pulled from memory:


SQL_ID  g6j671u7zc9mn, child number 0
-------------------------------------
select  /*+ monitor */  t1a.mod_1000, t1b.mod_1000 from  t1 t1a,  t1
t1b where  t1a.mod_1000 = 500 and t1b.id(+) = t1a.id and
nvl(t1b.mod_1000,0) + f2(t1a.id) + f3(t1a.id) > 0

Plan hash value: 83896840

----------------------------------------------------------------------------
| Id  | Operation           | Name | Rows  | Bytes | Cost (%CPU)| Time     |
----------------------------------------------------------------------------
|   0 | SELECT STATEMENT    |      |       |       |  2014 (100)|          |
|*  1 |  FILTER             |      |       |       |            |          |
|*  2 |   HASH JOIN OUTER   |      |   400 |  7200 |  2014   (4)| 00:00:01 |
|*  3 |    TABLE ACCESS FULL| T1   |   400 |  3600 |  1005   (3)| 00:00:01 |
|   4 |    TABLE ACCESS FULL| T1   |   400K|  3515K|  1001   (3)| 00:00:01 |
----------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------
   1 - filter(NVL("T1B"."MOD_1000",0)+"F2"("T1A"."ID")+"F3"("T1A"."ID")>0)
   2 - access("T1B"."ID"="T1A"."ID")
   3 - filter("T1A"."MOD_1000"=500)


Notice the two function calls that are part of the FILTER operation. That’s where the time is going – but I don’t think you can infer that from the SQL Monitor report (which rather suggests that the problem might be with the second full tablescan of t1 at operation 4).

Functions f2() and f3() both do a table scan of another table that is as large as t1 – and it looks as if they’re both going to be called 400 times, which is a lot of work. The 120MB of “lost” reads is the first table scan of each of the two tables, the 3M buffer gets (in the summary, if you didn’t notice it) is from the repeated tablescans as each row comes out of the hash join and the filter is applied.

Why doesn’t the report show us the CPU (and disk) samples? Because it’s querying ASH (v$active_session_history) by the SQL_ID of the principle SQL statement – and the work is being done by two other statements with different SQL_IDs.

Since it’s PL/SQL functions doing all the work why isn’t the 21 CPU seconds showing up in the “PL/SQL time(s)” summary figure? Because the time isn’t being spent in PL/SQL, it’s being spent in the SQL being run by the PL/SQL.

Just to finish off, let’s try to find the SQL being run by the PL/SQL. I’ll post the script to recreate the example at the end of the posting but for the moment I’ll just show you the query against v$sql that I ran to extract the SQL that’s embedded in the functions:


select  sql_id, executions, disk_reads, buffer_gets, sql_text
from    V$sql 
where   sql_text like 'SELECT%T2%' 
or      sql_text like 'SELECT%T3%'
;

SQL_ID        EXECUTIONS DISK_READS BUFFER_GETS SQL_TEXT
------------- ---------- ---------- ----------- --------------------------------------------------
12ytf1rry45d9        400       7683     3072817 SELECT MAX(ID) FROM T2 WHERE MOD_1000 = :B1
85dmsgqg3bh4w          1       7680        7698 SELECT MAX(ID) FROM T3 WHERE MOD_1000 = :B1

As you can see, there are roughly 120MB of disk I/O and 3M buffer gets due to these two statement – and one of them has run the 400 times we expected. It looks as if Oracle has done a cute little optimisation with the other function, though. If you look at the predicate it says:

  • NVL(“T1B”.”MOD_1000″,0)+”F2″(“T1A”.”ID”)+”F3″(“T1A”.”ID”)>0

It looks as if Oracle has either cached the result of the f3() function call (in which case why didn’t it also cache the f2() result) or it’s stopped evaluating the predicate as soon as the running total exceeded zero (but that might be a problem since f3() could return a negative number !). I don’t know exactly why Oracle is doing what it’s doing – but if I reverse the order of the functions in the predicates the f3() query will run 400 times and the f2() query will run once.

Appendix

If you want to re-run some tests here’s the code I used to create the demo:


create table t1
nologging
as
with generator as (
        select 
                rownum id
        from dual 
        connect by 
                level <= 1e4 -- > comment to avoid WordPress format issue
)
select
        rownum                          id,
        mod(rownum-1,1000)              mod_1000,
        lpad(rownum,10,'0')             v1,
        lpad(rownum,10,'0')             v2,
        lpad('x',100,'x')               padding
from
        generator       v1,
        generator       v2
where
        rownum <= 4e5 -- > comment to avoid WordPress format issue
;

-- alter table t1 add constraint t1_pk primary key(id);

create table t2 nologging as select * from t1;
create table t3 nologging as select * from t1;

create function f2 (i_in number) return number
as
        m_ret number;
begin
        select max(id)
        into    m_ret
        from    t2
        where   mod_1000 = i_in
        ;

        return m_ret;
end;
/

create function f3 (i_in number) return number
as
        m_ret number;
begin
        select  max(id)
        into    m_ret
        from    t3
        where   mod_1000 = i_in
        ;

        return m_ret;
end;
/


begin
        dbms_stats.gather_table_stats(
                ownname     => null,
                tabname     => 'T1',
                method_opt  => 'for all columns size 1'
        );
        dbms_stats.gather_table_stats(
                ownname     => null,
                tabname     => 'T2',
                method_opt  => 'for all columns size 1'
        );
        dbms_stats.gather_table_stats(
                ownname     => null,
                tabname     => 'T3',
                method_opt  => 'for all columns size 1'
        );
end;
/

alter system flush buffer_cache;

variable b1 number
variable b2 number

set timing on

select
        /*+ monitor */
        t1a.mod_1000, t1b.mod_1000
from
        t1      t1a,
        t1      t1b
where
        t1a.mod_1000 = 500
and     t1b.id(+) = t1a.id
and     nvl(t1b.mod_1000,0) + f3(t1a.id) + f2(t1a.id) > 0
;


One interesting little detail, if you try the tests, is that the join has to be an outer join for the FILTER operation to appear.

Oracle Recognizes Supply Chain Innovation at Modern Business Experience

Oracle Press Releases - Thu, 2019-03-21 07:15
Press Release
Oracle Recognizes Supply Chain Innovation at Modern Business Experience Oracle SCM Excellence Awards spotlight organizations and leaders using innovative technologies to digitize supply chain operations and drive business success

MODERN BUSINESS EXPERIENCE, Las Vegas, NV—Mar 21, 2019

To highlight the innovative strategies organizations are implementing to modernize their supply chain, Oracle today announced the winners of the Oracle SCM Excellence Awards. The awards recognize Oracle Supply Chain Management (SCM) Cloud customers who have successfully transformed their organization’s supply chain strategy and adopted industry best practices. The 2019 winners include ATCO Group, GE Power, Mondelez International and The AMES Companies.

“Shifting customer expectations continue to dramatically increase scrutiny placed on the modern supply chain,” said Jon Chorley, chief sustainability officer and group vice president of supply chain management, Oracle. “This year’s winners demonstrate innovative use of Oracle SCM Cloud to minimize risk, lower costs and create a more responsive, efficient and sustainable supply chain of the future.”

The Oracle SCM Excellence Awards recognize supply chain professionals who are using cloud technology to make a significant impact in their organization’s supply chain operations. Winners include:

  • Mark Kennedy, director, Enterprise Architecture and Applications, ATCO Group
  • Chakravarthi Rebbapragada, IT director, Global Logistics and Trade Compliance, GE Power
  • Robert Owen, North America transportation optimization lead, Mondelez International
  • Brandt Bjornsen, director, Information Technology, The AMES Companies, Inc.
 

The 2019 SCM Excellence award winners were announced at Oracle’s Modern Business Experience in Las Vegas, Nevada. Modern Business Experience brings together finance, supply chain and human resources professionals to explore how cloud applications and connected business processes can enhance business agility, drive new business models and create breakthrough experiences for customers, employees, partners and suppliers.

For additional information on these winners, please visit the Oracle SCM Excellence Awards website.

Contact Info
Bill Rundle
Oracle
+1.650.506.1891
bill.rundle@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About Modern Business Experience 2019

Modern Business Experience arms professionals across HR, finance, and supply chain with the tools to create a connected enterprise and thrive in the Experience Economy. For more information, please visit https://www.oracle.com/modern-business-experience/

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

Bill Rundle

  • +1.650.506.1891

Oracle Recognizes Finance Innovation at Modern Business Experience

Oracle Press Releases - Thu, 2019-03-21 07:10
Press Release
Oracle Recognizes Finance Innovation at Modern Business Experience Oracle Change Agents of Finance Awards spotlight organizations using innovative technology to transform finance operations and drive business growth

MODERN BUSINESS EXPERIENCE, Las Vegas, NV—Mar 21, 2019

Oracle Change Agents of Finance Awards

To celebrate organizations and finance leaders using technology to transform their business, Oracle today announced the winners of the Oracle Change Agents of Finance Awards. The awards honor Oracle Enterprise Resource Planning (ERP) Cloud and Oracle Enterprise Performance Management (EPM) Cloud customers who have implemented innovative cloud solutions to achieve tangible business results and drive growth across their organization. The 2019 winners include: Argo Group, Diversey, GE, Michael Baker International, MedStar Health, Royal Bank of Scotland, TTI, Inc. and Western Digital.

“The Change Agents of Finance Awards recognize leaders who are reinventing finance through the smart use of technology,” said Doug Kehring, executive vice president, Corporate Operations, Oracle.  “This year’s winners demonstrate innovation in finance, leveraging Oracle ERP Cloud and Oracle EPM Cloud to increase productivity, lower costs, improve controls and expand the influence of finance in their respective organizations.”

The global Oracle Change Agents of Finance Awards is a peer-driven awards program that recognizes the best of 21st century finance. Winners include:

  • Better Together Award: Donald Robertson, VP, chief accounting officer, Western Digital
  • Crystal Ball Award: David Dawson, VP and director, Business Intelligence, Michael Baker International
  • Frugal Finance Award: David Feierstein, SVP, global head of Transformation Office, Diversey
  • Fast Finance Award: Oscar Guerrero, group deputy CFO, Argo Group
  • Oracle Billion-Dollar Story Award: Robert Barocas and the cloud ERP team, GE
  • Roll With It Award: Stuart Wray, head of implementation, Finance Future, Royal Bank of Scotland
  • Shared Services Superstar Award: Chris Goodman, CFO, TTI, Inc.
  • Top Talent Award: Patricia Grubb, VP, Financial Planning and Analysis, MedStar Health
 

The 2019 Change Agents of Finance award winners were announced at Oracle’s Modern Business Experience in Las Vegas, Nevada. Modern Business Experience brings together finance, supply chain and human resources professionals to explore how cloud applications and connected business processes can enhance business agility, drive new business models and create breakthrough experiences for customers, employees, partners, and suppliers.

For additional information on these winners, please visit the Oracle Change Agents of Finance Awards website.

Contact Info
Bill Rundle
Oracle
+1.650.506.1891
bill.rundle@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About Modern Business Experience 2019

Modern Business Experience arms professionals across HR, finance, and supply chain with the tools to create a connected enterprise and thrive in the Experience Economy. For more information, please visit https://www.oracle.com/modern-business-experience/

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

Bill Rundle

  • +1.650.506.1891

Oracle Honors HR Trailblazers at Annual Awards Gala

Oracle Press Releases - Thu, 2019-03-21 07:05
Press Release
Oracle Honors HR Trailblazers at Annual Awards Gala Rubies Awards showcase organizations that use Oracle HCM technology to make a significant business impact

MODERN BUSINESS EXPERIENCE, Las Vegas, NV—Mar 21, 2019

To celebrate standout HR professionals who are using technology to transform their business, Oracle today announced the winners of the Oracle HCM Cloud Rubies Award. The awards honor Oracle Human Capital Management (HCM) Cloud customers who advocate for innovation, prioritize investment in employees, and have a vision to see the potential of tomorrow’s human resources possibilities, today. The 2019 winners include: UnitedHealth Group, Hilton Worldwide, Hilton Grand Vacations, Mars Petcare, Grupo Bimbo, AfrAsia Bank, Cobham Advanced Electronic Solutions, and Gruppo Mondadori.

“Much of today’s workforce is digitally-native and expects a personalized, seamless HR and employee experience,” said Gretchen Alarcon, group vice president, Oracle HCM Cloud. “It’s harder than ever for HR professionals to attract, onboard, and retain talent, so we’re excited to recognize Oracle customers who are embracing emerging technologies to re-think what is possible.”

The global Oracle HCM Cloud Rubies Awards is a peer-driven program that recognizes HR professionals who have used technology to increase efficiencies, enhance the employee experience, and deliver tangible business results. Winners include:

  • Bottom-Line Bonanza Award: Ann Rogotzke, VP, Human Capital Technology and Programs, UnitedHealth Group
  • It’s a Mobile World Award: Kellie Romack, VP, Digital HR and Strategic Planning, Hilton Worldwide
  • Dynamic Duo or Triumphant Trio Award: Richard Jackson, Senior Vice President and Chief Information Officer, Hilton Grand Vacations
  • M&A Matrimony Award: Karen Peringer, Sr. Director, People & Organization, Mars Petcare
  • Express Lane Award: Eric Cohen, Senior Director, HCM, Grupo Bimbo
  • Keep it in the Family Award: Maureen Treanor, Head of HR and Change Management, AfrAsia Bank Ltd.
  • Productive Powerhouse Award: Roger Casalengo, SVP of HR, Cobham Advanced Electronic Solutions (CAES)
  • Knowledge is Power Award: Daniele Sacco, Group HR and Organization Director of Gruppo Mondadori
 

The 2019 HCM Cloud Rubies award winners were announced at Modern Business Experience in Las Vegas, Nevada. Modern Business Experience brings together finance, supply chain, and human resources professionals to explore how cloud applications and connected business processes can enhance business agility, drive new business models, and create breakthrough experiences for customers, employees, partners, and suppliers.

For additional information on these winners, please visit the Oracle HCM Cloud Rubies Awards website.

Contact Info
Celina Bertallee
Oracle
+1.559.283.2425
celina.bertallee@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About Modern Business Experience 2019

Modern Business Experience arms professionals across HR, finance, and supply chain with the tools to create a connected enterprise and thrive in the Experience Economy. For more information, please visit https://www.oracle.com/modern-business-experience/

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

Celina Bertallee

  • +1.559.283.2425

Oracle Applauds Creators of Legendary Customer Experiences

Oracle Press Releases - Thu, 2019-03-21 07:00
Press Release
Oracle Applauds Creators of Legendary Customer Experiences Annual 2019 Markie Awards honor the movers, shakers, and experience makers across marketing, commerce, sales and service

MODERN CUSTOMER EXPERIENCE, Las Vegas, NV—Mar 21, 2019

Annual 2019 Markie Awards

To celebrate the creators of truly great experiences across the entire customer journey, Oracle today announced the winners of the Markie Awards. The awards showcase Oracle Customer Experience (CX) Cloud customers who have delivered standout customer experiences across marketing, sales, service and commerce. This year’s winners include Bonnier News, Samsung Business, Things Remembered, Movember Foundation and the City of Albuquerque, New Mexico.

“The Markie Awards have celebrated the art and science of digital marketing for more than a decade and to reflect the changing way customers interact with brands, we have expanded their scope to celebrate sales, service and commerce professionals as well,” said Christina Cavanna, vice president, Corporate Marketing, Oracle. “The Markies are our way to recognize the people and organizations that push the boundaries of innovation to create outstanding experiences. The results achieved are incredible and Oracle congratulates all of this year’s winners.”

Spanning several categories, the Markie Awards recognize the movers, shakers and experience-makers from across industries. The winners of the 2019 Markie Awards are:

  • The Apex Award for Best Overall Customer Experience: Panasonic Computer Products Europe
  • The Thinker Award for Best Innovation in CX:
    • Best Innovation in Marketing: Snap Tech
    • Best Innovation in Sales: Aon
    • Best Innovation in Service: City of Albuquerque, New Mexico
  • The Insight Award for Best Use of Data: Cisco
  • The Heartstrings People’s Choice Award: Health Resources in Action
  • The Upshot Award for Best Demonstrated ROI:
    • Best Demonstrated ROI in Marketing: Bonnier News
    • Best Demonstrated ROI in Sales & Service: Kenya Revenue Authority
  • The Cultivator Award for Best Lead Management Program: Samsung Business
  • The Omni Award for Best Omnichannel Experience: Things Remembered
  • The Borderless Award for Best International Marketing Campaign: Movember Foundation
  • The Pinpoint Award for Best Account-Based Marketing Strategy: Hewlett Packard Enterprise
  • The Convert Award for Best Commerce Experience: Livelo
 

The 2019 Markie Awards were presented on Wednesday, March 20, during Oracle Modern Customer Experience in Las Vegas. Every year, Modern Customer Experience brings together thousands of leading brands, industry visionaries, product experts and customer experience professionals to discuss the latest trends and best practices in marketing, commerce, sales and service.

Contact Info
Shasta Smith
Oracle
+1.503.560.0756
shasta.smith@oracle.com
About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. For more information about Oracle (NYSE: ORCL), please visit us at www.oracle.com.

About Modern Customer Experience 2019

Modern Customer Experience arms professionals across commerce, marketing, sales, and service with the tools to deliver legendary customer experiences and exceed in the Experience Economy. For more information, please visit https://www.oracle.com/moderncx/

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

Shasta Smith

  • +1.503.560.0756

Maui and Sons Chile Rides the Oracle Wave to Operational Agility

Oracle Press Releases - Thu, 2019-03-21 05:00
Press Release
Maui and Sons Chile Rides the Oracle Wave to Operational Agility Casual clothing retailer builds tech foundation for growth limited only by imagination

REDWOOD SHORES, Calif. and SANTIAGO, Chile—Mar 21, 2019

Maui and Sons Chile

Maui and Sons is one of the best-known surf and skateboard apparel brands in the world, selling in more than 100 countries. When executives at the brand’s regional arm, Maui and Sons Chile, ran into obstacles scaling operations in Latin America, they rethought their technology approach. Bringing in Oracle Retail, Maui and Sons Chile established a foundation for future growth by streamlining inventory, adding new sales channels, and more effectively serving the needs of its customers.

The Chilean-based company runs a complex supply chain that must allow for evolving product design and more than 100 worldwide suppliers who sell the Maui and Sons, Rip Curl and Volcom brands in Chile and Rip Curl and Volcom in Peru. With 30 percent of operations in wholesale and small stores across these regions, the company required detailed plans to deliver the right apparel assortment to each area, including over 10,000 combinations of sizes and colors per season.

“We have been successfully in business for nearly 40 years, but we knew it was time to invest in technology that could take us to the next level. Today, we have effectively documented, automated and organized our processes – removing a lot of the limitations to growing and scaling both our product lines and business throughout regions,” said Felipe Guerrero, chief information officer, Maui and Sons Chile. “With Oracle, we have empowered our people to continue to make a difference and accelerate customer value by placing innovation at their fingertips.”

After a competitive assessment, Maui and Sons Chile chose to modernize its approach with Oracle Retail Merchandising System and Oracle Warehouse Management Cloud. Oracle Database and Middleware solutions also support this new retail foundation.

“Using Oracle, Maui and Sons Chile can gain deep insights into its merchandising, allowing the company to serve its mission of selling high valued brands for young lifestyle consumers more effectively across channels, including in-store and online. We can also better connect suppliers, inventory, and stores to ensure a streamlined operation while delivering stellar service to customers,” said Javier Swinburn, chief project officer, Maui and Sons Chile.

“Today, retail is compressed by several factors—the massive scale of transactions, the narrow windows to fulfill orders, and the complexity of choice and format,” said Mike Webster, senior vice president and general manager, Oracle Retail. “By transforming its operations, Maui and Sons Chile gained operational agility that allows them to respond fast in one of the most sophisticated retail markets in Latin America.”

Maui and Sons Chile completed this strategic business initiative and implemented in 11 months by partnering with Oracle and Oracle PartnerNetwork (OPN) Gold Level member Logic Information Systems. Logic leveraged local retail expertise, cloud capabilities, and the power of the Oracle Retail Reference Library to outline processes and enable choices for Maui and Sons to deploy quickly and effectively.

Contact Info
Kris Reeves
Oracle PR
+1.925.787.6744
kris.reeves@oracle.com
About Oracle Retail

Oracle is the modern platform for retail. Oracle provides retailers with a complete, open, and integrated platform for best-of-breed business applications, cloud services, and hardware that are engineered to work together. Leading fashion, grocery, and specialty retailers use Oracle solutions to accelerate from best practice to next practice, drive operational agility and refine the customer experience. For more information, visit our website www.oracle.com/retail.

About Oracle

The Oracle Cloud offers a complete suite of integrated applications for Sales, Service, Marketing, Human Resources, Finance, Supply Chain and Manufacturing, plus Highly-Automated and Secure Generation 2 Infrastructure featuring the Oracle Autonomous Database. 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.

Talk to a Press Contact

Kris Reeves

  • +1.925.787.6744

Announcement: “Oracle Performance Diagnostics and Tuning” Webinar – 9-12 July 2019 !!

Richard Foote - Thu, 2019-03-21 02:30
I’m very excited to announce the first public running of my new “Oracle Performance Diagnostics and Tuning” Webinar will run between 9-12 July 2019 (6pm-10pm AEST): Webinar Series 9-12 July 2019 (start 6pm AEST, end 10pm AEST):  This is a must attend seminar aimed at Oracle professionals (both DBAs and Developers) who are interested in Performance Tuning.  […]
Categories: DBA Blogs

Date constraint to validate all bookings are in the future

Tom Kyte - Thu, 2019-03-21 01:06
Hi, I need to create a constraint which will not allow appointments to be booked in the past. I wonder if someone could help me with this please. Thank you. Juliana
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator