Oracle Projects

Tips for troubleshooting Purchase Order Import errors with Projects

Author: Jonathan LeBlanc Date: August 15th, 2011
Categories: Oracle E-Business Suite R12, Oracle Projects

Recently, I received a call from a customer requesting my assistance with troubleshooting Purchase Order Import errors in R12.  The customer was trying to import 1000 purchase orders that were related to projects.  They were encountering the following error and were having difficulty finding the root cause as the message was vague:

Project information on the distribution is not valid. &PJM_ERROR_MSG

Here are some tips on places to look to resolve such issues:

» Read More

Creating a Project utilizing the Oracle APIs

Author: Jonathan LeBlanc Date: August 8th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12, Oracle Projects

In my previous blog entry, I talked about the overall picture of developing a custom Oracle Projects interfacing process. In this entry, I’ll review the steps for creating the initial Project record and associated components. For the Projects Interface Application used as my reference, the main Project record requirements are: Customer; Project Manager; Tasks; Budget (Cost/Revenue)

For those familiar with developing API based interfaces, calling the Create-Project API functions in the same way. For those unfamiliar with API development, prior to the actual API call, inbound data from the third-party application should be assigned to the available API record-fields, for creating the Oracle Project (much like populating the fields of an Interface table). Some fields are required and will cause the Create Project API to fail, returning and error if missing or invalid.

» Read More

Interfacing with Oracle Projects – An Introduction

Author: Jonathan LeBlanc Date: May 17th, 2011
Categories: Oracle Application Services, Oracle E-Business Suite R12, Oracle Projects

Throughout my many years of Application Interface development, I have grown to love designing and implementing custom Oracle interface processes. No matter how many times you develop an Order Management Interface or Suppliers conversion, no two are alike. One particular module that has landed on my favorite’s list is Oracle Projects. What a cross-combination of items: customers, employees, assignments, locations, accounting and of course the Projects module objects themselves. With Projects you have Templates, tasks, budgets, expenditures, costing and billing, just to name some of the key aspects. Developing conversion and interface processes for this module has become a specialty of mine.

This will be the first in a series of blogs on Oracle Projects, as I pass on the major features for developing custom interface processes into Projects. The first interface I will detail, utilizes standard Oracle Project API’s, to create and update Project records. In subsequent blog entries, I will describe how to interface expenditure data to projects using Oracle’s standard Projects Interface table.

» Read More

Interfacing with Oracle Projects

Author: Jonathan LeBlanc Date: May 13th, 2011
Categories: Oracle E-Business Suite R12, Oracle Projects

Having logged over 10-years of Oracle Applications development, specializing in interfaces, conversions, and extensions, I have learned a thing or two on how to successfully design, build, test, and implement custom application processes. I will be contributing to this blog to assist Oracle Application Developers with helpful tips, best practice techniques, and know-how on customizing and extending the Oracle EBS Suite. Hopefully, this blog will help to lessen the time you spend searching for meaningful development information on many of the application modules such as, Order Management, Receivables, Purchasing, Payables, HRMS, General Ledger, e-Business Tax and Projects.

Stay tuned for the first of a series of blog entries on a new favorite module of mine – Oracle Projects.

I’ll take you through the process of designing and development of custom Interfaces that import data from a 3^rd party application to Oracle Projects every 15-minutes.

Blog author: Lamonte Bradley

Lamonte is a contributing blog author on the Applications Technical Services Practice team at BizTech.