Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]
Introducing Our Partnership with Incorta
We are excited to announce our partnership with Incorta, the only unified data analytics platform that aggregates large complex data in real time with no data warehouse required. Powered by Direct Data Mapping™, Incorta can make tens of billions of rows of data across multiple source databases analytics-ready in a matter of minutes. Our new […]
Seamless Integration of Oracle Fusion Apps Data with OAC Data Replication
One of the easiest and lowest maintenance approaches to feed Fusion Cloud Apps data into a data warehouse, is with Oracle Analytics Cloud (OAC) Fusion Business Intelligence Cloud Connector (BICC) Data Replication. Data Replication for Fusion Apps is a native feature of OAC Enterprise edition. If you’re migrating your on-premises application, such as E-Business Suite, […]
5 Snags to Avoid When Modifying Seeded Oracle Fusion Reports
Oracle Cloud Applications provide many predefined reports to generate important documents necessary for running a business. These documents support internal operations, communicate with trading partners, or produce legal documentation. Still, they almost always require modifications to include company branding or rearranging and adding data elements to appear similar to legacy documents. Thoughtfully, Oracle Fusion provides […]
Oracle Cloud OM Business Rules – A Primer
Oracle Cloud OM Business Rules are a great way to take the wheel and drive your business. They provide great flexibility and can help take the drudgery and human factors out of decision making. The best thing about them is that in most cases you don’t have to make modifications or create extensions to make […]
How to Create an OAC Data Replication from Oracle SaaS?
Oracle Analytics Cloud offer several options when it comes to loading data from Oracle SaaS (such as Financials, HCM, Sales, etc…). Using OAC against Oracle SaaS has several advantages, and most importantly being able to perform analytics on data that is not part of the SaaS application. You may be familiar with using Data Sync […]
How to Integrate Oracle SaaS Data into Oracle Analytics Cloud?
Reporting on Oracle Fusion and non-Fusion SaaS Apps from Oracle Analytics Cloud (OAC) is a common solution to performing cross-functional reporting from one or more Cloud and non-Cloud applications. The BI capabilities within each of the transaction systems, whether Financials, HCM, Sales or other, are limited when it comes to integrated reporting with external data […]
Using Physical SQL (PVOs) to Extract ERP Cloud Data from OTBI
Physical SQLs are essentially the same as Logical SQLs. Behind the scenes, Logical SQLs are converted back to physical SQLs by BI server using the OTBI Fusion public view objects (PVOs) defined in the RPD physical layer. Physical SQLs leverage the same Data Sync built-in Oracle BI Connector used by logical SQLs for extracting ERP Cloud data from OTBI. The process […]
Oracle Cloud ERP: Generating 1099-MISC – Be ready for tax season!
Yes, it’s only September. If you are in the financial industry – you know that tax season is looming just around the corner. In Oracle Cloud ERP Payables, generating 1099-MISC forms is a great feature that makes one part of tax reporting an easy task! In this blog are steps you can do now to […]
Content Integration in Oracle WebCenter
I recently blogged about content management in portals. Chris DeBracy, one of the lead architects in our Oracle practice gave me some additional information about how Oracle’s Web Center Suite integrates Oracle UCM (the old Stellent product). There are all kinds of ways to display UCM content in WebCenter Suite using little or a lot […]