My Oracle Support Banner

Customer And Account Information Is Not Loaded Post Graph Jobs (Doc ID 3012785.1)

Last updated on APRIL 01, 2024

Applies to:

Oracle Financial Services Crime and Compliance Investigation Hub - Version 8.0.8 and later
Information in this document applies to any platform.

Symptoms

Customer and Account information is not loaded post graph jobs

1. Access the application

2. Launch the CS 

3. Go to scheduler 

4. Run the Customer and account jobs.

Expected result:
The job should be successful and load the data.

Actual result:
The data is not loading.

 

Error encountered:

we see the below error while checking manually

Connecting to the database UAT_GRAPH.
SELECT COUNT(1) FROM SIT_GRAPH.FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B WHERE N_RUN_SKEY=398
SELECT COUNT(1) FROM ALL_TABLES WHERE OWNER= UPPER('SIT_GRAPH') AND TABLE_NAME ='FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B_SRC_DELTA_TAB_398'
truncate completed
TASK782_20240322194531
V_sql_stmt :- insert into FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B_SRC_DELTA_TAB_398 T select * from SIT_GRAPH.FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B_SRC S WHERE rowid BETWEEN :start_id AND :end_id
Error Happened while task runORA-27486: insufficient privileges
V_sql_stmt :- insert into FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B_SRC_INTER_COMP_RHS T select * from SIT_GRAPH.FCC_CUSTOMER853E4164_0968_4CB6_A6F3_2B4930614A8B_SRC S WHERE rowid BETWEEN :start_id AND :end_id
Error Happened while task runORA-27486: insufficient privileges

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


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