My Oracle Support Banner

OFSAA Table Classification Batch Getting Failed After ALM and LLFP 8.1 Installation (Doc ID 2776357.1)

Last updated on JUNE 01, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.0.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Loan Loss Forecasting and Provisioning (LLFP)
Oracle Financial Services Enterprise Performance Management (EPM)

Symptoms

Class assignement batch getting failed after successful installation of OFSAA 8.1 for LLFP & ALM.


ERROR
-----------------------
fsi_message_log:


VALIDATE_INST_LEAVES :: The Table FSI_D_REINS_CONTRACTS_HELD columns "ORG_UNIT_ID" are missing or incorrectly registered. Data Type must be NUMBER and FDM Data Type must be LEAF
VALIDATE_INST_KEY :: GET_INST_UNIQUE_INDEX ::  Table Property 1010 - Validate Instrument. Table: FSI_D_REINS_CONTRACTS_HELD. No valid unique index found. Last query executed was -> SELECT index_name FROM all_indexes WHERE table_owner =  'GRABATOM' AND table_name = 'FSI_D_REINS_CONTRACTS_HELD' AND uniqueness = 'UNIQUE'
Table FSI_D_REINS_CONTRACTS_HELD Failed (310). CHECK_TABLE_CLASS_REQ procedure returned status N while validating table FSI_D_REINS_CONTRACTS_HELD

Changes

 

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
References


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