Posts Tagged ‘Enterprise Resource Planning’

This post explains the process to unload ODI session log information Ex:  Session name, run-time, number of records inserted etc. from SNP_SESSION table to a delimited file and attach it to a Load Plan success notification email. This attachment can be used to identify the Session’s which are running longer than usual and causing performance issues, […]

When it comes to choosing the right Cloud BI platform, there is usually a trade off between governance and centralization on one hand and agility on the other. BI software vendors like Tableau and Qlik, that are relatively newer to the game than traditional BI platforms, have changed the rules of what defines a better BI […]

Enterprise Design in EBS is one of the first things you tackle when beginning a new client engagement. It will likely include chart of accounts design, number of business groups, ledgers, legal entities, operating units (OU), and inventory organizations. This document will brush lightly on a few of these areas but will focus primarily on […]

The intent of this document is provide the reader with a fundamental understanding of Oracle’s Secondary Ledgers, enriched with lessons learned from actual implementations. Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient. Feel free to ask him any questions in the comments section below the […]

The intent of this document is provide the reader with a fundamental understanding of Oracle’s Cross Validation Rules, enriched with lessons learned from actual implementations.  Matt Makowsky is an Oracle Financial Applications Consultant with 17 years experience and a Senior Solutions Architect with Perficient.  Feel free to ask him any questions in the comments section below […]

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert […]

This post explains the process to unload an error message from ODI repository log tables SNP_LPI_STEP_LOG, SNP_LPI_EXC_LOG to .txt file and attach it to a Load Plan failure notification email. Process: Create ‘Error_Notification’ package which uses ODISqlUnload utility to unload error message from log tables and write into text file, OdiSendMail utility to send email […]

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

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

Mazen just previewed What to Expect Next on BICS and now it is in the process of being released.  The first thing you’ll notice is the new clean and concise consumer-style user experience.  Site navigation and the Home page has changed dramatically as you can see in the screen shot below (the compass next to the user’s name brings up […]

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

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