Companies regulated under Title 21 who require project assistance are often confronted with growing complexity in their projects, needing multi-functional expertise from their service providers. To offer maximum quality, efficiency, and productivity to our clients, Coda Corp USA and J&R Consulting are pleased to announce the formation of a strategic alliance. This synergistic relationship will allow each company to offer to its existing and potential clients an expanded pool of resources available form both areas of expertise; Title 21 compliant quality systems and enterprising global automation solutions. Coda’s Executive Offices released the following...

The OracleAS 10g software is, among other things, a robust application container for web services. It has integrated performance monitoring, web service clients, and several other add-ons that make it a pleasure to work with. However, all of this is built on top of a somewhat dated web service technology, Java API for XML-Based RPC (JAX-RPC). This article will describe the settings necessary to configure an OracleAS 10g web service to using the Java API for XML-Based Web Services (JAX-WS) technology. Web Service Design Methods Classically, web services are created using one of two methods, typically referred to as bottom-up or top-down. Using the bottom-up approach, the developer...

In the process of implementing an ERP to LIMS interface, one of the challenges to overcome was how to clearly communication between Oracle E-Business Suite (EBS) and SQL*LIMS v5. In the past, I had been exposed to several methods of interface communication, text files containing single bits of data, records inserted directly into a database, and concatenated strings transmitted over a network. Each of these methods had at least one serious flaw: if the data structure changed the interface stopped working. This article will review how Business To Manufacturing Markup Language (B2MML) was used to robustly transfer data and instructions between an ERP and LIMS system. History In late...