Feed aggregator

Emails That I Do Not Like to Receive

Joel Kallman - Fri, 2017-09-01 09:07
There have been numerous articles and blog posts about how to properly write an email, or how to properly ask a technical question. These seem to be rarely read or they are simply misunderstood.  So let me tell you about the types of emails I receive with seemingly greater frequency, and which I completely abhor.

Message Body: +Joel

What they're saying:  Rather than provide a clear and succinct explanation why I'm including you in this email thread, it's my expectation that you will read the 15 messages and replies below and discern the issue being discussed.  You are to also guess why I'm including you in this thread, and if there is an action item for you in the message below, it's expected that you will find it and take action immediately.

Sentiment implied:  My time is more important than yours.

Message Body: +[someone I don't know]

What they're saying:  Rather than provide a clear and succinct explanation why I'm including this new person in this email thread, it's my expectation that they will read the 15 messages and replies below and discern the issue being discussed.  They are to also guess why I'm including them in this thread, and if there is an action item for them in the message below, it's expected that they will find it and take action immediately.  Additionally, I am choosing to subject everyone else to a barrage of followup emails in the near future, as this new recipient will surely reply all, and ask numerous questions about this topic and why they were included on the email in the first place.

Sentiment implied:  My time is more important than the person's whom I've added to this email thread.  And everyone else's, for that matter.

Message Body: Joel, since [one member of your team] is on vacation, can you please help with the issue below?

What they're saying:  It's possible that you don't have any context in the long-running issue which is discussed in the 15 messages and replies below.  I was too busy to provide a succinct explanation or even ask if you're familiar with the issues below, so can you please read all of the messages below and guess at what further information may be required?

Sentiment implied:  My time is more important than yours.

Any time I receive emails like this in the future, I'll respond back to the authors with a link to this succinct and lucid blog post.  Maybe I'll even include an explanation why I'm sending the link!

Rapid and free cloud deployment of Node applications and Docker containers with Now by ZEIT

Amis Blog - Fri, 2017-09-01 03:10

I was tipped off about this now service from ZEIT: https://zeit.co . A cloud service with free tier that allows command line deployment of a simple static website, any Node application or any Docker container to a cloud environment where the application is publicly accessible. Depending on resources consumed and the number of applications required, you may need to upgrade to higher service tiers (starting at $15/month). Note: for personal research and small team development, the free (or OSS) tier will probably suffice.

I decided to give it a spin.


1. Download now command line tool – in my case for Windows – https://zeit.co/download 

2. Install command line tool


3. Open the command line and login to now

now login


This will prompt you for an email address, trigger an email sent to that address and wait for you to click on the link in that email to confirm your human nature and email identity.

4. Navigate to a directory that contains a Node application (or a Docker build file + resources or a simple static web site); the now website provides samples (https://zeit.co/docs/examples/json-api) and of course any Node application will do.

A quick and dirty new Express/Node application:






5. Deploy the application:



You will get a unique URL for this deployment of the application. Note: your code will be launched into a 64-bit Node.js enviroment (the latest release of Node) running on Alpine Linux.

Deployment is not super fast – I experienced 30 secs to 4 minutes.

6. Using the URL – we can access the ‘dashboard’ for the application:


Both the log files:


and the sources are available:


And of course the application itself can be accessed, once deployment is complete:


7. If you make changes to the sources of the application


and want to redeploy, you simply execute again:


This results in a new unique URL – for this new deployment.


The previous deployment status available at its original URL. Presumably, now considers the application deployments similar to serverless functions and only spins them up when there is a demand. Old deployments will soon run out of steam – most of the time – and only consume storage after having gone to sleep. Having older deployments which are not active costs you nothing. You can actively remove those old deployments with now remove [url of deployment]. 




We can specify custom actions to be performed for installation or starting the Node application through instructions in the package.json file (build-now instead of build and start-now instead of start)

At runtime, the only writable location will be /tmp. Inside this directory, temporary data can be saved. But please note that it will be removed each time each deployment goes to sleep and wakes up again. In turn, it is not safe to be used as a file-based database.

Now can deploy code directly from Git(Hub, BitBucket and GitLab): using now <username>/<repository>

During deployment with now, we can pass environment variables for the runtime execution environment of the application; this can be done on the command line or through a local now.json configuration file.

Scaling can be configured for the application – specifying the (max and min) number of concurrent instances that can be running to handle the load; scaling beyond three instances (and fixed scaling) can only be done on the paid plans.

If you want to, you can now continue to buy a domain name for a friendly URL and associate that with the application you have just deployed. One of the ways for ZEIT to make money I guess is through this low threshold domain name name selling.



Five Minute Guide to now – https://zeit.co/docs/getting-started/five-minute-guide-to-now 

Real time deployments with Zeit’s Now   https://olegkorol.de/2017/03/12/Real-time-deployments-with-now/ 


Plans & Pricing




Dashboard/Activity Stream


The post Rapid and free cloud deployment of Node applications and Docker containers with Now by ZEIT appeared first on AMIS Oracle and Java Blog.

Oracle Joins Hyperledger and my Blockchain Session at Oracle OpenWorld

David Haimes - Fri, 2017-09-01 00:39

Blockchain ImageAlthough it was announced in an Oracle blog post a few weeks ago, there was an announcement from Hyperledger today which has been picked up by coindesk and a lot of other news outlets.

I have been working on/with Blockchain or Disitributed Ledger Techncology(DLT)* for some time, as have many, many people inside Oracle.  I have also been talking to A LOT of our customers, because when a technology has the possibility to make huge transformations to the way we do business, collaboration is critical.  I love that I am able to not only be part of the conversation on how the technology evolves, but also how enterprises will be able to benefit from it and how it will impact existing applications and business processes in the short, medium and long term.

I will share some of my work in my session at Oracle OpenWorld in a few weeks, so if you are coming to San Francisco for that, hopefully you’ll join me at the below session (register now in case it gets fully booked)

My OOW17 Blockchain Session

There are plenty of other sessions discussing Blockchain, watch this space for a comprehensive list.


*The controversy on what is a Blockchain and what is DLT merits a blog post all of its own.

Categories: APPS Blogs

TABLE operator on local plsql type

Tom Kyte - Thu, 2017-08-31 22:46
Hello AskTom Team, I am using TABLE operator on locally defined nested table type. As per my understanding of 12c plsql manual, it is supported I am doing following: - Defined a type in package specification "type t1_tblType is TABLE of ...
Categories: DBA Blogs

Table Statistics - Can massive updates on table leave stats stale for subsequent Selects ?

Tom Kyte - Thu, 2017-08-31 22:46
[Scenario] A table, in an OLTP environment, has ~40 columns and ~1,00,000 rows. One of the column stores timestamp values, like last maintenance date time for entity represented by that row. This column is not used in access or filter predicates ....
Categories: DBA Blogs

Oracle user unable to access network locations or permission issues?

Tom Kyte - Thu, 2017-08-31 22:46
Hi TOM, I am working on writing a package that has a requirement to create hyperlinks for photos if they exists on the server but have encountered an issue. Unsure if its the oracle user unable to access network locations (i.e. files shared on a d...
Categories: DBA Blogs

Importance Of Executive Dashboards For Insurance Companies

Nilesh Jethwa - Thu, 2017-08-31 12:38

Were there times when you became so handicapped because data were not readily available? You demanded for reports for your perusal but the teams were still scrambling for data from files.

This is not happening only to you. It is a common flaw among insurance company managers.

What is being sacrificed when this happens?

  • Companies incur revenue losses.
  • Customer trust erodes.
  • Management loses times in meetings without the availability of concrete data.
  • Tension builds up between the higher management and low-ranking teams.
  • Current problems are not resolved and allowed to pester executives as days go by.
  • Moods flare up.

This has to stop? The solution to avoid such problems from occurring again is to build a KPI executive dashboard. With a KPI dashboard incorporated to your system, you will have access to real-time performance data.

Accessibility to data is always within your fingertips. With a few clicks, important data are all flashed on the screen for your immediate and timely decision-making.

Benefits for the Insurance Industry

Performance dashboards can benefit insurance companies in several ways. Strict regulatory guidelines control many industries such as the insurance sector and the financial services sector.

In these sectors, two things are prominent:

  • Higher need for Innovative customer support and service.
  • High exposure to risk

It is therefore important for these sectors to have accurate and up-to-date information for quick detection of potential problems and to seize new market opportunities. Key Performance Indicator or KPI metrics, presented through clear graphic images, can help in determining the right steps for managers and executives to take to quickly achieve their goals.

Use Surrogate Key in Data Warehouse

Dylan's BI Notes - Thu, 2017-08-31 07:46
Using surrogate key is part of dimensional modeling technique for populating a data warehouse using a relational database. The original idea was to generate the sequence generated IDs and use them in between the fact and dimension table, so we can avoid using the concatenated string or using composite key to join.  Also, due to […]
Categories: BI & Warehousing

Oracle Expands IoT Cloud Portfolio, Enabling Customers to Accelerate Intelligence and ROI from Connected Assets

Oracle Press Releases - Thu, 2017-08-31 07:02
Press Release
Oracle Expands IoT Cloud Portfolio, Enabling Customers to Accelerate Intelligence and ROI from Connected Assets Introduces Digital Twin, Digital Thread, and artificial intelligence and machine learning capabilities

Redwood Shores, Calif.—Aug 31, 2017

Oracle today announced significant enhancements to the Oracle Internet of Things (IoT) Cloud. The offering now features built-in artificial intelligence (AI) and machine learning that powers Digital Twin and Digital Thread capabilities. As such, customers and partners can quickly gain operation-wide visibility and leverage predictive insights from connected assets. These insights can increase deployment times, reduce costs, improve business outcomes, and accelerate new market opportunities. Combining the power of Oracle IoT Cloud and enterprise applications, Oracle also introduced new industry solutions for digital field service, smart connected factories, and digital fleet management.

“IoT holds the potential to transform today’s siloed operations into a modern, interconnected, digital set of workflows with real-time visibility and responsiveness,” said Bhagat Nainani, group vice president, IoT Applications at Oracle. “Oracle continues to push the boundaries of IoT to help our customers significantly simplify their IoT deployments. By receiving real-time data streams enhanced with predictive insights, they can reach new levels of intelligence and a much quicker realization of ROI.”

Today’s expansion follows the recent introduction of new Oracle IoT Cloud Applications for asset monitoring, connected workforce, fleet monitoring, and production monitoring. Also, in the past six months alone, Oracle has more than tripled its IoT application ecosystem of device and systems integration partners. Oracle IoT Cloud is offered both as software-as-a-service (SaaS) applications, as well as platform-as-a-service (PaaS) offerings, enabling a high degree of adaptability for even the most demanding implementations.

“Hitachi Consulting is constantly looking for industry leaders like Oracle to help clients and prospects harness the power of data and IoT to optimize operational and financial performance, outpace their competition and solve significant business problems,” said Garth Carter, vice president North America Sales, Hitachi Consulting. “Our longstanding, strategic relationship with Oracle delivers industrial IoT solutions to digitize the physical world for manufacturing, energy, and transportation. In particular, Hitachi is leveraging Oracle IoT Applications—asset monitoring and production monitoring—that are uniquely engineered to meet specific industry and functional needs. These applications have a depth of OT, IT and IoT functionality that no competitor can match.”

New capabilities introduced today include:

  • Digital Twin for Supply Chain Management
    Digital Twin is a digital representation of a physical asset or equipment that enhances traditional analytics approaches. The object model includes multi-faceted views into current, historical, and predictive data, as well as operational and behavioral dimensions of that asset. This enables remote users to not only monitor the health of that asset to prevent failures before they occur, but also to run simulations of “what-if” scenarios in the context of the business processes. With Digital Twin, organizations have a new operational paradigm to interact with the physical world, allowing lower operational and capital expenditures, minimizing downtime, and optimizing asset performance.
  • Digital Thread for Supply Chain Management
    Supply Chain practitioners have spent millions of dollars in implementing SCM and ERP systems, but most often, data is manually fed into these systems. Digital Thread is a connected business process framework that leverages IoT and creates a “system of systems” by connecting traditionally siloed elements in real-time throughout the digital supply chain. By providing an end-to-end view of an asset throughout the entire manufacturing lifecycle, Digital Thread seamlessly bridges the entire supply chain process—from product design and order fulfillment, to manufacturing and product life cycle management, to warehousing and transportation, to logistics and procurement.
  • Artificial Intelligence and Machine Learning
    Built-in AI and machine learning features are now fully integrated across Oracle’s IoT solutions portfolio. These technologies leverage machine data in the context of business data from applications, such as manufacturing, maintenance, service, and logistics. The built-in operational analytics help detect anomalies, predict equipment failures, and recommend the best course of action. They also provide the intelligence needed to evolve capabilities to increase effectiveness and experiences of applications.
  • Industry Solutions Built on IoT Cloud Applications
    Oracle IoT industry solutions help customers reimagine and innovate business solutions for the connected, intelligent, context-aware, digital enterprise. New solutions introduced today include:
    • Digital Field Service: Showcases intelligent remote monitoring, failure prediction, over-the-air repair, and dynamic technician dispatch. The solution features IoT Asset Monitoring Cloud, CX Service Cloud, CX Engagement Cloud, and CX Field Service Cloud, plus the use of augmented reality (AR) for guided equipment repair.
    • Smart Connected Factory: Demonstrates how incident detection, root cause analysis, and smart resolution are performed within minutes in a connected factory. The solution features IoT Production Monitoring Cloud, SCM Cloud and ERP Cloud, and the use of virtual reality (VR) to navigate the manufacturing floor. It can also be used for remote worker training.
    • Digital Fleet Management: Showcases real-time shipment tracking, risk management, and logistics synchronization. The solution features IoT Fleet Management Cloud and Oracle Logistics Cloud.
Additional Information

For additional information, visit Oracle Cloud and connect with Oracle SCM Cloud and Oracle IoT Cloud Service on Twitter.

Contact Info
Vanessa Johnson
Kristin Reeves
Blanc & Otus
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 oracle.com.


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

Talk to a Press Contact

Vanessa Johnson

  • +1.650.607.1692

Kristin Reeves

  • +1.415.856.5146

Oracle and Mitsubishi Electric Collaborate to Develop Internet of Things Platform for Smart Manufacturing

Oracle Press Releases - Thu, 2017-08-31 06:55
Press Release
Oracle and Mitsubishi Electric Collaborate to Develop Internet of Things Platform for Smart Manufacturing Using Oracle Cloud, New FA-IT Open Platform Enables Rapid Collection, Analysis, and Utilization of Production Site Data

Redwood Shores, Calif.—Aug 31, 2017

Oracle today announced its collaboration with Mitsubishi Electric Corporation to develop an Internet of Things (IoT) platform for smart manufacturing. With Oracle Cloud, Mitsubishi Electric developed its new FA-IT Open Platform for factory automation. Using edge computing between devices and business applications, the new platform enables the rapid collection, analysis, and utilization of data at production site.

With organizations rapidly adopting Industry 4.0, manufacturers are increasingly seeking to optimize their total manufacturing processes by using IoT to collect data from all equipment in factories for visualization and analysis. Developing such IoT systems from scratch is an enormous task requiring that data be collected and modeled from a wide variety of production equipment, including existing equipment, for analytical purposes.

With FA-IT Open Platform, vendors can create manufacturing applications for operation on the platform, including connecting the platform to industrial networks to collect data from diverse devices and production equipment. The cloud-connected platform can be used to link manufacturing sites with cloud vendors' own cloud-supported manufacturing-optimization services for supply chains, administration of multiple factories worldwide, and other applications.

FA-IT Open Platform leverages Oracle Database Cloud, Oracle Java Cloud, Oracle BI Cloud, Oracle IoT Cloud, Oracle IoT Production Monitoring Cloud, Oracle SOA Cloud, and Oracle Infrastructure as a Service. Information received in real time from machine tools and production terminals is received by Oracle IoT Cloud, enabling efficient real time processing with the extensible infrastructure. Mitsubishi Electric utilizes machine learning of Oracle Database Cloud, the reporting function of Oracle BI Cloud, and the cost-effective Oracle Cloud Infrastructure in the analysis of accumulated Big Data, contributing to further development of solutions in the factory automation area for customers and to smart manufacturing industry.

Supporting Quote: “Mitsubishi Electric develops advanced technologies and products for rapidly emerging factory automation,” said Toshiya Takahashi, corporate executive group senior vice president, factory automation system, Mitsubishi Electric Corporation. “Our e-F@ctory concept for integrated automation reduces the total cost of developing, producing and maintaining products. Mitsubishi Electric’s new FA-IT Open Platform is based on edge computing to accelerate IoT utilization for smart manufacturing. By adding Oracle Cloud services to this platform, we believe that it will be possible to visualize factories and build an application development environment. In order to provide the platform to customers early, we will also work with partner companies, including IT companies, to develop applications utilizing the platform."

Contact Info
Nicole Maloney
Sarah Fraser
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.

Talk to a Press Contact

Nicole Maloney

  • +1.415.235.4033

Sarah Fraser

  • +1650.743.0660

Bulk Insert Takes time

Tom Kyte - Thu, 2017-08-31 04:26
Hi Tom, I am facing issue with insert and show the conflicts.its taking to much time for 2000 records its taking time 25 mins we have to implement millions records.can you please help on this. please find the below procedure. CREATE OR REPLACE...
Categories: DBA Blogs

concatenate dates to get data in a specific date\time range

Tom Kyte - Thu, 2017-08-31 04:26
OK - I have been asked to write a report that captures activity between 17:00 and 08:00 the next day. So when the query will run the next day we need to look back to sysdate -1 || 17:00 I was thinking to use Select * from table where date...
Categories: DBA Blogs

Serverless computing with Azure Functions – interaction with Event Hub

Amis Blog - Thu, 2017-08-31 01:16

In a previous article, I described my first steps with Azure Functions – one of the implementation mechanisms for serverless computing: Serverless Computing – Function as a Service (FaaS) – with Azure Functions – first small steps with a Node/JavaScript function. Functions can be triggered in many ways – by HTTP requests, the clock (scheduled), by database modifications and by events. In this article, I will look at a Function that is triggered by an event on the Azure Event Hub. I will also show how a function (triggered by an HTTP request) can write to Event Hub.

Functions can have triggers and input bindings. The first is the cause of the function to run – which can have a payload. An input binding is a declarative definition of data that the function has (read) access to during execution. Function also can have Output bindings – for each of the channels to which they write results.


The first steps: arrange Azure account, create Event Hubs namespace – as the context in which to create individual event hubs (the latter are comparable to Kafka topics)

On the Event Hub side of the world:

  • Create Event Hub
  • Create Shared Access Policy
  • Get Connection String URL for the shared access policy

In Azure Functions –

  • At the function app level: Create Connection String for Connection String URL copied from shared access policy
  • Create a function based on the template Data Processing/JavaScript/EventHub Trigger – a JavaScript function triggered by a message on the indicated Event Hub in the Event Hub namespace addressed through the connection string; save and (test) run the function (this will publish an event to the event hub)
  • Optionally: create a second function, for example triggered by an HTTP Request, and have it write to an output binding to the Event Hub; in that case, an HTTP request to the second function will indirectly – through Event Hub – cause the first function to be executed


In Event Hub Namespace

Create Event Hub GreetingEvents. Set the name and accept all defaults. Press Create.




Once the Event Hub creation is complete, we can inspect the details – such as 1 Consumer Group, 2 Partitions and 1 Day message retention:


This is our current situation:



Now return to the overview and click on the link Connection Strings. We need the to create a connection from Azure Functions app to Event Hub Namespace using the URL for the Shared Policy we want to leverage for that connection.


Click on Connection Strings to bring up a list of Shared Policies. Click on the Shared Policy to use for accessing the Event Hub namespace from Azure Functions.


Click the copy button to copy the RootManageSharedAccessKey connection string to the clipboard.

In Azure Function App

In order for the Function to access the Event Hub [Namespace], the connection string to the Event Hub [Namespace[ needs to be configured as app setting in the function app [context in which the Function to be triggered by Event Hub is created]. Note: that is the value in the clipboard.


Scrolll down.


Create Connection String to Event Hub Namespace using the value in the clipboard



Save changes in function app


At this point, a link is established between the function app (context) and the Event Hub Namespace. Any function in the app can link to any event hub in the namespace.



Create Function to be Triggered by Event

With the connection string in place, we can create a function that is executed when an event is published on Event Hub greetingevents. That is done like this:


Type the name of the function, click on the link new and select event hub greetingevents to associate the function with:




Click on create.

The function is created – including the template code:



The configuration of the function is defined in the file function.json. Its contents can be inspected and edited:


The value of connection is a reference to an APP Setting that has been created when the function was created, based on the connection string to Event Hub Namespace.

Click on Save and Run. A test event is published to the Event Hub greetingevents. In the log window – we can see the function reacting to that event. So we have lift off for our function – it is triggered by an event (and therefore presumably by all events) on the Event Hub and processes these events according to the (limited) logic it currently contains.


The set up looks like this:image



Publish to Event Hub from Azure Function


To make things a little bit more interesting we will make the Azure Function that was introduced in a previous article for handling HTTP Request “events” also produce output to the Event Hub greetingevents. This means that any HTTP request sent to function HttpTriggerJS1 leads to an event published to Event Hub greetingevents and in turn to function EventHubTrigger-GreetingEvents being triggered.



To add this additional output flow to the function, first open the Integration tab for the function and create a new Output Binding, of type Azure Event Hubs. Select the connection string and the target Event Hub – greetingevents. Define the name of the context parameter that provides the value to be published to the Event Hub – outputEventHubMessage:


We now need to modify the code of the function, to actually set the value of this context parameter called outputEventHubMessage:


At this point, we can test the function – and see how it sends the event


that indirectly triggers our former function.

When the HTTP Request is sent to the function HttpTriggerJS1 from Postman for example


The function returns it response and also publishes the event. We can tell, because in the logging for function EventHubTrigger-GreetingEvents we see the name sent as parameter to the HttpTriggerJS1 function.

(Note: In this receiving function, I have added the line the red to see the contents of the event message.)





Azure Function – Event Hub binding – https://docs.microsoft.com/en-us/azure/azure-functions/functions-bindings-event-hubs 

Azure Documentation on Configuring App Settings – https://docs.microsoft.com/en-us/azure/azure-functions/functions-how-to-use-azure-function-app-settings#settings 

Azure Event Hubs Overview – https://docs.microsoft.com/en-us/azure/event-hubs/event-hubs-what-is-event-hubs 

Azure Functions Triggers and Binding Concepts – https://docs.microsoft.com/en-us/azure/azure-functions/functions-triggers-bindings

The post Serverless computing with Azure Functions – interaction with Event Hub appeared first on AMIS Oracle and Java Blog.

Luxury Fashion Goods Wholesaler Scales its Hong Kong Business with NetSuite OneWorld

Oracle Press Releases - Wed, 2017-08-30 23:00
Press Release
Luxury Fashion Goods Wholesaler Scales its Hong Kong Business with NetSuite OneWorld Lfplaza Grows from a Startup to a $300 Million HKD Business Across Southeast Asia in Just Five Years

Hong Kong—Aug 31, 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 Lfplaza Group, a wholesale distributor of luxury and designer fashion clothing, bags, shoes and accessories, has scaled its business dramatically since deploying NetSuite OneWorld shortly after its launch in 2012. Based in Hong Kong, the company relies on NetSuite for financials, inventory management, CRM and marketing, as well as multi-subsidiary and multi-currency management for the Hong Kong, Australian and U.S. dollars, Chinese renminbi, British pound, Japanese yen, New Taiwan dollar and the Euro. NetSuite’s unified cloud business management platform has given Lfplaza scalability and agility as its business has soared from the startup phase to $300 million HKD (about $38.4 million USD) in revenue in just five years.

Starting out, Lfplaza had in place an entry-level accounting system from a Chinese software vendor. After evaluating several competing solutions, Lfplaza quickly settled on NetSuite OneWorld as an ideal fit for its objectives of an integrated system that could support rapid growth. NetSuite OneWorld today powers end-to-end processes for Lfplaza’s sales of goods from more than 100 brands to a network of over 600 wholesale clients and about 40 regional multi-brand boutiques across Hong Kong, mainland China, Taiwan, Japan, South Korea, Singapore, Malaysia, Indonesia, Thailand and Vietnam.

“NetSuite forms the core backbone on which we’ve rapidly grown our business,” said Jack Tsao, Lfplaza CEO. “We’ve been able to scale dramatically without adding too many staff. We’re very glad we started early with NetSuite as it gave us room to grow.”

As a cloud-based system, NetSuite enables Lfplaza to avoid the high capital expenditures of servers and software needed with traditional on-premise business systems. Ease of use, efficient workflows and high visibility into mission-critical data have allowed the 100+-person company to minimise administrative and operational costs and instead focus new hires on revenue-driving sales and marketing activities. Easy access to NetSuite across Lfplaza’s 10 wholesale stores, its head office in Hong Kong and three subsidiaries (Hong Kong, China and Macau) enables the company to ensure staff work from the same set of timely, reliable data.

“The advantages with NetSuite are felt across the business,” Tsao said. “We would be hiring more staff if we didn’t have NetSuite. It’s definitely been a very worthwhile investment.”

Implementation and optimisation by NetSuite Solution Provider Fern Limited, in Hong Kong, has helped Lfplaza make the most of its NetSuite OneWorld solution as usage evolved from inventory to accounting and CRM. Benefits that Lfplaza has realised with NetSuite include:

  • Real-time inventory management. NetSuite gives Lfplaza real-time visibility into tens of thousands of SKUs, particularly important as new products are constantly added. It also helps Lfplaza account for subtle variations in products, such as shiny vs. matte leather for the same handbag.
  • Business reporting. Lfplaza makes extensive use of NetSuite’s reporting and analytics capabilities to track revenue and product sales by brand, type of goods, gender, regions and other dimensions. Insights derived are vital to Lfplaza’s ability to adapt the business and product lineup as needed.
  • Agility in a fast-paced market. NetSuite has helped Lfplaza achieve business agility, better manage brand and customer partnerships, and optimise inventory and pricing in the fast-paced and rapidly changing luxury fashion market.
  • Multi-currency, multi-subsidiary management. NetSuite OneWorld lets Lfplaza easily transact in currencies including Hong Kong, Australian and U.S. dollars, Chinese renminbi, British pound, Japanese yen, New Taiwan dollar and the Euro, and manage three subsidiaries with efficient financial consolidation.
  • CRM capabilities. NetSuite CRM gives Lfplaza sales staff a unified record of all customer account, interaction and order history information to help drive sales and provide a superior customer experience.

“The fashion inventory moves very fast, with increasing velocity and sophistication every year,” Tsao said. “With NetSuite OneWorld, it’s very easy to adapt, customise processes and stay current, exploring all the business channels and marketing opportunities out there so we can continue to scale.”

The case study put the workforce at 120 but during the interview the CEO said it was 60. Not sure which is correct.

Contact Info
Suzanne Myerson
+61 414 101 583
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.hk/portal/hk/home.shtml

Follow 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 oracle.com.


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

Talk to a Press Contact

Suzanne Myerson

  • +61 414 101 583

Announcing the PeopleSoft Innovator Awards

PeopleSoft Technology Blog - Wed, 2017-08-30 17:59

We have been getting some great feedback from customers and partners on our major PeopleSoft endeavors.  Customers are doing some progressive and innovative things and realizing  benefits from the latest features and advances in PeopleTools, Enterprise Components, and PeopleSoft applications.

It’s rewarding to hear such feedback, and to talk with customers that are seeing positive results with today’s PeopleSoft.  We want to recognize your achievements, so we've created the brand new PeopleSoft Innovator Awards.

What are you doing with today’s powerful, modern, intuitive PeopleSoft?  You are a PeopleSoft Innovator if you are...

  • Deploying the Fluid UI
  • Using Simplified Analytics
  • Using Elasticsearch
  • Deploying new features through Selective Adoption
  • Rolling out new products
  • Eliminating customizations
  • Using personalization and configuration tools
  • Running PeopleSoft on the Oracle Cloud
  • Using Cloud Manager
  • Using PeopleSoft Update Manager analytics
  • Changing your approach to testing
  • And many, many more!

Nominate yourself or someone you know today!  Partners, nominate your customers.  You’ve earned it, and the rest of the PeopleSoft community wants to hear what you’ve done.  PeopleSoft Innovators will be announced at Oracle OpenWorld, invited to a special PeopleSoft Innovators event at OpenWorld, receive an award, and more.

This is a pretty incredible time to be a PeopleSoft customer.  We want to hear your story.  Take a moment to share it today!

Dashboards For Banking

Nilesh Jethwa - Wed, 2017-08-30 12:39

The integration of huge financial data, time sensitivity and security restrictions is an extremely complex process. In this regard, the banking sector has found dashboards to be useful.

There’s no doubt your own institution grapples with humungous sets of data. Because of the large volumes of data and the manual treatment given to it, it is highly likely that you cannot make sense of these data in a way that you can fully take advantage of them.

Given that as the case, a performance metrics dashboard can fill the gap. By making available data easily analyzable and findings utilizable, you can gain insights of how well your processes are doing. Dashboard snap shots can provide a lot of information helpful in decision-making.

What can a banking dashboard can provide?

Here is a quick look on what information a banking dashboard can provide:

  • A dashboard can give you information on the performance of your new products and effectiveness of your pricing policies.
  • With it, you can also gain insights on performance problems. In this regard, you can make use of the dashboard’s drill-down performance.
  • The dashboard will enable you to view of real-time operational information. Specifically, the dashboard will give you information on credit risk, operation risk, sales team performance, and service utilization.
  • With this tool, you can do analysis on profitability and perform margin analysis.
  • The dashboard will allow you to do away with periodic reporting. This is because the tool will give you information on a day-to-day basis.
  • Lastly, this tool can give you vital information of the past and present performance of your institution. What’s more is that it will give you possible scenarios for your bank in the future.

Learn more at http://www.infocaptor.com/dashboard/performance-metrics-and-reporting-dashboards-for-banking

Google dashboard for lazy businessman

Nilesh Jethwa - Wed, 2017-08-30 12:37

Once you start your own business or startup, the very first thing that comes to mind is "How many visitors did my website receive?"

Google Analytics provides tons of metrics and it becomes quite a chore to keep up with all the dashboard pages and filter options. As a small biz owner myself, I went through a phase where I ended up spending significant amount of time checking out Google Analytics

To save time and mental energy on a daily routine task, I asked "What are the most basic metrics I need to measure from Google Analytics?"

The answer pretty much came down as a need to have "one page dashboard that displays various metrics".

Read more at http://www.infocaptor.com/dashboard/what-are-the-bare-minimum-traffic-metrics-that-i-can-track-easily

Video: Large Datasets and R? Use the Features of Oracle R Enterprise!

OTN TechBlog - Wed, 2017-08-30 12:31

"Working with large datasets in R can be a challenge," says Oracle ACE Associate Maarten Smeets. "Memory can be a limitation and also CPU processing power." In his third 2 Minute Tech Tip in 4 weeks, Maarten offers a quick but detailed look at some of the features of Oracle R Enterprise.

Additional Resources Maarten's Other Tech Tips


MKS Toolkit 10 Certified with EBS R12 on Windows

Steven Chan - Wed, 2017-08-30 11:40

MKS Toolkit 10 is now certified with Oracle E-Business Suite Release 12.1 and 12.2 on Microsoft Windows x64 (64-bit) as a release maintenance tool. The operating systems supported by MKS Toolkit 10 on this platform are Microsoft Windows 2008 R2 and 2012 R2.

Please review the documents below for all requirements to use MKS Toolkit 10 with Oracle E-Business Suite Release 12.1 and 12.2:

Related Articles


Categories: APPS Blogs

Create type

Tom Kyte - Wed, 2017-08-30 10:06
I want to create type using cmd but it can't cursor goes to next line please help how can i create type using cmd thanks in advance. Query to create type create or replace TYPE DT_ARR AS TABLE OF DATE;
Categories: DBA Blogs


Subscribe to Oracle FAQ aggregator