Join mismatch in function to populate cs alerts in CS
(Doc ID 2778136.1)
Last updated on MAY 27, 2021
Applies to:Oracle Financial Services Customer Screening - Version 188.8.131.52.0 and later
Information in this document applies to any platform.
To correct the mismatch of join in function to populate CS Alerts in CS
While trrying to join the CS_MATCHES_HIST.CUST_ID on the EXTERNAL_ENTITY.EXTRL_NTITY_ID. However, CS_MATCHES_HIST.CUST_ID contains what is the external_entity_extrl_ntity_seq_id, not the external_entity_extrl_ntity_id.
Incorrect join used in function as below :
INNER JOIN EXTERNAL_ENTITY ON CS_MATCHES_HIST.CUST_ID = to_char(EXTERNAL_ENTITY.EXTRL_NTITY_ID)
INNER JOIN PARTY_PARTY_RLSHP ON EXTERNAL_ENTITY.EXTRL_NTITY_ID = PARTY_PARTY_RLSHP.RLTD_PARTY_ID
WHERE CS_MATCHES_HIST.FIC_MIS_DATE =v_date
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