My Oracle Support Banner

FCCM 801 Installation Issues (Doc ID 2636669.1)

Last updated on FEBRUARY 18, 2020

Applies to:

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

Symptoms

On : 8.0.1 version, Installers

ACTUAL BEHAVIOR
---------------
FCCM 801 installation issues

Installer console output shows that installation completed successfully but OFS_BD logs show huge amount of errors (more than 8000). On checking all logs, below is what we observed.

1. Pack_Install.log - 1 error as below
[Thu 30/1/2020 11:32:45] [WRAPPERINSTALLER] [ INFO] - Setup status : 2
[Thu 30/1/2020 11:32:45] [WRAPPERINSTALLER] [ERROR] - Error : APP Setup bin file failed.


2. OFS_BD failed with more than 8K errors
The 1st error encountered in this file is while creation of view de_audit_date (table or view does not exist for table KDD_CASE_ACTIONS). Before that point the log does not show any problems. We are wondering that since the table is created by the same installer before this step, how is it possible that it does not exist at this point. So either the create table did not run or it failed but without throwing any error in the log.

[Thu 30/1/2020 11:17:32] [OFSAAI] [ INFO] - Executing file:/data/applications/FCCM/AMUS/fichome2020.01.30.10.56.58/SQLScripts/AtomicSchema/Views/CM/de_audit_date.sql
[Thu 30/1/2020 11:17:32] [OFSAAI] [ERROR] - Query:'
create or replace view de_audit_date as
select KDD_CASE_ACTIONS.case_intrl_id, max (KDD_CASE_ACTIONS.action_ts) max_date from KDD_CASE_ACTIONS group by KDD_CASE_ACTIONS.case_intrl_id
'
Error:ORA-00942: table or view does not exist

[Thu 30/1/2020 11:17:32] [OFSAAI] [ INFO] - # of errors in file=1


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.