Search Tricks for Users of WCC running on Oracle Text Search

WebCenter Search

Search Tricks for Users of WCC running on Oracle Text Search

By: Brandon Prasnicki | Technical Architect

The WebCenter Content product (WCC) has been running on the powerful Oracle Text Search engine for quite some time. However, it is well known that WCC doesn’t always leverage all of the features that Oracle Text Search has to provide. While TekStream can help leverage many of the features via customizations, there are also a few that require no customization and can help make day-to-day activities more efficient right away. Here are two little-known, but out of the box search tricks that leverage the Oracle Text Search solution.

1 . Stemming

Stemming is the process of reducing inflected (or sometimes derived) words to their word stem, base or root form—generally a written word form. There are often times where it is unknown which variation of a word stem that a contributor might have used to tag content, and this is a great way to uncover those content items.

You can stem searches using the contains operator. To leverage this operator, simply prefix your search term with the ‘$’ (dollar sign character).

Try it!  Here are some fun examples:

$speak, expands to search for all documents that contain speak, speaks, spoke, and spoken.

$sing, expands to sang sung sing

Check in an item with a title of ‘sang’ and search for that document with a search term on the title field of ‘$sing’ and it will be returned!




2. Sounds Like

The Oracle Text Search index engine has the ability to use ‘Sounds like’ functionality. To do this use the soundex (!) function.

Here is a fun example:

First, check in an item with a Title of ‘Smith’. Then, do a search for that item with the text of ‘!Smyth’ or ‘!Smythe’. You can see screenshots of an example below.


Here you can see that a content item with a title of ‘Smith’ was returned when searching the title field with a ‘!Smyth’ value. This works for fulltext as well, since the fulltext search term uses the ‘contains’ operator.

Short cuts like these can improve your content searches and empower your business to quickly and efficiently find and utilize content in the system. Keep following the TekStream blog for more tips, tricks and short cuts!

For more information see:


Contact Brandon Prasnicki or TekStream about WebCenter Content Today.

We're here to help!


Accounts Payable Automation in the Cloud

Accounts Payable Automation

Accounts Payable Automation in the Cloud

By: Mariano Romano | Senior Developer

Accounts Payable (AP) has always been a crucial part of business, but as accounting becomes more and more complex or as it increases in volume, we are forced to upgrade our hardware and software. These issues can be easily solved when using an AP solution in the cloud.

What is AP Automation in the Cloud?

AP Automation in the cloud provides AP solutions that are hosted on the Internet. The solution can be combined with an on-premise EBS system or a cloud EBS system. When using an on-premise EBS system, you can create a Site-to Site VPN connection to your internal EBS system. This allows for your EBS system to remain in-house while your AP solution resides in the cloud.

Benefits of AP Automation in the Cloud

There are many benefits to providing your accounts payable solution in the cloud and for cloud solutions in general, including reduced support and maintenance costs and increased speed of upgrade deployments.

  1. No hardware to purchase or maintain. By having your AP solution in the cloud, you do not have to provision hardware for the solution. Additionally, as your needs grow, you will not have to purchase additional hardware to support the extra load.
  2. No need to perform software upgrades. Since it is hosted in the cloud, the provider will be responsible for implementing any updates at an OS level or application level. This also allows you to have the latest version running much sooner than having to go through weeks of testing before performing an upgrade.
  3. No need to support the OS. Since the hardware is hosted, you are not responsible for the OS on the hardware. This eliminates the need to have an OS expert to support your AP Solution hardware.
  4. No need to support security patches at an OS or application level. All security related patches are supported by the hosting partner.

Areas of Concern

There are also some areas of concern in using AP Automation in the Cloud.

  • Is my data safe in the cloud? Of course! Just because it is in the cloud doesn’t mean anyone can log in and access your data. AP Solutions offer many layers of security to ensure your data is protected at all times.
  • Will my data be backed up? Yes! Most cloud solutions offer multiple levels of backup and redundancies including offsite backups.

Regardless of the benefits or areas of concern, AP Automation in the Cloud is slowly becoming the future of AP systems. As more solutions are available in the Cloud, companies will become more comfortable with the architecture in general and will trust moving their own AP Systems to the Cloud as well.


Contact Mariano Romano about AP Automation in the Cloud Today!

We're here to help!


Oracle DoCS vs. OSN: Which One to Choose

Oracle Cloud

Oracle DoCS vs. OSN: Which One to Choose

By: Greg Becker | Technical Architect

With all of the recent releases and offerings from Oracle in the Cloud space, it’s easy to get confused when deciding which one(s) may be appropriate for your business. At the same time, it’s essential to understand the offerings, especially if you need to make important business decisions regarding which solutions and products to implement. Two of those recent offerings from Oracle are Documents Cloud Service (referred to as Oracle DoCS) and Oracle Social Network Cloud (referred to as OSN).

Oracle DoCS: Documents Cloud Service

Oracle Documents Cloud Service is an enterprise-level collaboration platform that is available in Oracle Cloud. It connects people and information. Built for the enterprise from the ground up, offering robust security and integration options, DoCS focuses on easy-to-use collaboration optimized for social and mobile use.


OSN: Oracle Social Network

Oracle Social Network enables people to have online conversations, share documents, start one-on-one chats for quick private exchanges, and build out rich user profiles to find the right people to connect with.


Differences of Intent Between DoCS and OSN

After reading Oracle’s introduction of both products, they sound very similar in nature; in fact, to some extent they are. The difference comes primarily in what each product is primarily used for and also what type of content it is based around. DoCS is primarily for files and conversations (discussions and annotations, real-time/online) based around various file types (contracts, presentations, etc.) and OSN is primarily for collaboration based around social objects (sales opportunities, talent profiles, incident reports, etc.).

Differences of Integration Capabilities

Another primary difference between the two products revolves around the software that each product integrates with. Oracle Social Network integrates with Oracle Sales Cloud, Oracle Human Capital Management Cloud, Oracle Enterprise Resource Planning Cloud, and Oracle Service Cloud. DoCS integrates with Oracle Process Cloud, Oracle Sites Cloud, SaaS, and on-premises applications and content management systems. There are also robust APIs for easy integration with PaaS, third-party systems using DOCS.

So…Should I choose Documents Cloud Service or Oracle Social Network?

Take a look at both products if you’re in the market for a cloud sharing and collaboration tool. If you’re looking for a product that revolves around social objects, Oracle Social Network might be the right one for you. If you’re looking to connect people and information across a wide range of business units within your organization, then DoCS may be the best solution to solve your business problem.

Check out the Oracle product pages for more information:

Documents Cloud Service:
Social Network Cloud:


Contact Greg Becker about Oracle DoCS or OCN Today!

We're here to help!

Press Release: TekStream Makes 2016 INC. 5000 List For Second Consecutive Year


Press Release: TekStream Makes 2016 INC. 5000 List For Second Consecutive Year

For the 2nd Time, Atlanta-based Technology Company Named One of the Fastest-growing Private Companies in America with Three-Year Sales Growth of 133%

Atlanta, GA (Oct 3, 2016) – Atlanta-based technology company, TekStream Solutions, is excited to announce that for the second time in a row, it has made the Inc. 5000 list of the fastest-growing private companies in America.  This prestigious recognition comes again just five years after Rob Jansen, Judd Robins, and Mark Gannon left major firms and pursued a dream of creating a strategic offering to provide enterprise technology software, services, solutions, and sourcing.  Now, they’re a part of an elite group that, over the years, has included companies such as Chobani, Intuit, Microsoft, Oracle, Timberland, Vizio, and

“Being included in this prestigious list of companies two years in a row is an honor and testament to the growth we’ve sustained since starting the company in February of 2011,” said TekStream Solutions Chief Executive Officer, Rob Jansen. “Our current and future success continues to be grounded by our employees who are passionately driven to exceed expectations and work in partnership with our clients and partners to deliver results,” he added.

This year’s Inc. 5000 nomination comes after TekStream has seen a three-year growth of over 133%, and 2016 is already on pace to continue this exceptional growth rate.  In addition, the company has added 25% more jobs over the last 12 months and recently doubled its office space at its Atlanta, GA US Headquarters.

“We are proud of the recognition and of the team we have assembled at TekStream,” stated Mark Gannon, Executive Vice President of Recruitment.  “We will continue to grow and diversify both our Federal and Commercial recruiting solutions in close collaboration with our technology team” Gannon noted.

To qualify for the award, companies had to be privately owned, established in the first quarter of 2013 or earlier, experienced a two-year growth in sales of more than 50 percent, and garnered revenue between $1 million and $300 million in 2015.

“It’s an honor to be nominated this year for the Inc. 5000.  Our growth can be attributed to continued efforts with key partnerships like Oracle and others. With the rapid adoption of Oracle Cloud and other cloud technologies, we expect that trend to continue well into 2017 with our eye on the nomination again next year,” said Judd Robins, Executive Vice President of Consulting Services.

TekStream Solutions

TekStream Solutions is an Atlanta-based technology solutions company that specializes in addressing the company-wide IT problems faced by enterprise businesses, such as consolidating and streamlining disparate content and application delivery systems and the market challenges to create “anytime, anywhere access” to data for employees, partners, and customers. TekStream’s IT consulting solutions combined with its specialized IT recruiting expertise helps businesses increase efficiencies, streamline costs, and remain competitive in an extremely fast-changing market. For more information about TekStream Solutions, visit or email Shichen Zhang at