Posts Tagged ‘BI Publisher’

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 […]

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 […]

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 […]

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 […]

Here are the blogs that I have posted previously as part of my blog series on Oracle DataSync (BICS). Best Practice to ETL with Data Sync (BICS) In this blog, I am going to talk about three different ways to integrate Oracle ERP Cloud data with Data Sync (BICS) through OTBI.         […]

  On January 14, 2016, Perficient hosted a webinar titled Leveraging Siebel CTMS for Risk-Based Monitoring. We received some good questions during the webinar and figured we’d share them (and the answers) with you.