Feed aggregator

Index script

Tom Kyte - Thu, 2017-04-27 05:26
I have two databases with indexes for same column different. I want a script that compares these two databases and generates the rename index script for the target database. Can you provide me a sample? Need to join dba_indexes and dba_ind_columns fr...
Categories: DBA Blogs

Incremental stats on large partitioned table

Tom Kyte - Thu, 2017-04-27 05:26
we have our a reporting database which is being cloned from our production database daily. The source database is a mission critical database where we can't make any changes(can't set table preferences for stats gathering ). We have a range partition...
Categories: DBA Blogs

Need assistance on calling shell script from oracle triggers.

Tom Kyte - Thu, 2017-04-27 05:26
Hi Tom, REQUIREMENT: Need to send database report before and after database bounce. Test Case: 1) Created a scheduler job. <code> BEGIN DBMS_SCHEDULER.CREATE_JOB ( job_name => 'RUN_CHECK_REPORT', schedule_name => 'HEALTHCHE...
Categories: DBA Blogs

TABLE Function for custom type

Tom Kyte - Thu, 2017-04-27 05:26
Hello , I have this collection: a nested table built from a custom record that holds three varchars fields, and two numeric ones. The collection is filled with data inside a procedure. I need to sort that collection and I also need to choose...
Categories: DBA Blogs

Date in a nearest leap year

Tom Kyte - Thu, 2017-04-27 05:26
I've got the problem to solve. To find nearest(next or previous) date of the event. It happens every leap year at the particular date. Let's say 1st of May. How to generate such dates and get the nearest of them? Thank you. Our request for more ...
Categories: DBA Blogs

Get Primary Keys of Affected Rows in Update Statements

Tom Kyte - Thu, 2017-04-27 05:26
Question is simple Is there any way where I can get primary keys of a table which have been updated by update statements ? By doing that I want to leverage a select for an update Example There is a table EMPLOYEE with EmployeeID,EmployeeNam...
Categories: DBA Blogs

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. 

Pages

Subscribe to Oracle FAQ aggregator