Search from 700 + Posts

Oct 30, 2019

How to Incremental Processing to a Data Flow in Oracle Analytics Cloud

Apply Incremental Processing to a Data Flow

Use incremental processing to determine the last data processed in the data flow and to process only the newly added data.
  1. Select a data element column as an incremental identifier for the data set.
    You can select an incremental identifier only for those data sets that are sourced through database connections.
    1. Go to the Data page and select Data Sets.
    2. Select a data set and click the Actions menu or right-click, then select Open.
    3. Click Edit Data Set on the Results toolbar.
    4. Select the data set node in the diagram. From the New Data Indicator list, select a column, then click Save.
  2. Apply incremental processing to the data flow using the data sets for which you’ve selected the incremental identifier.
    1. Create or open the data flow in which you want to apply incremental processing.
    2. In the Data Flow editor select the data set.
    3. In the Step editor pane, select Add new data only to mark the data set as incremental.
    4. Click Save.
In a data flow with multiple data sets, you can select only one data set as incremental. If you try to select a second data set as incremental, you see a warning message. Click Yes to enable incremental processing for the second data set for which you’ve selected Add new data only. Incremental processing is deselected for the first data set.

Oct 15, 2019

Oracle Integration Cloud Application Connectors/Adapters

Integration to applications is dramatically simplified by the use of application adapters that eliminate the complexity associated with web services and other connectivity methods. Simplify your integration to connect with virtually any application, service, or data store. Oracle offers a library of these adapters to provide you with a standardized way to rapidly connect the various protocols required by each application vendor. In addition to application adapters for CX, ERP, and HCM, there are database, productivity, social, RPA, and technology adapters. 

Below are list of connectors/Adapters available in Oracle Integration Cloud (OAIC)

Connector for Oracle
Oracle Commerce Cloud
Oracle CPQ Cloud
Oracle E-Business Suite
Oracle Field Service
Oracle Marketing Cloud (Eloqua)
Oracle ERP Cloud
Oracle JD Edwards EnterpriseOne
Oracle Logistics
Oracle NetSuite
Oracle PeopleSoft
Oracle Responsys
Oracle Service Cloud (RightNow)
Oracle Sales Cloud
Oracle Siebel
Oracle Taleo Cloud
Oracle HCM Cloud
Oracle Utilities
Oracle Advanced Queuing (AQ)
Oracle Database
Oracle Messaging Cloud Service
Oracle WebLogic JMS

Jul 23, 2019

Oracle EBS Enterprise Command Center

Oracle EBS Enterprise Command Center 

In this post I will highlight

  1. What is Enterprise Command Centers for EBS
  2. ECC Framework 
  3. Key Feature of Payables Command Center
  4. Key Feature of Service Contract Command Center
  5. Key Feature of Shipping/Logistics Command Center
  6. Key Feature of Service Command Center

Enterprise Command Centers (ECC) provide information discovery along with visualization and exploration capabilities embedded within Oracle E-Business Suite user interfaces. ECC Framework enables the creation of business dashboards in different functional areas. Oracle E-Business Suite users navigate transactional information using interactive visual components and guided discovery capabilities allowing exploratory data analysis. Mobility and responsive design is built into the ECC Framework, and all dashboards automatically adjust layout to better fit a desktop or mobile device form factor. ECC automatically adheres to existing Oracle E-Business Suite security. The dashboard content a user sees is completely consistent with Oracle E-Business Suite context and security.

Each Oracle Enterprise Command Center extends the owning Oracle E-Business Suite application with discovery-oriented dashboards that bring together diverse operational data from across the Oracle E-Business Suite. ECC dashboard users identify and act on top priorities without the need for custom operational reporting, and use information-driven navigation. With tools and visualizations such as actionable indicators, tag clouds, interactive charts, and consumer-like search and filters, users can browse and drill on whatever engages their attention. With each drilldown or search refinement, the data engine recalculates indicators, tag clouds, charts, and search choices to provide the user with new information on which to base next discovery steps. Through this "conversation with the data", users narrow in on today's most important business challenges, all without predefined navigation paths, structured queries, or operational reports.