Whenever a Full load is executed, all target tables are truncated and reloaded. This can result in missing historical data in Aggregate or Snapshot tables. Once erased, such historical data cannot easily be replaced. In order to preserve Account Payables (AP) and Account Receivables (AR) Snapshot data from aging invoice tables W_AP_AGING_INVOICE_A and W_AR_AGING_INVOICE_A, OOTB […]
Posts Tagged ‘Oracle BI Applications’
Restarting ODI Server, ODI Agent in BIAPPS using Web Logic Server
This post will explain steps to Start and Stop ODI Server, ODI Agent in BIAPPS using Web Logic Server Admin Console. Log into WebLogic server http://<hostname>:7001/console Click on Environments on left side under Domain Strucuture
Automating Load Plan to check previous Load status in ODI
The most common problem with ODI incremental loads: whenever a prior incremental load fails, we have to manually inactivate the load plan schedule and update the agent schedule to stop executing the next load. Once the prior incremental load’s issue is fixed and its execution completed successfully, we have to activate the load plan schedule […]
Sell More: Drive Revenue Growth with Analytics
In this 20-minute demo, watch how Perficient can accelerate your adoption of a state-of-the-art Sales Analytics solution leveraging Oracle’s BI Cloud Service and Perficient’s long history of implementing BI solutions for the Sales Line of Business. If you are a VP of Sales, a Sales Manager or an individual Sales Rep, you will find this BI solution valuable for staying on […]
Why is Oracle’s OBIEE 12c Important?
Last week, Oracle released version 12c of OBIEE (Oracle Business Intelligence Enterprise Edition). There are several features that are new to 12c, among which is the UI which has now been updated to become more modern compared to the prior 11g interface. The most interesting feature that has been added is the new Data Visualization […]
24 Hrs BI availability using Oracle Partitioning/Swap methodology
This blog deals with Global Organizational Data needs where there is insufficient window of non-Business hours to run heavy batch loads and at the same time a provision to access the data 24 hours with negligible or no interference. Why 24 hours availability is needed? Organizations have a high need for 24 hour availability of […]
Oracle OBIEE 11g Patches (11.1.1.9 and 11.1.1.7)
Although OOW15 is getting all the headlines, including the announcement of OBIEE 12c (more info to come), Oracle has announced two new Patch Set Updates (PSU) for OBIEE 11g. OBIEE 11.1.1.7.1 Bundle Patch 11.1.1.7.151020 is available for Windows64, Linux32 and Linux64; this document details the installation and bug fixes. OBIEE 11.1.1.9 Bundle Patch 11.1.1.9.5 is available […]
#OOW15 Session Recap: Oracle Policy Automation in 2 Minutes
Oracle Policy Automation in 2 minutes! No, that is not a teaser. After watching a 2-minute demonstration of Oracle’s Policy Automation at Oracle OpenWorld 2015, it is clear that the potential of this tool is unlimited, and the impact on customer service is virtually unlimited. With useful applications in everything from healthcare to telecom, the […]
Oracle’s Big Data Discovery in the Cloud
Larry Ellison ends his welcome keynote at Oracle Open World on Sunday evening with Big Data. He announces 2 new cloud services from Oracle related to big data: 1. Big Data Preparation: A cloud product that serves to prepare, repair, enrich, govern and publish data before its ready for analysis. For instance if you are […]
Oracle OpenWorld 2015 Starts With a Bang Both Indoors and Out
Oracle is big and mighty and Oracle is evolving to stay relevant at the forefront for many years to come. This is the message you get if you happen to pass by the Metreon today to watch a movie, shop at the Westfield mall in San Francisco or travel across the world to have an […]
A Modern Approach to Financial Reports Reconciliation
Gone are the days when several spreadsheets, pen and paper, and calculators are needed to reconcile financial reports. A common challenge in financial reporting is validating that what gets reported on executive dashboards matches with more detailed financial statements and transaction level reporting. What aggravates this endeavor is the fact that executive level dashboards are […]
Integrating OBIEE with Essbase for an Executive Mobile Dashboard
Client Headquartered in Denton, TX, Sally Beauty is an international specialty retailer and distributor of professional beauty supplies with revenues of more than U.S. $2.6 billion annually. Through the Sally Beauty Supply and Beauty Systems Group businesses, the company sells and distributes to more than 4,000 stores, including approximately 200 franchised units, throughout the United States, […]