Oracle

Last week at Oracle OpenWorld, I happened across a demo station related to Oracle REST Data Services.  While I have used Oracle Application Express (APEX) and its implementation of Oracle REST Data Services (ORDS) previously to deploy REST based web services, this demo intrigued me since it was utilizing SQL Developer (version 4.1+) to do the […]

Oracle sales cloud provides us with the help option which will enable us to get assistance on the application components.  On certain occasion the developer may come across a situation where custom help needs to be defined relevant to the application or for the other developers who are not so familiar with the project. To […]

The Manage Administrator Profile Values task in Setup and Maintenance is an excellent tool for troubleshooting issues throughout any of the Fusion applications. There have been several scenarios where access levels have been removed or a simple configuration may have been missing. For a majority of these scenarios, the answer was found in this task […]

Oracle announced a new subscription based machine called Oracle Cloud @ Customer. In this model, the same Public Cloud PaaS offering that Oracle currently offers in their Cloud Infrastructure, is now available at the Customer’s location. With this model, the customer can leverage their own data center and keep the cloud behind their firewall. Just […]

In my last post, I described the methods of reporting from Oracle Cloud (Fusion) Apps.  In that post I illustrated the advantage of using BICS and Data Sync to provide a true Enterprise Data Warehouse due to its abilities to integrate data from all our your cloud, relational, big data and flat file sources.  This […]

Many organizations today are using a Modern Business Intelligence Platform or Big Data to eliminate Customer Blind Spots. When most firms refer to Big Data, they are not necessarily using “BIG” data, the term is used interchangeably with Analytics by most of our Customers. Organizations today are increasingly relying on Data to make strategic decisions. […]

Oracle provides multiple ways of reporting from Oracle Cloud (Fusion) Apps.  Oracle HCM Cloud, CX Cloud, SCM Cloud and Cloud ERP all have Oracle Transactional Business Intelligence (OTBI) built into the application.  In addition, Oracle Business Intelligence Cloud Service (BICS) can also access Oracle Cloud application data and load it into the BICS Database via Data Sync.  While […]

When adding project details to a Purchase Order, it’s possible that the following errors may appear: These errors appear once the user attempts to save or validate the PO and also cause the PO Charge Account that was chosen for each line to disappear and become disabled. When the user goes back to review/edit the […]

In the August 2016 update of Oracle BI Cloud Service (BICS), Oracle has added a great new feature: scheduled report delivery, simply called Deliveries.  In a nutshell, Deliveries is a scheduling system that emails reports on an instantaneous or regular basis.  The scheduler itself is found in the BICS Console as seen below.  Once you click on […]

In this blog post, I’ll explain how you can use Oracle Data Integrator (ODI) to extract data from the Salesforce cloud and thereby perform detailed Analysis / Reporting in order to make better decisions. Prerequisites Salesforce Developer Edition account to access the Salesforce data. JDBC driver to interact with Salesforce from ODI. Get this from https://www.progress.com/datadirect-connectors Download Cloud […]

Effective and efficient financial reporting is crucial for the success of semiconductor companies.  It is critical to track revenue, shipments, and order backlogs in order to properly utilize company assets.  In addition to understanding the current financial position of the company, there needs to be visibility into company forecasts in order to do proper financial and manufacturing planning. Data […]

In Oracle R11, there is a redesigned Expenses work area with five infotiles: Expense Items, Expense Reports, Approvals, Cash Advances, and Trips.  As it is in most of the other Financial areas, each infotile has a drill-down detailed view for the user. The Expense Items infotile shows all expense items that are not included in […]