OBIA 11g : Analyzing ODI ETL Load Performance - Part 2

In the part1 in this series, we showed how you can identify the top running maps in a load plan. In this blog, we list certain parameter/settings at ODI/Database/Network level that can influence the overall load plan timings. ODI Settings 1) Check the number of parallel sessions configured against the ODI agent. Recommendation is to have NOT more than 5 ODI sessions configured to run in parallel. If your server is not sized up properly, this may have to be reduced further. You...

Thursday, November 30, 2017 | Database | Read More

OBIA 11g : Analyzing ODI ETL Load Performance - Part 1

When you run an ODI ETL Load plan, it takes certain time. At times, customers would like to understand a split of the time taken by the load plan and analyze the top running maps to see if they can be optimized to run faster. In the first part in this series, we help you understand how you can easily analyze the time taken by the load plan and identify the top running maps. Using ODI Studio, a customer can load at the Load Plan logs and see the time taken by each phase or if...

Tuesday, November 7, 2017 | Read More

OBIA 11g: How to change system account passwords in BI Applications

Once in a while, there might be a need to change some of the passwords of the system users in OBIA. These could include the BIAppsSystemUser or the database passwords for the BIAPPS warehouse. BIAPPS 10.2 version users can follow the instructions as mentioned in this MOS tech note. OBIA 11g: How to change the system account passwords in BI Applications (Doc ID 2264922.1) If you are on older versions of BIAPPS, you can refer to this document instead OBIA 11g: Installing Oracle BI...

Monday, October 30, 2017 | BI applications | Read More

How to build Fusion Apps Security in BI Apps

General guidelines for Customization,Configuration and Administration   SSO Authentication Implementers can refer to the steps to integrate SSO with IDM as explained in ‘Security Guide for Oracle Business Intelligence Enterprise Edition’. FA Security Metadata Extraction steps Identify the Data Objects to secure e.g. Supervisor Person, Department, Position, etc are typical Data security objects HR Line Manager, Payroll Administrator, etc are typical Object Security Roles*. Fusion Apps...

Monday, October 9, 2017 | Analytic Applications | Read More

Lift and Shift of Oracle BIAPPS Artifacts to Oracle Analytics Cloud

Authors: Swathi Singamareddygari , Anand Sadaiyan Table of Contents DisclaimerSection:1 DeliverablesSection: 2 Lifting and shifting Application Roles and Web CatalogueSection: 3 Lifting and Shifting RepositorySection: 4 FAQSection: 5 Limitations Disclaimer This document does not replace the Oracle Analytics Cloud Service Documentation Library or other Cloud Services documents. It serves as a supplement for Lifting and Shifting Business Intelligence Applications Artifacts (BIAPPS...

Tuesday, June 20, 2017 | BIAPPS on PAAS | Read More

OBIA 11g: Oracle BI Applications on Cloud Services – Deployment Options

The BIAPPS on PAAS Cloud Services, primarily consists of 4 services – DBCS (Database Cloud Service), Compute, OAC (Oracle Analytics Cloud) or BICS (Business Intelligence Cloud Service) and Storage CS (Storage Cloud Service). Together, along with the required BI Applications software, these make up the BIAPPS on PAAS setup. Data is pulled from Oracle Cloud Source Applications like Fusion and Taleo via https. Data from On Prem sources can be pulled via a VPN connection or...

Tuesday, May 30, 2017 | BIAPPS on PAAS | Read More

Using OBIA with Fusion 12

Customers who are in the process of upgrading their Fusion Applications to Release 12.1 will need to make the following changes in OBIA to ensure smooth ETL runs. Download Patch 21175627 from MOS that contains the View Object (VO) diffs between FA Rel 11 and Rel 12.1. Customers will have to review the Impact to BI Apps Modules and Interfaces listed in the sheet 'BIApps Interfaces Impacted' and make the necessary changes in OBIA. Apply the Cloud Adapter patches documented in...

Tuesday, May 23, 2017 | Fusion | Read More

OBIA 11g Installation on PaaS with Oracle Analytics Cloud (OAC)

Oracle BI Applications can now be installed on Oracle PAAS (Platform as a service) platform and used along with Oracle Analytics Cloud (OAC). Refer to this Tech note  Doc ID 2254057.1 on support.oracle.com for more details. What is Oracle Analytics Cloud? Oracle Analytics Cloud (OAC) is a comprehensive analytics platform that powers your analytics strategy at any scale, in every environment – cloud, premises, desktop, and data center. From self-service visualization and...

Wednesday, May 10, 2017 | BIAPPS on PAAS | Read More

Lift and Shift of BIAPPS Artifacts to Oracle Business Intelligence Cloud Service

Authors: Swathi Singamareddygari , Anand Sadaiyan Table of Contents DisclaimerSection 1: Lifting and Shifting Application RolesSection 2: Lifting and Shifting the RepositorySection 3: Lifting and Shifting the Web CatalogueSection 4: Repository ADF and Consistency Checks Disclaimer This document does not replace the Oracle Business Intelligence Cloud Service Documentation Library or other Cloud Services documents. It serves as a supplement for lifting and shifting Business...

Friday, May 5, 2017 | BIAPPS on PAAS | Read More

BIAPPS on PAAS – Backup and Restore - Introduction (Part1)

BI Applications (BIApps) is an integrated application involving multiple components. A backup of BIApps therefore would mean a backup of the integrated application and not just the datawarehouse or the database. High level architecture of BIAPPS on PAAS is shown below: There are four different cloud service instances involved at a minimum when using BIAPPS on PAAS. Following table shows the components/software that are installed on each: DBCS (Database Cloud Service) Database...

Thursday, March 23, 2017 | Backup - BIAPPS on PAAS | Read More

Including Fusion-on-Cloud Extensions in BIAPPS (Troubleshooting) - Part 3

Authors: "Yadukrishna Munugoti - Oracle " and "Guna Vasireddy - Oracle" The blog1 and blog2 in this series provided steps on how to get Fusion Flexfields into BIAPPS. This blog, the third in this series, details some common issues you might encounter when doing so and how to resolve those issues.  ODI-40444: Column not found:XXXXXXXXXXXXXXXXXX After doing the required configuration to get the Fusion Flexfields into BIAPPS, you might encounter the ODI-40444: Column not found error...

Tuesday, March 7, 2017 | Cloud Adaptor | Read More

Combined Data and Deleted Rows Extract when extracting from Fusion using BICCC

Authors: "Sankara Sampath - Oracle " and "Guna Vasireddy - Oracle" Starting PB14 onwards, Fusion 11 now has a new option that allows you to combine the Data and Deleted Rows extract into a single job using BICCC (BI Cloud Connector Console). Internally the individual extracts are done one after the other and there would be two manifest files generated along with the corresponding files. The Cloud Data extract is done first followed by the Deleted Rows extract. Figure 1 :...

Friday, March 3, 2017 | Cloud Adaptor | Read More

Special use cases for Replication to SDS via OGG

Authors: "Guna Vasireddy - Oracle","Sai Rajendra Vadakattu - Oracle ", "Ankur Jain - Oracle"   Replicating Table without Primary Key Replicating Views Replicating OLTP Packages     Replicating Table without Primary Key: Use Case: Customer is using Oracle Golden Gate (OGG) to replicate the Source to SDS and would like to configure BIAPPS to use the SDS instead of the Source. Note: The SDS table differs from the source table in primarily two things: BIAPPS expects CDC columns in the...

Tuesday, February 28, 2017 | EBS | Read More

Importing Custom tables from Source Systems

At times, the source system for BIAPPS might have additional tables that you want to extract the data from and get into BIAPPS. This blog specifies the steps on how to import a source table that is there in Source system but not present in the BIAPPS ODI repository. It is assumed that the user has already registered the Source system before attempting any of the steps in this document. Please refer to the BIAPPS documentation incase you need help with the Source Registration. Id...

Thursday, February 23, 2017 | Customization | Read More

Troubleshooting OBIA Load Plan Schedules

In OBIA, the normal process would be to use OBIACM to generate the load plan then schedule it. However at times, customers report issues with regards to load plan schedules. This blog explains why such things are likely to happen and how to resolve them Symptoms Observed: Duplicate Load plan schedules, so the same load plan running multiple times. However only one schedule visible in OBIACM Schedule not visible in OBIACM but load plan running daily as if it were scheduled Schedule...

Tuesday, February 14, 2017 | ETL | Read More

OBIA Fusion Cloud Adaptor - View extracted files in UCM

Authors: "Sireesha Mandava - Oracle" When using Cloud Adaptor, the files will get uploaded to UCM/Storage Service. This blog explains how to view the files in UCM. Every extract that is run creates what is referred to as a Manifest file. This file contains the list of files that make up that extract. The file name is MANIFEST.MF which gets renamed to <timestamp>_MANIFEST_<TIMESTAMP>.MF post successful download via the ODI Load Plan. At times you want to verify the files that got...

Friday, January 20, 2017 | Cloud Adaptor | Read More

BICS Lift and Shift of BIAPPS Content

Authors: Anand Sadaiyan, Swathi Singamareddygari Table of Contents Disclaimer Section 1: RPD Lift and shift Section 2: Application Roles Lift and shift Section 3: Webcat Lift and shift Section 4: Using RDC to connect to ON-PREM oracle database Section 4 .1: Troubleshooting BI Cloud Service RDC Section 5: Limitations Disclaimer This document does not replace the Oracle Business Intelligence Cloud Service Documentation Library or other Cloud Services documents. This document serves as a...

Monday, December 26, 2016 | BIAPPS on PAAS | Read More

BIAPPS Lift and Shift to OAC / BICS

This blog is the landing page for Migrating Oracle BIAPPS (RPD, webcat, Jazn) Content to OAC (Oracle Analytics Cloud) or BICS (Business Intelligence Cloud Service). For returning Users, “Welcome Back.. If you are looking for the existing content in this blog, it has been moved to a different link based on the classification. Please read further for understanding the classifications”. The Steps for Uploading BIAPPS artifacts to OAC (External Compute) and BICS (Internal...

Monday, December 26, 2016 | BIAPPS on PAAS | Read More

BIAPPS on PAAS – Source Connectivity

OBIA 11g: Oracle BI Applications Installation on Cloud Services, Doc ID 2136376.1 white paper describes how you can install BIAPPS on PaaS or in other words OBIA on the cloud. This article explains the options available to connect to various cloud and non-cloud sources using BIAPPS on PAAS. Connectivity to Cloud Sources:   For supported cloud sources like Fusion and Taleo, BI Apps connects to the sources via https and then loads the data to the SDS. From there the data...

Friday, December 23, 2016 | Architecture | Read More

Including Fusion-on-Cloud Extensions in BIAPPS - Part 2

Authors: "Guna Vasireddy - Oracle" and "Yadukrishna Munugoti - Oracle " The blog explains how to get Fusion DFFs into BI Apps when Fusion is On Premise. This blog explains how you can do the same if Fusion Applications is on Cloud. When using BI Apps for Fusion (Cloud adaptor) , certain Flex VOs are already seeded out of the box. The steps to follow for getting Fusion Flex Extensions would depend on whether the Flex VO is already seeded for extraction Out of the Box (OOTB) or...

Wednesday, December 14, 2016 | Cloud Adaptor | Read More

Including Fusion-on-Cloud Extensions in BIAPPS

Authors: "Guna Vasireddy - Oracle" and "Yadukrishna Munugoti - Oracle " The blog explains how to get Fusion DFFs into BI Apps when Fusion is On Premise. This blog explains how you can do the same if Fusion Applications is on Cloud. When using BI Apps for Fusion (Cloud adaptor), certain Flex VOs are already seeded out of the box. The steps to follow for getting Fusion Flex Extensions into BIAPPS for such VOs are as below. Extract and Load Fusion Custom Flex Extensions(VO already...

Friday, December 9, 2016 | Cloud Adaptor | Read More

Monitoring BIAPPS ETL via Oracle Enterprise Manager

Monitor ETL Status Monitor ETL Duration Phase-wise Sample Alerts Background BIAPPS ETL or Load Plan can be monitored from ODI clients or BIACM. However what if you wanted to automate the monitoring? Is there a way to detect ETL is running? Is there a way to be notified if a particular ETL phase (like SDE/SIL/PLP) is taking longer than expected? This blog shows how it is possible using the latest BIAPPS Version 11.1.1.10.2 and  Oracle Database Enterprise Manager (OEM),that comes...

Thursday, December 1, 2016 | ETL | Read More

BIAPPS on PaaS – Sizing for Middleware and Database

When implementing BIAPPS on PAAS, it is important you size the PAAS components appropriately. This community post provides details on how you can size the various BIAPPS on PAAS Components including compute, DBCS etc https://community.oracle.com/docs/DOC-1008583  

Tuesday, November 15, 2016 | BIAPPS on PAAS | Read More

OBIA 11g Installation on PaaS with BI Cloud Services (BICS)

Oracle BI Applications can now be installed on Oracle PAAS (Platform as a service) platform and used along with BI Cloud Service (BICS). Refer to this Tech note  Doc ID 2136376.1 on support.oracle.com for more details.  

Tuesday, May 10, 2016 | BIAPPS on PAAS | Read More

Utility For Selectively Disabling Upgrade Load Plan Steps

Author: Gourav Sarkar, Software Development Manager, Oracle BI-Apps Development Introduction: In OBIA, for data upgrades from one version to the other, standalone load plans are provided out-of-the-box (OOTB). These standalone load plans need to be executed by the customers after up-taking a new BI-Apps version. Data upgrade is required to facilitate the customers apply the data fixes related to OBIA upgrade. Impact to Customized Warehouse If customizations are done in DW ETL,...

Friday, October 23, 2015 | Knowledge | Read More

OBIA 11g 11.1.1.10.1 Is Now Available

We are pleased to announce the release of Oracle Business Intelligence Application 11.1.1.10.1. In this release of Oracle BI Applications (OBIA) you can deploy: Oracle BI Applications with Oracle Service Cloud source system. Oracle BI Applications with Oracle Taleo Cloud source system. Fusion Applications Releases 9.2 and 10 data sources. Oracle Data Integrator Repository for Non-Oracle Source Databases New certifications OBIEE 11.1.1.9.0+ Windows Server 2012 R2 Oracle Data Integrator...

Tuesday, October 13, 2015 | Product News | Read More

Loading Custom Calendars using the Universal Adaptor

  Loading Custom Calendars using the Universal Adaptor Author: Chuan Shi Introduction In Oracle BI Apps time dimension, we support fiscal calendars extracted from customers’ OLTP systems. However, there could be situations that customers need to use a custom calendar that does not exist. For example, Siebel customers do not have any fiscal calendars in the OLTP EBS/PSFT/Fusion customers do not have the specific calendar they want to use in their OLTP. In these cases, the...

Monday, June 8, 2015 | Customization | Read More

Customer RFM Analysis

Customer RFM Analysis Author: Grace Wang Customer RFM RFM (Recency, Frequency, Monetary) is a marketing technique used to determine quantitatively which customers are the best ones by examining: Recency – How recently did the customer purchase? Frequency – How often do they purchase? Monetary Value – How much do they spend? The method is based on the marketing axiom that “80% of your business comes from 20% of your customers.” RFM methodology provides an easy and economic way to...

Wednesday, April 22, 2015 | Analytic Applications | Read More

ETL Design for sharing the sequence ID

Introduction This blog describes an ETL design to share the same sequence ID among several tables. Party Dimension is an exceptional case where Records from different streams merge into one table. Organization, person and group party types are loaded into separate tables W_PARTY_ORG_D, W_PARTY_PER_D & W_PARTY_GROUP_D and later get merged into a master table W_PARTY_D. These dimensions are Slowly Changing dimension out-of-the-box in the BI Application. They also carry a slowly...

Friday, February 6, 2015 | Architecture | Read More

Fact Table Partitioning with Oracle BI Applications

Authors: Patrick Block, Principal Member Technical Staff, Oracle BI Apps Development Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) Support for table partitioning was introduced to the BI Applications 11.x release series starting with version 11.1.1.8.1.  Partitioning support is largely automated - define the partitions on the fact table directly in the database, and then the BI Apps Fact Table IKMs and the Oracle database does the work. ...

Wednesday, January 28, 2015 | Architecture | Read More

DB Link with Oracle BI Applications

Authors: Simon Miller, Director OBIA, Oracle Customer Engineering and Advocacy Lab (CEAL team) and Patrick Block, Principal, OBIA Development In an earlier blog post 3 Modes for Moving Data to the BI Applications DW from a Source Application Database the available options for setting up data source connections was provided in detail, along with screenshots.  It should be noted this information written for OBIA 11.1.1.7.1 is still applicable for 11.1.1.8.1. While not...

Friday, January 23, 2015 | Architecture | Read More

Configure DW generated 4-4-5 calendar and 13 period calendar

Author: Chuan Shi Introduction Oracle BI APPs provide two data warehouse generated fiscal calendars OOTB. They are the 4-4-5 calendar (with three different disciplines, i.e., 4-4-5, 4-5-4 and 5-4-4, and one of them can be chosen) and 13 period calendar. These fiscal calendars can be populated according to the configuration rule chosen by the customer, such as when such a calendar starts, when it ends, and if customer wants to use 4-4-5, 4-5-4, or 5-4-4 discipline for the 4-4-5...

Thursday, July 31, 2014 | Architecture | Read More

BI apps 11.1.1.8.1 is available now

Oracle Business Intelligence (BI) Applications 11.1.1.8.1 is now available on the Oracle Software Delivery Cloud (eDelivery), and on the Oracle BI Applications OTN page. This is the second major release on the 11g code line leveraging the power of ODI, and certified with the latest version of Oracle BI Foundation 11.1.1.7 Highlights from the announcement.   What’s New This new release of Oracle Business Intelligence Applications 11g adds: 1. Prebuilt Connector for Oracle...

Thursday, May 8, 2014 | Product News | Read More

How does TYPE2_FLG Work in ETL

Author: Vivian(Weibei) Li Instruction TYPE2_FLG is usually used in slowly changing dimensions in BI Applications. This flag indicates if the dimension is type 2, and it determines the data storing behavior in ETL. This blog is to give you a better understanding on how TYPE2_FLG works in ETL. Background Slowly Changing dimension There are many fundamental dimensions such as Customer, Product, Location and Employee in BI application. The attributes in these dimensions are revised...

Monday, April 21, 2014 | Architecture | Read More

3 Modes for Moving Data to the BI Applications DW from a Source Application Database

In BI Applications 11.1.1.7.1 the adaptors for the following product lines use the LKM BIAPPS SQL to Oracle (Multi Transport) to move the data from the source Application database to the target BI Applications DW database:  E-Business Suite  Siebel  PeopleSoft  JDE A key feature of this LKM developed specifically for BI Applications is that the data from the source system may be transported in 3 different ways and using a parameters set in Configuration Manager the mode can be...

Thursday, April 17, 2014 | Architecture | Read More

Snapshot Facts in OBIA (3)

Authors: Anbing Xue, Zhi Lin Delta Snapshot History Fact Besides the trend lines of snapshots, we have requirement to plot the trend lines of the delta changes on a transaction along time line. The changes here can be either quantitative (on amount, units, etc) or qualitative (on names, description, etc). Hence we invented a new kind of snapshot fact, to specifically address it. Typical Data Model A typical attributes of a delta snapshot history fact is– SNAPSHOT_DT IMAGE_TYPE Many...

Friday, April 11, 2014 | Architecture | Read More

Snapshot Facts in OBIA (2)

Authors: Divya Nandakumar, Zhi Lin Range Snapshot History Fact In a data warehouse implementation, the volume of OLTP transactions could be very big already, and consequentially the volume of the snapshot fact could be humongous, depending on the snapshot frequency.  The dilemma is that better accuracy of change history would be achieved with more frequent captures, which makes data size overwhelming and performance badly impacted. A solution is to create a variation of the...

Friday, April 11, 2014 | Architecture | Read More

Snapshot Facts in OBIA (1)

Authors: Divya Nandakumar, Zhi Lin Snapshot History Fact A snapshot captures an image of source data at certain point of time, and preserves the data image plus a (snapshot) time label. A regular, transactional fact intends to store data in data warehouse format and reflect OLTP transactions with near-real-time latency. In this context, a regular fact basically captures the near-current snapshot of the OLTP transactions, and is capable to support status de quo analysis. A...

Friday, April 11, 2014 | Architecture | Read More

BI apps 11.1.1.7.1 Cumulative Patch 1 is available now

BI applications 11.1.1.7.1 cumulative patch  is available now. Patch 17546336 - BIAPPS 11.1.1.7.1 ODI CUMULATIVE PATCH 1 (Patch) can be downloaded from My Oracle Support.  "To download patch , navigate to My Oracle Support- Patches & Update. Search with the patch number (17546336) on the Patch Name or Number field. Follow the instructions in the Readme to apply the patch."

Wednesday, March 5, 2014 | Product News | Read More

How to Implement Object Security in Project Analytics in OBIA 11.1.1.7.1

Author: Vijay Rajgopal Introduction   This blog details the steps needed to implement object security for any custom objects which the Customer has created in the Project Analytics Module in OBIA 11.1.1.7.1 onwards.   Object-level security controls the visibility to logical objects based on a user's duty/application roles. The access to following objects can be restricted usingobject level security: Presentation tables, Presentation table columns, Subject Areas, Reports,...

Monday, February 24, 2014 | Architecture | Read More

Notes for implementing Universal adapter for OBIA Project analytics

Author: Amit Kothari Introduction: This blog outlines the steps for implementing OBIA Project Analytics for Universal Adaptor. Similar steps can be followed for other modules. Supported OBIA releases: 11.1.1.7.1 onwards Supported Apps releases: Universal Adapter. Steps:  Please refer to the OBIA documentation and the DMR as a starting point for this exercise.Also refer to this blog entry. Please login to the ODI Designer to see the OBIA Projects Universal interfaces, the Source...

Wednesday, February 19, 2014 | Analytic Applications | Read More

How to include Fusion DFFs Into OBIA 11.1.1.7.1 In Premise Data Warehouse

Author: Saurabh Gautam Introduction This is a technote that explains the steps needed to extract the Fusion descriptive Flexfield (DFF) information into the in premise Oracle BI application (OBIA) Warehouse from the in premise Fusion applications (not SAAS). Note: The OBIA changes have to be done manually. Supported OBIA release: 11.1.1.7.1 onwards Supported Apps release: Fusion Release 5 onwards A. Enable and Deploy DFF 1. Enable the Descriptive Flexfield in Fusion Apps. Mark the...

Wednesday, February 19, 2014 | Customization | Read More

BIAPPS List of ODI Variables

Author: Chuan Shi The tables below list variables of different categories in terms of whether and where they are refreshed. Note that the intention of this blog is just to provide general information about ODI variables. If you are an Oracle BIAPPS customer and have specific questions regarding any ODI variable, please contact an Oracle support. Variables that are not refreshed Variables that are refreshed

Wednesday, February 19, 2014 | Architecture | Read More

How to Compare RPDs

Author: Vivian(Weibei) Li Introduction Comparing RPD is a very necessary and useful process in RPD development. It is good to consider doing it in the following use cases. You have a customized RPD and want to find out the differences between the customized RPD and the OOTB RPD. You did some customization on the RPD and want to check if the customization is done as expected. The administrator wants to check the differences in the later RPD with the older RPDs. You want to upgrade...

Tuesday, February 18, 2014 | Knowledge | Read More

Configuring Enterprise Calendar for Oracle BI Apps Time Dimension

Author: Chuan Shi Introduction One of the key common dimensions of Oracle BI Apps is the Time dimension. It contains calendars of different natures to support different types of analysis within various subjects in Oracle BI Apps. Different types of Calendar include: Gregorian Calendar Fiscal Calendar (multiple) Enterprise Calendar (unique enterprise wide) The Enterprise Calendar (or reporting calendar) enables cross subject area analysis. The Enterprise Calendar data warehouse...

Thursday, January 23, 2014 | Customization | Read More

Configure summary calendar file (file_summary_calendar.csv) for PeopleSoft ETL

Author: Chuan Shi Purpose and Audience This article explains how to configure an ETL source file for time dimension from PeopleSoft (PSFT) adaptors, i.e., file_summary_calendar.csv. This file is needed to populate the fiscal quarter information for fiscal calendars sourced from PSFT. It applies to all Oracle BI Apps customers who use PSFT sources. Oracle BI Apps supports calendars of different natures, including Gregorian calendar, fiscal calendar, and enterprise calendar....

Thursday, January 23, 2014 | Knowledge | Read More

Introduction and Tips of Oracle BI Apps Variable Refresh

Author: Chuan Shi Introduction The ETL logic in BI Apps uses parameters in packages, interfaces, load plans, and knowledge modules (KM) to control the ETL behaviors. Parameters can be configured by customers, pre-seeded in the ETL code, or maintained internally: Data Load parameters that can be configured by customers are maintained at product line (PLV) and fact/dimension group levels in the BI Apps Configuration Manager (BIACM). Some parameters are pre-seeded in the ETL code...

Wednesday, November 27, 2013 | Architecture | Read More

Tips and Usage of Group Account Number Configuration

Author: Sridhar Kasam Introduction The general concept discussed in this blog applies to all OBIA releases. The specific screenshots on Configuration Manager is only available starting 11.1.1.7.0. When you implement Financial Analytics, one of the most important steps is to set up Group Account Numbers. Many issues are reported due to incorrect setup of Group Account Numbers. - What is Group Account Number? o Group Account Number logically groups GL natural accounts into...

Tuesday, November 19, 2013 | Analytic Applications | Read More

Extracting PSFT Chartfield Hierarchy Data in OBIA 11.1.1.7.1

Author: Akshay Satyendranath  BI Apps 11.1.1.7.1 supports 26 chartfields with 3 of them considered to be mandatory chartfields and are mapped to specific dimensions as shown below. Department – Cost Center Dimension Fund – Balancing Segment Dimension Account – Natural Account Dimension All the remaining chartfields are mapped to one specific dimension which is GL Segment Dimension. The physical table is shared for all chartfields but there are multiple logical dimensions in the RPD...

Tuesday, November 19, 2013 | Analytic Applications | Read More

How to handle BIAPPS ETL failures due to duplicate data issues in Oracle DW

How to handle BIAPPS ETL failures due to duplicate data issues in Oracle DW Author: Amit Kothari Sometimes there are duplicate data rows in the source tables, due to this while running a ODI Load Plan (LP) in BI Applications 11.1.1.7.1 the ODI sessions may error out while creating the unique indexes. It is always recommended that the source data issues be fixed first but that may not be feasible sometimes or you may just want to fix the data in the warehouse and continue with...

Thursday, November 14, 2013 | Architecture | Read More

Registering BI Applications Data Sources

Author: Patrick Block BI Applications 11.1.1.7.1 introduced a number of changes; adding new components and processes and enhancing others.  As a result many customers and partners are re-learning how to install, configure and manage the application and naturally a number of questions have arisen.  This post walks through the steps of registering a source application system in BI Applications, and then looks a little deeper into what has actually been setup behind the scenes...

Friday, September 13, 2013 | ETL | Read More

Cleaning up ODI I$ and C$ work tables

Author: Patrick Block ODI E-LT and Work Tables (I$ and C$) In BI Applications 11.1.1.7.1, the ETL is performed by ODI, which transforms the data by issuing SQLs to both the source and DW DBMS, otherwise known as E-LT.  During this E-LT processing ODI creates intermediate or work tables in the BI Application Data Warehouse schema, these are tables prefixed with I$ and C$.  When a  scenario successfully completes, it will automatically delete these tables, as they're transitory...

Friday, September 13, 2013 | Architecture | Read More

Correlating SQL statement in DB Sessions with ODI Sessions in ODI 11.1.1.7

Author : Jayant Mahto NOTE: This support is only available for Oracle database. When a LP is executed by an ODI agent then it creates ODI sessions for the scenario steps and sends appropriate SQL to the DB for execution, which in turn creates DB sessions. For long running jobs (or when there is a suspicion that some sessions are hanging in ODI) we need to correlate ODI sessions and the corresponding DB sessions. This is achieved by examining the content of the ACTION column in...

Thursday, August 29, 2013 | ETL | Read More

Oracle BI Apps - Support for Unit of Measure conversion.

Authored by : Manjunath Gangadhar Overview UOM or Unit Of Measure is the method of expressing the quantity of an item so that it can be tracked and accounted for in a system. A data warehouse that stores and analyzes Items or Products must have a UOM standard defined. This post describes OBIA requirements, design and implementation of UOM What is UOM Conversion Let’s start with an example: Let’s say on 15thJan, 2013 100 Ea of Mont Blanc pens were sold. Here Ea is Each which is a...

Tuesday, June 11, 2013 | Analytic Applications | Read More

Implementing Oracle BI Applications using Universal Adaptors

1. Implementing Oracle BI Applications – Universal Adaptors  The purpose of this document is to provide enough information one might need while attempting an implementation of one or more offerings and subject areas using the Oracle BI Applications Universal Adaptors. There are several myths around what needs to be done while implementing Universal Adaptors, where can things go wrong if not configured correctly, what columns are to be populated as a ‘must’, how to provide...

Tuesday, May 21, 2013 | Architecture | Read More

Load Plan Generator – An Inside Look

Authored By : Don Co Seng Oracle BI Applications (BIAPPS) 11.1.1.7.1 was recently released and is now available for download. One of the biggest features in this release is the introduction of Oracle Data Integrator (ODI) as the embedded ETL tool. With the introduction of ODI, a new method of orchestrating the task of loading your data warehouse is now required. This requirement brings about the introduction of Load Plan Generator (LPG). LPG is a utility for generating ODI...

Tuesday, May 14, 2013 | Architecture | Read More

Oracle BI apps 11.1.1.7.1 (BI apps on ODI)

From the announcement today Oracle Business Intelligence (BI) Applications 11.1.1.7.1 (also known as 11g PS1) is now available on the Oracle Software Delivery Cloud (eDelivery) and on the Oracle Technology Network (OTN). This is the first major release on the 11g code line leveraging the power of ODI, and certified with the latest version of Oracle BI Foundation 11.1.1.7. What’s New This major new release of Oracle Business Intelligence Applications 11g adds: 1. New in-memory analytic...

Friday, May 10, 2013 | Product News | Read More

BI Warehouse - Analytics enabled by warehouse

A lot of times, a question comes up as to what value a warehouse based solution brings. Below are a few use cases that exemplify the need for a persistent storage. Both real time and warehouse based analytics are complementary to each other and serve different use cases. In a follow up post we will also cover the use cases best served by real time and not warehouse based solution. Feature Description Sample Use Case Currency Conversion 4 corporate level and functional currency...

Tuesday, April 23, 2013 | Architecture | Read More

Currency Conversion in Oracle BI applications

Authored by Vijay Aggarwal and Hichem Sellami A typical data warehouse contains Star and/or Snowflake schema, made up of Dimensions and Facts. The facts store various numerical information including amounts. Example; Order Amount, Invoice Amount etc. With the true global nature of business now-a-days, the end-users want to view the reports in their own currency or in global/common currency as defined by their business. This presents a unique opportunity in BI to provide the...

Monday, November 26, 2012 | Analytic Applications | Read More

BI Applications overview

Welcome to Oracle BI applications blog! This blog will talk about various features, general roadmap, description of functionality and implementation steps related to Oracle BI applications. In the first post we start with an overview of the BI apps and will delve deeper into some of the topics below in the upcoming weeks and months. If there are other topics you would like us to talk about, pl feel free to provide feedback on that. The Oracle BI applications are a set of...

Thursday, September 13, 2012 | Analytic Applications | Read More
 

Visit the Oracle Blog

 

Contact Us

Oracle

Integrated Cloud Applications & Platform Services