My Oracle Support Banner

CRR 807 - Customer And Accounts Not Populated In SAR. (Doc ID 2881770.1)

Last updated on JULY 13, 2022

Applies to:

Oracle Financial Services Regulatory Reporting - Version 8.1.1 and later
Information in this document applies to any platform.


On CRR 807 - Customer and Accounts not populated in SAR.

1. How to find if suspects in a SAR report are customers? Customer and account ids are not populated in FCT_SUSPECT_INFO.

2. Because of #1, unable to determine if customers in an ECM Case have SAR reports or not. All the customers in the ECM case will appear to have SAR reports even if the actual SAR report does not include all the customers of the case because joining between ECM case and SAR happens only on Case ID and not on customer or account IDs.



1. Take a ECM Case having 13 customers.
2. Do not designate any customer in the case as Involved Party.
3. Create SAR report from the ECM case by taking 'Close and Generate SAR' action.
4. All the 13 customers of the case are transferred to SAR report.
5. Delete 10 customers manually in the SAR report retaining only 3 customers.
6. File the SAR report with Fincen and upload the acknowledgment.

Not try to find if any SAR reports filed for each of the customers in the ECM Case.


When ECM and SAR tables are queried to get list of customers in ECM cases having SAR reports, because Customer IDs or Account Numbers are not present in SAR, we are not able to join ECM related tables with SAR tables based on customer id or account number and so it appears as though all the customers in ECM case have SAR reports even though only few customers of a caser are selected in SAR. ECM Case and SAR are linked only through Case Id’s and not with customer number or account numbers.


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.