Interface

Setting up and using the HR Update Salary Proposals Integrator

Author: Jonathan LeBlanc Date: October 6th, 2011
Categories: Oracle E-Business Suite R12

Recently I received a request to develop a custom interface to update the salaries of approximately 1000 employees.  My response was, “why re-invent the wheel”?  Several Web ADI Integrators are delivered out of the box including the HR Update Salary Proposals Integrator.

The HRMS Web ADI Integrators are extremely powerful as long as you know how to use them.  They can be tricky to setup since they are dependent on the settings of the browser and the security settings within Excel, however within 10 minutes I was able to get the users up and running and updating salaries for their end of year merit increases.  Within a few hours, they had entered and updated the salaries for all of their employees.

Here is a quick summary of the required setups and steps to utilize the HR Update Salary Proposals Integrator:

» Read More

Auto Invoice – Common pitfalls

Author: Jonathan LeBlanc Date: August 23rd, 2011
Categories: Oracle E-Business Suite R12

This is a continuation of my earlier post, ‘You have been tasked with developing an interface to AR and you’ve never used Oracle’s Auto Invoice before. What do you do?’. This time, the idea is to show some of the scenarios one would face while trying to import the invoices.

As most of you would agree, most of the time, the code never works the first time you run it. When you try to run Auto Invoice, after developing the code to interface the invoices into AR, you are naturally going to see some rejections.

» Read More

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

You have been tasked with developing an interface to AR and you’ve never used Oracle’s Auto Invoice before. What do you do?

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

You have been tasked with developing an interface to AR and you’ve never used Oracle’s Auto Invoice before. What do you do? Unfortunately, at one time I was in this situation. Though I knew the concepts of the process, the real time implementation involved a lot of challenges. The following is for those who have never interfaced invoices through Auto Invoice. My goal is to provide an overall understanding of the process and pitfalls that one should be aware of.  

» 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.