Posts Tagged ‘Oracle’

I am often asked by clients to create reports that display alternating shaded rows. We’ve all been there, squinting away trying to view those tiny numbers crammed onto a single report. Too often we find ourselves relying upon a ruler to help follow the values across the row as the columns continue to grow across […]

The fourth year of Oracle Industry Connect (OIC) was, overall, an absolute success. Several thousand attendees from around the world and a variety of industries met in Orlando to learn about the latest trends in technology and to hear firsthand how companies have been able to streamline and strengthen their businesses with software solutions from […]

I thought it might be helpful to provide instruction on how I set up each virtual machine to support the Oracle Siebel Clinical Trial Management System (CTMS) implementation and integration projects I work on. As I mentioned in a previous post, I have a clone master for each version of Siebel that I keep offline […]

While Siebel developers have always been encouraged to use non-scripting solutions to implement custom business functionality, almost every Siebel Clinical (CTMS) implementation project that I have worked on has included an integration component, and in almost every instance, it has required some coding with Siebel eScript. But, how do you debug your custom code? For […]

The purpose of this blog post is to share how to setup/customize the Oracle Drop Ship process to automatically create Purchase Orders originating from the Drop Ship Sales order lines. Standard Process: Oracle’s out-of-the-box functionality involves creation of a sales order in Oracle Order Management with sales order lines set to source type as External. Once […]

Next week, we are exhibiting at Oracle Industry Connect (OIC) 2017 in Orlando, Florida. For those not familiar with OIC, it is a conference dedicated to a variety of verticals, including Life Sciences and Healthcare. Prior to the existence of OIC, the Annual Oracle Health Sciences User Group (OHSUG) Meeting was an event devoted to users […]

As a technical resource at Perficient, many of the projects I work on relate to Siebel CTMS upgrades. Usually, our customers who are running Siebel CTMS 8.1.1.11, or earlier versions are interested in upgrading to the latest version. As of today, the most recent version is 16.9. At a high level, Siebel CTMS upgrade projects […]

These days most of the companies are using Oracle as their database to maintain their data. SQL*Plus is the major tool to access the Oracle DB because it is more secure than other tools. Handling flat files in the Oracle DB by using SQL*Plus is difficult one. SQL Loader is the one which is very use […]

Perficient’s Life Sciences practice regularly monitors the software release notes for several Oracle Health Sciences applications, as well as our own clinical and safety systems. The systems covered in our review are: Oracle Systems Argus Safety Oracle Clinical/Remote Data Capture (OC/RDC) Thesaurus Management System (TMS) Perficient Systems ASCEND (Siebel CTMS) Generally speaking, we review release […]

In the previous post, I talked about varying levels of scrutiny for data review and what happens when recording the user actions. In this post, I will talk about the importance of the user interface for a review. Successfully navigating requirements, design, development, testing, user acceptance and ongoing support of any application requires user involvement […]

Now that March is here, I thought it would be neat to look back at what our readers found most interesting last month. Below are the top five blog posts Perficient’s life sciences practice wrote in February – they’re ranked in order of popularity, with number one being the most viewed piece. How And Why I Use Oracle VM […]

As was mentioned in a previous post, providing an easy-to-use interface is important for data review, including filtering, audit data, and User Review Action buttons. The user actions buttons initiate recording that all, or a portion, of a review has been performed. In the previous section, we mentioned a Review Timestamp, which is one of […]