Ledger Stat Undo Batch Fails with 'FicGeneric Terminated normally. Exit code = 127 : Key not Found' (Doc ID 1505599.1)

Last updated on JUNE 25, 2016

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 has a Status of "Failed".  When you select the Task row, the following messages are listed:

Note: Depending on your 7.3 version, you may see different messages.

7.3.1:

[10264] FicGeneric started...
[10272] Parent going to wait for child
[10273] FicGen Execute returning
FicGeneric Terminated normally. Exit code = 127 : Key not Found

7.3.4:

[10264] Execution started
Key not Found
[10271] Error executing process : FICGeneric Terminated normally. Exit code = 100

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

Log Message here 1: Tue Nov 13 07:52:11 2012||INFO||[FicGenExecute] : FICGENERIC.MSG_0009
Log Message here 1: Tue Nov 13 07:52:11 2012||SEVERE||[FicGenExecute] : FAILED CommandReturnValue = -1
Log Message here 1: Tue Nov 13 07:52:11 2012||INFO||[FicGenImpl::FicGen] : FicGenExecute Complete

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

Note: You can run undo successfully from the command line as described in <Document 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