Duplicate table aliases in MHLWADMICSRCASENUM causes ambiguously defined column error in 8.1 OOTB PMDA profile (Doc ID 2269169.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Argus Safety - Version 8.1 and later
Oracle 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 (+)

 

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