Archive for April, 2010

Desktop Integration Framework for Web ADI in R12.1.2

Wednesday, April 21st, 2010 by Andy Coates

R12.1.2 contains powerful new functionality called the ‘Desktop Integration Framework’, or ‘DIF’ for short. The DIF allows E-Business Suite users to create custom integrators for Web ADI, and to therefore load data directly into the EBS using Microsoft Excel, Projects or Word. Read the rest of this entry »

Tags: , , , , , , , ,
Posted in E-Business Suite, Functional, Technical | 10 Comments »

Oracle SQL Functions in OBI Answers

Monday, April 19th, 2010 by Andy Coates
For those of you who use OBI Answers, you may have noticed that when defining column formulae in requests that the standard Oracle database function set is not used. This is likely to be a throwback to the pre-Oracle origins of the product, but it is most frustrating for those of us with a SQL background solely in the Oracle world. Read the rest of this entry »

Tags: , , , , , , , , ,
Posted in Business Intelligence, OBIEE, Project Analytics | 2 Comments »

Primavera and Oracle Projects Integration

Thursday, April 1st, 2010 by Darren Farr

Projected Consulting are pleased to announce the successful implementation of the integration of Oracle Primavera with Oracle Projects using the recently released Oracle® Application Integration Architecture (AIA) Release 2.5 Cross-Industry PIP.

The Project Management PIP includes:

  • Oracle Primavera to Oracle E-Business Suite
  • Oracle Primavera to JD Edwards EnterpriseOne

providing seamless integration between the two and Oracle Primavera P6 Enterprise Project Portfolio Management.

This allows users to create projects in JD Edwards EnterpriseOne, Oracle Project Portfolio Management (OP) or P6 Enterprise Project Portfolio Management (P6) and synchronize project structures, activities, resource details and assignments, budgets, actual costs, progress and cost to complete.

Projected Consulting have successfully implemented the integrated Oracle Primavera – Oracle Projects PIP at its world class training centre. We are keen to share this success with customers and potential clients and would like to identify some of the key configuration requirements and benefits available for our customers. Read the rest of this entry »

Tags: , , , , , , , ,
Posted in Functional, Primavera | 1 Comment »

Oracle Application Integration Architecture 2.5 Installation Summary

Thursday, April 1st, 2010 by Robin Harris

Over the past few weeks, Projected Consulting have been installing and testing Oracle’s Application Integration Architecture and the Project Portfolio Management Integration Pack for Primavera P6 and Oracle E-Business Suite 2.5. This article summarises the technical installation process.

Summary of Tips to avoid issues

Details of the following are contained in this article:-

  1. If installing on 64-bit OS use a 32-bit shell if the software is 32-bit
  2. Disable SELinux during OS install
  3. Be very careful when entering connection details in OSR, AIA and PIP install otherwise install will fail
  4. Deploy the OSR application manually after installation
  5. Do not create a database user called AIA before the AIA Foundation Pack install
  6. Alter timeout values before PIP installation
  7. AIA Foundation Pack and PIP install guide has sections to record the information that will be required during installation – use it!
  8. Be careful which java version is in use when installing OSR

Read the rest of this entry »

Tags: , , , , , , ,
Posted in Fusion, Primavera, Technical | 3 Comments »