Start Here

Get in touch with a
TriCore Solutions specialist


Blog | Dec 21, 2017

How to Avoid Row Chaining in a Database

Posted by Mukesh Kumar

We encounter row chaining when the size of the row is larger than the size of the database block used for storing it. In this situation, the row is split across more than one database block. When this row needs to be accessed, more than one database blocks are traversed, resulting in greater I/O.

Read More

Blog | Dec 14, 2017

Intro to Virtual Private Databases (VPDs)

Posted by Harish Durgapal

Oracle VPD enables you to create security policies or group policies to control database access at the row and column level. It allows multiple users to access a single schema while preventing them from accessing data which is not relevant to them. VPD uses Fine-Grained Access Control to limit visibility of the data to the specific users. 
Read More

Blog | Nov 1, 2017

Oracle BAS vs Oracle EBS

Posted by Carla Roddy

Two of our most helpful and widely used support services are Oracle Business Application Support (BAS) and Oracle EBS Application Managed Services. Oracle BAS and Oracle EBS are largely complementary. While Oracle BAS supports your business users, Oracle EBS supports your Oracle E-Business suite itself. Here we take a closer look at these two services, which can work independently or together to give your enterprise a true partner for a wide range of Oracle support needs.

Read More

Blog | Oct 19, 2017

R12.1.3 Security Configuration Console - New Feature Released Oct 2017

Posted by Shyamal Shah

By Shyamal Shah, PDBA

The Single Backport patch in R12.1.3 will enable Secure Configuration Console to automate security configuration process which consolidates everything under one user interface. 

Patch 26090737 can be applied in Hot mode (It will require Application restart to take effect)

Read More

Blog | Oct 11, 2017

Oracle OpenWorld 2017 in a Nutshell

Posted by Shyamal Shah

This year's OpenWorld was fully focused on Automation, planning for Oracle 18c which will be the First Self-Driving Database using Machine Learning. Although we are no strangers to Oracle's annual San Francisco conference, this was our first year attending as Rackspace. The conference was filled with educational sessions, networking, innovative ideas and exciting announcements. Below are some of the exciting takeaways and updates announced at #OOW17.

Read More

Blog | Oct 6, 2017

General Ledger Interface, Journal Import and posting using PL/SQL

Posted by Shobhit Mittal

There are many companies using a wide range of legacy systems to manage different areas of business, along with EBS. EBS GL is one of the crucial modules, companies generally come up with a requirement to import data from different types of legacy system. This blog will help those who want a solution which is automated, flexible and easy to manage.

Read More

Blog | Oct 2, 2017

A New Approach to Learning at Oracle OpenWorld 2017

Posted by Shyamal Shah

In an Oracle announcement in July and a Forbes article in August, we learn that Oracle has teamed up with the Stanford Center for Design Research this year to bring new, collaborative learning opportunities to Oracle OpenWorld 2017. Changes include a new, more participatory session format and a redesigned exhibit hall aimed at fostering conversation and active, collective learning.

Read More

Blog | Sep 7, 2017

Load Testing Oracle Database: Some Insights

Posted by Maheedhar Pasupuleti

The Preparation Phase is pivotal to the whole Load testing exercise. More caution needs to be exercised in analysis and conclusion especially when the load testing system is not a 1:1 replica of PROD.

Read More

Blog | Aug 18, 2017

Getting the Most out of Oracle BAS

Posted by Samantha Hoppe

Oracle  Business Application Support, or BAS, protects your Oracle investment by backing up your business users with Oracle-related business expertise. However, in order to take full advantage of that expertise, it's important to utilize BAS at every opportunity. Here we take a good look at how to get the most out of your BAS plan in order drive your Oracle-run enterprise to new heights.

Read More

Blog | Jul 13, 2017

Tips for Getting the Most Out of Hyperion EPM

Posted by Vikram R Kosanam

We are really quite keen on Oracle's Hyperion, so we put together the following tips to show how you can use it to your advantage. Let's start with a few basics.

Oracle Enterprise Performance Management. This isn't another application package that's just nice to have. Enterprise Performance Management (EPM) is a necessity in today's fast-paced, digital world. We are long past the time for hand-drawn spreadsheets or other manual processes that confine themselves to one department among several separate departments within an organization.

Read More