Operations

  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: 

In BIAPPS whenever a ODI package is executed it reads  W_ETL_LOAD_DATES table to verify if a record exists with that package name. If record found package is executed in incremental mode else Full load mode. In incremental mode package will update the last_executed_date of existing record in W_ETL_LOAD_DATES table and in Full load mode package will insert […]

This post explains the process to unload an error message from ODI repository log tables SNP_LPI_STEP_LOG, SNP_LPI_EXC_LOG to .txt file and attach it to a Load Plan failure notification email. Process: Create ‘Error_Notification’ package which uses ODISqlUnload utility to unload error message from log tables and write into text file, OdiSendMail utility to send email […]

  Demographics in clinical trials have always been scrutinized by the medical community and the public. Are various races, ethnicities, sexes, and ages fairly represented in trials? Does one segment respond better or worse than another to a particular treatment? These questions and more are being answered in Drug Trials Snapshots, a section of the […]

One of the technology points we make in digital transformation is that you cannot just focus on the front end. Failure to leverage all your assets in creating a great customer experience means you will probably be left behind. Venture Beat has an article on Uber’s API Bet. Their vision is very specific and entirely […]

The most common problem with ODI incremental loads: whenever a prior incremental load fails, we have to manually inactivate the load plan schedule and update the agent schedule to stop executing the next load. Once the prior incremental load’s issue is fixed and its execution completed successfully, we have to activate the load plan schedule […]

  Perficient wants to take a few minutes of your time and wish you and your loved ones health, happiness, and success in the New Year. Let it be more peaceful. Let it be brighter. The most important thing in life is life itself. Treasure it. Treasure those around you. Although many of you have […]

  According to FierceCRO and a new report by HR+Survey Solutions, a quarter of clinical trial monitors in the U.S. are ditching their jobs for more lucrative ones. The 2016 CRO Industry Global Compensation and Turnover Survey report, which includes responses from 24 public and private contract research organizations (CROs), indicates that over the last […]

The report of my death was an exaggeration – Mark Twain & SharePoint Server On-Premises SharePoint Server On-Premises was, in the recent past, presumed obsolete. While Office 365 and Cloud Computing are juggernauts, compelling use cases continue to exists for On-Premises deployment. Realizing this need, Microsoft is working toward a Q1 2016 release of SharePoint […]

  In an article from Clinical Leader, Chief Editor, Ed Miseta, and Bayer Healthcare’s VP Global Strategy & Development Advisor, Johann Proeve, discuss using electronic health record (EHR) and electronic data capture (EDC) systems to lower the overall costs of running clinical trials. 

This blog explains how to use auto mapping feature to automatically import data into oracle sales cloud instance without manually mapping the file source with the application instance. The automatic mapping is a new feature available in release 10. This auto-mapping feature is helpful when oracle P2T is not available. What is Auto Mapping? Auto […]

  Gordon Ritter, co-founder and general partner of Emergence Capital, wrote an article in TechCrunch the day after Thanksgiving in which he spoke about the prowess of “industry cloud companies” – companies that develop software for specific verticals. “These companies might not be well-known outside specific industries, but ask anyone within an industry vertical and […]