Oracle

In an Oracle Hyperion Financial Management (HFM) implementation, we always use the historical rate to translate the subsidiary’s equity. Historical rate means the actual exchange rate used when the transaction was consummated. For me, the most practical way of achieving this is by using equity overrides. This gives the client full control of the actual translated […]

Cisco recently released their Annual Cybersecurity report for 2017, which revealed several statistics I thought were real eye openers. You can pick up a copy here: http://b2me.cisco.com/en-us-annual-cybersecurity-report-2017. Of the major findings in this document, I consider a few quite concerning, in particular: “Spam accounts for nearly two-thirds (65 percent) of total email volume… about 8 percent […]

There are several analytical capabilities that Oracle Enterprise Performance Management (EPM) products, whether Hyperion on-premises or Cloud EPM, have to offer. Financial reports and ad-hoc analysis in Excel are all great. However, in general EPM reporting capabilities remain restricted to whatever data you have in EPM. Are you looking to do one or more of […]

Oracle Business Intelligence Suite provides comprehensive capabilities for business intelligence, including enterprise reporting, dashboards, ad-hoc analysis, multi-dimensional OLAP, scorecards, and predictive analytics on an integrated platform. It is also a core component of Oracle Exalytics, the industry’s first engineered in-memory analytics machine designed to deliver extreme performance. A majority of healthcare providers to some extent or […]

Oracle is aggressively re-engineering all of their popular suite of products over to cloud. Among several cloud offerings that Oracle announced at Oracle OpenWorld 2016 is Oracle Data Integration. Many of you may already be familiar with Oracle Data Integrator. Now, the same product is re-engineered to work in the cloud with several additional capabilities to fully leverage […]

The purpose of this blog post is to share how to setup/customize the Oracle Drop Ship process to automatically create Purchase Orders originating from the Drop Ship Sales order lines. Standard Process: Oracle’s out-of-the-box functionality involves creation of a sales order in Oracle Order Management with sales order lines set to source type as External. Once […]

Oracle Service Bus 12.2.1 provides a JavaScript action, which allows us to include snippets of JavaScript code to be executed during proxy pipeline processing. The most common case for using JavaScript is when dealing with JSON objects in REST services. Rather than converting the payload to XML and using XQuery or XSLT for manipulation, using […]

Perficient is proud to be a sponsor at Collaborate 17, which is being held April 2-6 in Las Vegas. It’s an opportunity for the Oracle user community to come together to share and learn through sessions, panels and networking events. We are honored to have been invited to present on six unique topics across multiple tracks at Collaborate and […]

Now that we have three different approaches to extract Oracle ERP Cloud data from OTBI, there comes the question – what’s the best practice, or which one should you recommend? Before answering the question, let’s take a look at the feature list of each approach so we can understand what they are best at. Feature List […]

Release 12 of Oracle Sales Cloud is just around the corner and with it comes some great improvements that make it an even more compelling solution for enabling modern sales in the cloud. Oracle Engagement Cloud is the crown jewel of the release, combining Oracle’s leading sales and service capabilities. From a single screen, users […]

Custom SQLs work differently than logical and physical SQLs.  Instead of going through the OBTI subject areas and the Fusion PVOs in the RPD physical layer, custom SQLs are used to create custom data models in BI Publisher to extract ERP Cloud data directly from the Fusion database tables.  The built-in Data Sync Oracle BI Connector does not support […]

In an Oracle Hyperion Financial Management (HFM) application, you can always create alternate hierarchies. We have created them for Entity, Accounts, and any of the custom dimensions. The guideline is always when the consultants leave, the HFM administrator must be able to efficiently maintain the application and meet the company’s management information and reporting needs. […]