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

Last updated on AUGUST 02, 2013

Applies to:

Oracle Financial Services Asset Liability Management Analytics - Version 5.1 and later
Oracle Financial Services Profitability 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms