Feed aggregator

New Video of Oracle Security Vulnerability Scanning

Pete Finnigan - Thu, 2017-08-17 10:46
I have just made a new video of a sample session using PFCLScan our vulnerability / security scanner for the Oracle database. In the video I show how easy it is to get started with PFCLScan and scan an Oracle....[Read More]

Posted by Pete On 17/08/17 At 01:50 PM

Categories: Security Blogs

How do I share a URL to my APEX application?

Joel Kallman - Thu, 2017-08-17 08:17
What is the URL for my APEX application?  If I want to provide a URL to my APEX application to others, what URL do I give them?

Great questions!  I see this done incorrectly all the time inside of Oracle.  A person new to Application Express (APEX) will create an application or install a Productivity Application, run it, copy the full URL, and include the full URL in an email.  I encountered this today in an email, for me to complete a Global Tax Survey via an APEX application (let the good times roll!).  The URL provided was:


Wow, that sure looks complex!  However, it's unnecessarily complex.

The syntax for the entry points into the APEX engine is well documented.  Interpreting the above URL and the colon-separated arguments, it means:

  • 23828 - Application ID
  • 2 - Page ID
  • 113570213685366 - APEX Session ID
  • ::::: - null values for the rest of the arguments in the URL

However, let's evaluate each one of these values in reverse order and assess their necessity:

  • ::::: - Utterly not necessary.  The argument values will default to null anyway.
  • 113570213685366 - Also utterly not necessary.  Assuming the application requires authentication, the APEX Session ID is specific to you, and only you, and only at a specific moment in time.  You'll notice that if you give this URL to someone else, they'll be prompted to authenticate, and then get an entirely new APEX Session ID.  Why include it if it's going to change anyway?
  • 2 - There is a Home URL to every application, so if you're including the starting Page ID in the URL, then it's redundant to include the Page ID again.  It's not necessary.  Additionally, if this is not the same Page ID which is specified in the Home URL, and you have Deep Linking disabled (the default), your end users are going to end up accessing your application via the Home URL anyway.  This is another reason not to include the Page ID in the URL which you share with others.
  • 23828 - This is the only value that is absolutely necessary.  This is the ID of the application you wish to share.

Thus, the URL that I received in email could have been provided simply as:


I don't fault new users to APEX for doing this.  It's not obvious.  But now, hopefully it is!

Build the Oracle APEX application: the framework

Dimitri Gielis - Thu, 2017-08-17 05:11
Over the years while developing Oracle APEX application, I noticed in every application I was following the same steps. It was a routine I followed over and over. For example: in every application I created a global page (page 0), enabled Feedback, ran the Advisor multiple times a week, used certain naming conventions etc.

A few years ago I wrote those steps in our APEX R&D development guide, so within our team we would be consistent. Just like the database best practices, I thought it would be a good idea to share the APEX best practices with you as well. There are about 9 pages, here's a screenshot of the first page:
I don't like too many rules, but a few are good to have, especially when you get new people on board or when the customer is working together with you. As I said in my previous post where I described our database guidelines, the guidelines in itself is not meant to be "this is best and you have to follow", it's more something to start from which you can adapt.

Based on those guidelines, we created a "starter application", so you get a head start in your project. The app in itself wasn't spectacular in itself, it contained the global page, feedback, some administrator pages which give statistics of your app, some application items, error handling package etc.

If you know what you have to build, it wouldn't even take that long to build it from scratch. I just don't like to do repetitive things, I far rather concentrate on the real solution, so anything that can help, I will embrace :) I also won't hesitate to take some components or solutions from other projects and reuse those. But just one piece of advice, always check if what you've been doing before, is still valid today and "the best" way of doing it -for your current problem-. For example if you developed something in APEX 4.2, maybe in APEX 5.x there's a build-in package to do that. Or the other way, that a feature of APEX became deprecated (e.g. apex_plsql_job) and you should use a database feature (dbms_scheduler).

In 2015 I also gave a presentation at some Oracle conferences how I developed in APEX 4.2 vs 5.0, which you find here.

So I could use my starter app for this project, but just as with Quick SQL (to create your database objects), there's a new feature in Oracle APEX 5.2 that will make the starter app irrelevant, so I will cover the new way of doing something in 2017 and further.

The new way of building an application, is to start from a "Blueprint". The concept is very similar to my workflow previously, but now it's built-in the APEX Builder and it's more powerful as it allows to customize the features you want to include in your app.

Blueprint is at the time of writing only available in Preview mode (since March 2017) through apex.oracle.com and will probably undergo some more changes. I see a lot of potential in this feature. It's not only the wizard you can use, rumors are you can also use JSON syntax to define your app.

Here's the video I recorded where I give a bit of background and you see me using Blueprint:

At the time of writing Blueprint isn't finished yet. Not sure what the end result will be, but although there's still a lot of room for improvement, it already looks spectacular. As you could see in the video, I will use it as my starting point for my multiplication table project. I've exported the app of apex.oracle.com and imported in my Oracle Exadata Express environment. Next I'll make changes to this app and customize further.

Blueprint is (or will become) the fastest and most low code way to build an Oracle APEX application.
Categories: Development

More notes on the transition to the cloud

DBMS2 - Thu, 2017-08-17 04:11

Last year I posted observations about the transition to the cloud. Here are some further thoughts.

0. In case any doubt remained, the big questions about transitioning to the cloud are “When?” and “How?”. “Whether”, by way of contrast, is pretty much settled.

1. The answer to “When?” is generally “Over many years”. In particular, at most enterprises the cloud transition will span multiple CIO’s tenure in their positions.

Few enterprises will ever execute on simple, consistent, unchanging “cloud strategies”.

2. The SaaS (Software as a Service) vs. on-premises tradeoffs are being reargued, except that proponents now spell SaaS C-L-O-U-D. (Ali Ghodsi of Databricks made a particularly energetic version of that case in a recent meeting.)

3. In most countries (at least in the US and the rest of the West), the cloud vendors deemed to matter are Amazon, followed by Microsoft, followed by Google. And so, when it comes to the public cloud, Microsoft is much, much more enterprise-savvy than its key competitors.

4. In another non-technical competitive factor: Wal-Mart isn’t the only huge company that is hostile to the Amazon cloud because of competition with other Amazon businesses.

5. It was once thought that in many small countries around the world, there would be OpenStack-based “national champion” cloud winners, perhaps as subsidiaries of the leading telecom vendors. This doesn’t seem to be happening.

Even so, some of the larger managed-economy and/or generally authoritarian countries will have one or more “national champion” cloud winners each — surely China, presumably Russia, obviously Iran, and probably some others as well.

6. While OpenStack in general seems to have fizzled, S3 compatibility has momentum.

7. Finally, let’s return to our opening points: The cloud transition will happen, but it will take considerable time. A principal reason for slowness is that, as a general rule, apps aren’t migrated to platforms directly; rather, they get replaced by new apps on new platforms when the time is right for them to be phased out anyway.

However, there’s a codicil to those generalities — in some cases it’s easier to migrate to the new platform than in others. The hardest migration was probably when the rise of RDBMS, the shift from mainframes to UNIX and the switch to client/server all happened at once; just about nothing got ported from the old platforms to the new. Easier migrations included:

  • The switch from Unix to Linux. They were very similar.
  • The adoption of virtualization. A major purpose of the technology was to make migration easy.
  • The initial adoption of DBMS. Then-legacy apps relied on flat file systems, which DBMS often found easy to emulate.

The cloud transition is somewhere in the middle between those extremes. On the “easy” side:

  • Popular database management technologies and so on are available in the cloud just as they are on-premise.
  • Major app vendors are doing the hard work of cloud ports themselves.

Nonetheless, the public cloud is in many ways a whole new computing environment — and so for the most part, customer-built apps will prove too difficult to migrate. Hence my belief that overall migration to the cloud will be very incremental.

Categories: Other


Tom Kyte - Wed, 2017-08-16 16:26
Dear Sir, I have a problem using sqlldr where I need to add a value that does not exist in the user text file but this value is needed in the table once the data from that text file is inserted into the table. For example: User text file has value...
Categories: DBA Blogs

creating a table with columns longer than 30 characters

Tom Kyte - Wed, 2017-08-16 16:26
Hi All, I am creating a table dynamically whose one column name exceeds more than 30 characters.So i am not able to create the table . I tried by keeping the column name within double quotes( " "). But it throw me the same error. is ther...
Categories: DBA Blogs

How to unload table data to csv file - fastest way for millions of records

Tom Kyte - Wed, 2017-08-16 16:26
I have a table with 100 million rows. Table size is around 25 GB in the DB. I need to unload this data to a csv file. What is the best fastest way to do this. I was reading about external tables to do this by using CTAS but I dont think there is...
Categories: DBA Blogs

Export pivot data with a pipeline function or procedure

Tom Kyte - Wed, 2017-08-16 16:26
I need to create a function (or stored procedure???) that takes pivoted data and outputs it. An external process needs to call the function/procedure and receive the data. The amount of data rows always varies; there is no set limit. However, th...
Categories: DBA Blogs

Alfresco – Unable to see the content of folders with ‘+’ in the name

Yann Neuhaus - Wed, 2017-08-16 15:23

As you might now if you are following our blogs (see this one for example), we are using Alfresco Community Edition internally for some years now and we also have a few customers using it. Today, I will present you a small issue I faced with Alfresco which wasn’t able to display the content of a few – very specific – folders… As you will see below, it was actually not related to Alfresco but that’s a good example.


For some background on this issue, an end-user contacted me, saying that he wasn’t able to see the content of three folders in which he was sure there were at least some PDFs. So I checked and yes, even as an Alfresco Admin, I wasn’t able to see the content of this folder using Share. The only common point I could see with these three folders is that they all contained a “+” in their name. I recently upgraded and migrated this Alfresco environment so I was kind of sure this was somehow linked (since the folders existed and were working before the upgrade+migration). For this blog, I will use a test folder named “Test+Folder” and I’m using an Apache HTTPD as a front end. I put this folder under the Shared folder:

//alfresco_server_01/share/page/context/shared/sharedfilesURL: https://alfresco_server_01/share/page/context/shared/sharedfiles


Clicking on this folder’s name from the central screen or from the browsertree on the left side will result in the following screen:

Folder2URL: https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1


As you can see above, the URL accessed is the correct one, it contains the “/Test+Folder” path so that’s correct (%2F is “/” and %2B is “+”). However, the screen is empty, just like if this path would not exist and on the breadcrumb, it is shown “Shared Files” while it should be “Shared Files > Test+Folder”. So in summary, the Share UI isn’t able to display the content of this folder. For testing purpose, I accessed this folder using WebDAV and AOS and these clients were able to see the content of the folder but not Share. Like I mentioned above, this Alfresco environment is using Apache HTTPD as a front-end and then mod_jk for the communication with the Tomcat. You can take a look at this blog or the official documentation for more information on this setup.


Since other clients were working properly, I tried to access Alfresco Share without going through the front-end (so accessing Tomcat directly) in order to ensure that the issue isn’t with Alfresco itself. By doing so, I was able to see the PDFs. If the issue isn’t with Alfresco, then it should be with the front-end and in particular with the mod_rewrite and mod_jk, in this case. The idea here is to check what are doing these two mods and then compare the outcome with the initial request and what is being transferred to the Tomcat using the access logs.


While doing this analysis, I found out that the mod_jk was most probably the root cause of this issue. When mod_jk is doing its job, it will decode the URL’s encoded characters like %2F for “/”, like %2B for “+”, like %20 for a space, aso… Then once the rules have been processed, it will, by default, re-encode these special characters before transmitting the request to Tomcat. However in the Tomcat access logs, it appeared that the other special characters were indeed present in their encoded format but it wasn’t the case for the “+” sign which was shown like that (so no %2B anymore).

This is an example (it’s not the real requests in the background but this is the URL on a Web browser so it gives a good example):

  • URL accessed:                    https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1
  • URL decoded by mod_jk:  https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|/Test+Folder|&page=1
  • URL sent to Tomcat:          https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest+Folder|&page=1


For some reasons (it looks like a bug), the mod_jk does not re-encode the “+” sign and this prevents the Tomcat in the back-end to complete the request properly. The behavior of mod_jk related to the URIs is managed using the JkOptions. This property can have the following values regarding the Forwarded URI:

  • JkOptions     +ForwardURIProxy
    • Default value in version > mod_jk 1.2.23
    • The forwarded URI will be partially re-encoded after processing inside Apache and before forwarding to Tomcat
  • JkOptions     +ForwardURICompatUnparsed
    • Default value in version = mod_jk 1.2.23
    • The forwarded URI will be unparsed so no decoding nor re-encoding
  • JkOptions     +ForwardURICompat
    • Default value in version < mod_jk 1.2.23
    • The forwarded URI will be decoded by Apache
  • JkOptions     +ForwardURIEscaped
    • The forwarded URI will be the encoded form of the URI used by ForwardURICompat


I’m using a fairly recent version of mod_jk on this Alfresco environment so the default value is “ForwardURIProxy”. Therefore on the paper, it should work properly since URIs will be decoded and re-encoded… However we saw above that this is working but not for the “+” sign which is not re-encoded.


To workaround this issue, I just updated the JkOptions to have “JkOptions     +ForwardURICompatUnparsed” in my Apache HTTPD configuration and after a reload of the conf, I was able to access the content of the folder:

Folder3URL: https://alfresco_server_01/share/page/context/shared/sharedfiles#filter=path|%2FTest%2BFolder|&page=1


Please note that “ForwardURICompatUnparsed” will always forward the original request URI, so rewriting URIs with mod_rewrite might not work properly, it all depends how you configured the rewrite rules and what you need to do with it. Honestly, I don’t think this issue is linked to all mod_jk versions above 1.2.23 since I was using a version 1.2.40 on RedHat before and I never noticed such issue so this might be linked to a specific mod_jk version on a specific OS (Ubuntu?). So basically if you don’t have this issue, I would suggest you to use the default JkOptions.



Cet article Alfresco – Unable to see the content of folders with ‘+’ in the name est apparu en premier sur Blog dbi services.

Oracle Java Cloud Service - Scaling and Cluster Setup for ADF

Andrejus Baranovski - Wed, 2017-08-16 12:10
Last couple of weeks I was busy preparing to my OOW'17 session about estimating Java Cloud Service performance for ADF application. I was running stress tests against various JCS instance configurations to be able to create performance estimation methodology. I will describe this methodology on OOW, but here today will list key steps required to scale up JCS instance.

Let's assume you are running single cloud node with 1 CPU and 7.5 GB RAM. This node contains WLS admin and managed server:

To scale up cloud node, simply invoke Scale Up command from the menu. Select new compute shape and confirm scale up operation:

Scale up completed:

Now go to WebLogic console and update Managed Server startup parameters, to adjust heap size to higher value:

Managed server memory can be increased up to certain amount. If more resources will be needed, at some point you will need to create multiple managed servers and connect them into cluster. This would require to define Load Balancer instance (to have single entry point to the cluster):

Cluster node must run in dedicated cloud node. If cluster is based on two managed servers, there must be two cloud nodes:

Managed servers from cloud nodes can be connected into single cluster, this can be done in WebLogic console:

Once cluster is defined, deployment becomes easy - you can deploy ADF application into cluster and it will be propagated to all nodes:

Traffic director running in load balancer instance will be automatically configured to route traffic to cluster nodes:

PurCotton Teams with Oracle Retail to Support Aggressive Annual Growth

Oracle Press Releases - Wed, 2017-08-16 12:00
Press Release
PurCotton Teams with Oracle Retail to Support Aggressive Annual Growth Renowned Chinese Retailer Builds a Solid Foundation for Continued Omnichannel Success

Redwood Shores, Calif.—Aug 16, 2017

Today, Oracle announced that PurCotton has deployed Oracle Retail Merchandise Operations Management Suite, Oracle Retail Planning and Optimization and Oracle Retail Insights to support the growth of its retail business. As a wholly-owned subsidiary of Winner Medical Group Inc., PurCotton inherits the parent company’s 20-year technology and manufacturing expertise in medical-grade cotton-based products. PurCotton is devoted to providing safe, comfortable and eco-friendly cotton products to meet consumer needs with a focus on quality life, mother and baby care, feminine care and medical care.

Since its founding in December of 2009, PurCotton has grown quickly managing 114 stores in shopping malls across China. In addition PurCotton also operates an online business to meet the demands of omnichannel consumers. PurCotton sales at TMALL.com and JD.com, two of China’s largest ecommerce platforms, have doubled for four consecutive years. Singles’ Day 2016, China’s largest online shopping festival, is an example of PurCotton’s growth with 1,180,000 on-line orders and sales of over 260 million RMB. PurCotton chose Oracle Retail for solutions that could scale and serve as a foundation for continued omnichannel growth.   

“We plan to open between 30 and 40 stores every year, with a goal of increasing our total revenue 100% annually. Our core customer base has grown to about 6 million,” said Li Jianquan, Managing Director of PurCotton Group. “We needed a strong foundation to run our retail business.  Oracle Retail has the industry experience and retail specific solutions to support our growth strategy.”

“Oracle Retail provides a complete and integrated suite of solutions from planning to execution,” said He Kaifeng, Chief Information Officer, PurCotton Group. “We needed a solution which could support our strategy, which includes our brick-and-mortar stores driving sales through multiple channels. With better visibility, insight and planning, PurCotton can better meet high customer demands.”

With the help of Accenture, PurCotton Group deployed Oracle Retail Merchandising System, Oracle Retail Merchandising Insight, Oracle Retail Merchandise Financial Planning, Oracle Retail Assortment Planning and Oracle Retail Allocation.

“Oracle Retail has built end-to-end process capabilities within our suite of applications and cloud services that can deliver individually or collectively to achieve Empowered Commerce,” said Ray Carlin, Senior Vice President and General Manager, Oracle Retail. “We are impressed by the growth trajectory and achievements of PurCotton and look forward to playing a role in their continued success.”

Contact Info
Matt Torres
About Oracle Retail

Oracle provides retailers with a complete, open, and integrated suite of best-of-breed business applications, cloud services, and hardware that are engineered to work together and empower commerce. Leading fashion, grocery, and specialty retailers use Oracle solutions to anticipate market changes, simplify operations and inspire authentic brand interactions. For more information, visit our website at www.oracle.com/retail.

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.


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

Matt Torres

  • 415-595-1584

New OA Framework 12.2.6 Update 5 Now Available

Steven Chan - Wed, 2017-08-16 11:31

Web-based content in Oracle E-Business Suite Release 12 runs on the Oracle Application Framework (also known as OA Framework, OAF, or FWK) user interface libraries and infrastructure. Since the initial release of Oracle E-Business Suite Release 12.2 in 2013, we have released a number of cumulative updates to Oracle Application Framework to fix performance, security, and stability issues.

These updates are provided in cumulative Release Update Packs, and cumulative Bundle Patches that can be applied on top of the Release Update Packs. In this context, cumulative means that the latest RUP or Bundle Patch contains everything released earlier.

The latest OAF update for Oracle E-Business Suite Release 12.2.6 is now available:

Oracle Application Framework (FWK) Release 12.2.6 Bundle 5 (Patch 26382210:R12.FWK.C)

Where is this update documented?

Instructions for installing this OAF Release Update Pack are in the following My Oracle Support knowledge document:

Who should apply this patch?

All Oracle E-Business Suite Release 12.2.6 users should apply this patch.  Future OAF patches for EBS Release 12.2.6 will require this patch as a prerequisite. 

What's new in this update?

This bundle patch is cumulative: it includes all fixes released in previous EBS Release 12.2.6 bundle patches.

In addition, this latest bundle patch includes fixes for the following issues:

  • OA Framework pages scroll to the top of the screen when a value is selected from LOV in IE11 browser.
  • Attributes set up as a read-only text area get misaligned with other components on the page.
  • KFFLovUpdateEvent is not getting fired on selecting a value from Key Flexfield window in IE11 browser.
  • Exporting table data fails when the View Object has view links associated with it and has a different number of bind parameters and bind values.
  • tzOffset and tzId parameters are not recognized by inline date picker on switching between months.

Related Articles

Categories: APPS Blogs

Podcast: Are Microservices and APIs Becoming SOA 2.0?

OTN TechBlog - Wed, 2017-08-16 10:54

When I sent out a call for suggestions for podcast topics, one of the first to respond was Phil Wilkins,  an Oracle ACE Associate and a senior consultant at Capgemini specializing in iPaaS. Among the list of topics Phil sent is the title you see above.

The panel for this program, which includes Phil, of course, tackles that question, discusses whether monolithic applications are really an anti-pattern, and also covers polyglot microservices, governance, and other issues. So, yeah, you really should listen.

This program is ArchBeat podcast #343. It was recorded at 12:30pm EDT on Tuesday  August 1, 2017. 

Click here to listenClick here to listen The Panelists

(In alphabetical order)

Chris Richardson

Chris Richardson
Founder/CEO, Eventuate, Inc., Java Champion

Boris Scholl

Boris Scholl
Vice President, Product Development, Oracle Cloud

Luis Weir

Luis Weir
Oracle ACE Director; Chief Architect, Capgemini UK PLC

Phill Wilkins

Phil Wilkins
Oracle ACE Associate; Senior Consultant, Capgemini

  Additional Resources Coming Soon

In the next ArchBeat podcast Oracle ACE Leon Smiers of Capgemini, Matt Hornung from Fishbowl Solutions, and Martin Deh, a member of the Oracle Intelligent Bots Cloud Service (IBCS) team, discuss first steps and lessons learned in chatbot development. (Coming in Sept)

ROLI Harmonizes Its Global Business with NetSuite OneWorld

Oracle Press Releases - Wed, 2017-08-16 08:00
Press Release
ROLI Harmonizes Its Global Business with NetSuite OneWorld Music and Technology Innovator Positioned for Accelerated Growth with Agility, Scalability of Cloud ERP

London—Aug 16, 2017

Oracle NetSuite, one of the world’s leading providers of cloud-based financials / ERP, HR, Professional Services Automation (PSA) and omnichannel commerce software suites, today announced that ROLI, a music technology innovator and maker of the award-winning Seaboard instrument, has implemented NetSuite OneWorld to manage critical business processes including financials, inventory management, order management, CRM, multi-currency management for the British pound, Euro and US dollar, and multi-subsidiary management for three subsidiaries in the UK and two in the US. As a result of its implementation of NetSuite OneWorld in September 2016, ROLI is better positioned to take advantage of rapid sales growth as innovative products like the Seaboard Block and Lightpad Block become more popular to music-makers.

Founded in 2009 in London, ROLI has revolutionized the world of musical instruments. Its newest product, Seaboard Block, is the most portable and versatile model of the multi-award-winning Seaboard, a digital instrument that is an evolution of the piano keyboard. Seaboards replace the white and black keys of a piano with a pliable, touch-responsive surface that lets musicians control sound in far more ways than they can on acoustic or electronic instruments. Last year ROLI also launched BLOCKS, a modular music-making system that allows musicians to connect musical Blocks together and build their instrument as they go. As demand for its products took off, ROLI determined that it needed more comprehensive and professional business systems to meet the opportunities of its next phase of growth.

ROLI selected NetSuite OneWorld due to its 360-degree customer view, inventory management and cloud-based architecture. NetSuite OneWorld provides the flexibility, agility and scalability ROLI needed for continued growth and a real-time view of business performance.

“As a company, ROLI is focused on innovation, growth and delivering world-class experiences for its customers and music lovers everywhere,” said Mark Woodhams, Managing Director, EMEA for Oracle NetSuite. “NetSuite OneWorld is an ideal fit for those goals, as a flexible, scalable solution with global reach that can serve as the foundation to continue to build upon its success.”

NetSuite OneWorld supports 190 currencies, 20 languages, automated tax calculation and reporting in more than 100 countries; customer transactions in more than 200 countries; and enables businesses to streamline their mission-critical business processes. NetSuite OneWorld supports ROLI’s worldwide growth and innovation by providing:

  • Real-time global financial consolidation. NetSuite OneWorld gives ROLI real-time visibility across all its subsidiaries, with a single financial system of record.
  • Superior inventory management that enables ROLI to plan for how much inventory it needs, track the movement of goods, and meet customer demand much more quickly.
  • Centralized order management that meets and exceeds rising customer expectations for omnichannel fulfillment across multiple sales channels by eliminating manual bottlenecks, preventing errors and establishing a smooth flow from sales quote to order fulfillment ensuring timely invoicing and payment.
  • 360-degree view of its customers allowing the company to provide better customer support and service across telephone and email channels.
  • Breadth of functionality designed for modern businesses, enabling the company to streamline mission-critical business processes and improve operational efficiency.
  • A highly scalable system with the ability to quickly and easily add functionality as a business evolves.
  • Built-in business intelligence that provides real-time insights into key business performance indicators for a unified view of the organization, and delivers a single version of truth.
  • A flexible and agile platform that enables the company to customize NetSuite to meet its business requirements and to integrate with other third-party systems to meet its specific needs with NetSuite’s SuiteCloud Platform.
Contact Info
Christine Allen
Public Relations, Oracle NetSuite
About Oracle NetSuite

Oracle NetSuite pioneered the Cloud Computing revolution in 1998, establishing the world's first company dedicated to delivering business applications over the internet. Today, it 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 http://www.netsuite.com.

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

About Oracle

The Oracle Cloud offers complete SaaS application suites for ERP, HCM and CX, plus best-in-class database Platform as a Service (PaaS) and Infrastructure as a Service (IaaS) from data centers throughout the Americas, Europe and Asia. For more information about Oracle (NYSE:ORCL), please visit us at www.oracle.com.


Oracle and Java are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners.

Apex Plugin: Password Strength Estimator

Jeff Kemp - Tue, 2017-08-15 23:26

I needed a simple password strength prompt for users when they need to create or change their password on my website. After a bit of Googling I found the “Low-Budget Password Strength Estimator” which is supposedly used by Dropbox, so you know it’s good :)

This simple javascript library runs entirely within the client’s browser, and when presented with a candidate password, gives a score from 0 (very poor) to 4 (very good). It can also return extra feedback, including a warning message for poor passwords, as well as suggestions for making a password more secure.


So I’ve created a very simple Dynamic Action plugin (try the demo here) that allows you to add this functionality to any item on your page. You can specify a minimum length for the password, and can override the default messages for each score. You can also select whether or not the feedback warnings or suggestions are shown.


It seems to catch a lot of poor passwords, including ones comprising common words and names, and ones involving a simple sequence or repetition.



Obviously it’s only really useful for password entry fields; but don’t use it on your Login page!

Download from: https://github.com/jeffreykemp/jk64-plugin-passwordstrength

Filed under: APEX, Oracle Tagged: APEX, passwords, plug-ins

extproc, database characteset and server characterset

Tom Kyte - Tue, 2017-08-15 22:26
I am testing an external procedure on a shared database environment on a Linux cluster using LANG UTF8, all at When calling a C library using extproc from a database using AL32UTF8 the call works as expected. When calling a C library us...
Categories: DBA Blogs

The Oracle Cloud user experience

Tom Kyte - Tue, 2017-08-15 22:26
For passed 2 years, I had noticed the Oracle Cloud has been added many many services to the end users compare with AWS and Azure, that's great. But somehow, my experience to use the Oracle Cloud is not that great, I feel it is difficult to use in som...
Categories: DBA Blogs

Generate missing dates from a given date.

Tom Kyte - Tue, 2017-08-15 22:26
I have a table as below: CREATE TABLE FACT ( AS_OF_DATE DATE NOT NULL, F_TYPE varchar2(50) , F_VALUE NUMBER(23,10) ); With this data into it: INSERT INTO FACT (AS_OF_DATE, F_TYPE,F_VALUE) VALUES (TO_DATE('2017/03/31','yyyy/mm/dd'), 'A...
Categories: DBA Blogs

Opposite of INTERSECT in SQL

Tom Kyte - Tue, 2017-08-15 22:26
hi TOM, please tell me, what is the opposite for INTERSECT?
Categories: DBA Blogs

Display Chinese Character

Tom Kyte - Tue, 2017-08-15 22:26
I have a test db from the client that allows you to see Chinese characters if you copy and paste them, but if I run a insert query I see "?????". I have this configuration: NLS_CHARACTERSET WE8MSWIN1252 NLS_NCHAR_CHARACTERSET AL16UTF16 The old ...
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator