AML Event Scoring

This section explains about AML Event Scoring use case.

Prerequisites

Before creating the sandbox workspace, the user should follow these steps:

1. Create the Tablespace
2. Create the Sandbox Schema
3. Assign Grants to the Sandbox Schema
4. Create a new data store for the sandbox schema
5. Register Conda Environment in BD Production Workspace

To create tablespace, sandbox schema and assign grants to sandbox schema, see the OFS Compliance Studio Installation Guide.

To create the data store, see How to Create Data Store section.

To register Conda Environment in BD Production Workspace, see How to Register Conda Environment in BD Production Workspace section.

Schema Grants for AML Event Scoring

In Production Workspace

For AML Event Scoring, production workspace is attached to the BD atomic schema, whereas AML event scoring reads tables/data from ECM atomic schema.

Assuming both BD and ECM atomic schemas are on the same database, hence SELECT grant on few of the listed ECM tables, to be provided to BD atomic schema by running set of grants in ECM atomic schema.

To grant the schema for AML Event Scoring in the Production workspace, execute the following query in the ECM atomic schema.

grant select on FCC_EVENT_BINDING to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_ENTITY_MAP to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_INVESTIGATION_STATUS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_SCENARIO_MASTER to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENTS to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_STATUS_B to <BD_ATOMIC_SCHEMA>;
grant select on FCC_EVENT_STATUS_TL to <BD_ATOMIC_SCHEMA>;
grant select on KDD_JRSDCN to <BD_ATOMIC_SCHEMA>;

If BD and ECM are on different schemas but the database is the same, then provide the following grants:

GRANT SELECT_CATALOG_ROLE TO <BD_ATOMIC_SCHEMA>; 
GRANT SELECT ANY DICTIONARY TO <BD_ATOMIC_SCHEMA>;

Sys User Grants

Login as the sys user in the production schema schema and provide the following grants:

GRANT EXECUTE ON sys.DBMS_CRYPTO TO <BD_ATOMIC_SCHEMA>;
GRANT EXECUTE ON sys.DBMS_METADATA TO <BD_ATOMIC_SCHEMA>;

In Sandbox Workspace

To grant the schema for AML Event Scoring in the Sandbox workspace, execute the following query in the ECM atomic schema.

grant select on FCC_EVENT_BINDING to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_ENTITY_MAP to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_INVESTIGATION_STATUS to <SANDBOX_SCHEMA>;
grant select on FCC_SCENARIO_MASTER to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_DETAILS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENTS to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_STATUS_B to <SANDBOX_SCHEMA>;
grant select on FCC_EVENT_STATUS_TL to <SANDBOX_SCHEMA>;
grant select on KDD_JRSDCN to <SANDBOX_SCHEMA>;
GRANT SELECT_CATALOG_ROLE TO <SANDBOX_SCHEMA>; 
GRANT SELECT ANY DICTIONARY TO <SANDBOX_SCHEMA>;

Sys User Grants

Login as the sys user in the sandbox schema and provide the following grants:

GRANT EXECUTE ON sys.DBMS_CRYPTO TO <SANDBOX_SCHEMA>;
GRANT EXECUTE ON sys.DBMS_METADATA TO <SANDBOX_SCHEMA>;

Entity Resolution (ER) with Oracle Text (OT) Matching

The following grants are only required if you are using ER with OT matching:

GRANT CREATE JOB TO <ER_SCHEMA>;
GRANT MANAGE SCHEDULER TO <ER_SCHEMA>;
GRANT EXECUTE ON DBMS_LOCK TO <ER_SCHEMA>;
GRANT EXECUTE ON CTXSYS.CTX_DDL TO <ER_SCHEMA>;
GRANT SELECT ON gv_$session TO <ER_SCHEMA>;
GRANT EXECUTE ON CTXSYS.CTX_THES TO <ER_SCHEMA>;