My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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

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


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