My Oracle Support Banner

FCC Studio IHub Notebook Error (Doc ID 3066517.1)

Last updated on JANUARY 10, 2025

Applies to:

Oracle Financial Services Compliance Studio - Version 8.1.2 and later
Information in this document applies to any platform.

Symptoms

Steps to reproduce : 

Step 1 : Login to CS 

Step 2 : Execute the ECM_Integration_L1 notebook for the Investigation Hub

Step 3 : Check if user encountered below issue.

Error Encountered : 

User reported When we try to execute ECM_Integration_L1 notebook for the Investigation Hub we are encountering below mentioned error.
 
| Exception java.lang.RuntimeException: java.util.concurrent.ExecutionException: oracle.pgx.api.MalformedQueryException: oracle.pgx.api.MalformedQueryException: Error(s) in line 1:
 
SELECT count(e."Activity Risk") AS count, CASE WHEN e."Activity Risk" > 7 THEN 'HIGH' ELSE 'LOW' END AS risk, id(acct) as accountId FROM MATCH (cust: Customer) - [e] -> (acct: Account) WHERE e.Label = 'cash trxn' and e.Type = 'primary' and id(acct) in ('Account(ACCR25793-001)') GROUP BY risk, accountId

Property does not exist for any of the labels

Changes

NA

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
Changes
Cause
Solution


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