Oracle

Gathering Statistics of a database schema before executing an ODI load plan will improve performance by helping the Optimizer to select optimal execution plan by referring to latest statistics, instead of stale statistics. We can gather statistics of Oracle database schema at a scheduled time of day using the DBMS_SCHEDULER and DBMS_AUTO_TASK_ADMIN packages, However, if […]

Oracle has recently introduced a new version of OBIEE 12c, 12.2.1.1 (not to be confused with the original 12.2.1.0) This is the first point release of the 12c platform and contains a host of changes.  The biggest changes are in the Data Visualization side of the house where the platform has seen significant functionality additions in […]

Oracle OpenWorld, is quickly approaching and the Perficient team extends a warm welcome to come visit with us. Perficient is proud to be an exhibitor at Oracle OpenWorld, which is being held September 18-22 in San Francisco. Visit us at booth #1715 to meet with subject matter experts and thought leaders and learn how we’ve […]

The use of the Payables Standard Invoice Template for importing mass invoices is great for clients who prefer not keying in invoices manually, which, let’s be honest here, is most clients. This FBDI (file-based data import) file comes in handy and is fairly simple to use. The greatest feature is the amount of invoices that […]

Organizations that rely on Oracle Business Intelligence (OBIEE) as their standard analytics platform may have already reaped the benefits of a common enterprise reporting solution from a data accuracy and accessibility perspective. However, they are most likely still using traditional means of collaboration. This entails communication of reported results, explanation of what they mean, their […]

We have to regularly purge the Oracle Data Integrator (ODI) log files to reduce the size of the ODI work repository and improve the performance of the ODI studio. Before purging we can export the ODI log files and archive them. If we ever want to analyze the log history, we can re-import the logs from […]

Assumption: Database 12c is installed successfully on a local VM that runs Oracle Enterprise Linux (OEL). Issue: After a successful install of Oracle Database 12c, starting with the listener and the database, you might notice that the Enterprise Manager (EM) is not accessible in FireFox that comes with the standard Linux install on a VM […]

Checklists serve a variety of purposes and are widely considered a valuable tool to get things done.  Some checklists may guide you to complete tasks in a particular order, while others are intended to assist in making a decision. According to the Aberdeen Group, buyers in the discovery phase use checklists to help them better define their […]

Upgrading an existing stage/production OSB 11g implementation to Service Bus 12c can be a massive job. It becomes an overwhelming task if it contains several clustered nodes and several OSB 11g projects that need to be imported to JDeveloper 12c. Some of the pre-requisites for a successful migration are: Only a domain that is running […]

With so many cloud products and concepts that currently exist in the Cloud Technology space, one can wonder, “What exactly is Java Cloud Service? How long will it take for my organization to move to cloud?” All these are genuine concerns. So, let me start addressing some of them. Oracle Java Cloud Service (JCS) is […]

Globalization is driving companies to keep up with innovation in order to stay competitive.  The ability to procure, analyze, and report real-time information to internal and external stakeholders regardless of their location is becoming a necessity to remain viable. According to the global market intelligence firm International Data Corp. (IDC), more than half of enterprises’ […]

In regard to the example I gave of AR transactions not functioning in last week’s blog, there is a simple fix. This is not something that my team discovered on Oracle Support or through Google, but it’s something that was discovered when looking at roles. The AR roles on the role template for the “Receivables […]