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

Last updated on JULY 13, 2023

Applies to:

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.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.