Two Drug Code records are displayed on J-Drug Encode screen for a single Drug Name (Doc ID 1901960.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

Two records with different Drug Code are displayed on J-Drug Encode screen for a single Drug Name after uploaded a new version J-Drug Dictionary.
The J-Drug Encode screen is invoked by Case Form >> Products tab >> [Encode] button.
This seems that the two version's Drug Code data are being displayed on the screen for the previous version which has been existing before
uploaded the new version and the uploaded new version itself.

For example, two records with different drug code are displayed when searched by drug name = 'トリニジール'.
------------------------------------------------------
Drug Code - Drug Name - Maintenance Flag
116900105 - トリニジール - Deleted
116900208 - トリニジール - Added
------------------------------------------------------

 


J-Drug Dictionary has been upgraded by the following steps:
---------------------------------------------------------------
1. Open schema creation tool
2. Click on J drug loader button
3. Connect using system user
4. Provide credentials
a. Choose load to new tables
b. Create new j drug user
c. Create new j drug role
d. Choose dictionary version
e. Choose dictionary files to be loaded
f. Click on load
5. Verify log file
---------------------------------------------------------------
Currently multiple schemas are existing for J-Drug Dictionary in the system after upgraded by the above procedure.

 

 

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