Oracle

Ever run into a problem when working with Oracle Cloud’s R11 Project Financial Management software when you go to run the “Edit Project Performance Data” process and nothing happens, nothing gets updated?  Well, there may be an easy and simple fix to that. There are certain steps to make sure you’ve completed to make this […]

In Part 1 of this series, I explained how to prepare your system for VirtualBox and download and extract the .ova file from the Oracle OTN site.  This post describes how to deploy the image, setup the virtual machine settings, how to set up your network adapters and run a critical patch.  At that point […]

Earlier this week, Oracle upgraded its BI Cloud Service platform as well as DataSync (now version 2.2) for cloud integrations. With those 2 upgrades come great benefits if you have any of the following and looking to do consolidated business analytics from multiple source systems and allow for cross-functional insights: Salesforce: There is no need […]

The intent of this document is provide the reader with a fundamental understanding of Oracle Ledger Sets and Data Access Sets, enriched with lessons learned from actual implementations.  Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient.   In Oracle EBS Release 12, two new concepts were […]

This article covers the implementation of the LDAP Adapter in Oracle Service Bus (12c). The LDAP Adapter provides an easy way to integrate with LDAP Servers. In this article we are going to use Apache Directory Studio as the LDAP server and Apache Directory Studio as the LDAP browser. First, you will need to download […]

The Oracle Internet Expenses application has quickly become one of the most intuitive products in the Financials suite. Not only have I previously discussed how simple it is to use the mobile app or how simple it is to create an expense report in the instance, but the seamless flow to Payables is definitely worth […]

Java Cloud Service (JCS) is a PaaS offering from Oracle. It supports all the PaaS requirements like – elasticity, scaling, automated patching, backup/recovery, etc. It’s an environment running on cloud hardware on which you can build, deploy, and manage Java applications just as you would in an ordinary virtual or physical server running on your […]

Shortly after the release of OBIEE 12.2.1.1, OBIEE Sample Application version 607 was released.  This Sample App is extremely robust and nicely highlights the updates to OBIEE 12c including Data Visualization improvements and really shows off what OBIEE 12c can do.  In addition to the core Sample App, an EPM Plug-in for Sample App is available, […]

Often times companies that rely on Oracle’s EPM products, whether these are on-premises like Hyperion Financial Planning or in Cloud like PBCS, lack a robust approach of navigating to transactional details within the context of an EPM summary view. This becomes a bigger challenge when there are multiple transaction systems involved in financial consolidation. Watch […]

OBIEE release 12.2.1.1 not only boasts improved Data Visualization capabilities as I outlined earlier this week, but there are many important updates to source system support.  One of the main drivers of this is that OBIEE now supports DataDirect 7.1.5.  For those of you unfamiliar with DataDirect, it is a set of ODBC drivers from Progress Software […]

We have noticed that in few interfaces, the NVL function is not working as expected when “_simple_view_merging” is set to be true in the Oracle source database. This problem is encountered if the column corresponding to the first function displays the correct results, but the columns corresponding to other functions return nothing. You can see […]

This post is a follow-up to my previous post: OBIEE Collaborative Analytics Enables Decision Making & Action In this blog, I provide detailed instructions and design aspects of implementing OBIEE Dashboard Commentary levergaing the Write Back feature. There are several steps involved, at the database, middleware and dashboard levels.