My Oracle Support Banner

PFTBI and ALMBI SCD Dimension Error FICGENERIC.MSG_0008 No Such File or Directory (Doc ID 1319737.1)

Last updated on JUNE 28, 2019

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.1 and later
Oracle Financial Services Enterprise Financial Performance Analytics - Version 5.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Analytics (PFTBI)
Oracle Financial Services Asset Liability Management Analytics (ALMBI)
PFT BI
ALM BI

Symptoms

When attempting to run SCD to migrate data into DIM_<DIMENSION> Business Intelligence (BI) reporting table the following error occurs in FSI_MESSAGE_LOG:

Error
[10264] FicGeneric started...
[8984] Parent NOT going to wait for child
[8985] Non Authoritative status update = S in case of WAIT=NO
FICGENERIC.MSG_0008No such file or directory: Key not Found

Steps
1. Run hierarchy flattening transformation.
2. Run SCD batch
3. Batch monitor status and FSI_MESSAGE_LOG shows error the above error.
4. SCD component log is generated to the /ftpshare/<infodom name>/logs directory.
5. No data is loaded to the DIM_<dimension> table.

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.