Feed aggregator

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.

Oracle 12.2 tables, indexes new features

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

The Oracle 12.2.0.1 version has some interesting new features  concerning tables or indexes.

The first new feature is about the online table move.

In 12.2 version Oracle offers now the possibility to move non-partitioned tables without blocking any DML operations.

To realise this operation, we must use the ONLINE keyword and/or the UPDATE_INDEXES clause. If you remember, in the previous Oracle version, we encountered the classical ORA-01502 error.

If you remember in version 12.1, we have the following behaviour, we create a table with a constraint and we insert some values:

SQL> create table emp (name varchar2(10), salary number );
Table created.
SQL> alter table emp add constraint emp_pk primary key (name);
Table altered.
SQL> insert into emp values ('Bill', 100000);
1 row created.
SQL> insert into emp values ('Larry', 10000000);
1 row created.
SQL> commit;
Commit complete.

SQL> select * from emp;
NAME           SALARY
 ---------- ----------
 Bill           100000
 Larry         10000000

Then if  we move the table to another tablespace, the index become unusable, and if we try to insert some data we receive the ORA-1502 error:

SQL> alter table emp move tablespace PSI;
Table altered.
 
SQL> select index_name, status from user_indexes;
 
INDEX_NAME        STATUS
EMP_PK           UNUSABLE
 
SQL> insert into emp values ('Pierre', 99999);
insert into emp values ('Pierre', 99999)
*
ERROR at line 1:
ORA-01502: index 'PSI.EMP_PK' or partition of such index is in unusable state

Now in 12.2 version, we do not have this problem anymore:

SQL> create table emp (name varchar2(10), salary number);
Table created.
 
SQL> alter table emp add constraint emp_pk primary key (name);
Table altered.
 
SQL> insert into emp values ('Bill', 100000);
1 row created.
 
SQL> insert into emp values ('Larry', 999999); 
1 row created.
 
SQL> commit;
Commit complete.
 
SQL> select * from emp;
 
NAME       SALARY
---------- ----------
Bill         100000
Larry        999999
 
 
SQL> select index_name, status from user_indexes;
 
INDEX_NAME        STATUS
EMP_PK            VALID
 
SQL> alter table emp move tablespace PSI2 update indexes;
Table altered.
 
SQL> select index_name, status from user_indexes;
INDEX_NAME        STATUS
EMP_PK            VALID
 
SQL> insert into emp values ('Pierre', 99999);
1 row created.

Using this way, we also can move indexes in different tablespaces:
SQL> alter table emp move online tablespace PSI
  2  update indexes
  3  (emp_pk tablespace psi_ix1,
  4  emp_ix2 tablespace psi_ix1);
 
Table altered.
 
SQL> select index_name, status, tablespace_name from user_indexes;
 
INDEX_NAME.   STATUS TABLESPACE_NAME
EMP_PK        VALID  PSI_IX1
EMP_IX2       VALID  PSI_IX1

Another interesting new feature is about the conversion to a partitioned table. Before the Oracle 12.2 version, the methods used to convert a non-partitioned table to a partitioned table were not online or were using dbms_redefinition. Now in 12.2 we have the possibility to realize the operation in online mode:

SQL> create table emp (name varchar2(10), emp_id number, salary number);

Table created.

SQL> insert into emp values(‘Larry’, 1, 1000000);

1 row created.

SQL> insert into emp values (‘Bill’, 100, 999999);

1 row created.

SQL> insert into emp values (‘Steve’, 1000, 1000000);

1 row created.

SQL> alter table emp modify

partition by range (emp_id) interval (100)

(partition p1 values less than (50),

partition p2 values less than (500),

partition p3 values less than (5000)

) online;

Table altered.

SQL> select table_name , partition_name, high_value from user_tab_partitions;

TABLE_NAME.     PARTITION_NAME      HIGH_VALUE

EMP                                  P1                                      50

EMP                                  P2                                     500

EMP                                  P3.                                    5000

As you can see, this is really an easy way to move a non partitioned table to a partitioned table.

The next new feature I will talk about is concerning the advanced compression. For example, we have the possibility to create a tablespace with such an argument:

SQL> create tablespace psi_ix_compress
  2  default index compress advanced high
  3  datafile '/u01/oradata/db1/db1pdb1/psi_ix_comp01.dbf' size 10M;
 
Tablespace created.

Every new index created in this tablespace will use high advanced compression. But at first approach it does not seem to work very well:

SQL> create index psi_ix2 on emp(salary) tablespace psi_ix_compress;
 
Index created.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME             COMPRESSION
EMP_PK                  DISABLED
EMP_IX2                 DISABLED
PSI_IX2                 DISABLED

But if you have a more precise look, there is a parameter you have also to modify:

SQL> show parameter db_index_compression_inheritance
 
NAME                                  TYPE VALUE
db_index_compression_inheritance     string NONE

SQL> alter system set db_index_compression_inheritance = 'TABLESPACE';
 
System altered.

And finally, it works fine:

SQL> create index psi_ix1_comp on emp (name, emp_id,salary) tablespace psi_ix_compress;
Index created.
 
SQL> select index_name, compression from user_indexes where index_name like '%COMP';
INDEX_NAME.      COMPRESSION
PSI_IX1_COMP     ADVANCED HIGH

We have the possibility to specify the ADVANCED COMPRESS HIGH or LOW argument in the create or rebuild statement:

 

SQL> create index psi_ix1 on emp (salary) compress advanced low;
 
Index created.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME         COMPRESSION
EMP_PK              DISABLED
PSI_IX1             ADVANCED LOW
PSI_NEW             DISABLED

And we can use alter index rebuild to modify to high advanced compression:

SQL> alter index psi_ix1 rebuild compress advanced high;
Index altered.
 
SQL> select index_name, compression from user_indexes;
 
INDEX_NAME.        COMPRESSION
EMP_PK              DISABLED
PSI_IX1.            ADVANCED HIGH
PSI_NEW             DISABLED

Enjoy using those Oracle 12.2.0.1 new features !

 

Cet article Oracle 12.2 tables, indexes new features est apparu en premier sur Blog dbi services.

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

Steven Chan - Wed, 2017-04-26 02:00

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

Cross-origin resource sharing (CORS) from Spring Boot Rest Controllers

Pas Apicella - Tue, 2017-04-25 18:45
Was involved in a hackathon recently and after creating a few Spring boot API's for the UI team to consume and they run into errors around (Cross-origin resource sharing ). For security reasons, browsers prohibit AJAX calls to resources residing outside the current origin.

I have seen this before and Spring Boot has support to ensure you can control which resources can be accessed outside of the current origin. It's as simple as an annotation "@CrossOrigin", as shown below. In this example every request from this Rest Controller supports resource calls residing outside the current origin.
  
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.http.HttpStatus;
import org.springframework.http.MediaType;
import org.springframework.web.bind.annotation.*;

import java.util.List;

@CrossOrigin
@RestController
@RequestMapping(value = "/beacon")
public class BeaconRest
{
private static Log logger = LogFactory.getLog(BeaconRest.class);

@Autowired
private BeaconRepository beaconRepository;

@RequestMapping(value = "/all",
method = RequestMethod.GET,
produces = MediaType.APPLICATION_JSON_VALUE)
public List<Beacon> allBeacons()
{
logger.info("Invoking /beacon/all RESTful method");
return beaconRepository.findAll();
}

Of course it's much more flexible then that adding the ability to add options, and you can read more about it here.

https://docs.spring.io/spring/docs/4.2.x/spring-framework-reference/html/cors.html
Categories: Fusion Middleware

Find duplicates in String.

Tom Kyte - Tue, 2017-04-25 17:06
Hello- I have bunch of numbers returned via a report, as shown. What would be the best way to return numbers that occur more than once? For ex: In the first data set, I should return 11; in the second data set I should return 9 and 12 and so on...
Categories: DBA Blogs

Pages

Subscribe to Oracle FAQ aggregator