J.4b (MHLWADMICSRCASENUMB) Item Does Not Exist In The E2B Follow-up Report
(Doc ID 1684388.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety Japan - Version 6.0.7 and laterInformation in this document applies to any platform.
Symptoms
J.4b (MHLWADMICSRCASENUMB) item is missing in E2B F/U (Follow-up) report.
When this issue is occurring, it is observed in CASE_PMDA_LICENSE table that there are duplicate deleted and active records for a LICENSE_ID value.
(one is DELETED is null and the other is DELETED is not null with the same LICENSE_ID value).
And both of these two records are having pmda number value (J.4b value) in PMDA_NUMBER column.
CASE_PMDA_LICENSE data sample:
| CASE_ID | SEQ_NUM | LICENSE_ID | PMDA_NUMBER | DELETED____ |
| 123456789 | 123456 | 23456789 | 12345678 | 19-JUN-2014 |
| 123456789 | 123567 | 23456789 | 12345678 |
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |