My Oracle Support Banner

OFS Retail Customer Analytics - Table Do No Exist (Doc ID 2546274.1)

Last updated on NOVEMBER 08, 2019

Applies to:

Oracle Financial Services Retail Customer Analytics - Version 8.0.0 and later
Information in this document applies to any platform.

Symptoms

Below mentioned batches/tasks that refresh the derived entity and hierarchies execution getting failed

##INFODOM##_ACCOUNT_SUMM_DE_REF - Task1
##INFODOM##_PC_DE_REFRESH - Task1
##INFODOM##_PC_DE_REFRESH - Task2
##INFODOM##_PC_DE_REFRESH - Task3

Below error occurs while executing above mentioned batches tasks, DT_<INFODOM>_PC_DE_REFRESH_<FICMISDATE>_1_Task1

Log Message here 1: ||INFO||exit status : 1
Log Message here 1: ||INFO||Step Failure -- FN_REFRSH_DE_1

Following error occurs in RunProc_<INFODOM>_PC_DE_REFRESH_<FICMISDATE>_1_Task1.log

Log Message here 1: ||INFO||Parameters : fn_refrsh_de,'OFSCAINFO_PC_DE_REFRESH_<FICMISDATE>_1','<FICMISDATE>','1','180','1','0','REPLNPC'
Log Message here 1: ||INFO||Statement to execute : BEGIN :D := fn_refrsh_de('OFSCAINFO_PC_DE_REFRESH_<FICMISDATE>_1','<FICMISDATE>','1','180','1','0','REPLNPC'); END;
Error Msg :-> ORA-06550: line 1, column 13:
PLS-00201: identifier 'FN_REFRSH_DE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
Log Message here 1: ||SEVERE||Could not Execute
Log Message here 1: ||INFO||After Calling execProc
Log Message here 1: ||SEVERE||Stored procedure execution failed

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


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