My Oracle Support Banner

Temp Table Refresh Failing After Upgrading To 8.0.7 From 8.0.4 (Doc ID 2720671.1)

Last updated on OCTOBER 21, 2020

Applies to:

Oracle Financial Services Behavior Detection Platform - Version 8.0 and later
Information in this document applies to any platform.

Symptoms

Customer is reported that Below command is failing in 8.0.7 after upgrading from 8.0.4:
refresh_temp_table.sh ML_ACCT_ADDR_MTCH_TMP ML_ACCT_ADDR_MTCH_T

Error :
[FATAL] 2020-09-30 11:57:28.019 [main] REFRESH_TEMP_TABLE - REFRESH_TEMP_TABLE - Message 265001: Error - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

/data/applications/FCCM/UK/database/db_tools/logs/refresh_temp_table.log
-------------- Output from database call END --------------

[Wed 30/9/2020 11:57:21] [REFRESH_TEMP_TABLE] [ INFO] - REFRESH_TEMP_TABLE - Message 265101: Ending the Refresh Temp Table Process.
[Wed 30/9/2020 11:57:27] [REFRESH_TEMP_TABLE] [ INFO] - REFRESH_TEMP_TABLE - Message 265235: Running query ML_ACCT_ADDR_MTCH_TMP
[Wed 30/9/2020 11:57:28] [REFRESH_TEMP_TABLE] [FATAL] - REFRESH_TEMP_TABLE - Message 265001: Error - java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist

[Wed 30/9/2020 12:12:21] [REFRESH_TEMP_TABLE] [ INFO] - REFRESH_TEMP_TABLE - Message 265235: Running query ML_ACCT_PHONE_MTCH_TMP
[Wed 30/9/2020 12:12:22] [REFRESH_TEMP_TABLE] [ INFO] - REFRESH_TEMP_TABLE - Message 265003

Changes

 

View ML_ACCT_ADDR_MTCH_T doesn't exist in 807 env. 
 

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.