Author Archive

Informatica being replaced by ODI in Oracle BI Apps

August 1, 2013

In a long anticipated move among both Fusion Intelligence and Oracle BI Apps customers, Oracle has released the first versions of its packaged business intelligence solution that replaces the third party tools of previous versions (IBM DataStage or Informatica Power Center) with Oracle Data Integrator as the back end ETL tool. You can find detailed […]

Tags: , , ,
Posted in Business Intelligence, E-Business Suite, ETL, Featured, Fusion Intelligence, Oracle BI Apps, Oracle Data Integrator (ODI) | 3 Comments »

11g Bug: Issue with equality operator on content filters

November 21, 2011

I ran into an weird issue yesterday trying to troubleshoot data security for my current gig. What it came down to is the fact that for some reason the equality operator in the expression below wasn’t being resolved correctly by OBI: LOWER( TRIM(“Data Warehouse”.””.”SCHEMA_NAME”.”ALS_BI_SEC_USER_DEPT”.”EMAIL_ADDRESS”)) = ( LOWER( TRIM( VALUEOF(NQ_SESSION.”USER”)))) Even after toying with :USER, applying […]

Tags: , , , , , ,
Posted in Business Intelligence, OBIEE, Technical, Tips, Troubleshooting | No Comments »

Changing the value of a session variable at the session level

November 12, 2011

I recently needed to update the value of a session variable beyond a prompt’s scope, I played a bit with the NQSSetSessionValue() ODBC function

Tags: , , , , , , , ,
Posted in Business Intelligence | 1 Comment »

Troubleshoting Error: unable to get file lock, will retry …

July 21, 2011

Troubleshooting error BEA-141281 unable to get file lock, will retry …

Tags: , ,
Posted in Business Intelligence, Featured, Infrastructure, Technical, Uncategorized | 5 Comments »

Fixing device references after importing a Linux guest in Oracle Virtual Box

June 9, 2011

After reading this post you should be better prepared to smoothly export and import Linux virtual machines from your Oracle Virtual Box servers by being ready to correct any disk device reference issues in fstab and grub.conf

Tags: , , , , , , ,
Posted in Featured, Infrastructure, Install and Configuration, Technical, UNIX/Linux | No Comments »

Configuring WebLogic Automated Startup Credentials

May 26, 2011

After reading this post you should be able to configure the file to provide the WebLogic server with startup credentials, a necessary step when configuring the server for automated startup …The WebLogic server does not start automatically, it is prompting for a user name and password    WebLogic not reading file

Tags: , , , , , ,
Posted in Featured, Fusion Intelligence, OBIEE, Technical | No Comments »

OBIEE 10g Administration – useful linux environment variables

November 14, 2010

Create some basic variables in your OBIEEE Linux server

Tags: , , ,
Posted in Featured, OBIEE, Tips, UNIX/Linux | No Comments »

Issues with DB Connection when creating the Informatica Power Center Repository

October 22, 2010

“An Exception has occurred. The database connection detail for service INFA_REPO_SVC are invalid. Please check log for details”

Tags: , , , ,
Posted in Informatica PowerCenter, Oracle BI Apps, Oracle Database, Technical | 1 Comment »