Ledger Stat Undo Batch Fails with 'FicGeneric Terminated normally. Exit code = 127 : Key not Found'
Last updated on MARCH 12, 2018
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)
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.
 FicGeneric started...
 Parent going to wait for child
 FicGen Execute returning
FicGeneric Terminated normally. Exit code = 127 : Key not Found
 Execution started
Key not Found
 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".
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