PFTBI and ALMBI SCD Dimension Error FICGENERIC.MSG_0008 No Such File or Directory
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)
When attempting to run SCD to migrate data into DIM_<DIMENSION> Business Intelligence (BI) reporting table the following error occurs in FSI_MESSAGE_LOG:
 FicGeneric started...
 Parent NOT going to wait for child
 Non Authoritative status update = S in case of WAIT=NO
FICGENERIC.MSG_0008No such file or directory: Key not Found
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.
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