Duplicate table aliases in MHLWADMICSRCASENUM causes ambiguously defined column error in 8.1 OOTB PMDA profile
(Doc ID 2269169.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety - Version 8.1 and laterOracle Life Sciences Argus Interchange - Version 8.1 and later
Information in this document applies to any platform.
Symptoms
MHLWADMICSRCASENUM tag logic in 8.1 OOTB (Out Of The Box) PMDA profile utilizes the same table alias for two tables: lm_rpt_category and lm_regulatory_contact.
MHLWADMICSRCASENUM tag logic:
SELECT lrc.e2b_code MHLWADMICSRCASENUMCLASS,
CASE
WHEN (lrc. COUNTRY = 107
AND lrc.RECEIVER_TYPE = 2)
THEN GSS_UTIL. Get_PMDA_Number(crr.reg_report_id, cpl.case_id,
:PREV_REPORT)
ELSE NULL
END MHLWADMICSRCASENUMB
FROM cmn_reg_reports crr,
case_pmda_license cpl,
lm_rpt_category lrc,
lm_regulatory_contact lrc
WHERE crr.reg_report_id = :REG_REPORT_ID
AND crr.agency_id = lrc. agency_id
AND cpl.case_id = :CASE_ID
AND cpl.license_id = crr. license_id
AND cpl.prod_seq_num = crr.prod_seq_num
AND cpl. rpt_category_id = lrc.rpt_category_id (+)
CASE
WHEN (lrc. COUNTRY = 107
AND lrc.RECEIVER_TYPE = 2)
THEN GSS_UTIL. Get_PMDA_Number(crr.reg_report_id, cpl.case_id,
:PREV_REPORT)
ELSE NULL
END MHLWADMICSRCASENUMB
FROM cmn_reg_reports crr,
case_pmda_license cpl,
lm_rpt_category lrc,
lm_regulatory_contact lrc
WHERE crr.reg_report_id = :REG_REPORT_ID
AND crr.agency_id = lrc. agency_id
AND cpl.case_id = :CASE_ID
AND cpl.license_id = crr. license_id
AND cpl.prod_seq_num = crr.prod_seq_num
AND cpl. rpt_category_id = lrc.rpt_category_id (+)
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 |
| Cause |
| Solution |
| References |