Error Running Ledger Stat Undo Batch: 'FICGENERIC.MSG_0008No such file or directory : Key not Found' (Doc ID 1505582.1)

Last updated on NOVEMBER 19, 2012

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 7.3, when you run the Ledger Stat Undo from a Batch, the related data is not removed from the LEDGER_STAT table.  When you review the Batch's Task in the Batch Monitor screen, the Batch is successful.  However, when you select the Task row following error is listed:

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

Additionally, a similar error exists in the ficgen_trace_xxxxxxx.log in $FIC_DB_HOME/log/ficgen:

ERROR in EXECVP : FICGENERIC.MSG_0008No such file or directory
ERROR in EXECVP : FICGENERIC.MSG_0008No such file or directory[FicGenExecute Child] : Exiting after exec error

The error prevents you from successfully running the Ledger Load Undo from a Batch.

Note: You can run the undo successfully from the command line as described in <Document ID 1363340.1> "How to Undo an OFSAA Ledger Stat Load".

Steps to Reproduce:

1. Go to Operations > Batch Maintenance
2. Create a new Batch for the Ledger Load Undo
3. Create a new Task under the batch with the following:

Component: RUN EXECUTABLE
Executable:./LEDGER_LOAD_UNDO.sh, 10403-02/29/2012, L

4. Run the Batch

The error above appears in the Batch Monitor screen.

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