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)
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".
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms