Feed aggregator

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.

Steps

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.

image

 

SNAGHTML2844af1

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

SNAGHTML284b19f

This is our current situation:

image

 

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.

image

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.

SNAGHTML2880164

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.

image

Scrolll down.

SNAGHTML28c5fb9

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

image

 

Save changes in function app

image

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.

image

 

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:

image

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

 

image

 

Click on create.

The function is created – including the template code:

 

image

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

image

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.

image

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.

image

 

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:

image

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

image

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

image

that indirectly triggers our former function.

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

image

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.)

 

image

 

Resources

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
Oracle
+61 414 101 583
suzanne.myerson@oracle.com
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.

Trademarks

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

1st Transaction of the day is always the slowest

Tom Kyte - Wed, 2017-08-30 10:06
Hi Masters, We use a screen for updating the underlying tables with certain values. And always the 1st transaction of the day is always the slowest, it takes 20 mins. And 2nd transaction onwards it completes in a minute or two. This being a bank, ...
Categories: DBA Blogs

Increase the column length Varchar

Tom Kyte - Wed, 2017-08-30 10:06
Hi Team, I have a table with approx 30 million records, where I need to modify the column length of 3 column from Varchar2(200) to Varchar2(400). My doubt is in case there if any insert is happening on the table at the moment I am altering the col...
Categories: DBA Blogs

Finding data which exist in one set but not the other.

Tom Kyte - Wed, 2017-08-30 10:06
In this example we find data that exists in one set but not the other. but why did I have to use CTE? (--x denote records expected in results) <code>With test1 (A,b,c) as ( SELECT 2001, 'abc', 'john' from dual union all-- SELECT 2008, 'ca...
Categories: DBA Blogs

oracle 12c Sharding

Tom Kyte - Wed, 2017-08-30 10:06
Hi, I need oracle 12c sharding detail. deployment steps . My target is to using 12c sharding keep each partitioned data into seperate shard-node. ( like oracle range partition where each rang/partitioned can b stored in separate tablespace...
Categories: DBA Blogs

Loading more than 45 columns into a table using wizard - Oracle apex 5.0.4

Tom Kyte - Wed, 2017-08-30 10:06
I was wondering if there's any workaround for uploading data into the tables using the apex wizard when there are more than 45 columns. I am using Apex 5.0.4, Oracle 12 C database. I was going through the documentation where it lists that number of c...
Categories: DBA Blogs

NVL - invalid number

Tom Kyte - Wed, 2017-08-30 10:06
Hi Tom, Can you explain why NVL has to process expr2 when expr1 is not null? I see the error is not occuring when used in WHERE condition. Error:- UPDATE mytable SET number_col = nvl(1234,'dummy') where number_col is null or select...
Categories: DBA Blogs

Show error about 'ORA-04043: object dba_data_files does not exist' on my Oracle DataGuard 11.2.0.1.0 physical standby when query 'desc dba_data_files' ??

Tom Kyte - Wed, 2017-08-30 10:06
Hi, When i query description of table 'dba_data_files' and 'dba_temp_files' with SQL command 'desc dba_data_files' and 'desc dba_temp_files' on Oracle DataGuard 11.2.0.1.0 physical standby,there has an error,content as follows, <code> SYS@standby>...
Categories: DBA Blogs

Perfomance Tuning

Tom Kyte - Wed, 2017-08-30 10:06
Hi Team/Steven. We have one table"A" with 100000 records based on "A" Table we have sequence id we are using that sequence id and fetching two more tables like insert into gtt_table select * from b join c where B.id=c.id and b.seq_id=rec.seq_id; ...
Categories: DBA Blogs

get_tab2.sql - Free Tool to show Privileges on an Object Updated

Pete Finnigan - Wed, 2017-08-30 10:06
I have a core set of PL/SQL scripts that I use when conducting Oracle security work on customer sites. Most of these are available on this website for many years. One of these is my script get_tab2.sql which shows grants....[Read More]

Posted by Pete On 30/08/17 At 12:11 PM

Categories: Security Blogs

ADF Client Side Validation with JavaScript

Andrejus Baranovski - Wed, 2017-08-30 09:25
In my previous post I explained how to use JS client side formatter for ADF Faces input components - ADF Goes Client Side - UI Performance Boost with JavaScript. The same principle can be applied for client side validation. Most likely you are not going to implement complex validation rules on the client side, but for simple checks - it will be perfect. There will be no roundtrip to the server and this will allow to improve user experience.

Client side validation check runs instantly when value is changed and there is no need to set Auto Submit = true to send value to the server. This rule checks value to be in certain range, similar simple checks can be implemented on client side (I'm sure you will find similar rules in your project):


If value is in range, client side formatter is applied as expected:


Custom JSF converter is registered in faces-config.xml and can be added to the input field either manually or dropped through the wizard:


Converter is based on ID, which is defined in faces-config.xml:


Definition in faces-config.xml:


Customer converter class defines range values, these properties will be consumed in JS logic:


Range check is done in JS. If validation fails, we display JSF error message. All happens on client side, without request to the server:


Download sample application with client side validation logic - ADFFormattingApp_v2.zip.

Pages

Subscribe to Oracle FAQ aggregator