Feed aggregator

Big Data SQL Cloud Service now Available!

Oracle Big Data SQL Cloud Service has been released! Big Data SQL is Oracle’s breakthrough approach to simplifying access to big data sources. Oracle Big Data SQL provides the ability to query...

We share our skills to maximize your revenue!
Categories: DBA Blogs

Accessing a Pivotal MySQL service instance within Pivotal Cloud Foundry

Pas Apicella - Thu, 2017-04-27 00:18
Recently at a hackathon we used the Pivotal MySQL service rather then a ClearDB MySQL service. As a result we could not connect to our instance from a third party tool as the service instance is locked down. There are various way to access the MySQL service to me the best two options are as follows.

1. Cloud Foundry CLI MySQL Plugin

cf-mysql-plugin makes it easy to connect the mysql command line client to any MySQL-compatible database used by Cloud Foundry apps. Use it to

  • inspect databases for debugging purposes
  • manually adjust schema or contents in development environments
  • dump and restore databases

Install it as explained in the link below:

  https://github.com/andreasf/cf-mysql-plugin

** Using It ** 

1. First ensure you are logged into a Pivotal Cloud Foundry instance you can determine that as follows

pasapicella@pas-macbook:~$ cf target -o ben.farrelly-org -s hackathon
API endpoint:   https://api.run.pivotal.io
API version:    2.78.0
User:           papicella@pivotal.io
Org:            ben.farrelly-org
Space:          hackathon

2. Verify you have a MySQL instance provisioned

pasapicella@pas-macbook:~$ cf services
Getting services in org ben.farrelly-org / space hackathon as papicella@pivotal.io...
OK

name        service   plan    bound apps                                                     last operation
nab-mysql   p-mysql   100mb   nabhackathon-beacon, nabhackathon-merchant, pivotal-mysqlweb   create succeeded

3. Log in as shown below

pasapicella@pas-macbook:~$ cf mysql nab-mysql

...

Copyright (c) 2000, 2016, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+-----------------------------------------+
| Database                                |
+-----------------------------------------+
| cf_53318c9c_caec_49be_9e33_075fade26183 |
| information_schema                      |
+-----------------------------------------+
2 rows in set (0.30 sec)

mysql> use cf_53318c9c_caec_49be_9e33_075fade26183;
Database changed

mysql> show tables;
+---------------------------------------------------+
| Tables_in_cf_53318c9c_caec_49be_9e33_075fade26183 |
+---------------------------------------------------+
| beacon                                            |
| beacon_product                                    |
| customer                                          |
| customer_registration                             |
| merchant                                          |
| payment                                           |
| payment_product                                   |
| product                                           |
+---------------------------------------------------+
8 rows in set (0.29 sec)

2. Pivotal MySQL*Web

PivotalMySQL*Web is a browser based SQL tool rendered using Bootstrap UI for MySQL PCF service instances which allows you to run SQL commands and view schema objects from a browser based interface. Use it to

  • Multiple Command SQL worksheet for DDL and DML
  • Run Explain Plan across SQL Statements
  • View/Run DDL command against Tables/Views/Indexes/Constraints
  • Command History
  • Auto Bind to Pivotal MySQL Services bound to the Application within Pivotal Cloud Foundry 
  • Manage JDBC Connections
  • Load SQL File into SQL Worksheet from Local File System
  • SQL Worksheet with syntax highlighting support
  • HTTP GET request to auto login without a login form
  • Export SQL query results in JSON or CSV formats
  • Generate DDL for schema objects


It does this deployed within Pivotal Cloud Foundry as an application instance and auto binds to the MySQL service for you if you choose to bind it as part of the "cf push" and a manifest.yml which looks as follows

---
applications:
- name: pivotal-mysqlweb
  memory: 512M
  instances: 1
  host: pivotal-mysqlweb-${random-word}
  path: ./target/PivotalMySQLWeb-0.0.1-SNAPSHOT.jar
  services:
    - pas-mysql

Install it as explained in the link below:

  https://github.com/pivotal-cf/PivotalMySQLWeb


Categories: Fusion Middleware

Migrating from oracle to postgresql with ora2pg

Yann Neuhaus - Wed, 2017-04-26 12:59

PostgreSQL is one of the most used Rdbms.
In this blog we are going to talk about migrating from oracle to postgresql using ora2pg. A previous blog about this topic can be found here.
After installing ora2pg tool, we will see how to configure and to run it to migrate our data. We are using an oracle 12.1 database and a postgresql 9.6.2. The server is runing on OEL 7.2
The oracle database and the postgresql server are running on the same server. But different servers can be used.

To install ora2pg we need following:
-DBD-Oracle-1.75_2.tar.gz : Oracle database driver for the DBI module
-DBD-Pg-3.6.0.tar.gz : PostgreSQL database driver for the DBI module
-DBI-1.636.tar.gz : Database independent interface for Perl
-ora2pg-18.1.tar.gz : ora2pg archive

The DBI modules can be found here
And the ora2pg can be downloaded from here

Install DBI module
[root@serveroracle postgres]#tar xvzf DBI-1.636.tar.gz
[root@serveroracle postgres]#cd DBI-1.636
[root@serveroracle postgres]#perl Makefile.Pl
[root@serveroracle postgres]#make
[root@serveroracle postgres]#make install

Install DBD-Oracle
[root@serveroracle postgres]# tar xvzf DBD-Oracle-1.75_2.tar.gz
[root@serveroracle postgres]# cd DBD-Oracle-1.75_2/
[root@serveroracle DBD-Oracle-1.75_2]# export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1
[root@serveroracle DBD-Oracle-1.75_2]# export LD_LIBRARY_PATH=/u01/app/oracle/product/12.1.0/dbhome_1/lib
[root@serveroracle DBD-Oracle-1.75_2]# perl Makefile.PL
[root@serveroracle DBD-Oracle-1.75_2]# make
[root@serveroracle DBD-Oracle-1.75_2]# make install

Install DBD-Pg
[root@serveroracle postgres]# tar xvzf DBD-Pg-3.6.0.tar.gz
[root@serveroracle postgres]# cd DBD-Pg-3.6.0
[root@serveroracle DBD-Pg-3.6.0]# perl Makefile.PL
Configuring DBD::Pg 3.6.0
Path to pg_config? /u01/app/postgres/product/96/db_2/bin/pg_config
[root@serveroracle DBD-Pg-3.6.0]# make
[root@serveroracle DBD-Pg-3.6.0]# make install

When we first run the command perl MakeFile.PL, we got following errors
[root@serveroracle DBD-Pg-3.6.0]# perl Makefile.PL
Configuring DBD::Pg 3.6.0
PostgreSQL version: 90602 (default port: 5432)
POSTGRES_HOME: /u01/app/postgres/product/96/db_2
POSTGRES_INCLUDE: /u01/app/postgres/product/96/db_2/include
POSTGRES_LIB: /u01/app/postgres/product/96/db_2/lib
OS: linux
Warning: prerequisite version 0 not found.
Could not eval '
package ExtUtils::MakeMaker::_version;
no strict;
BEGIN { eval {
# Ensure any version() routine which might have leaked
# into this package has been deleted. Interferes with
# version->import()
undef *version;
require version;
"version"->import;
} }
local $VERSION;
$VERSION=undef;
do {
use version; our $VERSION = qv('3.6.0');
};
$VERSION;
' in Pg.pm: Can't locate version.pm in @INC (@INC contains: t/lib /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at (eval 11) line 16, line 19.
BEGIN failed--compilation aborted at (eval 11) line 16, line 19.
WARNING: Setting VERSION via file 'Pg.pm' failed
at /usr/share/perl5/vendor_perl/ExtUtils/MakeMaker.pm line 619.
Using DBI 1.636 (for perl 5.016003 on x86_64-linux-thread-multi) installed in /usr/local/lib64/perl5/auto/DBI/
Writing Makefile for DBD::Pg

We correct errors by running the command below.
[root@serveroracle DBD-Pg-3.6.0]# yum -y install 'perl(version)'
Loaded plugins: langpacks, ulninfo
Resolving Dependencies
--> Running transaction check
---> Package perl-version.x86_64 3:0.99.07-2.el7 will be installed
--> Finished Dependency Resolution

Install ora2pg

[postgres@serveroracle ~]$ tar xvzf ora2pg-18.1.tar.gz
[root@serveroracle postgres]# cd ora2pg-18.1/
[root@serveroracle postgres]# perl Makefile.PL
[root@serveroracle postgres]# make
[root@serveroracle postgres]# make install


[root@serveroracle postgres]# ora2pg -version
Ora2Pg v18.1
[root@serveroracle postgres]#

Now that ora2pg is installed, we can proceed with the migration. The first step is to configure the ora2pg.conf file. We can do a copy of the default template and then modify the file. In our case the configuration file is located in /etc/ora2pg directory.

[root@serveroracle ora2pg]# cp ora2pg.conf.dist ora2pg.conf
[root@serveroracle ora2pg]# vi ora2pg.conf

In our configuration file, following changes where done. We are exporting only the HR schema

ORACLE_DSN dbi:Oracle:host=serveroracle.localdomain;sid=ORCL
ORACLE_USER system
ORACLE_PWD root
SCHEMA HR
TYPE TABLE PACKAGE COPY VIEW GRANT SEQUENCE TRIGGER FUNCTION PROCEDURE TABLESPACE TYPE PARTITION
OUTPUT HR_output.sql

ora2pg works by exporting and importing schemas. We can only export one schema at a time if we use the option SCHEMA. If we want to export all schemas we can just comment the option SCHEMA. In this case all non-oracle users will be extracted.
In the documentation we also have the option SYSUSERS
# Allow to add a comma separated list of system user to exclude from
# from Oracle extraction. Oracle have many of them following the modules
# installed. By default it will suppress all object owned by the following
# system users:
# CTXSYS,DBSNMP,EXFSYS,LBACSYS,MDSYS,MGMT_VIEW,OLAPSYS,ORDDATA,OWBSYS,
# ORDPLUGINS,ORDSYS,OUTLN,SI_INFORMTN_SCHEMA,SYS,SYSMAN,SYSTEM,WK_TEST,
# WKSYS,WKPROXY,WMSYS,XDB,APEX_PUBLIC_USER,DIP,FLOWS_020100,FLOWS_030000,
# FLOWS_040100,FLOWS_FILES,MDDATA,ORACLE_OCM,SPATIAL_CSW_ADMIN_USR,
# SPATIAL_WFS_ADMIN_USR,XS$NULL,PERFSTAT,SQLTXPLAIN,DMSYS,TSMSYS,WKSYS,
# APEX_040200,DVSYS,OJVMSYS,GSMADMIN_INTERNAL,APPQOSSYS
# Other list of users set to this directive will be added to this list.
#SYSUSERS OE,HR

Once configuration done, we can run the orap2g command. Note that you can see all options by running ora2pg -help
[root@serveroracle ora2pg]# ora2pg
[========================>] 7/7 tables (100.0%) end of scanning.
[> ] 0/7 tables (0.0%) end of scanning.
[========================>] 7/7 tables (100.0%) end of table export.
[========================>] 0/0 packages (100.0%) end of output.
[========================>] 25/25 rows (100.0%) Table COUNTRIES (25 recs/sec)
[==> ] 25/215 total rows (11.6%) - (0 sec., avg: 25 recs/sec).
[========================>] 27/27 rows (100.0%) Table DEPARTMENTS (27 recs/sec)
[=====> ] 52/215 total rows (24.2%) - (1 sec., avg: 52 recs/sec).
[========================>] 107/107 rows (100.0%) Table EMPLOYEES (107 recs/sec)
[=================> ] 159/215 total rows (74.0%) - (1 sec., avg: 159 recs/sec).
[========================>] 19/19 rows (100.0%) Table JOBS (19 recs/sec)
[===================> ] 178/215 total rows (82.8%) - (1 sec., avg: 178 recs/sec).
[========================>] 10/10 rows (100.0%) Table JOB_HISTORY (10 recs/sec)
[====================> ] 188/215 total rows (87.4%) - (2 sec., avg: 94 recs/sec).
[========================>] 23/23 rows (100.0%) Table LOCATIONS (23 recs/sec)
[=======================> ] 211/215 total rows (98.1%) - (2 sec., avg: 105 recs/sec).
[========================>] 4/4 rows (100.0%) Table REGIONS (4 recs/sec)
[========================>] 215/215 total rows (100.0%) - (3 sec., avg: 71 recs/sec).
[========================>] 215/215 rows (100.0%) on total estimated data (3 sec., avg: 71 recs/sec)
[========================>] 1/1 views (100.0%) end of output.
[========================>] 3/3 sequences (100.0%) end of output.
[========================>] 1/1 triggers (100.0%) end of output.
[========================>] 0/0 functions (100.0%) end of output.
[========================>] 2/2 procedures (100.0%) end of output.
[========================>] 0/0 types (100.0%) end of output.
[========================>] 0/0 partitions (100.0%) end of output.
[root@serveroracle ora2pg]#

Once finished, a file HR_output.sql is generated. This file can be used to load data in the postgresql database. We can also load data directly without using a file. We just have to specify the connection info for the postgresql.
Let’s know prepare the postgresql server to receive our data. First we create the user HR.

[postgres@serveroracle ~]$ psql
psql (9.6.2 dbi services build)
Type "help" for help.
postgres=# \c orclpg
You are now connected to database "orclpg" as user "postgres".
orclpg=# create user HR WITH PASSWORD 'root';

And then we can execute the file. The first time we ran the file, we had some constraints errors

orclpg=# \i HR_output.sql
ERROR: insert or update on table "countries" violates foreign key constraint "countr_reg_fk"
DETAIL: Key (region_id)=(2) is not present in table "regions".
STATEMENT: COPY countries (country_id,country_name,region_id) FROM STDIN;
psql:HR_output.sql:224: ERROR: insert or update on table "countries" violates foreign key constraint "countr_reg_fk"
DETAIL: Key (region_id)=(2) is not present in table "regions".
orclpg=#

To correct this, we put the option in the configuration file DROP_FKEY to 1

DROP_FKEY 1

With this option all foreign keys will be dropped before all data import and recreate them at the end of the import. After the load was successful.

orclpg=# \i HR_output.sql
SET
CREATE SCHEMA
ALTER SCHEMA
SET
CREATE TABLE
COMMENT
SET
SET
SET
SET
SET
BEGIN
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
SET
COPY 107
SET
COPY 19
SET
COPY 10
SET
COPY 23
SET
COPY 4
ALTER TABLE
ALTER TABLE
ALTER TABLE


COMMIT

We can verify that tables were created and that data were inserted.


orclpg=# \d
List of relations
Schema | Name | Type | Owner
--------+-------------+-------+----------
hr | countries | table | postgres
hr | departments | table | postgres
hr | employees | table | postgres
hr | job_history | table | postgres
hr | jobs | table | postgres
hr | locations | table | postgres
hr | regions | table | postgres
(7 rows)

orclpg=# select count(*) from countries;
count
-------
25
(1 row)
orclpg=#

Conclusion
As we can see ora2pg is a free easy tool to migrate data from oracle to postgresql. In coming blog we will talk about other tools that can be used to move data from oracle to postgresql

 

Cet article Migrating from oracle to postgresql with ora2pg est apparu en premier sur Blog dbi services.

JRE 1.6.0_151 Certified with Oracle E-Business Suite 12.1 and 12.2

Steven Chan - Wed, 2017-04-26 12:01

Java logThe latest Java Runtime Environment 1.6.0_151 (a.k.a. JRE 6u151-b10) and later updates on the JRE 6 codeline are now certified with Oracle E-Business Suite Release 12.1 and 12.2 for Windows-based desktop clients.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

Effects of new support dates on Java upgrades for EBS environments

Support dates for the E-Business Suite and Java have changed.  Please review the sections below for more details:

  • What does this mean for Oracle E-Business Suite users?
  • Will EBS users be forced to upgrade to JRE 7 for Windows desktop clients?
  • Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

New EBS installation scripts

This JRE release is the first with a 3-digit Java version. Installing this in your EBS 11i and 12.x environments will require new installation scripts.  See the documentation listed in the 'References' section for more detail.

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Deploying JRE documentation for your EBS release for details.

Implications of Java 6 End of Public Updates for EBS Users

The Support Roadmap for Oracle Java is published here:

The latest updates to that page (as of Sept. 19, 2012) state:

Java SE 6 End of Public Updates Notice

After February 2013, Oracle will no longer post updates of Java SE 6 to its public download sites. Existing Java SE 6 downloads already posted as of February 2013 will remain accessible in the Java Archive on Oracle Technology Network. Developers and end-users are encouraged to update to more recent Java SE versions that remain available for public download. For enterprise customers, who need continued access to critical bug fixes and security fixes as well as general maintenance for Java SE 6 or older versions, long term support is available through Oracle Java SE Support .

What does this mean for Oracle E-Business Suite users?

EBS users fall under the category of "enterprise users" above. Java is an integral part of the Oracle E-Business Suite technology stack, so EBS users will continue to receive Java SE 6 updates from February 2013 to the end of Java SE 6 Extended Support in June 2017.

In other words, nothing changes for EBS users after February 2013. 

EBS users will continue to receive critical bug fixes and security fixes as well as general maintenance for Java SE 6 until the end of Java SE 6 Extended Support in June 2017. 

How can EBS customers obtain Java 6 updates after the public end-of-life?

Java 6 is now available only via My Oracle Support for E-Business Suite users.  You can find links to this release, including Release Notes, documentation, and the actual Java downloads here: Both JDK and JRE packages are contained in a single combined download after 6u45.  Download the "JDK" package for both the desktop client JRE and the server-side JDK package.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.10 (Yosemite) can run JRE 7 or 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

JRE is used for desktop clients.  JDK is used for application tier servers.

JDK upgrades for E-Business Suite application tier servers are highly recommended but currently remain optional while Java 6 is covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JDK 6 for application tier servers. 

Java SE 6 is covered by Extended Support until June 2017.  All EBS customers with application tier servers on Windows, Solaris, and Linux must upgrade to JDK 7 by June 2017. EBS customers running their application tier servers on other operating systems should check with their respective vendors for the support dates for those platforms.

JDK 7 is certified with E-Business Suite 12 servers.  See:

References

Related Articles
Categories: APPS Blogs

JRE 1.7.0_141 Certified with Oracle E-Business Suite 12.1 and 12.2

Steven Chan - Wed, 2017-04-26 11:52

Java logo

Java Runtime Environment 1.7.0_141 (a.k.a. JRE 7u141-b11) and later updates on the JRE 7 codeline are now certified with Oracle E-Business Suite Release 12.1 and 12.2 for Windows-based desktop clients.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

Effects of new support dates on Java upgrades for EBS environments

Support dates for the E-Business Suite and Java have changed.  Please review the sections below for more details:

  • What does this mean for Oracle E-Business Suite users?
  • Will EBS users be forced to upgrade to JRE 7 for Windows desktop clients?
  • Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

EBS + Discoverer 11g Users

This JRE release is certified for Discoverer 11g in E-Business Suite environments with the following minimum requirements:

JRE 7 End of Public Updates

The JRE 7u79 release was the last JRE 7 update available to the general public. Java is an integral part of the Oracle E-Business Suite technology stack, so EBS users will continue to receive Java SE 7 updates to the end of Java SE 7 Premier Support to the end of July 2016.

How can EBS customers obtain Java 7 updates after the public end-of-life?

EBS customers can download Java 7 patches from My Oracle Support.  For a complete list of all Java SE patch numbers, see:

Both JDK and JRE packages are now contained in a single combined download.  Download the "JDK" package for both the desktop client JRE and the server-side JDK package. 

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

Java Auto-Update Mechanism

With the release of the January 2015 Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

Mac users running Mac OS X 10.7 (Lion), 10.8 (Mountain Lion), 10.9 (Mavericks), and 10.10 (Yosemite) can run JRE 7 or 8 plug-ins.  See:

Will EBS users be forced to upgrade to JDK 7 for EBS application tier servers?

JRE is used for desktop clients.  JDK is used for application tier servers.

JDK upgrades for E-Business Suite application tier servers are highly recommended but currently remain optional while Java 6 is covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JDK 6 for application tier servers. 

Java SE 6 is covered by Extended Support until June 2017.  All EBS customers with application tier servers on Windows, Solaris, and Linux must upgrade to JDK 7 by June 2017. EBS customers running their application tier servers on other operating systems should check with their respective vendors for the support dates for those platforms.

JDK 7 is certified with E-Business Suite 12.  See:

Known Issues

When using Internet Explorer, JRE 1.7.0_01 had a delay of around 20 seconds before the applet started to load. This issue is fixed in JRE 1.7.0_95.

References

Related Articles
Categories: APPS Blogs

JRE 1.8.0_131 Certified with Oracle EBS 12.1 and 12.2

Steven Chan - Wed, 2017-04-26 11:46

Java logo

Java Runtime Environment 1.8.0_131 (a.k.a. JRE 8u131-b11) and later updates on the JRE 8 codeline are now certified with Oracle E-Business Suite 12.1 and 12.2 for Windows clients.

Java Web Start is now certified with EBS 12.1 and 12.2 for Windows clients.  This JRE release may be run with either the Java plug-in or Java Web Start.

All JRE 6, 7, and 8 releases are certified with EBS upon release

Our standard policy is that all E-Business Suite customers can apply all JRE updates to end-user desktops:

  • From JRE 1.6.0_03 and later updates on the JRE 6 codeline
  • From JRE 1.7.0_10 and later updates on the JRE 7 codeline 
  • From JRE 1.8.0_25 and later updates on the JRE 8 codeline
We test all new JRE releases in parallel with the JRE development process, so all new JRE releases are considered certified with the E-Business Suite on the same day that they're released by our Java team. 

You do not need to wait for a certification announcement before applying new JRE 6, 7, or 8 releases to your EBS users' desktops.

32-bit and 64-bit versions certified

This certification includes both the 32-bit and 64-bit JRE versions for various Windows operating systems. See the respective Recommended Browser documentation for your EBS release for details.

Where are the official patch requirements documented?

All patches required for ensuring full compatibility of the E-Business Suite with JRE 8 are documented in these Notes:

For EBS 12.1 & 12.2

EBS + Discoverer 11g Users

This JRE release is certified for Discoverer 11g in E-Business Suite environments with the following minimum requirements:

Implications of Java 6 and 7 End of Public Updates for EBS Users

The Oracle Java SE Support Roadmap and Oracle Lifetime Support Policy for Oracle Fusion Middleware documents explain the dates and policies governing Oracle's Java Support.  The client-side Java technology (Java Runtime Environment / JRE) is now referred to as Java SE Deployment Technology in these documents.

Starting with Java 7, Extended Support is not available for Java SE Deployment Technology.  It is more important than ever for you to stay current with new JRE versions.

If you are currently running JRE 6 on your EBS desktops:

  • You can continue to do so until the end of Java SE 6 Deployment Technology Extended Support in June 2017
  • You can obtain JRE 6 updates from My Oracle Support.  See:

If you are currently running JRE 7 on your EBS desktops:

  • You can continue to do so until the end of Java SE 7 Deployment Technology Premier Support in July 2016
  • You can obtain JRE 7 updates from My Oracle Support.  See:

If you are currently running JRE 8 on your EBS desktops:

Will EBS users be forced to upgrade to JRE 8 for Windows desktop clients?

No.

This upgrade is highly recommended but remains optional while Java 6 and 7 are covered by Extended Support. Updates will be delivered via My Oracle Support, where you can continue to receive critical bug fixes and security fixes as well as general maintenance for JRE 6 and 7 desktop clients. Note that there are different impacts of enabling JRE Auto-Update depending on your current JRE release installed, despite the availability of ongoing support for JRE 6 and 7 for EBS customers; see the next section below.

Impact of enabling JRE Auto-Update

Java Auto-Update is a feature that keeps desktops up-to-date with the latest Java release.  The Java Auto-Update feature connects to java.com at a scheduled time and checks to see if there is an update available.

Enabling the JRE Auto-Update feature on desktops with JRE 6 installed will have no effect.

With the release of the January Critical patch Updates, the Java Auto-Update Mechanism will automatically update JRE 7 plug-ins to JRE 8.

Enabling the JRE Auto-Update feature on desktops with JRE 8 installed will apply JRE 8 updates.

Coexistence of multiple JRE releases Windows desktops

The upgrade to JRE 8 is recommended for EBS users, but some users may need to run older versions of JRE 6 or 7 on their Windows desktops for reasons unrelated to the E-Business Suite.

Most EBS configurations with IE and Firefox use non-static versioning by default. JRE 8 will be invoked instead of earlier JRE releases if both are installed on a Windows desktop. For more details, see "Appendix B: Static vs. Non-static Versioning and Set Up Options" in Notes 290807.1 and 393931.1.

What do Mac users need?

JRE 8 is certified for Mac OS X 10.8 (Mountain Lion), 10.9 (Mavericks), 10.10 (Yosemite), and 10.11 (El Capitan) desktops.  For details, see:

Will EBS users be forced to upgrade to JDK 8 for EBS application tier servers?

No.

JRE is used for desktop clients.  JDK is used for application tier servers.

JRE 8 desktop clients can connect to EBS environments running JDK 6 or 7.

JDK 8 is not certified with the E-Business Suite.  EBS customers should continue to run EBS servers on JDK 6 or 7.

Known Iusses

Internet Explorer Performance Issue

Launching JRE 1.8.0_73 through Internet Explorer will have a delay of around 20 seconds before the applet starts to load (Java Console will come up if enabled).

This issue fixed in JRE 1.8.0_74.  Internet Explorer users are recommended to uptake this version of JRE 8.

Form Focus Issue Clicking outside the frame during forms launch may cause a loss of focus when running with JRE 8 and can occur in all Oracle E-Business Suite releases. To fix this issue, apply the following patch:

References

Related Articles
Categories: APPS Blogs

BUILT/ Launches Innovative Omnichannel Company on the NetSuite Unified Cloud Commerce Platform

Oracle Press Releases - Wed, 2017-04-26 11:30
Press Release
BUILT/ Launches Innovative Omnichannel Company on the NetSuite Unified Cloud Commerce Platform UK business to transform the customer experience for professional builders and tradespeople

SuiteWorld 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites and a wholly-owned subsidiary of Oracle, today announced that BUILT/, a new company supported by a leading UK based organization in the sector, has selected NetSuite’s unified cloud commerce platform to support its omnichannel B2B business.

Officially unveiled today at SuiteWorld, BUILT/ aims to make it quicker and easier for professional builders to source materials for their projects, placing a greater focus on providing a superior brand experience with a digital-first approach designed around the customer. Offering both online and brick-and-mortar channels, BUILT/ will run its entire business on the NetSuite unified cloud commerce platform including ecommerce, point-of-sale, order and inventory management, CRM and financials. With NetSuite, BUILT/ will have a flexible, scalable platform that can help manage the business through every stage of its growth.

“We wanted a single, flexible platform that avoided silos of information and had the flexibility to change as the business evolved,” said Nick Thomas, CEO of BUILT/. “When evaluating options, it was clear that only NetSuite would be able to support our approach of ‘start small, grow fast’.”

Meeting the needs of small and midsize builders who source materials on a project-by-project basis, BUILT/’s mobile-optimized webstore, powered by NetSuite SuiteCommerce Advanced, will allow materials to be sourced more easily and builders will be able to order materials and have them shipped to the project site or collected in store.

Further unifying the online and in-store experience, a project product list can be created online. The customer can visit a local store and have a sales associate access their saved project list utilizing the NetSuite SuiteCommerce InStore point-of-sale (POS) system and work with them to finalize the list and complete the purchase in store. Products that a builder finds in store, but is not ready to purchase, can be added to their ecommerce cart or list and transacted later online or during another store visit.

With SuiteCommerce Advanced and SuiteCommerce InStore, which are natively unified with NetSuite’s order and inventory management system, real-time product availability can be shown online. Store associates will have visibility into inventory anywhere in the business, enabling them to fulfill orders from any inventory location be it a store, distribution center or even drop ship from a supplier.  

“Our mission is to make the entire purchasing experience as painless and efficient as possible. Greater convenience and ease of doing business rank among our customers’ top priorities. With NetSuite, we intend to ensure we support these customer expectations,” said Thomas.

NetSuite’s unified commerce platform will deliver the following benefits to BUILT/:

  • More than online purchasing. In addition to providing a great online purchasing experience with SuiteCommerce Advanced, builders can set up an online account that will allow them to get their purchase history, check their account balance, pay invoices online and more.
  • Modern POS system. With full POS capabilities for conducting complex transactions, SuiteCommerce InStore also enables store associates to better engage with customers by empowering them with full access to customer, order and inventory information.
  • Single customer view.  All customer information is captured in a single repository, providing a 360-degree view of all customer activity, including purchases, returns, exchanges, store visits, service requests and marketing campaigns.
  • Built-in business intelligence. BUILT/ will have real-time access to its business performance across customer, order and inventory data for better decision making, and advanced reporting to provide detailed financial reports to its parent company.
  • Streamlined IT with low cost and complexity. NetSuite's proven, secure cloud solution eliminates the hassles of managing, maintaining and upgrading business applications while allowing the company to quickly and easily set up new outlets as the company grows.
  • A scalable platform that can grow with the company. NetSuite provides a highly scalable platform for growth, with the ability to quickly and easily add functionality as BUILT/ opens new stores and expands across the UK.
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

truncate table reuse storage

Tom Kyte - Wed, 2017-04-26 11:26
Hi Tom, I am getting to do same action why? TRUNCATE TABLE xyz where to_date('12/30/1899', 'MM/DD/YYYY') + dtimestamp < to_date('01/01/2017','MM/DD/YYYY') REUSE STORAGE; still getting messages like Error report: SQL Error: ORA-03291: I...
Categories: DBA Blogs

Oracle DBMS_SCHEDULER looping found error ORA-27478

Tom Kyte - Wed, 2017-04-26 11:26
I've some script for running bat file windows using DBMS_SCHEDULER. But there is some error when there is looping with several data. <code>CREATE OR REPLACE procedure SEAT.ss_print_fundoshi_run_weld_tst (ptype varchar2) is cursor c_data is se...
Categories: DBA Blogs

migrating database among platforms of different endianness

Tom Kyte - Wed, 2017-04-26 11:26
Greetings, I am trying to migrate a whole database from windows to aix based platform. The endianess of these OS are small and big consecutively. I have done just the tablespace migration using datapump utility and rman conversion of datafiles. ...
Categories: DBA Blogs

SPFILE READ IN 12C

Tom Kyte - Wed, 2017-04-26 11:26
Hi team, I have seen alert log it is showing message like this. DB has not been restarted then why the spfile read it is showing because as per my understanding it shows message like this when we start the db. DB IS - 12c ASM also there. ...
Categories: DBA Blogs

Views perform better?

Tom Kyte - Wed, 2017-04-26 11:26
We are displaying several complicated reports in our web application. These reports use joins in many Orcale tables. Tables may have 1000s of records. Do we gain any performance by making Views that perform complicated SQL. And then in our applicatio...
Categories: DBA Blogs

NetSuite Announces OneWorld for Nordics-headquartered Companies

Oracle Press Releases - Wed, 2017-04-26 11:15
Press Release
NetSuite Announces OneWorld for Nordics-headquartered Companies Localized and Designed to Meet Business Requirements, Regulatory and Tax Compliance

SuiteWorld 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle NetSuite Global Business Unit (GBU), one of the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced NetSuite OneWorld for Nordics-headquartered businesses. NetSuite OneWorld is now localized for Nordics-based businesses. With over 730 subsidiaries and legal entities of global companies already running businesses in Sweden, Norway, Denmark and Finland, the new localized OneWorld offering will bring more global cloud ERP capabilities for the region. Nordic companies will benefit from the combination of NetSuite’s increased product investment and Oracle’s localization capabilities.

“NetSuite’s commitment to the Nordic region was a compelling factor in our decision to go with NetSuite OneWorld,” said Tomi Holmberg, Director Sales Operations at Napa Ltd., a Helsinki-based company providing software solutions and services for the maritime industry. “We’re eager to learn more on the new and existing features of NetSuite to further improve our internal end-to-end process. I’m looking forward to meeting NetSuite professional personnel as well as other NetSuite users from different companies to have fruitful discussions on how we can utilize this great system to its full extent.”

“NetSuite is already providing Nordic businesses with one of the industry’s leading cloud ERP and these country-specific capabilities are a signal of our continued commitment to the success of companies headquartered in the region and across Europe,” said Craig Sullivan, Group Vice President of Product Development for NetSuite. “NetSuite OneWorld delivers the local tax, currency and accounting support to help Nordic companies continue to drive growth, expand and prepare for whatever comes next.”

NetSuite OneWorld, a Game-Changer for Nordic Businesses

NetSuite OneWorld provides a unified and cloud-based suite of software that is flexible enough to meet the needs of diverse business models, legal structures and geographies. NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries, and customer transactions in more than 200 countries.

Further, NetSuite OneWorld delivers omnichannel commerce capabilities to enable both B2B and B2C businesses to move from siloed online, in-store and call center shopping channels to an integrated commerce solution. Connecting ecommerce to order management, inventory, merchandising, marketing, financials and customer service gives NetSuite users the seamless brand experience needed to exceed customer expectations across the business.

NetSuite OneWorld for Nordics-Headquartered Companies Delivers:

Multi-subsidiary management. NetSuite OneWorld’s support for businesses with multiple subsidiaries, business units and legal entities, provides real-time access to subsidiary and parent operational data through detailed reports that can drill down to specific country-level data.

Global currency and accounting. NetSuite OneWorld offers easy configuration to support International Financial Reporting Standards (IFRS), local Generally Accepted Accounting Practices (GAAP) and legal requirements, flexible revenue recognition rules, depreciation and costing methods to help meet local norms and support for more than 190 currencies, including the ISO standard currencies with automated feeds to maintain exchange rates between currencies from a choice of providers.

Comprehensive tax compliance. By providing triangulation reporting for business engagements that span three countries, Intracommunity Sales and Purchase reporting, Intrastat declarations and Tax Audit File generation in various formats, including SAF-T, NetSuite OneWorld bridges the gap between traditional ERP and external tax engines and provides seamless access to key data required to satisfy those tax authorities.

Country-specific indirect tax support. NetSuite OneWorld supports the Nordics’ indirect VAT reports, including Skatt (DK), Skatteverket (SE), VERO Skatt (FI) and Skatteetaten (NO), along with other regional and global variants of Value-Added Tax, Sales Tax and Withholding Tax. It can be easily configured to calculate, track and report on the indirect tax obligations of businesses regardless of country, which can materially simplify tax management, tax compliance, filing, and audit accountability. Within the EU, NetSuite Global Tax also handles triangulation reporting requirements for business engagements that span three countries or more. It also supports Mini-One-Stop-Shop (MOSS) tax calculation and reporting obligations for companies delivering electronic services to European customers.

Local bank and payment support. NetSuite OneWorld offers a highly configurable payment solution with more than 90 predefined bank formats and a payment partner program that offers strong coverage for credit card, debit card and alternative payment methods in the region.

Local language support. NetSuite OneWorld supports 20 languages including Danish, Swedish, Finnish and Norwegian for the Nordics. Further, NetSuite OneWorld enables businesses to trade with customers, suppliers and partners anywhere in the world in the language of their choice while meeting local compliance standards and cultural expectations through easily customizable forms.

Cloud-based architecture. NetSuite OneWorld frees businesses from the hassles and expenses of managing on-premise software and associated hardware with a system able to be available anywhere at any time with an internet connection with mobile access from iPhone and Android devices with optimized screens to enable on-the-move executives and field staff.

Robust development platform. The SuiteCloud development platform enables businesses in the region to customize the software to their specific needs and integrate with third-party applications. NetSuite’s SuiteCloud Development Network provides a vibrant partner ecosystem that has strong regional and vertical industry partners with domain expertise and knowledge.

For Nordics-Headquartered Companies, NetSuite OneWorld can deliver country-specific features and functionality such as:

  • Global currency and accounting
  • Country-specific indirect tax support
  • Local language support in Danish, Swedish, Finnish and Norwegian
  • Robust development platform with a vibrant partner ecosystem that has strong regional and vertical industry partners with domain expertise and local knowledge such Staria Oyj and Accountor Enterprise.

For Denmark-Headquartered Companies, NetSuite OneWorld can deliver country-specific features and functionality such as:

  • Global currency and accounting
  • Country-specific indirect tax support
  • Flexible reporting engine that provides country-specific reporting
  • Local bank and payment support
  • Local language support
  • Robust Development Platform

For Sweden-Headquartered Companies, NetSuite OneWorld can deliver country-specific features and functionality such as:

  • Global currency and accounting
  • Country-specific indirect tax support
  • Local language support
  • Flexible reporting engine that supports country-specific reporting
  • SIE compliance and local payment processing for Bankgiro, Plusgiro, and SEPA
  • Swedish invoice layout
  • Robust Development Platform

For Norway-Headquartered Companies, NetSuite OneWorld can deliver country-specific features and functionality such as:

  • Global currency and accounting
  • Country-specific indirect tax support
  • Local language support
  • Flexible reporting engine that supports country-specific reporting
  • Robust Development Platform

For Finland-Headquartered Companies, NetSuite OneWorld can deliver country-specific features and functionality such as:

  • Global currency and accounting
  • Country-specific indirect tax support
  • Local language support
  • FAS reporting
  • Payroll integration
  • E-invoicing / Finnish invoice layout
  • Banking integration including Finnish invoice numbering and SEPA payment format
  • Robust Development Platform 
About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

NetSuite Unveils Major Global ERP Enhancements

Oracle Press Releases - Wed, 2017-04-26 11:00
Press Release
NetSuite Unveils Major Global ERP Enhancements New Functionality Spans Global Financials, Revenue Recognition, Billing, SRP, SCM and GRC to Empower Companies Ready for Next

SuiteWorld 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle NetSuite Global Business Unit (GBU), the industry's leading provider of cloud financials / ERP, HR and omnichannel commerce software suites, today announced the new release of major global ERP features. These new cloud ERP features are designed to ready businesses for next, with a host of enhancements to its core ERP suite. The new functionality spans global financials, revenue recognition, billing, Services Resource Planning (SRP), Supply Chain Management (SCM), and Governance, Risk and Compliance (GRC). These enhancements give NetSuite customers the ability to continue to scale and innovate efficiently.

NetSuite keeps customers ready for next with two major upgrades every year, with customizations that carry forward automatically, giving customers the assurance that they’re always on the latest version of the software.

“For many years, NetSuite has been the clear leader in global cloud financials and ERP. With this release the lead just got bigger,” said Jim McGeever, Executive Vice President of Oracle NetSuite Global Business Unit. “The major investments we have made in product development over the last several years, combined with the incremental Oracle resources, have allowed us to deliver the greatest amount of new financial and ERP features and functionality ever.”

Global Financials: more automation and simplification of complex multi-company and multi-country financials
  • New Intercompany Journal Entry: As NetSuite continues to extend and enhance its best of breed global financials capabilities, NetSuite OneWorld delivers the advanced intercompany journal entry capability which allows accountants more flexibility and control when booking intercompany transactions.
  • GL Impact Locking: NetSuite is introducing new functionality designed to help customers meet the accounting and compliance requirements of many countries around the world. The new functionality also improves support for GRC mandates such as Sarbanes–Oxley (SOX), internal controls, enhanced GL audit numbering, and more visible changes to financial records.
  • FX Revaluation Sustainability: Many companies have changed their operating structures, expanded internationally, and often transact business in multiple global currencies. Enterprises that report financial results in one currency may have branches or subsidiaries operating in different currency environments. Those businesses may, in turn, engage in transactions denominated in currencies different from the operating currency requiring them to meet the local statutory compliance requirements.

Revenue Recognition and Billing: simplifying complexities
  • Next Generation Revenue Management: With new, more onerous revenue recognition regulations due to take effect over the next couple of years, revenue management is already a really big deal. NetSuite's Advanced Revenue Management automates revenue forecasting, allocation, recognition, reclassification, and auditing through a rule-based event handling framework. It is designed to support compliance with the ASC 606 revenue standard. With advanced revenue management you can defer revenue for recognition across future periods according to the rules you configure. It supports fair values based on vendor-specific objective evidence (VSOE), best estimate of selling price (ESP), and third-party evidence providing greater flexibility and transparency in recognizing revenue.
  • Billing Price Books: Allows for multiple pricing schemes to be available for each subscription plan whether it’s by currency or region, or any other dimension critical to the business.

Services Resource Planning: more flexibility, automation for services companies
  • Improved Performance and Ease of Use when Running Charges: Running large numbers of charge transactions can be tedious and time consuming. Improvements in the latest version address many of these problems and improve the entire user experience.
  • Time Rejection Note: Enforces that timesheet approvals provide details as to why a timesheet entry was rejected and what actions the submitter must take to address the errors.
  • Time Threshold Improvements: Adds additional rules to enforce limits for timesheet hour entry and produce fewer errors.
  • Enhancements to Contract Renewals: Flexible contract creation, creating contracts based on status of sales order, flexible start date for renewals, relieve restrictions imposed by the contract, and flexible maintenance and support pricing.
  • Improve Billing Flexibility with Billing Rate Cards: Tailor billing rates per customer and project, consolidate view of billing rates and optimize rate cards across eco-system of customers and projects.

Supply Chain Management: more optimization of complex supply chains
  • In-Transit Accounting Enhancements: The inclusion of in-transit quantities and amounts in the Group Average Cost feature allows customers to have better visibility of their total investment and activity relative to the items they are managing across locations.
  • Enhanced Transfer Order Processing: Inventory managers can now move inventory using intercompany and transfer orders at cost, while warehouse managers can now declare the inventory ownership on the intercompany and transfer orders to change either at time of shipment or receipt.
  • Vendor Dashboard: The new vendor dashboard provides at-a-glance access to any and all information related to your vendors and also allows you to customize the screen – choosing from a variety of standard or custom reports, saved searches, KPI’s, charts, tasks and alerts.
  • New WMS Lite Features: Including fulfillment, receiving, inventory movements and the ability to create flexible cycle count plans that can be reused to speed up count generation process, simple replenishment based on orders, being able to execute picking on RF device without Pick Reports. Users can now enter transactions using different and multiple UOMs. The UOM conversion information and calculations for the transaction will also be visible. A new icon based touch menu interface improves the look and feel of the mobile application.
  • Phantom BOMs: More easily supports complex BOM structures and systems by using phantoms to streamline the engineering process.
  • Edit In-Process Work Orders: Handles the unknowns of manufacturing by making on-the-fly changes to the work order to account for re-work, repair and unexpected situations.

GRC: more GRC controls
  • Enhanced 2FA: All users with non-customer center roles are able to use time-based one-time password (TOTP) Authenticator applications as their second factor to log in to NetSuite. Examples include Google Authenticator, Microsoft Authenticator (Both on Screen), Okta Verify, Duo Mobile, Authy or any other authenticator app that supports the TOTP algorithm defined by IETF RFC 6238.
  • Detailed Audit Trails for Script and Script Deployment: This enhancement gives development teams, account administrators and auditors granular and detailed visibility into changes to these records, by whom and when. As with other system notes in NetSuite, this is also a searchable audit trail.

“We’re repeatedly amazed with the features NetSuite continues to add to the product and their commitment to ongoing development,” said John Gardiner, President and CFO at DiscoverOrg, a leading sales intelligence software provider. “The latest enhancements to billing and revenue recognition are going to have a big impact on our business and our bottom line.”

About Oracle NetSuite Global Business Unit

Oracle NetSuite Global Business Unit pioneered the Cloud Computing revolution in 1998, establishing the world’s first company dedicated to delivering business applications over the internet. Today, Oracle NetSuite Global Business Unit provides a suite of cloud-based financials / Enterprise Resource Planning (ERP), HR and omnichannel commerce software that runs the business of companies in more than 100 countries. For more information, please visit www.netsuite.com.

Follow Oracle NetSuite Global Business Unit’s Cloud blog, Facebook page and @NetSuite Twitter handle for real-time updates.

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. 

Announcing Oracle Content and Experience Cloud

WebCenter Team - Wed, 2017-04-26 07:34

In a press release today, Oracle announced Oracle Content and Experience Cloud -- a digital experience platform that enables organizations to manage and deliver content to any digital channel to drive effective engagement with customers, partners, and employees. The cloud-based content hub allows organizations to easily create and distribute content in a meaningful way to improve brand engagement and customer growth and retention.

What’s new in Oracle Content and Experience Cloud?

Oracle Content and Experience Cloud delivers a single cloud-native platform for content production, management, and delivery across all lines of business. It provides unique capabilities to support a variety of business needs, from employee and customer engagement, to sales enablement and business development.

What are the key capabilities in Oracle Content and Experience Cloud?

  • Content Collaboration: Easily collaborate on content internally and with external teams. Discuss, share, and annotate content with mobile access, anywhere, anytime.
  • Centralized Content Hub: Utilize a single content hub to create, share, manage, and publish content to any channel, including business documents, digital assets, user-generated content, and web content.
  • Consistent Omni-Channel Experience: Leverage rich APIs to deliver engaging experiences across any channels and put your business in charge with business-friendly tools.
  • Enhanced Enterprise Applications with Content: Manage content from within your enterprise applications and enhance your application experience.

Where can you get more information on Oracle Content and Experience Cloud?

We encourage you to read the press release to learn more. We also invite you to join David Le Strat, senior director, product management, Oracle, in a webcast on May 2 at 10:00am PDT as he goes into depth about the key capabilities listed above and demonstrates Oracle Content and Experience Cloud in action!

Oracle Introduces a Smarter Approach to Customer Experience Management

Oracle Press Releases - Wed, 2017-04-26 07:30
Press Release
Oracle Introduces a Smarter Approach to Customer Experience Management Chatbots, artificial intelligence and enhanced mobile, video and messaging capabilities empower customer experience professionals to transform existing business processes

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced a series of new innovations within the Oracle Customer Experience (CX) Cloud Suite. By combining innovative new technologies such as chatbots and artificial intelligence with enhanced mobile, video and messaging capabilities, the latest updates to Oracle CX Cloud Suite enable commerce, marketing, sales and service professionals to reduce IT complexity, provide innovative customer experiences and deliver tangible business results.

Digital technologies have fundamentally changed how customers interact with brands and now a new generation of innovations, such as artificial intelligence and the Internet of Things (IoT), are reaching the mainstream. With the latest enhancements to the Oracle CX Cloud Suite, Oracle empowers customer experience professionals to take a smarter approach to managing digital business transformation. The latest enhancements include updates to commerce, marketing, sales and service applications within the Oracle CX Cloud Suite.

Chatbot Innovations

Innovative chatbot capabilities enable new customer experiences by asking and intelligently answering customer questions on both text and voice-driven platforms such as Facebook Messenger and Amazon Alexa. Marketing professionals can take advantage of chatbot capabilities for their cross-channel marketing in order to enhance larger, marketer-orchestrated customer journeys. Service professionals can benefit from the conversational style of a new Virtual Assistant to provide differentiated customer self-service experiences, as well as to improve response and resolution times across chat and messaging channels. Sales professionals can leverage a new Virtual Assistant that improves sales productivity by acting as a mobile, voice-driven assistant that automates common sales tasks such as account search, transaction creation and updates.  

Artificial Intelligence Innovations

New artificial intelligence based customer experience apps empower commerce, marketing, sales and service professionals to deliver smarter experiences across the customer lifecycle. The new Adaptive Intelligent Apps for CX uniquely blend first-party and third-party customer data with sophisticated decision science and machine learning, to help organizations optimize customer experiences and business outcomes.

Adaptive Intelligent Apps for CX embed within existing Oracle CX Cloud Suite commerce, marketing, sales and service applications. This ensures that business professionals are able to achieve immediate impact and value. For further details, see Adaptive Intelligent Apps for CX announcement.

Mobile, Video and Social Messaging Innovations

Enhanced mobile, video and social messaging capabilities help customer experience professionals transform existing business processes to meet the increasing expectations of empowered customers. New video and social messaging capabilities for service professionals power next-generation customer service strategies by enabling customer service agents to interact with customers across WeChat, Facebook Messenger and video channels. New mobile capabilities for sales professionals maximize productivity for sales reps, managers and partners with a voice-activated, task-based and role-based user experience. In addition, sales professionals now have the flexibility to use Windows Surface tablets, as well as iOS and Android devices, and take advantage of full offline capabilities to create and edit sales data without a cellular or Wi-Fi connection.

“These enhancements to the Oracle CX Cloud Suite underscore our commitment to an innovation-driven approach to software development and delivery across our entire platform,” said Rondy Ng, senior vice president, Application Development, Oracle. “By combining new mobile, video and messaging capabilities with the latest innovations in chatbots, artificial intelligence and IoT, we are uniquely able to help organizations of all sizes drive innovation and business transformation. We are committed to helping organizations meet the demands of empowered customers for seamless, personalized and immediate experiences today and in the future.”

Part of Oracle Applications Cloud, Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Marketing Cloud, Oracle Sales Cloud, Oracle CPQ Cloud, Oracle Commerce Cloud, Oracle Service Cloud and Oracle Social Cloud.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@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

Simon Jones

  • +1.415.856.5155

Oracle Empowers Customer Experience Professionals with New Artificial Intelligence Apps

Oracle Press Releases - Wed, 2017-04-26 07:05
Press Release
Oracle Empowers Customer Experience Professionals with New Artificial Intelligence Apps Innovative commerce, marketing, sales and service apps enable smarter customer experiences that drive tangible and predictable business results

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced new artificial intelligence based customer experience apps that empower commerce, marketing, sales and service professionals to deliver smarter experiences across the customer lifecycle in real time. The new Adaptive Intelligent Apps for CX uniquely blend first-party and third-party data with sophisticated decision science and machine learning to deliver the industry’s most powerful AI-based customer experience solutions. Adaptive Intelligent Apps for CX are designed to help enhance existing commerce, marketing, sales and customer service applications within the Oracle CX Cloud Suite.

Adaptive Intelligent Apps are powered by insights from the Oracle Data Cloud, which is the largest data marketplace in the world with a collection of more than 5 billion global consumer and business IDs and more than 7.5 trillion data points collected monthly.

By applying advanced data science and machine learning to Oracle’s web-scale data and an organization’s own data, the new Adaptive Intelligent Apps for CX can have an unprecedented ability to react, learn and adapt in real time based on historical and dynamic customer data such as click-stream and social activity as well as inputs such as weather, lookalike audiences and Internet of Things (IoT) data. The new Adaptive Intelligence Apps for CX helps deliver customized insights that improve with every customer interaction and include innovative apps designed for consumer and B2B professionals.

Adaptive Intelligent Apps for CX deliver immediate impact by embedding within Oracle CX Cloud Suite applications to support customer experience workflows across commerce, marketing, sales and service.

  • Commerce Professionals: New AI-powered capabilities help turn static journeys into smart ones by delivering targeted product and content that is most relevant to the shopper’s immediate context. Recommendations utilize account data, shopper third-party data and real-time inputs to optimize outcomes and create superior consumer experiences for both first time and known shoppers. This drives repeat visits, loyalty and ultimately revenue.
  • Marketing Professionals: New AI-powered capabilities help enable smarter cross-channel experiences by delivering the most relevant, personalized content for each individual customer, at scale. By personalizing engagements in real time across all channels, the new AI capabilities help empower marketers to capture attention, drive engagement and improve conversion.
  • Customer Service Professionals: New AI-powered capabilities help enable smarter and faster resolution of customer issues by providing the best information in the right channel at the right time. By delivering predictive product failure, predictive account health and predictive recommendation capabilities to customer service professionals, customers can receive connected service experiences that ultimately improve customer loyalty and advocacy.
  • Sales Professionals: New AI-powered capabilities help enable smarter sales experiences by optimizing the selling process for sales teams and customers. For customers, the buying process is made more effortless and seamless as the right offer, optimized for the individual customer, is presented digitally or through a sales professional. Sales professionals can improve productivity by following guidance derived from opportunity analysis as well as using account engagement and next-best-action capabilities to accelerate and close more deals.

“Oracle is uniquely placed to deliver on the promise of artificial intelligence based enterprise applications and is delivering on the future of AI driven business applications today,” said Clive Swan, SVP Applications Development, Oracle Adaptive Intelligence. “By combining first and third party data with advanced machine learning and the industry’s most comprehensive cloud applications suite, Oracle provides a complete package that helps eliminate the need for more integrations or other costly and time-consuming processes. This enables our customers to achieve immediate value and take a smarter approach to business transformation.”

Part of Oracle Applications Cloud, Oracle CX Cloud Suite empowers organizations to take a smarter approach to customer experience management and business transformation initiatives. By providing a trusted business platform that connects data, experiences and outcomes, Oracle CX Cloud Suite helps customers reduce IT complexity, deliver innovative customer experiences and achieve predictable and tangible business results. The Oracle CX Cloud Suite includes Oracle Marketing Cloud, Oracle Sales Cloud, Oracle CPQ Cloud, Oracle Commerce Cloud, Oracle Service Cloud and Oracle Social Cloud.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@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

Simon Jones

  • +1.415.856.5155

Oracle Content and Experience Cloud Empowers Organizations to Deliver Modern, Engaging Digital Experiences

Oracle Press Releases - Wed, 2017-04-26 07:02
Press Release
Oracle Content and Experience Cloud Empowers Organizations to Deliver Modern, Engaging Digital Experiences New cloud-based content hub drives omni-channel marketing asset management

Modern Marketing Experience, Las Vegas, Nev.—Apr 26, 2017

Oracle today announced Oracle Content and Experience Cloud, a digital experience platform that enables organizations to manage and deliver content to any digital channel to drive effective engagement with customers, partners, and employees. The cloud-based content hub allows organizations to easily create and distribute content in a meaningful way to improve brand engagement and customer growth and retention.

“Organizations are faced with a deluge of content,” said David Le Strat, senior director, product management, Oracle. “Oracle Content and Experience Cloud helps organizations develop, use, and distribute content in a meaningful way to deliver contextualized experiences, improve customer loyalty, and create brand advocates.”

“Renault Italy implemented CRUEL’s WONDER Marketing solution powered by Oracle Content and Experience Cloud in 2015 and 2016 and is now able to distribute marketing materials 90 percent faster and respond to its auto dealers 40 percent faster,” said Antonio Orefice, Business Account Manager, Renault Italia SPA.

Part of the Oracle Cloud Platform, Oracle Content and Experience Cloud delivers a single cloud-native platform for content production, management, and delivery across all lines of business. It provides unique capabilities to support a variety of business needs, from employee and customer engagement, to sales enablement and business development. Key capabilities include:

  • Content Collaboration: Easily collaborate on content internally and with external teams. Discuss, share, and annotate content with mobile access, anywhere, anytime.
  • Centralized Content Hub: Utilize a single content hub to create, share, manage, and publish content to any channel, including business documents, digital assets, user-generated content, and web content.
  • Consistent Omni-Channel Experience: Leverage rich APIs to deliver engaging experiences across any channels and put your business in charge with business-friendly tools.
  • Enhanced Enterprise Applications with Content: Manage content from within your enterprise applications and enhance your application experience.

 “In today’s digital economy, everyone expects to have a seamless experience across channels,” said Melissa Webster, program vice president, content and digital media technologies, IDC. “Enterprises need the ability to unlock content from existing systems, and drive native cloud content production to publish across any channels. This helps organizations deliver consistent omni-channel experiences for their customers and build brand advocates.”

Oracle Content and Experience Cloud is uniquely capable of addressing the needs of both the business user and IT, enabling them to work together to deliver modern, engaging digital experiences (DX). The platform integrates with the Oracle Customer Experience Cloud Suite, an integrated suite of cloud applications that empower organizations to take a smarter approach to customer experience management and business transformation initiatives. The Content and Experience Cloud also integrates with a number of leading Oracle Cloud Platform services, including Oracle Process Cloud, Oracle Mobile Cloud and Oracle Integration Cloud. This forms the most comprehensive and powerful DX platform for managing content operations, data integration, complex workflow management, and mobile and marketing automation capabilities.

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.415.235.4033
nicole.maloney@oracle.com
Simon Jones
Public Relations for Oracle
+1.415.856.5145
simon.jones@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.415.235.4033

Simon Jones

  • +1.415.856.5145

Oracle Honors Excellence in Modern Marketing at the 2017 Markie Awards

Oracle Press Releases - Wed, 2017-04-26 07:00
Press Release
Oracle Honors Excellence in Modern Marketing at the 2017 Markie Awards Awards recognize creativity, innovation and success in modern marketing

Modern Customer Experience 2017, Las Vegas, Nev.—Apr 26, 2017

To promote best practices and celebrate the accomplishments of modern marketers around the world, Oracle has announced the winners of the 2017 Markie Awards. Now in its 11th year, the Markie Awards recognize the top companies and leaders for creative, innovative, and effective modern marketing campaigns that delivered increased engagement, conversion and ROI. Past winners include notable companies such as Lenovo, Royal Philips, Cisco Systems, Dell, Inc. and Mobovida, LLC.

The 2017 Markie Awards featured 17 categories that reflect the evolving marketing landscape, including: Account-Based Marketing Team of the Year, Best Digital Marketing Ecosystem, Best Integrated Mobile Experience, Best Use of Data, Most Creative Marketing Campaign, and Modern Marketing Leader of the Year.

“The annual Markie Awards are our way to recognize and celebrate heroic marketing and the most prominent modern marketing success stories over the past year,” said Laura Ipsen, senior vice president and general manager, Oracle Marketing Cloud. “This year’s winners have gone above and beyond, fully leveraging the most innovative marketing technologies to create customer-centric campaigns that delivered outstanding results.”

Winners of the 2017 Markie Awards are:

  • Account-Based Marketing Team of the Year: Covance Inc.
  • Best Cross-Channel Marketing Program: Cisco Inc.
  • Best Digital Marketing Ecosystem: Juniper Networks
  • Best Email Marketing Campaign: Jetstar Airways
  • Best Emerging Company Marketing Campaign: National MI
  • Best Integrated Mobile Experience: Mountain America Credit Union
  • Best International Campaign: Tableau Software
  • Best Lead Management Program: Morningstar, Inc.
  • Best Overall Customer Experience: Avon
  • Best Social Campaign: TD Ameritrade Institutional
  • Best Testing and Optimization: Hilton Worldwide
  • Best Use of Data: Calçados Bibi
  • Best Use of Insights & ROI: Deltek
  • Modern Marketing Leader of the Year: Kenya Airways
  • Most Creative Marketing Campaign: Eaton
  • Rapid Transformation: FIS
  • People’s Choice Award – Best Video Submission: Juniper Networks

The 2017 Markie Awards were presented on Tuesday, April 25th, during Modern Customer Experience 2017 Las Vegas, Nevada.

Contact Info
Simon Jones
Public Relations for Oracle
+1.415.856.5155
sjones@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

Simon Jones

  • +1.415.856.5155

Save the date: Swiss PGDay 2017

Yann Neuhaus - Wed, 2017-04-26 05:52

The 30th of June is not too far away and if you want to learn more about the “World’s most advanced open source database” you should register soon. The sessions are not yet officially announced but you can expect that to happen next week. What we can say already is that we will be there and that you can expect these sessions from dbi:

  • How to migrate data from MongoDB to Postgres with ToroDB
  • Elking your PostgreSQL database infrastructure
  • PostgreSQL upgrade best practices

Hope to see you in June.
PGDay2017CH

 

Cet article Save the date: Swiss PGDay 2017 est apparu en premier sur Blog dbi services.

Pages

Subscribe to Oracle FAQ aggregator