WHO-XXX uncoded product Records in LM_PRODUCT And LM_PRODUCT FAMILY Records Exist In The Database (Doc ID 2134355.1)

Last updated on DECEMBER 20, 2016

Applies to:

Oracle Argus Safety - Version 7.0.6 and later
Information in this document applies to any platform.

Symptoms

Oracle Argus Safety : Version 7.0.6

Noted that there few records present in the database in LM_PRODUCT and LM_PRODUCT_FAMILY tables, where product does not have formulation and can’t be created via Console.

Discovered that such records are getting created by Argus itself automatically when a study case is created with Non-Company Study and enter the Non-Company product, after creating case and later Make non-company product to
“Make a Study Product” and after saving case Argus inserts a row in LM_PRODUCT and LM_PRODUCT_FAMILY also it appends “WHO-xxxx uncoded product” as prefix with the Family name.

Also if remove/delete the Non-Company product which is earlier made as Study noted that Argus is not deleting these records and creating inconsistent entry in the database which can’t be accessed from Front end.

Steps to Reproduce

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms