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 laterInformation 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 |