My Oracle Support Banner

ECM 808 - Case Search By Tax ID Doesn't Appear To Work (Doc ID 2763497.1)

Last updated on MARCH 30, 2021

Applies to:

Oracle Financial Services Enterprise Case Management - Version 8.0.7 and later
Information in this document applies to any platform.


ECM 808 - case search by tax ID

in ECM 808 we have an option to search for cases by tax_identifier.
I looked for a case in kdd_case_customers where we have a customer with a tax ID, but I cannot find these cases when I search by the case's customer's tax id.

case_id = CA5454
cust_intrl_id = XXCUDEVPGPRODUTAC-0400
tax_id = XXTXDPGPUAC-0400
bus_dmn_list_tx = a

Steps to Reproduce Problem
go to case search, more search options.
use entity type tax_identifier, and entity ID use a tax identifier for which
you know a customer has a case. Then click on search.

select * from kdd_case_customers where cust_intrl_id = '#CUST_INTRL_ID' and

tax_id ='#TAXID';




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

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